XenForo Can't post to some nodes, server errors

[grumpy2]

Getting a lot of these timeout errors in the admin console. How do I find and kill the offending process in phpMyAdmin?

• XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction
  
  Code:
  
  

  Stack trace            SELECT *
              FROM xf_thread
              WHERE thread_id = ?
              FOR UPDATE
          
  ------------
  
  #0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
  #1...

Read more

Continue reading...