search

shopware / shopware

Shopware 6 is an open commerce platform based on Symfony Framework and Vue and supported by a worldwide community and more than 1.500 community extensions
https://shopware.com
MIT License
2.81k stars 1.02k forks source link

Scheduled Tasks - product_download.media.cleanup failed #5378

Open mazuk6 opened 2 hours ago

mazuk6 commented 2 hours ago

PHP Version: 8.2 | Shopware Version: 6.6.7.1 | Affected area / extension: Platform(Default)

Expected behaviour:

Execute Task without error.

Actual behaviour:

Task exits with: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay" at ExceptionConverter.php line 118 {"exception":"[object] (Doctrine\DBAL\Exception\DriverException(code: 1104): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay at /is/htdocs/wp13707735_6J5JOPKX6E/www/www.spexx.org/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:118)\n[previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 1104): SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay at /is/htdocs/wp13707735_6J5JOPKX6E/www/www.spexx.org/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay at /is/htdocs/wp13707735_6J5JOPKX6E/www/www.spexx.org/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"} []

How to reproduce:

Manually start Task product_download.media.cleanup in Tools Plugin (Friends of Shopware)

shopwareBot commented 2 hours ago

[public] Shopware automated response: This issue is linked to the internal issue: NEXT-39400

[created from NEXT-39400, comment 509236]