Cypher idempotent query : `...Multi-page record #10:4495 was modified during read...`

[vitoprr]

Hello,

cc @ExtReMLapin

Version : built on HEAD with this PR fix : #3392

At the office, we're running this idempotent query which fails to execute (not easy reproduction)

Query :

MATCH ()-[r]->()
RETURN COUNT(r) AS count

Return :

Record #10:4495 not found -> Multi-page record #10:4495 was modified during read (page PageId(TEST/10/2) version changed from 337 to 338). Please retry the operation

To us, we expect it to work on an ACID compliant database.

All queries are ran using REST API

Have a wonderful day ~~

[lvca]

The issue is a concurrent read+write on same pages. Normally this is automatically managed by the transaction. If you always wraps it in a transaction, it work. But @ExtReMLapin is right, it should be easier to handle this common use case. Coming up with an idea

[lvca]

@ExtReMLapin and @vitoprr what if we add a autoCommit parameter in the request? If true (default is false, for backward compatibility), the query and command are wrapped in a transaction. WDYT?

{
  "language": "sql",
  "command": "INSERT INTO Person SET name='\''Alice'\''", 
  "autoCommit": true
}

And same for /query?

[lvca]

It's already in the main branch. @ExtReMLapin and @vitoprr please let me know if setting "autoCommit":true resolves the issue