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