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 Gerrit Code Review 4 months ago
- Status changed from New to Under Review
Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/82268
Updated by Nikita Hovratov 4 months ago
- Is duplicate of Bug #102295: Task "Storage Index" has nofile index Limit ends in a Excpection added
Updated by Nikita Hovratov 4 months ago
- Status changed from Under Review to Closed
This is already fixed in https://forge.typo3.org/issues/102295
But not for v11.
Actions