Project

General

Profile

Actions

Bug #26161

closed

cache_treelist is out of date when using starttime

Added by D. Pöpping over 13 years ago. Updated 4 months ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Caching
Start date:
2011-04-21
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
7.2
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

When using a startdate for a page the tslib_cObj->getTreeList will never get this page in its results until "clear all cache" is used in order to clear the cache table for the tree list results.
(see Feature #18852 and related Bug #22412)


Files

Diff-REALMCTECHNIK-227.diff (3.29 KB) Diff-REALMCTECHNIK-227.diff Patch Daniel Siepmann, 2013-09-17 14:01

Related issues 3 (0 open3 closed)

Related to TYPO3 Core - Feature #18852: Speed up tslib_cObj->getTreeList by caching its resultsClosedIngo Renner2008-05-26

Actions
Related to TYPO3 Core - Bug #22412: cache_treelist is out of dateClosedDmitry Dulepov2010-04-10

Actions
Related to TYPO3 Core - Bug #103139: Missing expires in cache_treelist leads to duplicate key value violates unique constraint in the databaseClosed2024-02-17

Actions
Actions #1

Updated by Daniel Siepmann about 11 years ago

We have same issue in 4.7.15.

Here is our setup:
- [1] Folder
-- [2] Page 1 [Start Monday End Tuesday]
-- [3] Page 2 [Start Tuesday End Wednesday]
-- [4] Page 3 [Start Wednesday End Thursday]
-- ...

Our TypoScript is the following:

lib.example < styles.content.get
lib.example.select {
    where = colPos=1
    pidInList = 1
    recursive = 3
}

On Monday the first entry will be inserted into the table containing only 1 and 2.
On Tuesday the same entry will be fetched, but Page 2 is no more accessible. But Page 2 is which is not in the cache entry.

If you don't clear the cache it will not work.

I attached our own working patch for 4.7.15.
It will insert the expired time for the first possible situation. So if we have Tuesday it will no longer fetch the cached entry, but will create a new one and remove the old one.

Another problem was that the simulated time was not used, so you could not test this scenario using the admin panel.

Actions #2

Updated by Wouter Wolters about 11 years ago

  • Is Regression set to No

Hi Daniel,

Can you push a patch for this to Gerrit?
For information about how to do this see: http://wiki.typo3.org/CWT

Greetz Wouter

Actions #3

Updated by Mathias Schreiber almost 10 years ago

  • Target version set to 7.2 (Frontend)
Actions #4

Updated by Benni Mack over 9 years ago

  • Target version changed from 7.2 (Frontend) to 7.4 (Backend)
Actions #5

Updated by Susanne Moog over 9 years ago

  • Target version changed from 7.4 (Backend) to 7.5
Actions #6

Updated by Benni Mack about 9 years ago

  • Target version changed from 7.5 to 7 LTS
Actions #7

Updated by Mathias Schreiber about 9 years ago

  • Target version changed from 7 LTS to 8 LTS
Actions #8

Updated by Benni Mack over 7 years ago

  • Target version changed from 8 LTS to Candidate for patchlevel
Actions #9

Updated by ondro no-lastname-given about 6 years ago

D. Pöpping wrote:

When using a startdate for a page the tslib_cObj->getTreeList will never get this page in its results until "clear all cache" is used in order to clear the cache table for the tree list results.
(see Feature #18852 and related Bug #22412)

Can confirm same behaviour with Typo3 8.7.19

Actions #10

Updated by Philipp Thiele almost 4 years ago

  • TYPO3 Version changed from 4.4 to 10
  • PHP Version changed from 5.3 to 7.2

Can confirm this issue with TYPO3 Version 10.4.10

Actions #11

Updated by Christian Kuhn 9 months ago

  • Related to Bug #103139: Missing expires in cache_treelist leads to duplicate key value violates unique constraint in the database added
Actions #12

Updated by Christian Kuhn 9 months ago

  • Status changed from New to Resolved

This was finally solved by avoiding cache_treelist since v12 with #103139.

Actions #13

Updated by Benni Mack 4 months ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF