MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: How to resolve deadlock caused during concurrent inserts into one table
Posted by: Rick James
Date: September 22, 2010 10:53PM

Both of those are trying to insert into the same spot at the same time. InnoDB will abort (ROLLBACK) one of your transactions. All you need to do is catch the error in your code and re-execute the failed transaction.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to resolve deadlock caused during concurrent inserts into one table
16029
Borislav Andruschuk
September 21, 2010 08:23AM
Re: How to resolve deadlock caused during concurrent inserts into one table
5362
DBA Lead
September 22, 2010 06:38PM
Re: How to resolve deadlock caused during concurrent inserts into one table
5095
Rick James
September 22, 2010 10:53PM
Re: How to resolve deadlock caused during concurrent inserts into one table
4337
DBA Lead
September 23, 2010 05:21AM
Re: How to resolve deadlock caused during concurrent inserts into one table
3902
Rick James
September 23, 2010 08:27AM
Re: How to resolve deadlock caused during concurrent inserts into one table
3844
DBA Lead
September 23, 2010 10:27AM
Re: How to resolve deadlock caused during concurrent inserts into one table
3635
Rick James
September 23, 2010 09:21PM
Re: How to resolve deadlock caused during concurrent inserts into one table
3453
DBA Lead
September 26, 2010 06:30AM
Re: How to resolve deadlock caused during concurrent inserts into one table
3521
Rick James
September 26, 2010 09:12AM
Re: How to resolve deadlock caused during concurrent inserts into one table
3489
Borislav Andruschuk
September 29, 2010 12:13PM
Re: How to resolve deadlock caused during concurrent inserts into one table
3170
Rick James
September 29, 2010 06:14PM
Re: How to resolve deadlock caused during concurrent inserts into one table
3593
Borislav Andruschuk
September 30, 2010 01:40PM
Re: How to resolve deadlock caused during concurrent inserts into one table
4076
thushara wijeratna
November 13, 2010 04:22PM
Re: How to resolve deadlock caused during concurrent inserts into one table
3172
Borislav Andruschuk
November 14, 2010 05:44AM


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.