Re: Deadlock issue and table lock frequently
Posted by:
Rick James
Date: August 22, 2015 01:45PM
Look at your code. Check for "transactions". See if the "85" is being generated in a non-transacton-safe way. Etc.
The problem is in the application, not InnoDB. It makes no sense for one thread to be updating a row that is being inserted. The Updater should not know that the row exists yet. How did the Update think that "85" existed??
Subject
Views
Written By
Posted
2309
August 07, 2015 02:57AM
893
August 07, 2015 10:09PM
978
August 17, 2015 02:50AM
904
August 18, 2015 09:23PM
2995
August 20, 2015 12:06AM
Re: Deadlock issue and table lock frequently
1127
August 22, 2015 01:45PM
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.