Could not execute statement 'UPDATE chat1_room_to_user SET lastPush = ? WHERE roomID = ? AND userID = ?'

Shalin · Dec 12th 2020

Hallo, ich habe einen Fehler, ich glaub, der hat was mit dem Chat und Push zu tun?

Code

Sat, 12 Dec 2020 16:19:10 +0000
Message: Could not execute statement 'UPDATE chat1_room_to_user SET lastPush = ? WHERE roomID = ? AND userID = ?'
PHP version: 7.4.10
WoltLab Suite version: 5.3.1
Request URI: POST /wsc/chat/index.php?ajax-proxy/&t=ff6bb465382e2ddc461e2afa35f1054744ea0e7d
Referrer: https://seelenschreiberei.org/wsc/chat/room/3-lobby/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36
Peak Memory Usage: 14532744/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'UPDATE chat1_room_to_user SET lastPush = ? WHERE roomID = ? AND userID = ?'
Error Code: 40001
File: /www/htdocs/w018f428/seelenschreiberei.org/wsc/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTozOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjE2MDc3ODk5NTA7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO2k6Mzt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aToxMzQ7fX0=
Stack Trace: [{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/chat\/lib\/data\/message\/MessageAction.class.php","line":39,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"chat\\data\\message\\MessageAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/chat\/lib\/system\/command\/PlainCommand.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/chat\/lib\/data\/message\/MessageAction.class.php","line":306,"function":"execute","class":"chat\\system\\command\\PlainCommand","type":"->","args":[{"text":"[redacted]"},"chat\\data\\room\\Room"]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"push","class":"chat\\data\\message\\MessageAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/chat\/index.php","line":16,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["chat"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
Error Code: 40001
File: /www/htdocs/w018f428/seelenschreiberei.org/wsc/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/chat\/lib\/data\/message\/MessageAction.class.php","line":39,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"chat\\data\\message\\MessageAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/chat\/lib\/system\/command\/PlainCommand.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/chat\/lib\/data\/message\/MessageAction.class.php","line":306,"function":"execute","class":"chat\\system\\command\\PlainCommand","type":"->","args":[{"text":"[redacted]"},"chat\\data\\room\\Room"]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"push","class":"chat\\data\\message\\MessageAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w018f428\/seelenschreiberei.org\/wsc\/chat\/index.php","line":16,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["chat"]}]

Display More

**Tim** · Dec 13th 2020

Hallo,

Quote from ZeroGravity

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

das kann mitunter vorkommen. Wenn das nicht auf einer regelmäßigen Basis passiert, dann kann der Fehler ignoriert werden.

Shalin · Dec 13th 2020

Quote from Tim

Hallo,

Quote from ZeroGravity

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

das kann mitunter vorkommen. Wenn das nicht auf einer regelmäßigen Basis passiert, dann kann der Fehler ignoriert werden.

Hallo Tim,

der Fehler kommt in regelmäßigen Abständen.

Was bedeutet der Fehler und was kann ich jetzt machen?

Liebe Grüße,

ZeroGravity

**Tim** · Dec 15th 2020

Hallo,

die Problematik ist schwierig für technische Laien zu erklären. Im Wesentlichen bedeutet das, dass zwei gleichzeitige Anfragen auf besondere Weise auf die gleichen Daten zugreifen und sich gegenseitig blockieren.

Eine Lösung dafür lässt sich praktisch nur finden, wenn man an die detaillierten Logs des Datenbankservers kommt (SHOW ENGINE InnoDB STATUS). Das kann aber nur der Webhoster und das dann auch nur kurz nachdem der Fehler aufgetreten ist.

Ohne die Ausgabe von dem Befehl ist das ganze nur Rätsel raten.

Shalin · Dec 16th 2020

Hallo Tim,

wir hosten bei all-inkl.com und sie sagen, sie haben keine Logs von den Datenbankservern.

Quote

"Unser Datenbank-Server verfügt leider über keine Protokolle."

Was können wir denn jetzt tun? Kann das Forum kaputt gehen? Macht es Sinn, den Anbieter zu wechseln?

**Tim** · Dec 19th 2020

Hallo,

Quote from ZeroGravity

Was können wir denn jetzt tun? Kann das Forum kaputt gehen? Macht es Sinn, den Anbieter zu wechseln?

Die Fehlermeldung ist in der Form recht unkritisch. Möglicherweise werden einzelne Chatnachrichten verschluckt, das Forum kann dadurch nicht kaputt gehen. Ein Anbieterwechsel ist ebenfalls nicht unbedingt notwendig.

Shalin · Dec 20th 2020

Okay danke für deine Antwort, gut, dass das Forum dadurch nicht kaputtgehen kann.

mmaark · Mar 16th 2021

all-inkl.com verbietet Chats zum Beispiel.

Vielleicht ist deswegen die Fehlermeldung?

https://all-inkl.com/webhosting/verbotenes/

Shalin · Jan 16th 2022

Ich habe den Fehler mittlerweile in 3 verschiedenen Installationen auf 3 verschiedenen Servern, liegt das dann vielleicht doch am Chat? Der Fehler taucht auch regelmäßig auf.

thedoctor · Jul 10th 2022

Hallo, bei uns tritt der Fehler auch vermehrt auf, ich habe den Code unten angehängt. Vielleicht kannst kannst du daraus etwas ableiten und bestenfalls sagen, woran es liegt.

Code

Sun, 10 Jul 2022 06:39:25 +0000
Message: Could not execute statement 'UPDATE  chat1_room_to_user                     SET     lastPush = ?                     WHERE   roomID = ?                         AND userID = ?'
PHP version: 7.4.28
WoltLab Suite version: 5.4.20
Request URI: POST /chat/index.php?ajax-proxy/&t=c185cb875c12a23f955006b2ed5eedc213575e4545fa71a03faa5e36e93243bf-lv0CouUEpQ76unhtCuVLXQ==
Referrer: https://borderline-forum.eu/chat/room/1-lobby/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36
Peak Memory Usage: 10201576/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'UPDATE  chat1_room_to_user                     SET     lastPush = ?                     WHERE   roomID = ?                         AND userID = ?'
Error Code: 40001
File: /customers/shalin/home/borderline-forum.eu/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YTozOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjE2NTc0MzUxNjU7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO2k6MTt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aTo0Mzt9fQ==
Stack Trace: [{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/chat\/lib\/data\/message\/MessageAction.class.php","line":56,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"create","class":"chat\\data\\message\\MessageAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/chat\/lib\/system\/command\/PlainCommand.class.php","line":94,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/chat\/lib\/data\/message\/MessageAction.class.php","line":398,"function":"execute","class":"chat\\system\\command\\PlainCommand","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"push","class":"chat\\data\\message\\MessageAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/RequestHandler.class.php","line":121,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/chat\/index.php","line":20,"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: /customers/shalin/home/borderline-forum.eu/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/chat\/lib\/data\/message\/MessageAction.class.php","line":56,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"create","class":"chat\\data\\message\\MessageAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/chat\/lib\/system\/command\/PlainCommand.class.php","line":94,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/chat\/lib\/data\/message\/MessageAction.class.php","line":398,"function":"execute","class":"chat\\system\\command\\PlainCommand","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"push","class":"chat\\data\\message\\MessageAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/RequestHandler.class.php","line":121,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/chat\/index.php","line":20,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

Display More

Gruß,

thedoctor