How to cope with deadlocks? |
[eluser]kezman[/eluser]
Hey everyone! I've written an application (codeigniter 2) using MySQL InnoDB engine. Recently I've started obtaining 1205 error Code: Lock wait timeout exceeded; try restarting transaction I've optimized the length of my transactions, but it didn't help. I've read http://dev.mysql.com/doc/refman/5.0/en/i...locks.html Quote: Normally, you must write your applications so that they are always prepared to re-issue a transaction if it gets rolled back because of a deadlock. How can I do this using CodeIgniter 2? Thanks in advance! PS I know that I can just increase "lock_wait_timeout" but this is not the best solution, because it doesn't solve the reason. |
Messages In This Thread |
How to cope with deadlocks? - by El Forum - 02-10-2013, 09:32 AM
How to cope with deadlocks? - by El Forum - 02-11-2013, 04:22 AM
How to cope with deadlocks? - by El Forum - 02-11-2013, 04:55 AM
How to cope with deadlocks? - by El Forum - 02-11-2013, 11:54 AM
|