[#290] Serialization Error

API General
,
1

Migrated from Redmine #290 | Author: Anonymous
Status: New | Priority: Normal | Created: 2018-11-20

I’m getting this error on the server when calling addServiceProvider or setWorkDayInfo:

JSONRpcClientException {

code: -32000,
message: ‘SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction’ }

Any ideas?

2

Redmine Admin wrote:

please provide raw http request

3

Anonymous wrote:

Looks like what was happening was I was hitting the simplybook.me API too fast. I was looping over about 5 requests to send to setWorkDayInfo and once I throttled the loop to once every two seconds the error stopped. Sadly SBM can’t handle high frequency requests.

4

Anonymous wrote:

Nevermind, I’m still getting the error even with it throttled to 2 seconds though far less frequent.

5

Anonymous wrote:

I don’t have access to the http request. This is being sent via a serverless cloud function from firebase not the browser.

6

Redmine Admin wrote:

we can’t help you without http request unfortunately

7

Anonymous wrote:

{
“jsonrpc”: “2.0”,
“method”: “setWorkDayInfo”,
“params”:
[{
“start_time”:“”,
“end_time”:“”,
“is_day_off”:1,
“breaktime”:[{“start_time”:“”, “end_time”:“”}],
“index”:“2”,
“name”:“”,
“date”:“”,
“unit_group_id”:“xxx”
“event_id”:“”
}],
“id”: 1
}

8

Redmine Admin wrote:

You need to pass date and name