XF 2.2 Lock wait timeout exceeded; try restarting transaction in src/XF/Db/AbstractStatement.php at line 230

[Dkf]

I have deleted 5000 messages from a user via "Spam". After that, the forum has error for 2 hours. Help


XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction in src/XF/Db/AbstractStatement.php at line 230

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 79
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
4. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 324
5. XF\Db\AbstractAdapter->update() in src/XF/Repository/ThreadField.php at line 54
6. XF\Repository\ThreadField->rebuildThreadFieldValuesCache() in src/XF/Entity/Thread.php at line 1509
7. XF\Entity\Thread->rebuildThreadFieldValuesCache() in src/XF/Job/Thread.php at line 46
8. XF\Job\Thread->rebuildById() in src/XF/Job/AbstractRebuildJob.php at line 47
9. XF\Job\AbstractRebuildJob->run() in src/XF/Job/Manager.php at line 260
10. XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
11. XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 118
12. XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 122
13. XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
14. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
15. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
16. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2353
18. XF\App->run() in src/XF.php at line 524
19. XF::runApp() in admin.php at line 13

 

[TPerry]

Server issue with MySQL not being properly tuned.
Are you on shared hosting or a vps/dedicated server?

 

[Dkf]

Are you on shared hosting or a vps/dedicated server?

Dedicated server

 

[Dkf]

fixed
all ok