Fehler: user_notification

TeRRible__KHONS · Aug 31st 2020

Hallo,

Mir wurde ein Fehler von einem User gemeldet:

Quote

Hi Team

Ich hab soeben auf meinem Iphone über Safarie, die Fehlermeldung bekommen die im Bild zu sehen ist.

Dachte mir ich teil euch das hier mal mir.

74835860ac55815634e1fefb974d2736de7

Passiert ist das ganze, als ich oben rechts auf den Buddy geklickt hab, dann auf benachrichtigungen und dann auf ein Thema geklickt hab.

Requested URL: /thread/XXX

Referrer: https://domain.tld/cms/conversation/XXX

Error Message: Could not execute statement 'DELETE FROM wcf1_user_notification_to_user WHERE notificationID NOT IN ( SELECT notificationID FROM wcf1_user_notification WHERE confirmTime = ? )'

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (105)

Query Parameter 1: 0

Stacktrace

/var/www/domain.tld/public/cms/lib/system/user/notification/UserNotificationHandler.class.php (856): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/domain.tld/public/lib/data/thread/ThreadAction.class.php (424): wcf\system\user\notification\UserNotificationHandler->markAsConfirmed(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (205): wbb\data\thread\ThreadAction->markAsRead(…)
/var/www/domain.tld/public/lib/page/AbstractThreadPage.class.php (324): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/domain.tld/public/lib/page/AbstractThreadPage.class.php (179): wbb\page\AbstractThreadPage->updateThreadVisit(…)
/var/www/domain.tld/public/lib/page/ThreadPage.class.php (62): wbb\page\AbstractThreadPage->readData(…)
/var/www/domain.tld/public/cms/lib/page/AbstractPage.class.php (291): wbb\page\ThreadPage->readData(…)
/var/www/domain.tld/public/cms/lib/page/AbstractPage.class.php (114): wcf\page\AbstractPage->show(…)
/var/www/domain.tld/public/cms/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/domain.tld/public/cms/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/domain.tld/public/index.php (9): 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): /var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (93)

Stacktrace

/var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
/var/www/domain.tld/public/cms/lib/system/user/notification/UserNotificationHandler.class.php (856): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/domain.tld/public/lib/data/thread/ThreadAction.class.php (424): wcf\system\user\notification\UserNotificationHandler->markAsConfirmed(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (205): wbb\data\thread\ThreadAction->markAsRead(…)
/var/www/domain.tld/public/lib/page/AbstractThreadPage.class.php (324): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/domain.tld/public/lib/page/AbstractThreadPage.class.php (179): wbb\page\AbstractThreadPage->updateThreadVisit(…)
/var/www/domain.tld/public/lib/page/ThreadPage.class.php (62): wbb\page\AbstractThreadPage->readData(…)
/var/www/domain.tld/public/cms/lib/page/AbstractPage.class.php (291): wbb\page\ThreadPage->readData(…)
/var/www/domain.tld/public/cms/lib/page/AbstractPage.class.php (114): wcf\page\AbstractPage->show(…)
/var/www/domain.tld/public/cms/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/domain.tld/public/cms/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/domain.tld/public/index.php (9): wcf\system\request\RequestHandler->handle(…)

Sun, 30 Aug 2020 14:59:29 +0000
Message: Could not execute statement 'DELETE FROM    wcf1_user_notification_to_user             WHERE        notificationID NOT IN (                         SELECT    notificationID                         FROM    wcf1_user_notification                         WHERE    confirmTime = ?                     )'
PHP version: 7.4.9
WoltLab Suite version: 5.2.9
Request URI: /thread/XXX
Referrer: https://domain.tld/cms/conversation/XXX
User Agent: Mozilla/5.0 (iPhone; CPU iPhone OS 13_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.2 Mobile/15E148 Safari/604.1
Peak Memory Usage: 4671272/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'DELETE FROM    wcf1_user_notification_to_user             WHERE        notificationID NOT IN (                         SELECT    notificationID                         FROM    wcf1_user_notification                         WHERE    confirmTime = ?                     )'
Error Code: 40001
File: /var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YToxOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjA7fX0=
Stack Trace: [{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/user\/notification\/UserNotificationHandler.class.php","line":856,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/data\/thread\/ThreadAction.class.php","line":424,"function":"markAsConfirmed","class":"wcf\\system\\user\\notification\\UserNotificationHandler","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"markAsRead","class":"wbb\\data\\thread\\ThreadAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/page\/AbstractThreadPage.class.php","line":324,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/page\/AbstractThreadPage.class.php","line":179,"function":"updateThreadVisit","class":"wbb\\page\\AbstractThreadPage","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/page\/ThreadPage.class.php","line":62,"function":"readData","class":"wbb\\page\\AbstractThreadPage","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wbb\\page\\ThreadPage","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
Error Code: 40001
File: /var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/user\/notification\/UserNotificationHandler.class.php","line":856,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/data\/thread\/ThreadAction.class.php","line":424,"function":"markAsConfirmed","class":"wcf\\system\\user\\notification\\UserNotificationHandler","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"markAsRead","class":"wbb\\data\\thread\\ThreadAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/page\/AbstractThreadPage.class.php","line":324,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/page\/AbstractThreadPage.class.php","line":179,"function":"updateThreadVisit","class":"wbb\\page\\AbstractThreadPage","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/page\/ThreadPage.class.php","line":62,"function":"readData","class":"wbb\\page\\AbstractThreadPage","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wbb\\page\\ThreadPage","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

EDIT: Kann geschlossen werden, hatte den Fehler bereits gemeldet, ist wieder dieser Deadlock-Fehler.

Woodmen · Aug 31st 2020

Quote from TeRRible__KHONS

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

Edit: Mist. Hatte deinen Edit zu spät gesehen. Sorry!

Fehler: user_notification

Participate now!

Share