When I run this query:
r.db('geodata').table('os50kgazetteer')
.getAll(false, { index: 'has_geolocation' })
.update({'geolocation': r.point(r.row('Coordinates')(0),r.row('Coordinates')(1))}
)
after several minutes of activity (a lot of reads followed by some writes) I receive the following error message:
e: Query terminated by an unknown cause in: r.db("geodata").table("os50kgazetteer").getAll(false, {"index": "has_geolocation"}).update({"geolocation": r.point(r.row("Coordinates")(0), r.row("Coordinates")(1))}) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Some of the documents get updated, but only a few thousand out of the 250K+ in the table.
I would have thought it should always be possible to know the cause of an error - that seems sloppy to me and makes the error message essentially worthless.
Documents in the table look like this (this is one that has been correctly updated, as it has the geolocation
field):
Is there anything obviously wrong with this query?
NOTE: I'm running the preview release of the Windows version of RethinkDB (2.2.4-windows-alpha-4) so it could be a bug...