"Lock wait timeout exceeded try restarting transaction"

, ,
1

Hi All,

I am getting below error message when i am trying to run a adapter query. operations(insert,update and select) is happening successfully but in error logs i see below error.

Error Message :

[ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service
[ADA.1.316] Cannot execute the SQL statement “UPDATE lxk_edr_ap.salesrep_party SET EFF_TO_DT = ?, DELETE_FLAG = ?, UPD_BY = ?, UPDATED_DTTM = ? WHERE MDM_ACCT_ID = ? AND USER_NM = ? OR EFF_TO_DT IS NULL”. "
(41000/1205) Lock wait timeout exceeded; try restarting transaction"
Lock wait timeout exceeded; try restarting transaction
Caused by: com.wm.adk.error.AdapterServiceException: [ADA.1.316] Cannot execute the SQL statement “UPDATE lxk_edr_ap.salesrep_party SET EFF_TO_DT = ?, DELETE_FLAG = ?, UPD_BY = ?, UPDATED_DTTM = ? WHERE MDM_ACCT_ID = ? AND USER_NM = ? OR EFF_TO_DT IS NULL”. "
(41000/1205) Lock wait timeout exceeded; try restarting transaction"
Lock wait timeout exceeded; try restarting transaction
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

Please let me know what is causing any this issue.

Thanks

2

Better to consult a DBA and refer the link Fixing "Lock wait timeout exceeded; try restarting transaction" for a 'stuck" Mysql table? - Stack Overflow

[b]Check InnoDB status for locks

SHOW ENGINE InnoDB STATUS;[/b]