Hello.
Wir haben in einem Projekt ca. 12.000 Artikel, die in einem Export via Sales Channel Produktvergleich landen sollen. Mit ein paar tausend geht es, mit der vollen Menge bricht es ab:
[2021-02-12 11:19:04] console.ERROR: Error thrown while running command "scheduled-task:run --time-limit=295 --memory-limit=512M". Message: "An exception occurred while executing 'SELECT `scheduled_task`.`id` as `scheduled_task.id`, `scheduled_task`.`name` as `scheduled_task.name`, `scheduled_task`.`scheduled_task_class` as `scheduled_task.scheduledTaskClass`, `scheduled_task`.`run_interval` as `scheduled_task.runInterval`, `scheduled_task`.`status` as `scheduled_task.status`, `scheduled_task`.`last_execution_time` as `scheduled_task.lastExecutionTime`, `scheduled_task`.`next_execution_time` as `scheduled_task.nextExecutionTime`, `scheduled_task`.`created_at` as `scheduled_task.createdAt`, `scheduled_task`.`updated_at` as `scheduled_task.updatedAt` FROM `scheduled_task` WHERE ((`scheduled_task`.`next_execution_time` < ?) AND `scheduled_task`.`status` = ?)' with params
["2021-02-12T11:19:04+00:00", "scheduled"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'SELECT `scheduled_task`.`id` as `scheduled_task.id`, `scheduled_task`.`name` as `scheduled_task.name`, `scheduled_task`.`scheduled_task_class` as `scheduled_task.scheduledTaskClass`, `scheduled_task`.`run_interval` as `scheduled_task.runInterval`, `scheduled_task`.`status` as `scheduled_task.status`, `scheduled_task`.`last_execution_time` as `scheduled_task.lastExecutionTime`, `scheduled_task`.`next_execution_time` as `scheduled_task.nextExecutionTime`, `scheduled_task`.`created_at` as `scheduled_task.createdAt`, `scheduled_task`.`updated_at` as `scheduled_task.updatedAt` FROM `scheduled_task` WHERE ((`scheduled_task`.`next_execution_time` < ?) AND `scheduled_task`.`status` = ?)' with params [\"2021-02-12T11:19:04+00:00\", \"scheduled\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /www/htdocs/.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /www/htdocs/.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /www/htdocs/.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)","command":"scheduled-task:run --time-limit=295 --memory-limit=512M","message":"An exception occurred while executing 'SELECT `scheduled_task`.`id` as `scheduled_task.id`, `scheduled_task`.`name` as `scheduled_task.name`, `scheduled_task`.`scheduled_task_class` as `scheduled_task.scheduledTaskClass`, `scheduled_task`.`run_interval` as `scheduled_task.runInterval`, `scheduled_task`.`status` as `scheduled_task.status`, `scheduled_task`.`last_execution_time` as `scheduled_task.lastExecutionTime`, `scheduled_task`.`next_execution_time` as `scheduled_task.nextExecutionTime`, `scheduled_task`.`created_at` as `scheduled_task.createdAt`, `scheduled_task`.`updated_at` as `scheduled_task.updatedAt` FROM `scheduled_task` WHERE ((`scheduled_task`.`next_execution_time` < ?) AND `scheduled_task`.`status` = ?)' with params [\"2021-02-12T11:19:04+00:00\", \"scheduled\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away"} []
Die Cron Ausführung läuft generell und wurde exakt nach Doku aufgebaut: https://docs.shopware.com/de/shopware-6-de/tutorials-und-faq/scheduled-tasks-anlegen
Hoster all-inkl sagt, dass es nichts mit der max_execution_time oder set_time_limit zu tu hat (beides setze ich vor der Ausführung der Cron Scripte).
Hier wird genannt: “Problem im SQL Satement oder fehlendes schließendes Kommando einer offenen Verbindung”.
Ich habe alles nach Vorgabe gemacht, Shopware Boardmittel bricht ab, Hoster sagt, dass es am Server nicht liegt.
Frage ist hier: Was tun? Ich habe leider keine Ideen mehr … 
Gibt es andere, die etwas ähnliches haben?
EDIT : Das gleiche Spiel übrigens auch bei der Sitemap, die generiert er auch nicht.
Selbst, wenn ich den Produktexport auf ca. 2000 setze, bricht er ab mit “Mysql Server has gone away”.
Manuell via console geht das alles …
Schöne Grüße!
Niklas