#102711Many entries in sys_file lead to sql error because query gets too long
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.
Reviews 1
History 23
-
Gerrit Code Review pushed patch set 2 for main to change 82268 status
NewUnder Review 12/21/23, 19:19 -
Nikita Hovratov changed Duplicates #102295 12/21/23, 19:22
-
Nikita Hovratov commented and changed status
Under ReviewClosed 12/21/23, 19:24
This is already fixed in https://forge.typo3.org/issues/102295
But not for v11.