Bug #20502
closed
MYSQL Replication breaks because of lack of AUTO_INCREMENT PK in cache_treesection
Added by Lukas Taferner about 15 years ago.
Updated over 5 years ago.
Description
Thank you for implementing auto_incrementing PK's in cache_pages and cache_pagesection in 4.3, the table cache_treelist however still has a md5 hash as primary key. This will break replication in a multimaster mysql setup.
Solution:
CREATE TABLE `cache_pages` (
`id` int(11) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
)
(issue imported from #M11184)
Lukas, could you please send me your MySQL Server and Replication settings?
Are there two MySQL Masters running and replicating at the same time in your scenario?
Hi Oliver, we have a setup with multiple MySQL Masters with crossreplication i.e. every write operation is replicated to all the other DB hosts. We could have chosen to set caching to 5 min. and exclude cache* from replication, but it's better to be able to clear the cache on the livebackend (and replicate this to the other hosts) in realtime.
Oliver, can you please take care that the issue will be fixed :)
Please check my comment @ #0010508
Same for cache_imagesizes.
- Status changed from New to Needs Feedback
- Target version deleted (
0)
The issue is very old, does this issue exists in newer versions of TYPO3 CMS (4.5 or 6.1)?
- Status changed from Needs Feedback to New
Alexander Opitz wrote:
does this issue exists in newer versions of TYPO3 CMS (4.5 or 6.1)?
Table "cache_treesection" does not exist anymore in current versions.
The problem however is still present for the table "cache_imagesizes".
The problem exists for all MM relation tables, too.
Problem still present in 4.5 too.
- TYPO3 Version changed from 4.3 to 6.2
- Is Regression set to No
Problem is still present in 6.2 (I mean, about cache_imagesizes)
In 7.x cache_imagesizes is ported to the caching framework.
- Status changed from New to Resolved
resolved as mentioned about the caching framework
- Status changed from Resolved to Closed
Also available in: Atom
PDF