MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Error: Lock wait timeout exceeded randomly occuring
Posted by: Muntaquim Bagadia
Date: December 06, 2017 02:26AM

Thanks Peter.

1. I use mysql version 5.5
2. No, currently it does not retry which is causing an issue.
I am now handling this explicitly and retry it

3. innodb_print_all_deadlocks is OFF, i will turn it on temporarily - thanks!

Based on my analysis, I feel this is caused due to lock on a specific index - which is a sequential number. And especially caused on 2 tables which have an "After insert" trigger which sets a value in the same row which is inserted.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Error: Lock wait timeout exceeded randomly occuring
2535
Muntaquim Bagadia
December 05, 2017 05:20AM
Re: Error: Lock wait timeout exceeded randomly occuring
816
Peter Brawley
December 05, 2017 10:38AM
Re: Error: Lock wait timeout exceeded randomly occuring
674
Muntaquim Bagadia
December 06, 2017 02:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.