[eluser]stevefink[/eluser]
Hey folks,
I'm dealing with a block of code that deals heavily with transactions. However, it seems that there is a locked thread or some kind of locked status somewhere (even after gracefully restarted the database).
I keep seeing this in my system logs appear:
ERROR - 2008-03-23 17:45:45 --> Query error: Lock wait timeout exceeded; try restarting transaction
As far as I'm aware, you can only ROLLBACK within the current thread that's executing the transaction -- so I'm not entirely sure how to reset this lock. Better than resetting it, I would like to ultimately learn how the lock was not cleaned up as it's not affecting the rest of my issues.
Anyway, I'm almost certain this isn't a CI specific error. But, perhaps one of you also ran into it.
Thank you for your insight,
/sf