Bug #49177
closed
INSERT cache in DB-table 'cache_pagesection' produces the MySQL-Error 'Duplicate Entry'
0%
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
Updated by Markus Klein almost 11 years ago
- Status changed from New to Accepted
- Target version set to next-patchlevel
Hi Jürgen,
thanks for your patch.
Would you mind pushing your patch to our review system?
Details can be found here: http://wiki.typo3.org/Contribution_Walkthrough_Tutorials
~Markus
Updated by Alexander Opitz almost 11 years ago
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.
Updated by Mathias Schreiber over 8 years ago
- Target version deleted (
next-patchlevel)
Updated by Benni Mack over 8 years ago
- 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.
Updated by Juergen Kussmann over 8 years ago
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.
Updated by Riccardo De Contardi over 8 years ago
- Status changed from Needs Feedback to Closed
closed as requested by the reporter
Thank you