RSS Feed/News MySQL query error: Deadlock found when trying to get lock in UPDATE xf_user

Status
Not open for further replies.

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
25,459
Points
823

Reputation:

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:

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

Continue reading...
 
Status
Not open for further replies.
Top