Bug #87304
closed
typo3 cleanup:missingrelations memory problem, Typo3 9.5.3
0%
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
Updated by Garvin Hicking 5 months ago
- Status changed from New to Closed
I believe this has been optimized with more recent TYPO3 versions. Also, DB integrity is a tough nut to crack - 8GB may not be enough for large datasets.
I would recommend using https://github.com/lolli42/dbdoctor which is specifically aimed at situations like these to iteratively fix datasets also with larger data.
Due to the age of this issue and no special progress here, I will close this issue for now, if you feel this is a mistake or have additional feedback, please get in touch. You can also create a follow-up issue. I also think with the improvements in the DB Analyzer and the RefIndex in v13 this should get better. Else we might need to get a specific dataset to track what is wrong and leads to this kind of memory exhaustion.