Project

General

Profile

Actions

Bug #103139

closed

Missing expires in cache_treelist leads to duplicate key value violates unique constraint in the database

Added by Sascha Nowak 9 months ago. Updated 4 months ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Caching
Target version:
Start date:
2024-02-17
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
12
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

In one of my projects I have a lot of "duplicate key value violates unique constraint" errors in the database log:

ERROR:  duplicate key value violates unique constraint "cache_treelist_pkey" 
DETAIL:  Key (md5hash)=(c26b3f85a19047fd109fbb6dc008ede5) already exists.
STATEMENT:  INSERT INTO "cache_treelist" ("md5hash", "pid", "treelist", "tstamp") VALUES ($1, $2, $3, $4)

After digging into it, I found out that the cache entry has no expires timestamp which lead to not having a cache at all and the entry is written multiple times per request. In my case twice.


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Task #103165: Remove treelist cache completely from coreClosed2024-02-21

Actions
Related to TYPO3 Core - Bug #26161: cache_treelist is out of date when using starttimeClosed2011-04-21

Actions
Actions

Also available in: Atom PDF