Bug #103139
closed
Missing expires in cache_treelist leads to duplicate key value violates unique constraint in the database
100%
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.
Updated by Gerrit Code Review 3 months ago
- Status changed from New to Under Review
Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83023
Updated by Gerrit Code Review 2 months ago
Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83023
Updated by Gerrit Code Review 2 months ago
Patch set 3 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83023
Updated by Gerrit Code Review 2 months ago
Patch set 1 for branch 12.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83055
Updated by Christian Kuhn 2 months ago
- Related to Task #103165: Remove treelist cache completely from core added
Updated by Sascha Nowak 2 months ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset b04415d6dd75bc977cb08cc734352d2c86b4d000.
Updated by Christian Kuhn 2 months ago
- Related to Bug #26161: cache_treelist is out of date when using starttime added