Bug #70928
closed
Garbage collection of entries without tags fail
0%
Description
Due to the join statement entries without tags are never deleted from the database backend by the garbage collector.
Updated by Stephan Großberndt over 8 years ago
- Status changed from New to Needs Feedback
I guess you are referring to this change: http://review.typo3.org/33254
The JOIN statement is only used if flushing by tags - then you explicitly want to remove only those with the tag. If all caches are cleared flush() is used instead of flushByTag() where the table is truncted and no JOIN is used.
Please explain in more detail what is wrong in your opinion if this is not the problem you want to report.
Updated by Gernot Leitgab over 8 years ago
The problem is, that entries without tags are removed after clearance of all caches only, but the garbage collector will never remove them, so a manual admin interation is required. Especially on large installations this is a problem, because the database will grow very fast. I did a quick fix (actually working on MySQL only I think) for now, during the next few days I'll have a closer look on that problem and provide a fix for it.
Updated by Stefan Froemken about 8 years ago
I have just looked into the current master. There you have a query to remove all old cache entries incl. their tags AND, that is new, remove all tags which does not have a relation to an cache entry anymore.
I don't know why this was not backported, but with an own extension you can implement that feature update save to TYPO3 6.2 via: $GLOBALS['TYPO3_CONF_VARS']['SYS']['Objects'][$className]
Updated by Christian Kuhn almost 8 years ago
I think this was fixed in master, 7.6 and 6.2 see https://review.typo3.org/#/c/49907/
Updated by Christian Kuhn almost 8 years ago
- Status changed from Needs Feedback to Closed