XenForo MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction

[Nirjonadda]

Server error log from update reaction score.

Code:

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

Generated by: Nargish Apr 9, 2019 at 7:23 PM

Stack trace

            UPDATE xf_user
            SET reaction_score = reaction_score + ?
            WHERE user_id = ?
        
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1...

Read more

Continue reading...