XF 2.2 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
  
  

  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 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
  #2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
  #3 src/XF/Db/AbstractAdapter.php(147): XF\Db\AbstractAdapter->query('
              SELECT *
          ...', 278564)
  #4 src/XF/Service/Thread/Replier.php(181): XF\Db\AbstractAdapter->fetchRow('
              SELECT *
          ...', 278564)
  #5 src/XF/Service/ValidateAndSavableTrait.php(42): XF\Service\Thread\Replier->_save()
  #6 src/XF/Pub/Controller/Thread.php(616): XF\Service\Thread\Replier->save()
  #7 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Thread->actionAddReply(Object(XF\Mvc\ParameterBag))
  #8 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'AddReply', Object(XF\Mvc\RouteMatch), Object(XFMG\XF\Pub\Controller\Thread), NULL)
  #9 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XFMG\XF\Pub\Controller\Thread), NULL)
  #10 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
  #11 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
  #12 src/XF.php(524): XF\App->run()
  #13 index.php(20): XF::runApp('XF\\Pub\\App')
  #14 {main}
  Request state
  array(4) {
    ["url"] => string(87) "/forums/index.php?threads/what-are-you-listening-to-right-now-and-more.278564/add-reply"
    ["referrer"] => string(110) "https://audiokarma.org/forums/index.php?threads/what-are-you-listening-to-right-now-and-more.278564/page-55170"
    ["_GET"] => array(1) {
      ["threads/what-are-you-listening-to-right-now-and-more_278564/add-reply"] => string(0) ""
    }
    ["_POST"] => array(10) {
      ["_xfToken"] => string(8) "********"
      ["message_html"] => string(498) "<p>Old friends...&nbsp;</p><p><br></p><img src="/forums/index.php?attachments/img_20241024_164527_edit_807818397047565-jpg.3327916/&amp;hash=82f57502a8aa2b44104708f867149232" class="fr-fic fr-dii" status="ok" message="Your changes have been saved." redirect="https://audiokarma.org/forums/index.php?attachments/upload&amp;type=post&amp;context[thread_id]=278564&amp;hash=82f57502a8aa2b44104708f867149232" attachment="[object Object]" visitor="[object Object]" data-attachment="full:3327916"><p></p>"
      ["attachment_hash"] => string(32) "82f57502a8aa2b44104708f867149232"
      ["attachment_hash_combined"] => string(88) "{"type":"post","context":{"thread_id":278564},"hash":"82f57502a8aa2b44104708f867149232"}"
      ["last_date"] => string(10) "1729761994"
      ["last_known_date"] => string(10) "1729761994"
      ["load_extra"] => string(1) "1"
      ["_xfRequestUri"] => string(88) "/forums/index.php?threads/what-are-you-listening-to-right-now-and-more.278564/page-55170"
      ["_xfWithData"] => string(1) "1"
      ["_xfResponseType"] => string(4) "json"
    }
  }

 

[briansol]

increase your wait_timeout setting in mysql.cnf
restart mysql.d