Hallo,
ich habe bei mir den CLI Worker eingrichtet und lief auch ganz gut.
V 6.3.5.2
Aber seit 2 Tage bekomme ich nun folgende Meldung
// The worker will automatically exit once it has been running for 295s or
// received a stop signal via the messenger:stop-workers command.
// Quit the worker with CONTROL-C.
// Re-run the command with a -vv option to see logs about consumed messages.
12:15:01 CRITICAL [messenger] Error thrown while handling message Shopware\Core\Content\Sitemap\ScheduledTask\SitemapMessage. Removing from transport after 3 retries. Error: „An exception occurred while executing '\n UPDATE message_queue_stats\n SET size = size - 1\n WHERE name = ?;\n ’ with params [„Shopware\Core\Content\Sitemap\ScheduledTask\SitemapMessage“]:\n\nSQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT check.message_queue_stats.size failed for c1w2db1.message_queue_stats“ [„message“ => Shopware\Core\Content\Sitemap\ScheduledTask\SitemapMessage { …},„class“ => „Shopware\Core\Content\Sitemap\ScheduledTask\SitemapMessage“,„retryCount“ => 3,„error“ => „“" An exception occurred while executing '\n UPDATE message_queue_stats\n SET size = size - 1\n WHERE name = ?;\n ’ with params [„Shopware\Core\Content\Sitemap\ScheduledTask\SitemapMessage“]:\n \n SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT check.message_queue_stats.size failed for c1w2db1.message_queue_stats „“",„exception“ => Doctrine\DBAL\Exception\DriverException { …}]
12:15:01 CRITICAL [console] Error thrown while running command „messenger:consume --time-limit=295“. Message: „An exception occurred while executing '\n UPDATE message_queue_stats\n SET size = size - 1\n WHERE name = ?;\n ’ with params [„Shopware\Core\Content\Sitemap\ScheduledTask\SitemapMessage“]:\n\nSQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT check.message_queue_stats.size failed for c1w2db1.message_queue_stats“ [„exception“ => Doctrine\DBAL\Exception\DriverException { …},„command“ => „messenger:consume --time-limit=295“,„message“ => „“" An exception occurred while executing '\n UPDATE message_queue_stats\n SET size = size - 1\n WHERE name = ?;\n ’ with params [„Shopware\Core\Content\Sitemap\ScheduledTask\SitemapMessage“]:\n \n SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT check.message_queue_stats.size failed for c1w2db1.message_queue_stats „“"]
In AbstractMySQLDriver.php line 106:
An exception occurred while executing ’
UPDATE message_queue_stats
SET size = size - 1
WHERE name = ?;
’ with params [„Shopware\Core\Content\Sitemap\ScheduledTask\Si
temapMessage“]:
SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT check.mes sage_queue_stats.size failed for c1w2db1.message_queue_stats
In PDOStatement.php line 123:
SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT check.mes sage_queue_stats.size failed for c1w2db1.message_queue_stats
In PDOStatement.php line 121:
SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT check.mes sage_queue_stats.size failed for c1w2db1.message_queue_stats
messenger:consume [-l|–limit LIMIT] [-m|–memory-limit MEMORY-LIMIT] [-t|–time-limit TIME-LIMIT] [–sleep SLEEP] [-b|–bus BUS] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [–ansi] [–no-ansi] [-n|–no-interaction] [-e|–env ENV] [–no-debug] [–] […]
Mein Aufruf
[php] -d memory_limit=1024M [web_root]/bin/console messenger:consume --time-limit=295
In der Message Queue für Sitemap steht size 0 drin.
„id“: „938ca19882654cdbad2bd092e3c70266“,
„type“: „message_queue_stats“,
„attributes“: {
„name“: „Shopware\Core\Content\Sitemap\ScheduledTask\SitemapMessage“,
„size“: 0,
„createdAt“: „2021-01-22T13:42:24.928+00:00“,
„updatedAt“: „2021-03-02T06:35:59.450+00:00“,
„apiAlias“: null
Die Sitemap Generierung habe auf manuell stehen.
Was kann ich tuen ?
Gruss
