We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL Error: Lock wait timeout exceeded; try restarting transaction

Received Response
17
Views
1
Comments
edited Mar 29, 2017 12:32AM in Integrations and APIs 1 comment

Content

Hi,

 

We are facing intermittent issue while syncing the contact information from external system via custom script (Connect PHP API). We are getting below error in our log, same request if retried goes without any error.

 

Please suggest/help in this case, support is unable to replicate the issue and no much help is provided as of now.

------------------------------ERROR DETAIL LOG----------------------------------------

<error>
<piid>8062</piid>
<app>0</app>
<common_user_id></common_user_id>
<type>1</type>
<count>00000001</count>
<first_occur>1490681698</first_occur>
<last_occur>1490681698</last_occur>
<msg>
DB API Error
     SQL Fcn: execute() [SQLStatement.cpp: 805] 
   Called By: iapiu_pair_update() [iapi_util.c: 270]

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!