I’ve come across something quite annoying. We’re about to start moving our Moodle system onto a more powerful machine after a series of issues with the current set up and I’ve been playing around with the test system. When I attempted to update a manual account password I received the following error message:
Timed out while waiting for session lock. Wait for your current requests to finish and try again later.
Debug info:
Error code: sessionwaiterr
A quick Show Full Process list on the database shows the following:
db: moodle
Command: Query
Time: 524
State: preparing
Info: DELETE FROM mdl_sessions WHERE userid IN (SELECT id FROM mdl_user WHERE deleted <> 0)
The only thing we’ve done to the database recently was move from a single INNODB file to a file per table setup, has anyone seen this before?
Thanks,
Andy