Hallo zusammen,
heute morgen habe ich zwei Contao Installationen von 5.2.8 auf 5.3 upgedatet. Die Updates liefen problemlos und die Seiten funktionieren soweit einwandfrei.
Seitdem gibt es allerdings bei jedem Cronjob-Aufruf etliche Fehlermeldungen bzgl. max_user_connections in den Log-Dateien. Hier ein Auszug:
Code:
[2024-02-18T20:40:23.227068+01:00] console.CRITICAL: Error thrown while running command "messenger:consume --time-limit=60 --sleep=5 contao_prio_high". Message: "An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1203): An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)","command":"messenger:consume --time-limit=60 --sleep=5 contao_prio_high","message":"An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections"} []
[2024-02-18T20:40:23.228826+01:00] console.CRITICAL: Error thrown while running command "messenger:consume --time-limit=60 --sleep=10 contao_prio_normal". Message: "An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1203): An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)","command":"messenger:consume --time-limit=60 --sleep=10 contao_prio_normal","message":"An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections"} []
[2024-02-18T20:40:28.286152+01:00] console.CRITICAL: Error thrown while running command "messenger:consume --time-limit=60 --sleep=5 contao_prio_high". Message: "An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1203): An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)","command":"messenger:consume --time-limit=60 --sleep=5 contao_prio_high","message":"An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections"} []
[2024-02-18T20:40:28.286574+01:00] console.CRITICAL: Error thrown while running command "messenger:consume --time-limit=60 --sleep=10 contao_prio_normal". Message: "An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1203): An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)","command":"messenger:consume --time-limit=60 --sleep=10 contao_prio_normal","message":"An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections"} []
[2024-02-18T20:40:28.301905+01:00] console.CRITICAL: Error thrown while running command "messenger:consume --time-limit=60 --sleep=20 contao_prio_low". Message: "An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1203): An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)","command":"messenger:consume --time-limit=60 --sleep=20 contao_prio_low","message":"An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections"} []
[2024-02-18T20:40:33.323472+01:00] console.CRITICAL: Error thrown while running command "messenger:consume --time-limit=60 --sleep=10 contao_prio_normal". Message: "An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1203): An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections at /home/www/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)","command":"messenger:consume --time-limit=60 --sleep=10 contao_prio_normal","message":"An exception occurred in the driver: SQLSTATE[HY000] [1203] User webxxx already has more than 'max_user_connections' active connections"} []
Es muss mit dem Contao-Update zusammenhängen, evtl. mit dem neuen SuperviseWorkersCommand.php Skript, da der Fehler vorher nicht auftrat und auch keine Erweiterungen aktualisiert wurden. Hat jemand evtl. dasselbe Problem?
Gruß Tim
PS: Ich habe bereits einen Bug-Report auf Github eingereicht: https://github.com/contao/contao/issues/6907
Lesezeichen