Deep save exception. Lock wait timeout exceeded; try restarting transaction

I get these from time to time. What is the cause, and any suggestions on how to prevent this or manage it?

Thank you,

Hi @Tim_Jones ,

Could you, please, provide ID of application where you receive this error?

Regards, Andriy

Hi @Andriy_Konoz,

The app Id is EEE25B20-17FA-97DD-FF29-EC45A5072A00.


@Tim_Jones ,

What kind of structure are you trying to save when you get such error?
This error comes from DB and caused by fact that something locks rows which “deep save” tries to update. I try to uderstand what may cause such locks.

Regards, Andriy

Hi @Andriy_Konoz

I have two or three deep saves in the cloud code that threw this error. I will update the code to wrap each deep save in a try/catch to narrow down which deep save is causing the problem.

I received seven deep save errors on March 6th between 7:00 - 7:06 am ET and none since then. This code runs hourly to synchronize data between Backendless and another system. To have it start throwing errors with no changes made me wonder if you were having issues.


Hello @Tim_Jones

Please tell us where in the cloud code you use the deep save methods.

Do you have the data or the data structure was used between 7:00 - 7:06 am?

In try/catch wrapper save the data used in the deep save method.


Hi @viktor.liablin,

The cloud code is in utils.officeSystemSync.

It was either -

Or -

This is what the officeSystemRow variable contains (XXX out private data) -

“SchoolId”: “XXXXXXXXX”,
“School”: “XXXXXXXXX”,
“Address”: “XXXXXXXXX”,
“City”: “XXXXXXXXX”,
“State”: “XXXXXXXXX”,
“Zipcode”: “XXXXXXXXX”,
“EMail”: null,
“SalesRepId”: “11”,
“SalesRepEmail”: “XXXXXXXXX”,
“TotalStudentNumber”: “XXXXXXXXX”,
“Sponsor”: “XXXXXXXXX”,
“SpEmail”: “XXXXXXXXX”,
“SpPhone_Cell”: “XXXXXXXXX”,
“Sale_Start”: “2024-03-18 00:00:00.000”,
“Sale_End”: “2024-04-01 00:00:00.000”,
“Target_Deliv”: null,
“Status”: “1”,
“StatusDate”: “2024-03-05 00:00:00.000”,
“CRD”: “0”,
“HomeDeliv”: “0”,
“NoCandy”: “1”,
“NoMags”: “0”,
“Catalogs”: “112,899”,
“PassiveDate”: null

I received another notification of the same error: “Deep save exception. Lock wait timeout exceeded; try restarting transaction”. This happened on Mar 18, 2024, 6:14 AM ET.

This was from different logic, but in both cases I’m doing a loop to update many records.


Hello @Tim_Jones

It seems we have found the reason, we are working on its solution.


1 Like

Great. Please keep me updated.