Hi Chris,
Chris Cormack <chris@katipo.co.nz> wrote:
show processlist \g; Is a great command to run in mysql, it will show you what is causing it to lock up. So if you can find the offending query with that command, then we can start to look into why its going bad.
OK this problem has occurs when a Koha admin user was trying to resave a Biblio. Please find attached a file containing the mysql processes, top and vmstat.
From what I understand, it looks like biblio record 2802 or 2671 was being updated, and someone tried to change it while it was being updated? Maybe they navigated back on their browser to a previous web page and changed some details and resubmitted the record? (I don't know, I don't use Koha, I just try to support it! :) )
Thanks, Greg