Frontend Item Search Error

[Sib315]

Hey guys,

I get an error when I search for single items in the frontend shop (no matter what item).
Is there any known problem?

Our version is 2020.10.9

Error log:

Code: Select all

Time: 4350.8059978485ms
Class: Aimeos\MShop\Index\Manager\MySQL
SELECT "key", COUNT("id") AS "count"
FROM (
SELECT mindsu."supid" AS "key", mpro."id" AS "id"
FROM "mshop_product" AS mpro
LEFT JOIN "mshop_index_catalog" AS mindca USE INDEX ("idx_msindca_s_ca_lt_po", "unq_msindca_p_s_cid_lt_po") ON mindca."prodid" = mpro."id"
LEFT JOIN "mshop_index_supplier" AS mindsu USE INDEX ("idx_msindsup_sid_supid_lt_po", "unq_msindsup_p_sid_supid_lt_po") ON mindsu."prodid" = mpro."id"
LEFT JOIN "mshop_index_text" AS mindte ON mindte."prodid" = mpro."id"
WHERE ( ( mpro."siteid" = '' OR mpro."siteid" = '1.' ) AND ( ( mindca."catid" IS NOT NULL AND ( mpro."status" = 1 AND ( mpro."type" = 'event' OR mpro."start" IS NULL OR mpro."start" <= '2021-11-27 19:19:00' ) AND ( mpro."end" IS NULL OR mpro."end" >= '2021-11-27 19:19:00' ) ) AND ( mindte."siteid" = '' OR mindte."siteid" = '1.' ) AND mindte."langid" = 'de' AND MATCH( mindte."content" ) AGAINST( '357107764623205* "357107764623205"' IN BOOLEAN MODE ) > 0 ) AND mindsu."supid" IS NOT NULL AND mpro."id" IS NOT NULL ) )
GROUP BY mindsu."supid", mpro."id"
ORDER BY mpro."id" ASC
LIMIT 10000 OFFSET 0
) AS list
GROUP BY "key"
#0 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(979): Aimeos\MShop\Common\Manager\Base->getSearchResults()
#1 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(373): Aimeos\MShop\Common\Manager\Base->searchItemsBase()
#2 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Index/Manager/Standard.php(85): Aimeos\MShop\Common\Manager\Base->aggregateBase()
#3 [internal function]: Aimeos\MShop\Index\Manager\Standard->aggregate()
#4 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(51): call_user_func_array()
#5 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/ext/ai-controller-frontend/controller/frontend/src/Controller/Frontend/Product/Standard.php(68): Aimeos\MShop\Common\Manager\Decorator\Base->__call()
#6 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/ext/ai-client-html/client/html/src/Client/Html/Catalog/Count/Supplier/Standard.php(265): Aimeos\Controller\Frontend\Product\Standard->aggregate()
#7 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/ext/ai-client-html/client/html/src/Client/Html/Base.php(67): Aimeos\Client\Html\Catalog\Count\Supplier\Standard->addData()
#8 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/ext/ai-client-html/client/html/src/Client/Html/Catalog/Count/Standard.php(165): Aimeos\Client\Html\Base->addData()
#9 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Controller/CatalogController.php(35): Aimeos\Client\Html\Catalog\Count\Standard->getHeader()
#10 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Aimeos\Shop\Controller\CatalogController->countAction()
#11 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction()
#12 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch()
#13 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\Routing\Route->runController()
#14 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\Routing\Route->run()
#15 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing\closure()
#16 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#17 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Routing\Middleware\SubstituteBindings->handle()
#18 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#19 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Auth\Middleware\Authenticate->handle()
#20 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#21 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle()
#22 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#23 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\View\Middleware\ShareErrorsFromSession->handle()
#24 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#25 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Session\Middleware\StartSession->handle()
#26 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#27 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
#28 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#29 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\EncryptCookies->handle()
#30 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#31 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\Pipeline\Pipeline->then()
#32 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Router->runRouteWithinStack()
#33 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\Routing\Router->runRoute()
#34 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\Routing\Router->dispatchToRoute()
#35 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\Routing\Router->dispatch()
#36 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\closure()
#37 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#38 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#39 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#40 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#41 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#42 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
#43 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#44 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle()
#45 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#46 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Fideloper\Proxy\TrustProxies->handle()
#47 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure()
#48 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Pipeline\Pipeline->then()
#49 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
#50 /var/www/vhosts/eubeto.de/httpdocs/FreischaltportalWEB/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle()
#51 main

[aimeos]

It's not really an error but a warning that your query takes too long (4.35sec in your case).
Most likely, there's a problem with the MySQL full text index and you should run:

Code: Select all

ANALYZE TABLE mshop_index_text
OPTIMIZE TABLE mshop_index_text