Announcement

Collapse
No announcement yet.

Database error 5.05: Deadlock found when trying to get lock; try restarting transaction

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error 5.05: Deadlock found when trying to get lock; try restarting transaction

    Dear All,

    I received the following database error in my mailbox, does anybody what happened and if i can do something about it?

    Database error in vBulletin 5.0.5:

    Invalid SQL:
    UPDATE vbulletin_node SET
    textcount =
    CASE WHEN 1 > 0 OR textcount > -1 * 1
    THEN textcount + (1)
    ELSE 0 END,
    textunpubcount =
    CASE WHEN 0 > 0 OR textunpubcount > -1 * 0
    THEN textunpubcount + (0)
    ELSE 0 END
    WHERE nodeid = 20048
    /**UpdateParentCount**/;

    MySQL Error : Deadlock found when trying to get lock; try restarting transaction
    Error Number : 1213
    Request Date : Tuesday, March 11th 2014 @ 12:30:37 PM
    Error Date : Tuesday, March 11th 2014 @ 12:30:49 PM
    Script : http:///create-content/text/
    Referrer : http://www.wijhebbensarcoidose.nl/fo...len-thea/page2
    IP Address : ******************
    Username : theetje
    Classname : vB_Database_MySQL
    MySQL Version :

  • #2
    This is a known bug. But I don't know if it will be fixed in 5.1.

    It won't cause much trouble though.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X