# ständiger Core Error in core\_production-\*.log
**URL:** https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649
**Category:** Allgemein
**Created:** [9. Mai 2017 um 12:35 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649 "2017-05-09T12:35:44Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@KaiNeahnung](https://forum.shopware.com/u/KaiNeahnung)
#### Post date: [9. Mai 2017 um 12:35 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649/1 "2017-05-09T12:35:44Z")
Hallo zusammen,
ich erhalte in regelmäßigen Abständen folgenden Error in den Logs (core\_production-2017-05-07.log).
Weiß da jemand Rat?
Vielen Dank,
Kai Neahung
—[2017-05-07 14:30:28] core.ERROR: PDOException: 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 in /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:833 Stack trace: #0 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(833): PDO-\>query(’\n SE…’) #1 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(766): Doctrine\DBAL\Connection-\>executeQuery(’\n SE…’, Array, Array) #2 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(264): Doctrine\DBAL\Connection-\>fetchAll(’\n SE…’) #3 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(209): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer-\>cleanupIndex() #4 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(105): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer-\>build() #5 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchTermQueryBuilder.php(84): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer-\>validate() #6 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1681): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchTermQueryBuilder-\>\_\_construct(Object(Shopware\_Components\_Config), Object(Doctrine\DBAL\Connection), Object(Shopware\Bundle\SearchBundleDBAL\SearchTerm\CacheKeywordFinder), Object(Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer), Object(Shopware\Bundle\SearchBundleDBAL\SearchTerm\TermHelper)) #7 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareSearchdbal\_SearchQueryBuilderDbalService() #8 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‘shopware\_search…’, 1) #9 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‘shopware\_search…’, 1) #10 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1669): Shopware\Components\DependencyInjection\Container-\>get(‘shopware\_search…’) #11 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareSearchdbal\_SearchConditionHandlerDbalService() #12 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‘shopware\_search…’, 1) #13 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‘shopware\_search…’, 1) #14 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1581): Shopware\Components\DependencyInjection\Container-\>get(‘shopware\_search…’) #15 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareSearchdbal\_DbalQueryBuilderFactoryService() #16 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‘shopware\_search…’, 1) #17 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‘shopware\_search…’, 1) #18 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1385): Shopware\Components\DependencyInjection\Container-\>get(‘shopware\_search…’) #19 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareSearch\_ProductNumberSearchService() #20 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‘shopware\_search…’, 1)
* * *
---
### Author:  [@KaiNeahnung](https://forum.shopware.com/u/KaiNeahnung)
#### Post date: [9. Mai 2017 um 12:36 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649/2 "2017-05-09T12:36:21Z")
#21 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‚shopware\_search…‘, 1) #22 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1389): Shopware\Components\DependencyInjection\Container-\>get(‚shopware\_search…‘) #23 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareSearch\_ProductSearchService() #24 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‚shopware\_search…‘, 1) #25 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‚shopware\_search…‘, 1) #26 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1969): Shopware\Components\DependencyInjection\Container-\>get(‚shopware\_search…‘) #27 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareStorefront\_SimilarProductsServiceService() #28 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‚shopware\_storef…‘, 1) #29 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‚shopware\_storef…‘, 1) #30 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1909): Shopware\Components\DependencyInjection\Container-\>get(‚shopware\_storef…‘) #31 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareStorefront\_ProductServiceService() #32 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‚shopware\_storef…‘, 1) #33 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‚shopware\_storef…‘, 1) #34 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Core/sArticles.php(198): Shopware\Components\DependencyInjection\Container-\>get(‚shopware\_storef…‘) #35 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/Modules.php(236): sArticles-\>\_\_construct() #36 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/Modules.php(84): Shopware\_Components\_Modules-\>loadModule(‚sArticles‘) #37 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/Modules.php(130): Shopware\_Components\_Modules-\>getModule(‚sArticles‘) #38 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Controllers/Widgets/Compare.php(32): Shopware\_Components\_Modules-\>Articles() #39 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Widgets\_Compare-\>indexAction() #40 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‚indexAction‘) #41 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Template/Plugins/function.action.php(100): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #42 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/templates/frontend\_Responsive\_de\_DE\_1\_secure/5e/ed/1c/5eed1cbddde3acc8007df42bc2f8e707641c6ba0.snippet.index.tpl.php(802): smarty\_function\_action(Array, Object(Enlight\_Template\_Default)) #43 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/templates/frontend\_Responsive\_de\_DE\_1\_secure/5e/ed/1c/5eed1cbddde3acc8007df42bc2f8e707641c6ba0.snippet.index.tpl.php(284): content\_590af8ce102912\_31881287(Object(Enlight\_Template\_Default)) #44 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Smarty/sysplugins/smarty\_internal\_templatebase.php(180): content\_590af8ce65df05\_39840743(Object(Enlight\_Template\_Default)) #45 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/View/Default.php(274): Smarty\_Internal\_TemplateBase-\>fetch() #46 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(216): Enlight\_View\_Default-\>render(Object(Enlight\_Template\_Default)) #47 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(242): Enlight\_Controller\_Plugins\_ViewRenderer\_Bootstrap-\>renderTemplate(Object(Enlight\_Template\_Default)) #48 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(136): Enlight\_Controller\_Plugins\_ViewRenderer\_Bootstrap-\>render() #49 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Event/Handler/Default.php(91): Enlight\_Controller\_Plugins\_ViewRenderer\_Bootstrap-\>onPostDispatch(Object(Enlight\_Controller\_ActionEventArgs)) #50 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Event/EventManager.php(214): Enlight\_Event\_Handler\_Default-\>execute(Object(Enlight\_Controller\_ActionEventArgs))
---
### Author:  [@KaiNeahnung](https://forum.shopware.com/u/KaiNeahnung)
#### Post date: [9. Mai 2017 um 12:37 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649/3 "2017-05-09T12:37:52Z")
#51 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Action.php(200): Enlight\_Event\_EventManager-\>notify(‚Enlight\_Control…‘, Object(Enlight\_Controller\_ActionEventArgs)) #52 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‚indexAction‘) #53 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #54 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Kernel.php(182): Enlight\_Controller\_Front-\>dispatch() #55 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel-\>handle(Object(Enlight\_Controller\_Request\_RequestHttp), 1, true) #56 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #57 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #58 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #59 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/HttpCache/AppCache.php(187): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #60 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #61 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #62 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/shopware.php(117): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #63 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing ’ SELECT STRAIGHT\_JOIN keywordID, fieldID, sk.keyword FROM `s_search_index` si INNER JOIN s\_search\_keywords sk ON si.keywordID=sk.id LEFT JOIN s\_articles\_categories t2 ON si.elementID=t2.categoryID AND si.fieldID IN (1, 2) LEFT JOIN s\_articles t3 ON si.elementID=t3.supplierID AND si.fieldID IN (6) LEFT JOIN s\_articles\_details t4 ON si.elementID=t4.id AND si.fieldID IN (5) GROUP BY keywordID, fieldID HAVING COUNT(\*) \> (SELECT COUNT(\*)\*0.9 FROM `s_articles`) ‚: 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 in /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:119 Stack trace: #0 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚\n SE…‘, Array) #1 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(766): Doctrine\DBAL\Connection-\>executeQuery(‘\n SE…’, Array, Array) #2 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(264): Doctrine\DBAL\Connection-\>fetchAll(’\n SE…’) #3 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(209): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer-\>cleanupIndex() #4 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(105): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer-\>build() #5 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchTermQueryBuilder.php(84): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer-\>validate() #6 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1681): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchTermQueryBuilder-\>\_\_construct(Object(Shopware\_Components\_Config), Object(Doctrine\DBAL\Connection), Object(Shopware\Bundle\SearchBundleDBAL\SearchTerm\CacheKeywordFinder), Object(Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer), Object(Shopware\Bundle\SearchBundleDBAL\SearchTerm\TermHelper)) #7 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareSearchdbal\_SearchQueryBuilderDbalService() #8 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‚shopware\_search…‘, 1) #9 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‚shopware\_search…‘, 1) #10 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1669): Shopware\Components\DependencyInjection\Container-\>get(‚shopware\_search…‘) #11 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareSearchdbal\_SearchConditionHandlerDbalService() #12 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‚shopware\_search…‘, 1) #13 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‚shopware\_search…‘, 1) #14 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1581): Shopware\Components\DependencyInjection\Container-\>get(‚shopware\_search…‘) #15 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareSearchdbal\_DbalQueryBuilderFactoryService() #16 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‚shopware\_search…‘, 1)
---
### Author:  [@KaiNeahnung](https://forum.shopware.com/u/KaiNeahnung)
#### Post date: [9. Mai 2017 um 12:37 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649/4 "2017-05-09T12:37:59Z")
#17 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‘shopware\_search…’, 1) #18 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1385): Shopware\Components\DependencyInjection\Container-\>get(‘shopware\_search…’) #19 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareSearch\_ProductNumberSearchService() #20 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‘shopware\_search…’, 1) #21 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‘shopware\_search…’, 1) #22 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1389): Shopware\Components\DependencyInjection\Container-\>get(‘shopware\_search…’) #23 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareSearch\_ProductSearchService() #24 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‘shopware\_search…’, 1) #25 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‘shopware\_search…’, 1) #26 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1969): Shopware\Components\DependencyInjection\Container-\>get(‘shopware\_search…’) #27 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareStorefront\_SimilarProductsServiceService() #28 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‘shopware\_storef…’, 1) #29 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‘shopware\_storef…’, 1) #30 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/proxies/ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer.php(1909): Shopware\Components\DependencyInjection\Container-\>get(‘shopware\_storef…’) #31 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/dependency-injection/Container.php(314): ShopwareProduction9f936627482ad21c509e4ae73cc63bedb4495676ProjectContainer-\>getShopwareStorefront\_ProductServiceService() #32 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(217): Symfony\Component\DependencyInjection\Container-\>get(‘shopware\_storef…’, 1) #33 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/DependencyInjection/Container.php(146): Shopware\Components\DependencyInjection\Container-\>doLoad(‘shopware\_storef…’, 1) #34 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Core/sArticles.php(198): Shopware\Components\DependencyInjection\Container-\>get(‘shopware\_storef…’) #35 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/Modules.php(236): sArticles-\>\_\_construct() #36 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/Modules.php(84): Shopware\_Components\_Modules-\>loadModule(‘sArticles’) #37 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/Modules.php(130): Shopware\_Components\_Modules-\>getModule(‘sArticles’) #38 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Controllers/Widgets/Compare.php(32): Shopware\_Components\_Modules-\>Articles() #39 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Widgets\_Compare-\>indexAction() #40 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‘indexAction’) #41 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Template/Plugins/function.action.php(100): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #42 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/templates/frontend\_Responsive\_de\_DE\_1\_secure/5e/ed/1c/5eed1cbddde3acc8007df42bc2f8e707641c6ba0.snippet.index.tpl.php(802): smarty\_function\_action(Array, Object(Enlight\_Template\_Default)) #43 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/var/cache/production\_201704210836/templates/frontend\_Responsive\_de\_DE\_1\_secure/5e/ed/1c/5eed1cbddde3acc8007df42bc2f8e707641c6ba0.snippet.index.tpl.php(284): content\_590af8ce102912\_31881287(Object(Enlight\_Template\_Default)) #44 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Smarty/sysplugins/smarty\_internal\_templatebase.php(180): content\_590af8ce65df05\_39840743(Object(Enlight\_Template\_Default)) #45 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/View/Default.php(274): Smarty\_Internal\_TemplateBase-\>fetch() #46 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(216): Enlight\_View\_Default-\>render(Object(Enlight\_Template\_Default)) #47 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(242): Enlight\_Controller\_Plugins\_ViewRenderer\_Bootstrap-\>renderTemplate(Object(Enlight\_Template\_Default)) #48 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(136): Enlight\_Controller\_Plugins\_ViewRenderer\_Bootstrap-\>render() #49 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Event/Handler/Default.php(91): Enlight\_Controller\_Plugins\_ViewRenderer\_Bootstrap-\>onPostDispatch(Object(Enlight\_Controller\_ActionEventArgs)) #50 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Event/EventManager.php(214): Enlight\_Event\_Handler\_Default-\>execute(Object(Enlight\_Controller\_ActionEventArgs)) #51 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Action.php(200): Enlight\_Event\_EventManager-\>notify(‘Enlight\_Control…’, Object(Enlight\_Controller\_ActionEventArgs)) #52 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‘indexAction’) #53 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #54 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Kernel.php(182): Enlight\_Controller\_Front-\>dispatch() #55 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel-\>handle(Object(Enlight\_Controller\_Request\_RequestHttp), 1, true) #56 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #57 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #58 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #59 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/HttpCache/AppCache.php(187): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #60 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #61 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #62 /is/htdocs/wp12345678\_A1BCDEFG2K/www/labor/shopware.php(117): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #63 {main} {“uid”:“b57a9a2”}
---
### Author:  [@SebastianKloepper](https://forum.shopware.com/u/SebastianKloepper)
#### Post date: [9. Mai 2017 um 12:47 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649/5 "2017-05-09T12:47:12Z")
Hallo,
einmal ein Post mit der Meldung hätte auch gereicht bzw. ein Blick in die Suche [Suchergebnisse für „“ - Shopware Community Forum](https://forum.shopware.com/search?Search=SQL%5C_BIG%5C_SELECTS&sLanguage=1)
Bei deinem Hosting / Server benötigst du die Einstellung „BIG\_SQL\_SELECT = 1“
Siehe auch Auszug aus deinem ersten Post oben:
> 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
Sebastian
---
### Author:  [@webmasterOli](https://forum.shopware.com/u/webmasterOli)
#### Post date: [15. Oktober 2020 um 14:11 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649/6 "2020-10-15T14:11:29Z")
Wir haben in unseren Shop eine Lösung gefunden, diese ist nur leider nicht Update sicher. Wir haben die Datei “engine/Shopware/Bundle/SearchBundl/DBAL/SeacrhTerm/SearchIndexer.php” am Anfang der Funktion “private function cleanupIndex()” folgende Zeile direkt am Anfang hinzugefügt:
```
$this->connection->executeUpdate("SET sql_big_selects = 1");
```
Seit dem taucht die Meldung nicht mehr auf, Probleme mit der Suchfunktion haben wir auch noch nicht festgestellt. Leider weiß ich nicht ob es eine bessere Lösung gibt. Die Config Datei anpassen hat leider nicht geholfen  Wenn jemand noch eine bessere Idee hat, wäre das sehr cool.
---
### Author:  [@zweigelb](https://forum.shopware.com/u/zweigelb)
#### Post date: [1. Februar 2021 um 13:30 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649/7 "2021-02-01T13:30:43Z")
Gibt es hierfür noch immer keine Lösung? Danke @webmasterOli - funktioniert bei uns leider nicht. Webserver Medium bei Hosteurope. Natürlich die gleiche Antwort, können wir bei Shared Hosting nicht aktivieren bla bla.
@SebastianKlöpper Gibt es keine andere Lösung dafür? Der “Trick” mit der config.php funzt leider auch nicht. Idee?
Viele Grüße
-Dirk
Hier noch die Antwort von HE:
Wie die Fehlermeldung aussagt, versucht hier ein MySQL-Query mehr Reihen zu durchsuchen, als in “MAX\_JOIN\_SIZE” definiert ist.
Um zu vermeiden das unsere Shared-Hosting-Pakete durch zu schlecht optimierte MySQL-SELECTs überlastet werden, können wir den Wert der MAX\_JOIN\_SIZE auch nicht erhöhen.
In diesem Fall müssten Sie also einfach die SELECTs optimieren. Dies kann zum Beispiel durch das setzen sinnvoller Indizes in der Datenbank erreicht werden.
Eine weitere Möglichkeit wäre es, die SQL\_BIG\_SELECTS zu aktivieren. Hierbei handelt es sich um eine Session-Variable, die beim Verbindungsaufbau \_einmalig\_ gesetzt werden muss. Diese gilt dann für diese eine Verbindung zur Datenbank, bis diese wieder beendet wird. Innerhalb dieser Verbindung würde MAX\_JOIN\_SIZE dann auch nicht mehr beachtet werden.
Die SQL\_BIG\_SELECTS sind bei uns Standardmäßig deaktiviert. Die Aktivierung muss wie oben beschrieben über Ihr Skript erfolgen.
---
### Author:  [@XJulia](https://forum.shopware.com/u/XJulia)
#### Post date: [29. März 2021 um 15:36 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649/8 "2021-03-29T15:36:48Z")
@webmasterOli - Danke! Das hat bei uns geklappt. Jetzt haben wir neuerdings das Problem, dass unsere Artikeldetailseiten nicht mehr gehen wegen des Problems mit max\_join\_size. Weißt du eventuell, wo und wie genau man sql\_big\_selects für das gesamte Shop-Frontend für die Sessions einbauen kann? Ich habe deine Codezeile mal hier und da ausprobiert, jedoch nie mit Erfolg… die hat tatsächlich nur an der Stelle im Searchindexer funktioniert. danke im Voraus!
---
### Author:  [@R4M](https://forum.shopware.com/u/R4M)
#### Post date: [30. März 2021 um 06:37 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649/9 "2021-03-30T06:37:53Z")
Nur aus reiner Neugier: Bei welchen Hoster traten denn diese Probleme auf?
---
### Author:  [@Webmaster-Oli](https://forum.shopware.com/u/Webmaster-Oli)
#### Post date: [30. März 2021 um 07:32 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649/10 "2021-03-30T07:32:45Z")
Sorry leider habe ich dafür keine Antwort ☹
---
### Author:  [@zweigelb](https://forum.shopware.com/u/zweigelb)
#### Post date: [1. April 2021 um 16:24 UTC](https://forum.shopware.com/t/standiger-core-error-in-core-production-log/45649/11 "2021-04-01T16:24:22Z")
Hier bei Hosteurope!