#109039Exception with cleanup:localprocessedfiles and too many records to delete
Description
This exception occurs when too many (more than the sql IN() clause can handle) sys_file_processed records has to be deleted.
[ Doctrine\DBAL\Exception\DriverException ]
An exception occurred while executing a query: Prepared statement contains too many placeholders
Exception code: 1390
Exception trace:
#0 ()
vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:129
#1 Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
vendor/doctrine/dbal/src/Connection.php:1976
#2 Doctrine\DBAL\Connection->handleDriverException()
vendor/doctrine/dbal/src/Connection.php:1918
#3 Doctrine\DBAL\Connection->convertExceptionDuringQuery()
vendor/doctrine/dbal/src/Connection.php:1218
#4 Doctrine\DBAL\Connection->executeStatement()
vendor/doctrine/dbal/src/Query/QueryBuilder.php:363
#5 Doctrine\DBAL\Query\QueryBuilder->executeStatement()
vendor/typo3/cms-core/Classes/Database/Query/QueryBuilder.php:303
#6 TYPO3\CMS\Core\Database\Query\QueryBuilder->executeStatement()
vendor/typo3/cms-lowlevel/Classes/Service/CleanUpLocalProcessedFilesService.php:202
#7 TYPO3\CMS\Lowlevel\Service\CleanUpLocalProcessedFilesService->deleteRecord()
vendor/typo3/cms-lowlevel/Classes/Command/CleanUpLocalProcessedFilesCommand.php:112
#8 TYPO3\CMS\Lowlevel\Command\CleanUpLocalProcessedFilesCommand->execute()
vendor/symfony/console/Command/Command.php:341
#9 Symfony\Component\Console\Command\Command->run()
vendor/symfony/console/Application.php:1102
#10 Symfony\Component\Console\Application->doRunCommand()
vendor/symfony/console/Application.php:356
#11 Symfony\Component\Console\Application->doRun()
vendor/symfony/console/Application.php:195
#12 Symfony\Component\Console\Application->run()
vendor/typo3/cms-core/Classes/Console/CommandApplication.php:112
#13 TYPO3\CMS\Core\Console\CommandApplication->run()
vendor/typo3/cms-cli/typo3:23
#14 {closure:/production/www/clients/ccifi/site/vendor/typo3/cms-cli/typo3:20}()
vendor/typo3/cms-cli/typo3:24
#15 include()
vendor/bin/typo3:119Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.
History 3
-
Rémy DANIEL changed Duplicates #106566 <span data-processor="relativetime" data-value="2026-02-20T13:32:35+00:00" > 02/20/26, 13:32 </span>
-
Garvin Hicking changed status
NewClosed <span data-processor="relativetime" data-value="2026-02-20T16:35:45+00:00" > 02/20/26, 16:35 </span>
Duplicate of #106566
I will backport the fix to v12.
Can be closed.