Welcome Guest, Not a member yet? Register   Sign In
How to cope with deadlocks?
#1

[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



Theme © iAndrew 2016 - Forum software by © MyBB