SQL COMMIT with RETRY does not work #1097
Description
(Issue reported on Discord channel by louisP):
We have never been able to overcome the error of
Error on command execution (PostCommandHandler)
com.arcadedb.exception.ConcurrentModificationException: Concurrent modification on page PageId(386/23) in file 'Users_0_out_edges.386.65536.v0.bucket' (current v.78 <> database v.79). Please retry the operation (threadId=40)
When we have an slq script which is runing multiple script one after the other. In this case it is only three scripts, but the pauses and repeats we use just do not work. Do you have any suggestions you can help us with? I read through to see if this issue has been adressed and couldnt find anything, we do the script as follows:
LET photo = CREATE vertex Photos SET id = "182b6562-a60d-41d0-80a5-90aba92a3adf", name = "730c866a-0fe4-4268-81a6-94c31c848daf-thumb717164048000auto.jpg", url = "https://i.iconlookup.com/i-i/730c866a-0fe4-4268-81a6-94c31c848daf-thumb717164048000auto.jpg", thumbnail_path = "https://i.iconlookup.com/i-i/730c866a-0fe4-4268-81a6-94c31c848daf-thumb717164048000auto.jpg", status = "";
LET user = SELECT * FROM Users WHERE id = "92122bab-609a-41f4-86c0-a5fc70795b0c";
LET userEdge = Create edge HasUploaded FROM $user to $photo set type = "User_Photos";commit retry 10;sleep 30;return $photo;Thanks if you or anyone has a solution to allow these to complete.