[arangodb-google] error with UPDATE

Discussion:

Mike

2018-10-06 22:49:45 UTC

this query fails when updating, looks simple not sure why it would do that.

db._query("FOR act in @actz UPDATE act WITH { subscounter:
act.subscounter+1 } IN actor" ,{ "actz": [ { "_key":
"e1dc93c3-8f2b-45b8-8321-957e3576cf78" }] }).toArray();

with a pretty long exception:

#############################################################################
EXCEPTION

JavaScript exception in file
'/usr/share/arangodb3/js/client/modules/@arangodb/arangosh.js' at 99,7:
ArangoError 4: AQL: DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
(exception location:
/var/lib/otherjenkins/workspace/RELEASE__BuildPackages/arangod/Aql/ExecutionEngine.cpp:708).
Please report this error to arangodb.com (while executing) (exception
location:
/var/lib/otherjenkins/workspace/RELEASE__BuildPackages/arangod/RestHandler/RestCursorHandler.cpp:135).
Please report this error to arangodb.com
! throw error;
! ^
stacktrace: ArangoError: AQL: DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
DB SERVER ANSWERED WITH ERROR:
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
(exception location:
/var/lib/otherjenkins/workspace/RELEASE__BuildPackages/arangod/Aql/ExecutionEngine.cpp:708).
Please report this error to arangodb.com (while executing) (exception
location:
/var/lib/otherjenkins/workspace/RELEASE__BuildPackages/arangod/RestHandler/RestCursorHandler.cpp:135).
Please report this error to arangodb.com
at Object.exports.checkRequestResult
(/usr/share/arangodb3/js/client/modules/@arangodb/arangosh.js:97:21)
at ArangoStatement.execute
(/usr/share/arangodb3/js/client/modules/@arangodb/arango-statement.js:174:12)
at Proxy.ArangoDatabase._query
(/usr/share/arangodb3/js/client/modules/@arangodb/arango-database.js:950:42)
at <shell command>:1:4

#############################################

This is my version string :

arangosh (ArangoDB 3.3.16 [linux] 64bit, using jemalloc, build
tags/v3.3.16-0-gc765a7c, VPack 0.1.30, RocksDB 5.6.0, ICU 58.1, V8
5.7.492.77, OpenSSL 1.0.2k-fips 26 Jan 2017)
Copyright (c) ArangoDB GmbH

Im running this in a small cluster with 4 nodes, new installation, three
documents, and a graph defined on top that does not involve this actor
document. any clues?

--
You received this message because you are subscribed to the Google Groups "ArangoDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to arangodb+***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Mike

2018-10-07 16:11:34 UTC

Permalink

backup, droping all data and databases, foxx directories, and restoring
with latest version solved it.

Post by Mike
this query fails when updating, looks simple not sure why it would do that.
"e1dc93c3-8f2b-45b8-8321-957e3576cf78" }] }).toArray();
#############################################################################
EXCEPTION
JavaScript exception in file
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
/var/lib/otherjenkins/workspace/RELEASE__BuildPackages/arangod/Aql/ExecutionEngine.cpp:708).
Please report this error to arangodb.com (while executing) (exception
/var/lib/otherjenkins/workspace/RELEASE__BuildPackages/arangod/RestHandler/RestCursorHandler.cpp:135).
Please report this error to arangodb.com
! throw error;
! ^
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
{"code":400,"error":true,"errorMessage":"Expecting type
Bool","errorNum":1590}
/var/lib/otherjenkins/workspace/RELEASE__BuildPackages/arangod/Aql/ExecutionEngine.cpp:708).
Please report this error to arangodb.com (while executing) (exception
/var/lib/otherjenkins/workspace/RELEASE__BuildPackages/arangod/RestHandler/RestCursorHandler.cpp:135).
Please report this error to arangodb.com
at Object.exports.checkRequestResult
at ArangoStatement.execute
at Proxy.ArangoDatabase._query
at <shell command>:1:4
#############################################
arangosh (ArangoDB 3.3.16 [linux] 64bit, using jemalloc, build
tags/v3.3.16-0-gc765a7c, VPack 0.1.30, RocksDB 5.6.0, ICU 58.1, V8
5.7.492.77, OpenSSL 1.0.2k-fips 26 Jan 2017)
Copyright (c) ArangoDB GmbH
Im running this in a small cluster with 4 nodes, new installation, three
documents, and a graph defined on top that does not involve this actor
document. any clues?

Jan

2018-10-08 07:06:08 UTC

Permalink

Hi,

this is a strang error, and I don't see any obvious reason for it.
Additionally, the file names & line numbers of the cpp files mentioned in
the error messages do not match with the existing code in 3.3.16 (nor
anything before it up to including 3.3.9). Is it possible that only parts
of the cluster were running 3.3.16 and at least one of the process was
running a different version?

Best regards
Jan