Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13274

mysql_upgrade fails if dbname+tablename+partioname > 64 chars

    XMLWordPrintable

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

          Activity

            People

              serg Sergei Golubchik
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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