[MDEV-13274] mysql_upgrade fails if dbname+tablename+partioname > 64 chars - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0(EOL), 10.1(EOL)
Fix Version/s: 10.1.26, 10.0.32, 10.2.8
Component/s: Server
Labels:
- upstream
Environment:
Ubuntu 16.04

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

Bug #86926 mysql 5.7

Activity

Ascending order - Click to sort in descending order

Richard Stracke created issue - 2017-07-07 19:31

Elena Stepanova made changes - 2017-07-09 19:57

Field	Original Value	New Value
Assignee		Alice [ alice ]

Sergei Golubchik made changes - 2017-07-10 06:30

Description

{code:sql}
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
) */
{code}

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

{code:sql}
truncate mysql.innodb_table_stats;
{code}

mysql_upgrade runs fine.

{code:sql}
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
) */
{code}
{noformat}
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
{noformat}
After

{code:sql}
truncate mysql.innodb_table_stats;
{code}

mysql_upgrade runs fine.

Alice Sherepa made changes - 2017-07-10 21:56

Labels

upstream

Alice Sherepa made changes - 2017-07-10 21:57

Status

Open [ 1 ]

Confirmed [ 10101 ]

Alice Sherepa made changes - 2017-07-10 22:00

Remote Link

This issue links to " related in mysql 5.7 (Web Link)" [ 28003 ]

Alice Sherepa made changes - 2017-07-10 22:01

Remote Link

This issue links to " related in mysql 5.7 (Web Link)" [ 28003 ]

Alice Sherepa made changes - 2017-07-10 22:02

Remote Link

This issue links to "mysql 5.7 (Web Link)" [ 28004 ]

Alice Sherepa made changes - 2017-07-10 22:02

Remote Link

This issue links to "mysql 5.7 (Web Link)" [ 28004 ]

Alice Sherepa made changes - 2017-07-10 22:03

Remote Link

This issue links to "Bug #86926 mysql 5.7 (Web Link)" [ 28005 ]

Sergei Golubchik made changes - 2017-07-11 13:39

Assignee

Alice Sherepa [ alice ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2017-07-11 13:39

Fix Version/s		10.0 [ 16000 ]
Fix Version/s		10.1 [ 16100 ]
Fix Version/s		10.2 [ 14601 ]

Sergei Golubchik made changes - 2017-07-11 13:39

Description

{code:sql}
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
) */
{code}
{noformat}
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
{noformat}
After

{code:sql}
truncate mysql.innodb_table_stats;
{code}

mysql_upgrade runs fine.

{code:sql}
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
) */
{code}
{noformat}
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
{noformat}
After

{code:sql}
truncate mysql.innodb_table_stats;
{code}

mysql_upgrade runs fine.

Sergei Golubchik made changes - 2017-07-20 13:01

Link

This issue is caused by MDEV-13360 [ MDEV-13360 ]

Sergei Golubchik made changes - 2017-07-20 13:05

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2017-07-20 13:05

Labels

upstream

Sergei Golubchik made changes - 2017-07-20 13:06

Labels

upstream

Sergei Golubchik made changes - 2017-07-20 13:09

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Sergei Golubchik made changes - 2017-07-20 18:15

Fix Version/s		10.0.32 [ 22504 ]
Fix Version/s		10.1.26 [ 22553 ]
Fix Version/s		10.2.8 [ 22544 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.0 [ 16000 ]
Fix Version/s	10.1 [ 16100 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:45

Workflow

MariaDB v3 [ 81599 ]

MariaDB v4 [ 152452 ]

Jira Automation (IT) made changes - 2024-07-04 08:22

Zendesk Related Tickets

164082

People

Assignee:: Sergei Golubchik

Reporter:: Richard Stracke

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2017-07-07 19:31

Updated:: 2024-07-08 00:38

Resolved:: 2017-07-20 18:15

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration