Sunday 15 September 2013

cake_session 1213: Deadlock found when trying to get lock; try restarting transaction

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?

1 comment:

  1. Did you know that that you can make dollars by locking premium sections of your blog or website?
    Simply join AdscendMedia and run their content locking plug-in.

    ReplyDelete