Bug #49177
closed
INSERT cache in DB-table 'cache_pagesection' produces the MySQL-Error 'Duplicate Entry'
Added by Juergen Kussmann almost 11 years ago.
Updated about 8 years ago.
Description
Hi,
if there are two concurrent PHP-Requests, which try to write the same Cache of DB-table 'cache_pagesection', than the MySQL-Error 'Duplicate Entry' can appear.
My Bugfix fixes to bug.
Files
- Status changed from New to Accepted
- Target version set to next-patchlevel
Your patch is ok if an update statement returns 0 rows cause there was nothing to update.
The problem that between select and insert another process can insert the row is left, but isn't easy fixable.
- Target version deleted (
next-patchlevel)
- Status changed from Accepted to Needs Feedback
- Is Regression set to No
Can you please check again with 6.2 or 7 LTS or master? The code changed quite a lot and we're using the more flexible caching framework now.
Hi Benni,
please close this bug-report. In our TYPO3 6.2, wo don't use this bugfix anymore and our (big) TYPO3-instance/-project run fine without that bugfix.
- Status changed from Needs Feedback to Closed
closed as requested by the reporter
Thank you
Also available in: Atom
PDF