ArcadeDB Version:

ArcadeDB Server v23.2.1 is my main version. I also tried the latest ArcadeDB build but no success.

OS and JDK Version:

Windows 11

Hey guys, I am absolutely wrecking myself here debugging the DB 😭

I'm getting into a situation where some of my queries seem to get the DB stuck, such that although future queries return correctly, new information is not persisted

Like:
Query A -> Result A -> Persist A
Query B -> Result B -> Persist B
Break
Query C -> Result C -> Persist B
Query D -> Result D -> Persist B

I've just been investigating through the console, and I saw a couple of things:

...
|warnings               |1[edge #261:499 points to the outgoing vertex #245:498 that is not found (deleted?)]|
...
|corruptedRecords       |2[#261:499,#245:498]
...

I run the check database fix command and it fixed the corruptions. That seemed to help somewhat at first, however, after continuing to run my server with its queries, I got back into the same problem outlined above and got a probably related error: 2023-09-24 04:16:33.777 SEVER [BucketIterator] Error on loading record #451:4451 (error: User 'root' is not allowed to read records on type 'Building')"

Note: other queries are running fine, it's just the queries relating to these data blocks that seem to mess up. Even once the break happens, the other non-related queries continue to run fine. Restarting fixes things until they break again.

Any help or guidance?