XF 1.5 Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction

[jb9826]

I banned a spam bot using the spam cleaner. He posted thousands of posts. I deleted his posts with spam cleaner but only half of them got deleted.
I am trying to manually delete his posts but I keep getting this error when i try to delete a banned users posts.
I disabled every add-on and still get this error

what does it mean?

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
Generated By: jb9826, 9 minutes ago
Stack Trace
#0 /home/myforum/public_html/library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/myforum/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/myforum/public_html/library/XenForo/DataWriter/DiscussionMessage.php(919): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tUPDATE xf_...', 11493)
#3 /home/myforum/public_html/library/XenForo/DataWriter/DiscussionMessage/Post.php(200): XenForo_DataWriter_DiscussionMessage->_updateUserMessageCount(true)
#4 /home/myforum/public_html/library/XenForo/DataWriter/DiscussionMessage.php(840): XenForo_DataWriter_DiscussionMessage_Post->_updateUserMessageCount(true)
#5 /home/myforum/public_html/library/XenForo/DataWriter.php(1793): XenForo_DataWriter_DiscussionMessage->_postDelete()
#6 /home/myforum/public_html/library/XenForo/Model/InlineMod/Post.php(125): XenForo_DataWriter->delete()
#7 /home/myforum/public_html/library/XenForo/ControllerPublic/InlineMod/Abstract.php(125): XenForo_Model_InlineMod_Post->deletePosts(Array, Array, NULL)
#8 /home/myforum/public_html/library/XenForo/ControllerPublic/InlineMod/Post.php(56): XenForo_ControllerPublic_InlineMod_Abstract->executeInlineModAction('deletePosts', Array, Array)
#9 /home/myforum/public_html/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_InlineMod_Post->actionDelete()
#10 /home/myforum/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /home/myforum/public_html/index.php(13): XenForo_FrontController->run()
#12 {main}
Request State
array(3) {
  ["url"] => string(44) "https://myforum123123.com/inline-mod/post/delete"
  ["_GET"] => array(1) {
    ["mod"] => string(4) "post"
  }
  ["_POST"] => array(6) {
    ["hard_delete"] => string(1) "1"
    ["save"] => string(12) "Delete Posts"
    ["posts"] => array(3) {
      [0] => string(8) "75355671"
      [1] => string(8) "75355647"
      [2] => string(8) "75355623"
    }
    ["_xfConfirm"] => string(1) "1"
    ["redirect"] => string(47) "https://myforum123123.com/search/83127027/?mod=post"
    ["_xfToken"] => string(8) "********"
  }
}

and when i try to post a thread into a forum i get this message

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
Generated By: jb9826, 1 minute ago
Stack Trace
#0 /home/myforum/public_html/library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/myforum/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/myforum/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_foru...', Array)
#3 /home/myforum/public_html/library/XenForo/DataWriter.php(1654): Zend_Db_Adapter_Abstract->update('xf_forum', Array, 'node_id = 83')
#4 /home/myforum/public_html/library/XenForo/DataWriter.php(1623): XenForo_DataWriter->_update()
#5 /home/myforum/public_html/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /home/myforum/public_html/library/XenForo/DataWriter/Discussion.php(556): XenForo_DataWriter->save()
#7 /home/myforum/public_html/library/XenForo/DataWriter/Discussion.php(440): XenForo_DataWriter_Discussion->_updateContainerPostSave()
#8 /home/myforum/public_html/library/XenForo/DataWriter.php(1423): XenForo_DataWriter_Discussion->_postSave()
#9 /home/myforum/public_html/library/XenForo/ControllerPublic/Forum.php(830): XenForo_DataWriter->save()
#10 /home/myforum/public_html/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Forum->actionAddThread()
#11 /home/myforum/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /home/myforum/public_html/index.php(13): XenForo_FrontController->run()
#13 {main}
Request State
array(3) {
  ["url"] => string(56) "https://myforum123123.com/forums/forum-talk.83/add-thread"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(12) {
    ["title"] => string(5) "test2"
    ["message_html"] => string(12) "<p>test2</p>"
    ["_xfRelativeResolver"] => string(59) "https://myforum123123.com/forums/forum-talk.83/create-thread"
    ["tags"] => string(0) ""
    ["watch_thread_state"] => string(1) "1"
    ["discussion_open"] => string(1) "1"
    ["_set"] => array(2) {
      ["discussion_open"] => string(1) "1"
      ["sticky"] => string(1) "1"
    }
    ["poll"] => array(5) {
      ["question"] => string(0) ""
      ["responses"] => array(2) {
        [0] => string(0) ""
        [1] => string(0) ""
      }
      ["max_votes_type"] => string(6) "single"
      ["change_vote"] => string(1) "1"
      ["view_results_unvoted"] => string(1) "1"
    }
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(38) "/forums/forum-talk.83/create-thread"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

and when i try to move a thread i get this error

Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 632
Zend_Db_Adapter_Abstract->update() in XenForo/DataWriter.php at line 1654
XenForo_DataWriter->_update() in XenForo/DataWriter.php at line 1623
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
XenForo_DataWriter->save() in XenForo/DataWriter/Discussion.php at line 544
XenForo_DataWriter_Discussion->_updateContainerPostSave() in XenForo/DataWriter/Discussion.php at line 440
XenForo_DataWriter_Discussion->_postSave() in XenForo/DataWriter.php at line 1423
XenForo_DataWriter->save() in XenForo/Model/InlineMod/Thread.php at line 675
XenForo_Model_InlineMod_Thread->moveThreads() in XenForo/ControllerPublic/InlineMod/Thread.php at line 215
XenForo_ControllerPublic_InlineMod_Thread->actionMove() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/myforum/public_html/index.php at line 13

This error is only happening in 1 specific forum.

I tried moving threads out of that forum to a newly fresh created node and i get those errors.

I tried testing on other nodes and no errors. So issue is only on that 1 node.