MySQL query error: Deadlock found when trying to get lock in UPDATE xf_user

I've seen a few similar posts, not sure how related this is with them though.
And FWIW, I never saw this error in the last decade running XenForo, but now got it once a day after finally upgrading from v2.2 to v2.3.4.

Code:

                    UPDATE xf_user
                    SET message_count = GREATEST(0, CAST(message_count AS SIGNED) - ?)
                    WHERE user_id = ?
               
------------

#0 src/XF/Db/Mysqli/Statement.php(207)...

Read more

Читать далее...