MySQL Forums
Forum List  »  InnoDB

MySQL lock time out exceeds, restart the transaction
Posted by: Prashant Palo
Date: July 16, 2018 01:18PM

We rae using innodb engine, storedprocedure is used for insert, update transactions from web front end. Frequently getting hang situation, the error captured is, locks time exceeds, restart the transaction, error 1205 hy00.
Checked the resource, performance, rverything normal, table is also very small.
Frequent deadlocks happening as saying record lock on index primary.
Please help to resolve the issue.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.