MySQL :: Re: Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; try restarting transaction" : for SELECT statement

New Topic

Re: Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; try restarting transaction" : for SELECT statement

Posted by: Anwar Reefat
Date: November 27, 2015 11:34PM

Increasing TransactionDeadlockDetectionTimeout solves the problem.
But i think it's a temporary solution.
Increasing this value will work for few more extra query.
but that has a limit too and after reaching that max limit, again deadLock exception will appear.

But i am wondering why SELECT statement doesn't work concurrently ?

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; try restarting transaction" : for SELECT statement

2306

Anwar Reefat

November 24, 2015 12:15AM

Re: Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; try restarting transaction" : for SELECT statement

1164

Ted Wennmark

November 26, 2015 01:55AM

Re: Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; try restarting transaction" : for SELECT statement

1056

Anwar Reefat

November 27, 2015 11:34PM

Re: Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; try restarting transaction" : for SELECT statement

1460

Ted Wennmark

December 29, 2015 10:17AM

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.