XenForo Site down for two hours because of XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exce

[Mr Shap]

Hi All.

A few hours ago I tried to spam clean a big user. This made the site unusable. Ever since then (2+ hours now) the site is up but anything we try to do results in the same Mysql lock wait error.

Here is the first logged error

• XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction
• src/XF/Db/AbstractStatement.php:228
• Generated by: utropia90
• Mar 15, 2022 at 6:56 PM

Stack trace​

UPDATE xf_forum SET...

Read more

Continue reading...