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.
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.