Bug #97775
closedRename of directory name in file list results in updating of all related sys_file_metadata
100%
Description
In TYPO3 v10. The renaming of a directory took very long and at some point there was an exception related to an UPDATE query on sys_file_metadata. The exception is a different problem, but I was wondering why all sys_file_metadata are updated. Should they not be related to the uid in sys_file and not be concerned about the path at all?
As noted, this causes the renaming of directories to take longer than necessary.
Reproduce¶
1. check timestamp of a sys_file_metadata record, e.g.
select uid,FROM_UNIXTIME(tstamp),title,file from sys_file_metadata where file=291201;
2. Rename a directory which contains this file
3. check the timestamp again.
Updated by Gerrit Code Review about 1 year ago
- Status changed from New to Under Review
Patch set 1 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/+/81046
Updated by Gerrit Code Review about 1 year ago
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/+/81046
Updated by Gerrit Code Review about 1 year ago
Patch set 3 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/+/81046
Updated by Gerrit Code Review about 1 year ago
Patch set 1 for branch 12.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81061
Updated by Oliver Bartsch about 1 year ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset e0a0643bfa68cb2f6fc7c2425e9858d6bd94a645.