SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

  • Affected Version
    WoltLab Suite 5.4
    Affected App
    WoltLab Suite Core

    Guten Tag zusammen,


    wir erhalten seit Monaten täglich folgende Fehlermeldung. Es haben sich über die letzten Monate auch Benutzer gemeldet und mitgeteilt, dass teilweise Fehler aufgetreten seien. Die Version des Forums und des Cores ist jeweils die letzte aktuelle (5.4).


    Code
    Could not execute statement 'UPDATE wcf1_user_notification SET confirmTime = ? WHERE confirmTime = ? AND eventID = ? AND userID IN (?) AND objectID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)'

    Ich bin mir recht sicher, dass die Meldung bereits häufiger gepostet wurde. Ist mit 5.5 mit einer Behebung zu rechnen?


    Vollständig:


    Requested URL
    GET /forum/thread/3802-*snip*/?postID=528825
    Referrer
    https://xxx2-forum.de/forum/thread/4706-*snip*/?postID=528859
    Error Message
    Could not execute statement 'UPDATE wcf1_user_notification SET confirmTime = ? WHERE confirmTime = ? AND eventID = ? AND userID IN (?) AND objectID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)'
    Type
    wcf\system\database\exception\DatabaseQueryExecutionException
    File (Line)
    /usr/www/users/xxxxxf/xxx2/forum/lib/system/database/statement/PreparedStatement.class.php (144)
    Stacktrace
    1. /usr/www/users/xxxxxf/xxx2/forum/lib/system/user/notification/UserNotificationHandler.class.php (925): wcf\system\database\statement\PreparedStatement->execute(…)
    2. /usr/www/users/xxxxxf/xxx2/forum/forum/lib/data/thread/ThreadAction.class.php (481): wcf\system\user\notification\UserNotificationHandler->markAsConfirxxx(…)
    3. /usr/www/users/xxxxxf/xxx2/forum/lib/data/AbstractDatabaseObjectAction.class.php (216): wbb\data\thread\ThreadAction->markAsRead(…)
    4. /usr/www/users/xxxxxf/xxx2/forum/forum/lib/page/AbstractThreadPage.class.php (359): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    5. /usr/www/users/xxxxxf/xxx2/forum/forum/lib/page/AbstractThreadPage.class.php (200): wbb\page\AbstractThreadPage->updateThreadVisit(…)
    6. /usr/www/users/xxxxxf/xxx2/forum/forum/lib/page/ThreadPage.class.php (79): wbb\page\AbstractThreadPage->readData(…)
    7. /usr/www/users/xxxxxf/xxx2/forum/lib/page/AbstractPage.class.php (339): wbb\page\ThreadPage->readData(…)
    8. /usr/www/users/xxxxxf/xxx2/forum/lib/page/AbstractPage.class.php (122): wcf\page\AbstractPage->show(…)
    9. /usr/www/users/xxxxxf/xxx2/forum/lib/system/request/Request.class.php (89): wcf\page\AbstractPage->__run(…)
    10. /usr/www/users/xxxxxf/xxx2/forum/lib/system/request/RequestHandler.class.php (119): wcf\system\request\Request->execute(…)
    11. /usr/www/users/xxxxxf/xxx2/forum/forum/index.php (11): wcf\system\request\RequestHandler->handle(…)
    Error Message
    SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
    Type
    PDOException
    File (Line)
    /usr/www/users/xxxxxf/xxx2/forum/lib/system/database/statement/PreparedStatement.class.php (126)
    Stacktrace
    1. /usr/www/users/xxxxxf/xxx2/forum/lib/system/database/statement/PreparedStatement.class.php (126): PDOStatement->execute(…)
    2. /usr/www/users/xxxxxf/xxx2/forum/lib/system/user/notification/UserNotificationHandler.class.php (925): wcf\system\database\statement\PreparedStatement->execute(…)
    3. /usr/www/users/xxxxxf/xxx2/forum/forum/lib/data/thread/ThreadAction.class.php (481): wcf\system\user\notification\UserNotificationHandler->markAsConfirxxx(…)
    4. /usr/www/users/xxxxxf/xxx2/forum/lib/data/AbstractDatabaseObjectAction.class.php (216): wbb\data\thread\ThreadAction->markAsRead(…)
    5. /usr/www/users/xxxxxf/xxx2/forum/forum/lib/page/AbstractThreadPage.class.php (359): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    6. /usr/www/users/xxxxxf/xxx2/forum/forum/lib/page/AbstractThreadPage.class.php (200): wbb\page\AbstractThreadPage->updateThreadVisit(…)
    7. /usr/www/users/xxxxxf/xxx2/forum/forum/lib/page/ThreadPage.class.php (79): wbb\page\AbstractThreadPage->readData(…)
    8. /usr/www/users/xxxxxf/xxx2/forum/lib/page/AbstractPage.class.php (339): wbb\page\ThreadPage->readData(…)
    9. /usr/www/users/xxxxxf/xxx2/forum/lib/page/AbstractPage.class.php (122): wcf\page\AbstractPage->show(…)
    10. /usr/www/users/xxxxxf/xxx2/forum/lib/system/request/Request.class.php (89): wcf\page\AbstractPage->__run(…)
    11. /usr/www/users/xxxxxf/xxx2/forum/lib/system/request/RequestHandler.class.php (119): wcf\system\request\Request->execute(…)
    12. /usr/www/users/xxxxxf/xxx2/forum/forum/index.php (11): wcf\system\request\RequestHandler->handle(…)

    Edited once, last by itsmeJAY ().

  • Tim Düsterhus

    Changed the title of the thread from “Wiederholter Fehler - Could not execute statement” to “SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction”.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!