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

mysql_upgrade fails if dbname+tablename+partioname > 64 chars

    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

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

                Dates

                • Created:
                  Updated:
                  Resolved: