Fehlermeldung: Could not execute statement

  • Affected Version
    WoltLab Suite 5.3
    Affected App
    WoltLab Suite Core

    Wie gewünscht ein separater Thread für meine Fehlermeldungen die zum Glück bis jetzt nur 1x aufgetreten sind.

    Vielleicht ist es ja wichtig für eventuelle Fehler in der Software...

    Could not execute statement 'INSERT INTO wcf1_user_to_group (userID, groupID) VALUES (?, ?)'

    Sat, 03 Jul 2021 06:43:25 +0000

    Message: Could not execute statement 'INSERT INTO wcf1_user_to_group (userID, groupID) VALUES (?, ?)'

    PHP version: 7.4.18

    WoltLab Suite version: 5.3.9

    Request URI: GET /index.php?register-activation/&u=13056&a=6585a0c81fd3026aebcda3e69946a28481eead52

    Referrer:

    User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36

    Peak Memory Usage: 3302640/536870912

    ======

    Error Class: wcf\system\database\exception\DatabaseQueryExecutionException

    Error Message: Could not execute statement 'INSERT INTO wcf1_user_to_group (userID, groupID) VALUES (?, ?)'

    Error Code: 23000

    File: /var/www/vhosts/xxxxxx.netcup.net/httpdocs/lib/system/database/statement/PreparedStatement.class.php (105)

    Extra Information: YToyOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjEzMDU2O31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjM7fX0=

    Stack Trace: [{"file":"\/var\/www\/vhosts\/xxxxxx.netcup.net\/httpdocs\/lib\/data\/user\/UserProfileAction.class.php","line":472,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/vhosts\/xxxxxx..netcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"updateUserOnlineMarking","class":"wcf\\data\\user\\UserProfileAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx..netcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":441,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx..netcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"removeFromGroups","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx..netcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":352,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx..netcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"update","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx..netcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":694,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx.netcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":651,"function":"enable","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx.netcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"confirmEmail","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx.netcup.net\/httpdocs\/lib\/form\/RegisterActivationForm.class.php","line":103,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx..netcup.net\/httpdocs\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\form\\RegisterActivationForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx..netcup.net\/httpdocs\/lib\/form\/RegisterActivationForm.class.php","line":139,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx.netcup.net\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\form\\RegisterActivationForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx.netcup.net\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx.netcup.net\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxx.netcup.net\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

    ======

    Error Class: PDOException

    Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '13056-3' for key 'userID'

    Error Code: 23000

    File: /var/www/vhosts/xxxxxx.netcup.net/httpdocs/lib/system/database/statement/PreparedStatement.class.php (93)

    Extra Information: -

    Stack Trace: [{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserProfileAction.class.php","line":472,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"updateUserOnlineMarking","class":"wcf\\data\\user\\UserProfileAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":441,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"removeFromGroups","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":352,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"update","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":694,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":651,"function":"enable","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"confirmEmail","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/form\/RegisterActivationForm.class.php","line":103,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\form\\RegisterActivationForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/form\/RegisterActivationForm.class.php","line":139,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\form\\RegisterActivationForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

    Could not execute statement 'UPDATE wcf1_user SET userOnlineGroupID = ? WHERE userID = ?'

    Sat, 03 Jul 2021 06:43:25 +0000

    Message: Could not execute statement 'UPDATE wcf1_user SET userOnlineGroupID = ? WHERE userID = ?'

    PHP version: 7.4.18

    WoltLab Suite version: 5.3.9

    Request URI: GET /index.php?register-activation/&u=13056&a=6585a0c81fd3026aebcda3e69946a28481eead52

    Referrer:

    User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36

    Peak Memory Usage: 3084528/536870912

    ======

    Error Class: wcf\system\database\exception\DatabaseQueryExecutionException

    Error Message: Could not execute statement 'UPDATE wcf1_user SET userOnlineGroupID = ? WHERE userID = ?'

    Error Code: 40001

    File: /var/www/vhosts/xxxxxnetcup.net/httpdocs/lib/system/database/statement/PreparedStatement.class.php (105)

    Extra Information: YToyOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjM7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO2k6MTMwNTY7fX0=

    Stack Trace: [{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserProfileAction.class.php","line":490,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"updateUserOnlineMarking","class":"wcf\\data\\user\\UserProfileAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":441,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"removeFromGroups","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":352,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"update","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":694,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":651,"function":"enable","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"confirmEmail","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/form\/RegisterActivationForm.class.php","line":103,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\form\\RegisterActivationForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/form\/RegisterActivationForm.class.php","line":139,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\form\\RegisterActivationForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

    ======

    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/vhosts/xxxxxnetcup.net/httpdocs/lib/system/database/statement/PreparedStatement.class.php (93)

    Extra Information: -

    Stack Trace: [{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserProfileAction.class.php","line":490,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"updateUserOnlineMarking","class":"wcf\\data\\user\\UserProfileAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":441,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"removeFromGroups","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":352,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"update","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":694,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/user\/UserAction.class.php","line":651,"function":"enable","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"confirmEmail","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/form\/RegisterActivationForm.class.php","line":103,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\form\\RegisterActivationForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/form\/RegisterActivationForm.class.php","line":139,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\form\\RegisterActivationForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/xxxxxnetcup.net\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]


    Danke und Gruß

    mfg

    moere

  • Hallo,

    die beiden Fehlermeldungen deuten darauf hin, dass die identische Anfrage zeitgleich an den Server gesendet wurde. In so einem Fall wird die erste Anfrage korrekt verarbeitet, die zweite wird aber abgewiesen, da diese versucht dieselbe Aktion auszuführen. Das ist erst einmal nicht weiter schlimm, so etwas kann z. B. bei einem Zugriff über eine instabile Internetverbindung auftreten und ist ein Symptom des Verbindungsproblems.

    Alexander Ebert
    Senior Developer WoltLab® GmbH

Participate now!

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