cake_session 1213: Deadlock found when trying to get lock; try restarting
transaction
I moved to a SQL cluster environment with Percona (3 master-master
synchronous nodes, using galera load balancer), and converted all dbs to
InnoDB. we now keep getting this in our CakePHP 1.3 application
2013-09-11 09:16:52 Sql_errors: Session error: (1213: Deadlock found when
trying to get lock; try restarting transaction) -
File:/cake/libs/cake_session.php - Line:759 2013-09-11 09:16:52
Sql_errors: Session error: (1213: Deadlock found when trying to get lock;
try restarting transaction) - File:/cake/libs/cake_session.php - Line:759
2013-09-11 10:54:49 Sql_errors: Session error: (1213: Deadlock found when
trying to get lock; try restarting transaction) -
File:/cake/libs/cake_session.php - Line:759 2013-09-11 11:36:36
Sql_errors: Session error: (1213: Deadlock found when trying to get lock;
try restarting transaction) -
since it's part of the core of CakePHP I am a bit weary of making any
modifications. I wonder if anyone has ever had this problem with CakePHP
and what suggestions might be useful to avoid it?
Did you know that that you can make dollars by locking premium sections of your blog or website?
ReplyDeleteSimply join AdscendMedia and run their content locking plug-in.