AQL Syntax error on rollback on inserting executionPlan

[vishalag001]

Hi @wajda,

I am getting the following AQL syntax error on the rollback code. Not sure how it is coming ? It is referring the same code as the develop branch. Ideally rollback should not happen on inserts, but somehow there is a error and the rollback script is getting triggered. The database is sharded across all collections. In the logs I only see this:

Service "/spline" encountered error 400 while handling POST vst://:::8529/_db/spline/spline/execution-events 
via ArangoError: AQL: syntax error, unexpected end of query string near '                ' at position 6:1 (while parsing)
    at ArangoStatement.execute (/arangodb/data/coordinator8529/data/js/server/modules/@arangodb/arango-statement.js:84:16)
    at ArangoDatabase._query (/arangodb/data/coordinator8529/data/js/server/modules/@arangodb/arango-database.js:102:45)
    at t.TxManagerImpl.rollback (/arangodb/data/coordinator8529/apps/_db/spline/spline/APP/index.js:205:4348)
    at t.SubscribableTxManagerDecorator.rollback (/arangodb/data/coordinator8529/apps/_db/spline/spline/APP/index.js:205:2584)
    at /arangodb/data/coordinator8529/apps/_db/spline/spline/APP/index.js:75:1197
    at t.withTimeTracking (/arangodb/data/coordinator8529/apps/_db/spline/spline/APP/index.js:218:422)
    at t.storeExecutionEvent (/arangodb/data/coordinator8529/apps/_db/spline/spline/APP/index.js:61:320)
    at Route._handler (/arangodb/data/coordinator8529/apps/_db/spline/spline/APP/index.js:1:4587)
    at next (/arangodb/data/coordinator8529/data/js/server/modules/@arangodb/foxx/router/tree.js:419:15)
    at next (/arangodb/data/coordinator8529/data/js/server/modules/@arangodb/foxx/router/tree.js:417:7)

Can you help resolve this issue ? Thanks in advance

[wajda]

AQL syntax error might be caused by missing escaping somewhere in the input data during the AQL generation.
By default it only logs a small part of the failed query string that in most cases should be enough for developers to locate it in the code. But in this case the "small part" happened to be just indentation :)

Try to set property spline.database.logFullQueryOnError=true, it will log the entire query.

[vishalag001]

@wajda https://github.com/AbsaOSS/spline/blob/develop/arangodb-foxx-services/src/main/services/txm/tx-manager-impl.ts
As per this file which line is having the issue ?

[wajda]

As I said I don't know. It could be in different file. Try to insert console.log() statements through out the JS code and try to narrow the problem down. The log messages will be visible in arangodb logs (also on logs UI tab).