Actions
Bug #102711
closed
Many entries in sys_file lead to sql error because query gets too long
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
scheduler
Target version:
Start date:
2023-12-21
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
11
PHP Version:
8.1
Tags:
Complexity:
easy
Is Regression:
Sprint Focus:
Description
We currently maintain a TYPO3 instance with about 220k entries in sys_file. When we run
\TYPO3\CMS\Scheduler\Task\FileStorageIndexingTask
then we get an sql query error because the query in
\TYPO3\CMS\Core\Resource\Index\FileIndexRepository::findInStorageAndNotInUidList
just gets too long with all those 220k uids in the "not in ()" part.
Happenend in v11, code is still the same in v12.
Updated by 
Updated by
Actions