Bug #20502

MYSQL Replication breaks because of lack of AUTO_INCREMENT PK in cache_treesection

Added by Lukas Taferner over 12 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Caching
Target version:
-
Start date:
2009-05-25
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
4.3
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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)


Related issues

Related to TYPO3 Core - Bug #20065: MYSQL Replication breaks because of lack of AUTO_INCREMENT PK in cache_pagesectionClosedChristian Kuhn2009-02-20

Actions

Also available in: Atom PDF