Bug #77204: Typo3DatabaseBackend flushByTag() and collectGarbage() - TYPO3 Core - TYPO3 Forge

Custom queries

12 LTS
Accessibility
Dashboard issues
Easy tasks
Extbase Issues
FAL Issues
FAL Sprint 2023
Hierarchical Issues
Issues reported for v11
JavaScript issues
JavaScript Issues (w/o Epics/Stories)
Most wanted Bugfixes
Most wanted Features
My open issues
New & Unassigned
No feedback within 90 days
Open Bugs
Open issues of 10
Page Tree Regressions after 2020-07-28
Recently modified
Regressions
Stabilization Issues
Usability or UX

Actions

Copy link

Bug #77204

closed

Typo3DatabaseBackend flushByTag() and collectGarbage()

Added by Christian Kuhn almost 8 years ago. Updated over 5 years ago.

Status:

Closed

Priority:

Must have

Assignee:

Category:

Caching

Target version:

Start date:

2016-07-21

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

PHP Version:

Tags:

Complexity:

medium

Is Regression:

Yes

Sprint Focus:

Description

The 7.6 and 6.2 implementation of Typo3DatabaseBackend cache backend has bugs in two methods (in mysql-non-dbal versions). Those were introduced by #61814 and fixed in master with #77160

flushByTag() leaves orphaned tags in tags table - if a row has two tags and flushByTag() is executed on one tag, the other is left.

collectGargabe() does not find orphaned tags
collectGarbage() does not delete an expired cache row if it has no tags (fix: left outer join)

Task is to migrate the functional tests from master over to 7.6 (and 6.2?) - those will show the issues.

Related issues 3 (0 open — 3 closed)

Related to TYPO3 Core - Task #77160: Doctrine: migrate ext:core cache Typo3DatabaseBackend

Closed

2016-07-20

Actions

Related to TYPO3 Core - Bug #61814: Caching framework garbage collection scheduler task taking ages with database backend and large websites

Closed

2014-09-23

Actions

Related to TYPO3 Core - Bug #21309: Move t3lib_matchCondition::whichDevice() to t3lib_utility_Client::getDeviceType()

Closed

Oliver Hader

2009-10-19

Actions

Issue # Delay: days Cancel

History
Notes
Property changes
Associated revisions

Actions

Copy link

Updated by Gerrit Code Review over 7 years ago

Status changed from New to Under Review

Patch set 1 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49309

Actions

Copy link

Updated by Gerrit Code Review over 7 years ago

Patch set 2 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49309

Actions

Copy link

Updated by Gerrit Code Review over 7 years ago

Patch set 3 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49309

Actions

Copy link

Updated by Gerrit Code Review over 7 years ago

Patch set 4 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49309

Actions

Copy link

Updated by Gerrit Code Review over 7 years ago

Patch set 5 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49309

Actions

Copy link

Updated by Gerrit Code Review over 7 years ago

Patch set 6 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49309

Actions

Copy link

Updated by Gerrit Code Review over 7 years ago

Patch set 7 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49309

Actions

Copy link

Updated by Gerrit Code Review over 7 years ago

Patch set 8 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49309

Actions

Copy link

Updated by Gerrit Code Review over 7 years ago

Patch set 9 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49309

Actions

Copy link

#10

Updated by Gerrit Code Review over 7 years ago

Patch set 1 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49907

Actions

Copy link

#11

Updated by Gerrit Code Review over 7 years ago

Patch set 2 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49907

Actions

Copy link

#12

Updated by Gerrit Code Review over 7 years ago

Patch set 3 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49907

Actions

Copy link

#13