#106597Big contains in find: 504 Gateway Time-out
Description
Hi,
I use the function in the repository:
public function find (
$assortment = null,
$product = null,
$limit = 1,
$random = false,
$excludeId = null,
$excludeCampaignIds = null
)
{
$query = $this->createQuery();
$query->getQuerySettings()
->setRespectStoragePage(False);
$query->setLimit($limit);
$constraints = [];
$constraints[] = $query->lessThan('activeFrom', time());
if ($assortment) {
$assortmentConstraints = [];
$assortmentConstraints[] = $query->equals('assortment', 0);
foreach ($assortment as $assortmentId) {
$assortmentConstraints[] = $query->contains('assortment', $assortmentId);
}
if (count($assortmentConstraints) === 1) {
$constraints[] = reset($assortmentConstraints);
} else {
$constraints[] = $query->logicalOr(...$assortmentConstraints);
}
}
if ($product) {
$productConstraints = [];
$productConstraints[] = $query->equals('product', 0);
foreach ($product as $productId) {
$productConstraints[] = $query->contains('product', $productId);
}
if (count($productConstraints) === 1) {
$constraints[] = reset($productConstraints);
} else {
$constraints[] = $query->logicalOr(...$productConstraints);
}
}
if ($excludeId) {
$constraints[] = $query->logicalNot($query->equals('uid', $excludeId));
}
if ($excludeCampaignIds) {
$constraints[] = $query->logicalNot($query->in('uid', explode(';',$excludeCampaignIds)));
}
$query->matching(
$query->logicalAnd(...$constraints)
);
if ($random) {
/** @var Typo3DbQueryParser $queryParser */
$queryParser = GeneralUtility::makeInstance(Typo3DbQueryParser::class);
$queryBuilder = $queryParser->convertQueryToDoctrineQueryBuilder($query);
$queryBuilder
->addSelectLiteral('RAND() as rando')
->setMaxResults($limit)
->orderBy('rando');
$query->statement($queryBuilder->getSQL(), $queryBuilder->getParameters());
} else {
$query->setOrderings(['activeFrom' => QueryInterface::ORDER_DESCENDING]);
if ($this->writeCampaignRepositoryLog) {
$logger = ObjectUtility::getLogger(__CLASS__);
$queryParser = GeneralUtility::makeInstance(Typo3DbQueryParser::class);
$queryBuilder = $queryParser->convertQueryToDoctrineQueryBuilder($query);
$logger->critical('find ');
$logger->critical('find excludeCampaignIds : ' . $excludeCampaignIds);
$logger->critical('find COUNT assortment : ' . count($assortment));
$logger->critical('find COUNT product : ' . count($product));
$logger->critical('find limit : ' . $limit);
$logger->critical('find SQL Parameters : ', (array)$queryBuilder->getParameters());
$logger->critical('find SQL : ' . $queryBuilder->getSQL());
}
}
return $query->execute()->toArray();
}
If I use a small number of companies, product ranges and products, then I get a SQL query and the result on the frontend:
find excludeCampaignIds : 17;6;20;12;1;16;10
find COUNT assortment : 5
find COUNT product : 4
find limit : 1
find SQL Parameters : - {"dcValue1":1744713272,"dcValue2":0,"dcValue3":1,"dcValue4":2,"dcValue5":5,"dcValue6":6,"dcValue7":3,"dcValue8":0,"dcValue9":2,"dcValue10":4,"dcValue11":1,"dcValue12":3,"dcValue13":"17","dcValue14":"6","dcValue15":"20","dcValue16":"12","dcValue17":"1","dcValue18":"16","dcValue19":"10"}
find SQL : SELECT `tx_sitpartnercenter_domain_model_campaign`.* FROM `tx_sitpartnercenter_domain_model_campaign` WHERE ((((((`tx_sitpartnercenter_domain_model_campaign`.`active_from` < :dcValue1) AND (((((((((((`tx_sitpartnercenter_domain_model_campaign`.`assortment` = :dcValue2) OR (`tx_sitpartnercenter_domain_model_campaign`.`uid` IN (SELECT `uid_local` FROM `tx_sitpartnercenter_campaign_assortment_mm` WHERE `uid_foreign` = :dcValue3)))) OR (`tx_sitpartnercenter_domain_model_campaign`.`uid` IN (SELECT `uid_local` FROM `tx_sitpartnercenter_campaign_assortment_mm` WHERE `uid_foreign` = :dcValue4)))) OR (`tx_sitpartnercenter_domain_model_campaign`.`uid` IN (SELECT `uid_local` FROM `tx_sitpartnercenter_campaign_assortment_mm` WHERE `uid_foreign` = :dcValue5)))) OR (`tx_sitpartnercenter_domain_model_campaign`.`uid` IN (SELECT `uid_local` FROM `tx_sitpartnercenter_campaign_assortment_mm` WHERE `uid_foreign` = :dcValue6)))) OR (`tx_sitpartnercenter_domain_model_campaign`.`uid` IN (SELECT `uid_local` FROM `tx_sitpartnercenter_campaign_assortment_mm` WHERE `uid_foreign` = :dcValue7)))))) AND (((((((((`tx_sitpartnercenter_domain_model_campaign`.`product` = :dcValue8) OR (`tx_sitpartnercenter_domain_model_campaign`.`uid` IN (SELECT `uid_local` FROM `tx_sitpartnercenter_campaign_product_mm` WHERE `uid_foreign` = :dcValue9)))) OR (`tx_sitpartnercenter_domain_model_campaign`.`uid` IN (SELECT `uid_local` FROM `tx_sitpartnercenter_campaign_product_mm` WHERE `uid_foreign` = :dcValue10)))) OR (`tx_sitpartnercenter_domain_model_campaign`.`uid` IN (SELECT `uid_local` FROM `tx_sitpartnercenter_campaign_product_mm` WHERE `uid_foreign` = :dcValue11)))) OR (`tx_sitpartnercenter_domain_model_campaign`.`uid` IN (SELECT `uid_local` FROM `tx_sitpartnercenter_campaign_product_mm` WHERE `uid_foreign` = :dcValue12)))))) AND ( NOT(`tx_sitpartnercenter_domain_model_campaign`.`uid` IN (:dcValue13, :dcValue14, :dcValue15, :dcValue16, :dcValue17, :dcValue18, :dcValue19))) AND (`tx_sitpartnercenter_domain_model_campaign`.`sys_language_uid` IN (0, -1)) AND (`tx_sitpartnercenter_domain_model_campaign`.`t3ver_oid` = 0) AND (`tx_sitpartnercenter_domain_model_campaign`.`deleted` = 0 AND ((`tx_sitpartnercenter_domain_model_campaign`.`t3ver_state` <= 0) AND (`tx_sitpartnercenter_domain_model_campaign`.`t3ver_wsid` = 0)) AND ((`tx_sitpartnercenter_domain_model_campaign`.`t3ver_oid` = 0) OR (`tx_sitpartnercenter_domain_model_campaign`.`t3ver_state` = 4)) AND `tx_sitpartnercenter_domain_model_campaign`.`hidden` = 0 AND `tx_sitpartnercenter_domain_model_campaign`.`starttime` <= 1744713240 AND ((`tx_sitpartnercenter_domain_model_campaign`.`endtime` = 0) OR (`tx_sitpartnercenter_domain_model_campaign`.`endtime` > 1744713240)))) ORDER BY `tx_sitpartnercenter_domain_model_campaign`.`active_from` DESC
If I use a large number of companies, product ranges and products, then I don’t get the SQL query and the result on the frontend gives a timeout error: 504 Gateway Time-out.
find excludeCampaignIds : 90;149;137;138;139;142;146;149;153;160;152;57;144;35;164;29;28;27;37;166;174;176
find COUNT assortment : 12
find COUNT product : 31
find limit : 1
TYPO3 Errors:
component="TYPO3.CMS.Frontend.ContentObject.Exception.ProductionExceptionHandler": Oops, an error occurred! Request: b91194d312c82- BadConstraintException: The IN operator needs a non-empty value list to compare against. The given value list is empty., in file /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php:413 - {"exception":"TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Storage\\Exception\\BadConstraintException: The IN operator needs a non-empty value list to compare against. The given value list is empty. in /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php:413\nStack trace:\n#0 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php(387): TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Storage\\Typo3DbQueryParser->parseDynamicOperand()\n#1 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php(233): TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Storage\\Typo3DbQueryParser->parseComparison()\n#2 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php(220): TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Storage\\Typo3DbQueryParser->parseConstraint()\n#3 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php(162): TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Storage\\Typo3DbQueryParser->parseConstraint()\n#4 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Persistence/Generic/Storage/Typo3DbBackend.php(334): TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Storage\\Typo3DbQueryParser->convertQueryToDoctrineQueryBuilder()\n#5 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Persistence/Generic/Backend.php(94): TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Storage\\Typo3DbBackend->getObjectCountByQuery()\n#6 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Persistence/Generic/PersistenceManager.php(71): TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Backend->getObjectCountByQuery()\n#7 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Persistence/Generic/QueryResult.php(126): TYPO3\\CMS\\Extbase\\Persistence\\Generic\\PersistenceManager->getObjectCountByQuery()\n#8 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/public/exts/sit_partnercenter/Classes/Domain/Repository/CampaignRepository.php(800): TYPO3\\CMS\\Extbase\\Persistence\\Generic\\QueryResult->count()\n#9 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/public/exts/sit_partnercenter/Classes/Controller/CampaignManagerController.php(174): SchirraIT\\SitPartnercenter\\Domain\\Repository\\CampaignRepository->countByAssortments()\n#10 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Mvc/Controller/ActionController.php(470): SchirraIT\\SitPartnercenter\\Controller\\CampaignManagerController->listAction()\n#11 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Mvc/Controller/ActionController.php(390): TYPO3\\CMS\\Extbase\\Mvc\\Controller\\ActionController->callActionMethod()\n#12 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Mvc/Dispatcher.php(68): TYPO3\\CMS\\Extbase\\Mvc\\Controller\\ActionController->processRequest()\n#13 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Core/Bootstrap.php(152): TYPO3\\CMS\\Extbase\\Mvc\\Dispatcher->dispatch()\n#14 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-extbase/Classes/Core/Bootstrap.php(131): TYPO3\\CMS\\Extbase\\Core\\Bootstrap->handleFrontendRequest()\n#15 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/ContentObject/ContentObjectRenderer.php(4487): TYPO3\\CMS\\Extbase\\Core\\Bootstrap->run()\n#16 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/ContentObject/UserContentObject.php(44): TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer->callUserFunction()\n#17 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/ContentObject/ContentObjectRenderer.php(656): TYPO3\\CMS\\Frontend\\ContentObject\\UserContentObject->render()\n#18 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/ContentObject/ContentObjectRenderer.php(603): TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer->render()\n#19 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Controller/TypoScriptFrontendController.php(685): TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer->cObjGetSingle()\n#20 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Controller/TypoScriptFrontendController.php(646): TYPO3\\CMS\\Frontend\\Controller\\TypoScriptFrontendController->processNonCacheableContentPartsAndSubstituteContentMarkers()\n#21 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Controller/TypoScriptFrontendController.php(615): TYPO3\\CMS\\Frontend\\Controller\\TypoScriptFrontendController->recursivelyReplaceIntPlaceholdersInContent()\n#22 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Http/RequestHandler.php(176): TYPO3\\CMS\\Frontend\\Controller\\TypoScriptFrontendController->INTincScript()\n#23 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Middleware/ResponsePropagation.php(34): TYPO3\\CMS\\Frontend\\Http\\RequestHandler->handle()\n#24 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Core\\Middleware\\ResponsePropagation->process()\n#25 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/ContentSecurityPolicyHeaders.php(58): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#26 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\ContentSecurityPolicyHeaders->process()\n#27 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/CacheTimeout.php(34): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#28 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\CacheTimeout->process()\n#29 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-adminpanel/Classes/Middleware/AdminPanelRenderer.php(41): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#30 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Adminpanel\\Middleware\\AdminPanelRenderer->process()\n#31 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/ContentLengthResponseHeader.php(41): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#32 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\ContentLengthResponseHeader->process()\n#33 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/ShortcutAndMountPointRedirect.php(94): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#34 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\ShortcutAndMountPointRedirect->process()\n#35 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/OutputCompression.php(44): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#36 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\OutputCompression->process()\n#37 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/blueways/bw-captcha/Classes/Middleware/Captcha.php(48): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#38 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): Blueways\\BwCaptcha\\Middleware\\Captcha->process()\n#39 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/blueways/bw-captcha/Classes/Middleware/Audio.php(45): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#40 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): Blueways\\BwCaptcha\\Middleware\\Audio->process()\n#41 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/PrepareTypoScriptFrontendRendering.php(186): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#42 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\PrepareTypoScriptFrontendRendering->process()\n#43 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/TypoScriptFrontendInitialization.php(126): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#44 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\TypoScriptFrontendInitialization->process()\n#45 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/yoast-seo-for-typo3/yoast_seo/Classes/Middleware/PageRequestMiddleware.php(28): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#46 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): YoastSeoForTypo3\\YoastSeo\\Middleware\\PageRequestMiddleware->process()\n#47 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/PageArgumentValidator.php(104): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#48 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\PageArgumentValidator->process()\n#49 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/PreviewSimulator.php(92): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#50 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\PreviewSimulator->process()\n#51 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-adminpanel/Classes/Middleware/SqlLogging.php(53): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#52 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Adminpanel\\Middleware\\SqlLogging->process()\n#53 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/PageResolver.php(101): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#54 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\PageResolver->process()\n#55 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/StaticRouteResolver.php(71): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#56 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\StaticRouteResolver->process()\n#57 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-adminpanel/Classes/Middleware/AdminPanelInitiator.php(51): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#58 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Adminpanel\\Middleware\\AdminPanelInitiator->process()\n#59 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/ContentSecurityPolicyReporter.php(57): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#60 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\ContentSecurityPolicyReporter->process()\n#61 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/SiteBaseRedirectResolver.php(90): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#62 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\SiteBaseRedirectResolver->process()\n#63 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-redirects/Classes/Http/Middleware/RedirectHandler.php(68): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#64 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Redirects\\Http\\Middleware\\RedirectHandler->process()\n#65 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/FrontendUserAuthenticator.php(76): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#66 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\FrontendUserAuthenticator->process()\n#67 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/BackendUserAuthenticator.php(82): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#68 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\BackendUserAuthenticator->process()\n#69 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Middleware/RequestTokenMiddleware.php(71): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#70 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Core\\Middleware\\RequestTokenMiddleware->process()\n#71 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/evoweb/sf-register/Classes/Middleware/AjaxMiddleware.php(45): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#72 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): Evoweb\\SfRegister\\Middleware\\AjaxMiddleware->process()\n#73 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/MaintenanceMode.php(51): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#74 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\MaintenanceMode->process()\n#75 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/EidHandler.php(48): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#76 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\EidHandler->process()\n#77 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/SiteResolver.php(80): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#78 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\SiteResolver->process()\n#79 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Middleware/CacheDataCollectorAttribute.php(53): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#80 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Core\\Middleware\\CacheDataCollectorAttribute->process()\n#81 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Middleware/NormalizedParamsAttribute.php(44): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#82 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Core\\Middleware\\NormalizedParamsAttribute->process()\n#83 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Middleware/TimeTrackerInitialization.php(49): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#84 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Frontend\\Middleware\\TimeTrackerInitialization->process()\n#85 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(70): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#86 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/AbstractApplication.php(87): TYPO3\\CMS\\Core\\Http\\MiddlewareDispatcher->handle()\n#87 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-frontend/Classes/Http/Application.php(50): TYPO3\\CMS\\Core\\Http\\AbstractApplication->handle()\n#88 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/RequestHandler.php(42): TYPO3\\CMS\\Frontend\\Http\\Application->handle()\n#89 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Middleware/ResponsePropagation.php(34): TYPO3\\CMS\\Core\\Http\\RequestHandler->handle()\n#90 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Core\\Middleware\\ResponsePropagation->process()\n#91 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Middleware/NormalizedParamsAttribute.php(44): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#92 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Core\\Middleware\\NormalizedParamsAttribute->process()\n#93 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Middleware/VerifyHostHeader.php(55): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#94 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\\CMS\\Core\\Middleware\\VerifyHostHeader->process()\n#95 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(70): Psr\\Http\\Server\\RequestHandlerInterface@anonymous->handle()\n#96 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/AbstractApplication.php(87): TYPO3\\CMS\\Core\\Http\\MiddlewareDispatcher->handle()\n#97 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/Application.php(44): TYPO3\\CMS\\Core\\Http\\AbstractApplication->handle()\n#98 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/vendor/typo3/cms-core/Classes/Http/AbstractApplication.php(110): TYPO3\\CMS\\Core\\Http\\Application->handle()\n#99 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/public/index.php(20): TYPO3\\CMS\\Core\\Http\\AbstractApplication->run()\n#100 /var/www/vhosts/mdh-upgrade.sitevertreiber.de/httpdocs/public/index.php(21): {closure}()\n#101 {main}","code":"20250417094039cf2241c4","requestId":{"long":"b91194d312c82a9770ca4cc5441d81e6e4fc38f7","short":"b91194d312c82","microtime":1744875639934733,"nonce":{"value":"hTVRxtHczbKiEz3YdRpSKcKvb-ewkOLgkd6AH-l5FPRymJ-j9eATvA"}}}Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.
Related issues 1
History 7
-
Garvin Hicking commented and changed status
NewNeeds Feedback <span data-processor="relativetime" data-value="2025-04-22T15:54:35+00:00" > 04/22/25, 15:54 </span> -
Garvin Hicking changed Related to #106013 <span data-processor="relativetime" data-value="2025-04-22T15:55:03+00:00" > 04/22/25, 15:55 </span>
-
Garvin Hicking commented <span data-processor="relativetime" data-value="2025-04-22T15:58:49+00:00" > 04/22/25, 15:58 </span>
BTW: Have you evaluated if you really need “contains” instead of “in”? The latter has a much better performance and resource usage footprint. I only superficially read your code, so I’m sorry if it does not apply to you. But foreach()in on a list of UIDs usually means it could be done with a “uid IN (1,2,3,4….)” query with one join instead of having 4 joins. Also note that every “contains” will lead to at least one join, so this stacks up quickly.
-
Yurii Panchenko commented <span data-processor="relativetime" data-value="2025-04-22T16:23:36+00:00" > 04/22/25, 16:23 </span>
Garvin Hicking wrote in #note-1:
> This sounds very much like this patch that has recently been merged:
>
> https://forge.typo3.org/issues/106013
>
> Can you verify this?I will try and report the result.
-
Yurii Panchenko commented <span data-processor="relativetime" data-value="2025-04-22T16:24:10+00:00" > 04/22/25, 16:24 </span>
Garvin Hicking wrote in #note-3:
> BTW: Have you evaluated if you really need “contains” instead of “in”? The latter has a much better performance and resource usage footprint. I only superficially read your code, so I’m sorry if it does not apply to you. But foreach()in on a list of UIDs usually means it could be done with a “uid IN (1,2,3,4….)” query with one join instead of having 4 joins. Also note that every “contains” will lead to at least one join, so this stacks up quickly.Thanks. I will try and report the result.
-
Yurii Panchenko commented <span data-processor="relativetime" data-value="2025-04-23T20:56:12+00:00" > 04/23/25, 20:56 </span>
Garvin Hicking wrote in #note-3:
> BTW: Have you evaluated if you really need “contains” instead of “in”? The latter has a much better performance and resource usage footprint. I only superficially read your code, so I’m sorry if it does not apply to you. But foreach()in on a list of UIDs usually means it could be done with a “uid IN (1,2,3,4….)” query with one join instead of having 4 joins. Also note that every “contains” will lead to at least one join, so this stacks up quickly.I optimized the SQL request (I use IN). The loading speed is the same as in version 10.
I haven’t tested the patch yet. I hope there will be a new release with this patch soon))) -
Garvin Hicking commented and changed status
Needs FeedbackClosed <span data-processor="relativetime" data-value="2025-04-23T21:06:37+00:00" > 04/23/25, 21:06 </span>Happy to hear that. I do think it should be fine with the patch, too – closing this issue then as duplicate of #106013
This sounds very much like this patch that has recently been merged:
https://forge.typo3.org/issues/106013
Can you verify this?