ständiger Core Error in core_production-*.log

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)


#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}  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)

#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”}

Hallo,

einmal ein Post mit der Meldung hätte auch gereicht bzw. ein Blick in die Suche https://forum.shopware.com/search?Search=SQL_BIG_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

1 Like

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 Crying Wenn jemand noch eine bessere Idee hat, wäre das sehr cool.

2 Likes

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.

@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!

Nur aus reiner Neugier: Bei welchen Hoster traten denn diese Probleme auf?

Sorry leider habe ich dafür keine Antwort :frowning:

Hier bei Hosteurope!