Issue Bug Closed

#102711Many entries in sys_file lead to sql error because query gets too long

Franz Kugelmann 12/21/23, 17:14 updated 12/21/23, 19:24

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

  1. Gerrit Code Review pushed patch set 2 for main to change 82268 status New Under Review 12/21/23, 19:19

  2. Nikita Hovratov changed Duplicates #102295 12/21/23, 19:22

  3. Nikita Hovratov commented and changed status Under Review Closed 12/21/23, 19:24

    This is already fixed in https://forge.typo3.org/issues/102295
    But not for v11.