SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock

TeRRible__KHONS · Jun 22nd 2020

Hallo,

Wurde heute wieder auf einen Fehler aufmerksam (einmalig) aber möglicherweise ein race condition:

Requested URL: /thread/13534-abluft-zu-laut/?postID=329868

Referrer: https://domain.tld/thread/13534-abluft-zu-laut/?postID=329875

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(…)
[internal function] (?): wbb\data\thread\ThreadAction->markAsRead(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (205): call_user_func(…)
/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(…)
[internal function] (?): wbb\data\thread\ThreadAction->markAsRead(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (205): call_user_func(…)
/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, 21 Jun 2020 22:00:11 +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.7
WoltLab Suite version: 5.2.6
Request URI: /thread/13534-abluft-zu-laut/?postID=329868
Referrer: https://domain.tld/thread/13534-abluft-zu-laut/?postID=329875
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.106 Safari/537.36
Peak Memory Usage: 4575248/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":[]},{"function":"markAsRead","class":"wbb\\data\\thread\\ThreadAction","type":"->","file":"[internal function]","line":"?","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","class":"","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":[]},{"function":"markAsRead","class":"wbb\\data\\thread\\ThreadAction","type":"->","file":"[internal function]","line":"?","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","class":"","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":[]}]

**Tim Düsterhus** · Jun 26th 2020

Hallo,

in solchen Fällen bitte, möglichst bald nach Auftreten des Fehlers das Ergebnis von SHOW ENGINE InnoDB STATUS ermitteln und sichern. Gerne dann im Rahmen eines TIckets bereitstellen. Generisch und „nachdem es passiert ist“ lassen sich derartige Deadlocks praktisch nicht analysieren.

TeRRible__KHONS · Jun 26th 2020

War auch nur einmalig bisher und genauso ist es unmöglich für mich das gleich nach dem Auftreten des Fehlers zu analysieren, sitze ja auch nicht 24/24 vor der konsole

Aber danke der Untersuchung, wenns nochmals vorkommt gebe ich bescheid.

TeRRible__KHONS · Jul 1st 2020

Hallo,

Heute wieder diese Fehlermeldung:

Requested URL: /thread/XXXX

Referrer

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

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: 1593566574

Query Parameter 2: 25

Query Parameter 3: 6499

Query Parameter 4: 328157

Query Parameter 5: 328166

Query Parameter 6: 328319

Query Parameter 7: 328753

Query Parameter 8: 329897

Query Parameter 9: 329908

Query Parameter 10: 329917

Query Parameter 11: 329925

Query Parameter 12: 329978

Query Parameter 13: 330121

Query Parameter 14: 331044

Query Parameter 15: 331046

Query Parameter 16: 331050

Stacktrace

/var/www/domain.tld/public/cms/lib/system/user/notification/UserNotificationHandler.class.php (837): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/domain.tld/public/lib/data/thread/ThreadAction.class.php (478): wcf\system\user\notification\UserNotificationHandler->markAsConfirmed(…)
[internal function] (?): wbb\data\thread\ThreadAction->markLikeNotificationsAsConfirmed(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (205): call_user_func(…)
/var/www/domain.tld/public/lib/page/AbstractThreadPage.class.php (329): 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 (837): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/domain.tld/public/lib/data/thread/ThreadAction.class.php (478): wcf\system\user\notification\UserNotificationHandler->markAsConfirmed(…)
[internal function] (?): wbb\data\thread\ThreadAction->markLikeNotificationsAsConfirmed(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (205): call_user_func(…)
/var/www/domain.tld/public/lib/page/AbstractThreadPage.class.php (329): 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(…)

Wed, 01 Jul 2020 01:22:54 +0000
Message: Could not execute statement 'UPDATE    wcf1_user_notification             SET    confirmTime = ?             WHERE eventID = ? AND userID IN (?) AND objectID IN (?,?,?,?,?,?,?,?,?,?,?,?,?)'
PHP version: 7.4.7
WoltLab Suite version: 5.2.7
Request URI: /thread/XXXX
Referrer: 
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36 OPR/68.0.3618.173
Peak Memory Usage: 5222920/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'UPDATE    wcf1_user_notification             SET    confirmTime = ?             WHERE eventID = ? AND userID IN (?) AND objectID IN (?,?,?,?,?,?,?,?,?,?,?,?,?)'
Error Code: 40001
File: /var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YToxNjp7aTowO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAxIjtpOjE7aToxNTkzNTY2NTc0O31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjI1O31pOjI7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDMiO2k6MTtpOjY0OTk7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO2k6MzI4MTU3O31pOjQ7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDUiO2k6MTtpOjMyODE2Njt9aTo1O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA2IjtpOjE7aTozMjgzMTk7fWk6NjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNyI7aToxO2k6MzI4NzUzO31pOjc7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDgiO2k6MTtpOjMyOTg5Nzt9aTo4O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA5IjtpOjE7aTozMjk5MDg7fWk6OTthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTAiO2k6MTtpOjMyOTkxNzt9aToxMDthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTEiO2k6MTtpOjMyOTkyNTt9aToxMTthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTIiO2k6MTtpOjMyOTk3ODt9aToxMjthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTMiO2k6MTtpOjMzMDEyMTt9aToxMzthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTQiO2k6MTtpOjMzMTA0NDt9aToxNDthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTUiO2k6MTtpOjMzMTA0Njt9aToxNTthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTYiO2k6MTtpOjMzMTA1MDt9fQ==
Stack Trace: [{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/user\/notification\/UserNotificationHandler.class.php","line":837,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/data\/thread\/ThreadAction.class.php","line":478,"function":"markAsConfirmed","class":"wcf\\system\\user\\notification\\UserNotificationHandler","type":"->","args":[]},{"function":"markLikeNotificationsAsConfirmed","class":"wbb\\data\\thread\\ThreadAction","type":"->","file":"[internal function]","line":"?","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","class":"","type":"","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/page\/AbstractThreadPage.class.php","line":329,"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":837,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/data\/thread\/ThreadAction.class.php","line":478,"function":"markAsConfirmed","class":"wcf\\system\\user\\notification\\UserNotificationHandler","type":"->","args":[]},{"function":"markLikeNotificationsAsConfirmed","class":"wbb\\data\\thread\\ThreadAction","type":"->","file":"[internal function]","line":"?","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","class":"","type":"","args":[]},{"file":"\/var\/www\/domain.tld\/public\/lib\/page\/AbstractThreadPage.class.php","line":329,"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":[]}]

rs90 · Jul 1st 2020

Quote from Tim Düsterhus

Hallo,

in solchen Fällen bitte, möglichst bald nach Auftreten des Fehlers das Ergebnis von SHOW ENGINE InnoDB STATUS ermitteln und sichern. Gerne dann im Rahmen eines TIckets bereitstellen. Generisch und „nachdem es passiert ist“ lassen sich derartige Deadlocks praktisch nicht analysieren.

Und hast du dies diesesmal gemacht?

TeRRible__KHONS · Jul 1st 2020

Quote from TeRRible__KHONS

genauso ist es unmöglich für mich das gleich nach dem Auftreten des Fehlers zu analysieren, sitze ja auch nicht 24/24 vor der konsole

Quote from TeRRible__KHONS

Wed, 01 Jul 2020 01:22:54 +0000

Irgendwo, irgendwas muss ja hier die Tabelle oder so, blockieren.

**Tim Düsterhus** · Jul 1st 2020

Hallo,

Quote from TeRRible__KHONS

Irgendwo, irgendwas

und genau dieses „irgendwo, irgendwas“ ist der Grund, warum die Ausgabe der genannten Abfrage relevant ist. Alternativ kannst du den MySQL-Server auch alle Deadlocks in die Logdatei loggen lassen, die Ausgabe in der Logdatei ist aber bei weitem nicht so präzise.

TeRRible__KHONS · Jul 1st 2020

Ist jedoch komisch dass es immer zu anderen Zeiten vorkommt und immer die user_notification davon betoffen ist. Jedoch nicht immer sondern nur spontan:

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

Sehr schwer zu lokalisieren also.

EDIT: Werden diese errors nicht default irgendwo geloggt sodass ich nachschauen kann?

TeRRible__KHONS · Jul 1st 2020

Hier noch ein Screenshot meiner installierten Plugins (eventuell hilft das):

Man sieht es ist hier relativ einfach und nicht überladen, daher weiß ich nicht was hier den Deadlock provozieren könnte, vielleicht das Community Bot von UdoZ dieses greift ja öfters und automatisch auf die Notifications ein.

UdoZ · Jul 1st 2020

Quote from TeRRible__KHONS

vielleicht das Community Bot von UdoZ dieses greift ja öfters und automatisch auf die Notifications ein.

Das ist so nicht korrekt. Der Bot greift da in keinster Weise ein.

TeRRible__KHONS · Jul 1st 2020

War nur eine Vermutung, keiner der anderen Plugins außer das Community Bot und die Standart-Plugins von Woltlab haben irgendwas mit den Notifications zu tun.

Susi · Feb 14th 2021

Ich hab das auch ab und an, aber keinen Community Bot installiert.

TeRRible__KHONS · Feb 14th 2021

Hatte es jetzt einige Zeit nicht mehr, nicht rausgefundne an was es liegt, aber denke nicht am Communit bot

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock

Tim Düsterhus Jun 26th 2020

Tim Düsterhus Jul 1st 2020

Participate now!

Share

Similar Threads

SQL Fehlermeldung bei Aktualisierung Beitragszähler