Issue Bug Closed

#20502MYSQL Replication breaks because of lack of AUTO_INCREMENT PK in cache_treesection

Lukas Taferner 05/25/09, 17:07 updated 10/02/18, 12:25

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.