Project

General

Profile

Actions
Copy link

Bug #87139

closed

Regression: getTreeList inserts duplicate keys in cache_treelist

Added by Alexander Schnitzler almost 6 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Alexander Schnitzler
Category:
Caching
Target version:
next-patchlevel
Start date:
2018-12-12
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
9
PHP Version:
7.2
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:

Description

Unfortunately https://review.typo3.org/58951/ did not actually solve issues 86028 and 86491 for good.

There are several issues with the last approach:

1) The expiration time of all created caches was 0, which resulted in a permanent creation and deletion of cache entries. This behaviour cannot be called caching.
2) Number 1 increases the chance for race conditions where several parallel requests tried to create the same cache entry.

The solution:

New cache entries get an expiry date of 2145909600 (that's equal PHP_INT_MAX (32bit) and the same number that is used in the caching framework).
Also, new caches are created within a transaction, which prevents duplicate key errors.

Related issues 2 (0 open — 2 closed)

Related to TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelistClosedAlexander Schnitzler2018-08-29

Actions
Related to TYPO3 Core - Bug #86491: Duplicate entry for PRIMARY key in cache_treelistClosedAlexander Schnitzler2018-10-01

Actions
Actions
Copy link

Also available in: Atom PDF