MySQL Forums
Forum List  »  InnoDB

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.

Options: ReplyQuote

Written By
Re: Error: Lock wait timeout exceeded randomly occuring
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.