Issue Bug Closed

#109039Exception with cleanup:localprocessedfiles and too many records to delete

Rémy DANIEL 02/20/26, 13:30 updated 02/20/26, 16:35

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:119

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.

History 3

  1. Rémy DANIEL commented <span data-processor="relativetime" data-value="2026-02-20T13:33:21+00:00" > 02/20/26, 13:33 </span>

    Duplicate of #106566

    I will backport the fix to v12.
    Can be closed.