Bug #87304

typo3 cleanup:missingrelations memory problem, Typo3 9.5.3

Added by Benjamin Kott 7 months ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
CLI
Target version:
-
Start date:
2018-12-28
Due date:
% Done:

0%

TYPO3 Version:
9
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Reported on Slack by Peter Schubert in #typo3-cms-issues
Since he is unable to log into forge I´ve copied the description into this report.

I found out that I can remove the following memory problem if I manually remove all records in table sys_file and sys_file_metadata which are not have a 1:1 reference.
Perhaps it would be helpful if the user get a message that something is wrong with the references between this two tables. First I increased the allowed PHP memory to 8GB but this doesn’t help.

php /srv/www/htdocs/typo3/sysext/core/bin/typo3 cleanup:missingrelations
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 54039456 bytes) in
/srv/www/typo3_src-9.5.3/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php
on line 203

Also available in: Atom PDF