console.CRITICAL bei Cronjob-Ausführung in Log-Datei seit Update von 5.2 auf 5.3

[Silent-Bob]

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:

[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

[Silent-Bob]

Bei WebGo, und evtl. auch anderen Hostern, wird der ps-Befehl in der Shell-Umgebung nicht unterstützt. Das führt dazu, dass bei Ausführung des SuperviseWorkersCron sehr viele Prozesse gestartet bzw. Datenbank-Verbindungen herstellt werden. Bei meist eingeschränkten Shared Hosting Paket kann dann max_user_connections überschritten werden, wodurch die Seite für kurze Zeit nicht mehr erreichbar ist.

Wer ebenfalls Probleme damit hat, kann den Worker temporär mit diesem Eintrag in der config/config.yaml deaktivieren:

contao:
    messenger:
        workers: []

Anschließend muss der Produktionscache erneuert werden.
Dank an Leo für den Tipp!

[Silent-Bob]

Das Problem wurde mit #6995 gefixt. Vielen Dank an alle Beteiligten!