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

General
1

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

Thank you,
Tim

2

Hi @Tim_Jones ,

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

Regards, Andriy

3

Hi @Andriy_Konoz,

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

Thanks,
Tim

4

@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

5

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.

Tim

6

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.

Regards

7

Hi @viktor.liablin,

The cloud code is in utils.officeSystemSync.

It was either -

image
image1448Ă—753 85.2 KB

Or -

image
image1311Ă—715 76.6 KB

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
}

9

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.

Tim

11

Hello @Tim_Jones

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

Regards,
Volodymyr

1 Like
12

Great. Please keep me updated.

Thanks,
Tim