Details
Description
CREATE TABLE `extralongname_extralongname_extralongname_extralongname_ext` ( |
`id` int(10) unsigned NOT NULL, |
`created_date` date NOT NULL DEFAULT '1970-01-01' COMMENT 'DATE(created), for index & partitions', |
`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', |
PRIMARY KEY (`created`,`id`,`created_date`) |
) ENGINE=InnoDB STATS_PERSISTENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC |
/*!50100 PARTITION BY RANGE ( YEAR(created_date))
|
SUBPARTITION BY HASH ( MONTH(created_date))
|
SUBPARTITIONS 2
|
(PARTITION p2007 VALUES LESS THAN (2008) ENGINE = InnoDB,
|
PARTITION p2008 VALUES LESS THAN (2009) ENGINE = InnoDB
|
) */ |
Phase 4/7: Running 'mysql_fix_privilege_tables'
|
ERROR 1062 (23000) Duplicate entry 'extralongname_extralongname_extralongname_extralongname_ext#P#p2' for key 'PRIMARY'
|
ERROR 1062 (23000) Duplicate entry 'extralongname_extralongname_extralongname_extralongname_ext#P#p2' for key 'PRIMARY'
|
FATAL ERROR: Upgrade failed
|
After
truncate mysql.innodb_table_stats; |
mysql_upgrade runs fine.
Attachments
Issue Links
- is caused by
-
MDEV-13360 too long values in mysql.innodb_table_stats.table_name
- Stalled
- links to