xf_session_activity: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction

  • Thread starter Thread starter PaulB
  • Start date Start date

PaulB

Guest
Member
We recently upgraded from XF1.5.x to XF2.2.7 Patch 1. This was quite an ordeal, as we had a lot of custom add-ons to port, but it's gone relatively well so far. That being said, xf_session_activity has become an issue. Today I woke up to 18 pages of error logs, and that's been happening consistently since we upgraded.

As a disclaimer, we're not using the MEMORY engine, which seems to be the default for xf_session_activity. We can't use it: except under very limited circumstances...

Read more
 
Top