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}
Hallo,
einmal ein Post mit der Meldung hätte auch gereicht bzw. ein Blick in die Suche Suchergebnisse für „“ - Shopware Community Forum
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 „Gefällt mir“
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
2 „Gefällt mir“
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
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.
XJulia
29. März 2021 um 15:36
8
@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!
R4M
30. März 2021 um 06:37
9
Nur aus reiner Neugier: Bei welchen Hoster traten denn diese Probleme auf?
Sorry leider habe ich dafür keine Antwort
Wenn jemand noch eine bessere Idee hat, wäre das sehr cool.