#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.