Hallo zusammen,
habe gerade im Log folgende Meldungen entdeckt:
[2024-02-23T23:45:44.935789+00:00] messenger.CRITICAL: Error thrown while handling message Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexingMessage. Removing from transport after 3 retries. Error: "Handling "Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexingMessage" failed: An exception occurred while executing a query: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row" {"class":"Shopware\\Core\\Content\\Product\\DataAbstractionLayer\\ProductIndexingMessage","retryCount":3,"error":"Handling \"Shopware\\Core\\Content\\Product\\DataAbstractionLayer\\ProductIndexingMessage\" failed: An exception occurred while executing a query: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row","exception":"[object] (Symfony\\Component\\Messenger\\Exception\\HandlerFailedException(code: 1242): Handling \"Shopware\\Core\\Content\\Product\\DataAbstractionLayer\\ProductIndexingMessage\" failed: An exception occurred while executing a query: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row at /var/www/vhosts/somedomain.com/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:124)\n[previous exception] [object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1242): An exception occurred while executing a query: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row at /var/www/vhosts/somedomain.com/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1242): SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row at /var/www/vhosts/somedomain.com/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 21000): SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row at /var/www/vhosts/somedomain.com/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"} []
Beeinträchtigungen können wir nicht feststellen, aber wäre gut, diese Meldung nicht zu haben.
Der Shop wurde mehrmals bis auf die neuste Version geupgraded. Läuft mit MariaDB 10.6.
Kann mir jemand einen Tipp geben, an welcher Stelle in der Datenbank ich suchen soll?