Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1716

LP #1358681: Mtr against a standalone mysql-codership: innodb.innodb-alter-autoinc

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Esa Kettunen last update 09-02-2015 22:57:14

      Running mysql standard test suite mtr against a standalone mysql with
      codership patches:

      ./mtr -reorder --report-features --comment="Trying reorder, report
      features" --mem --suite innodb --debug-server --no-warnings --force
      --max-test-fail=100 | tee /home/egge/mtr-run-2014-08-18-a.txt

      [The bug is repeatable and deterministic.]

      CURRENT_TEST: innodb.innodb-alter-autoinc
      — /home/egge/aug/codership-mysql/mysql-test/suite/innodb/r/innodb-alter-autoinc.result 2014-08-05 14:51:52.924766000 +0300
      +++ /home/egge/aug/codership-mysql/mysql-test/var/log/innodb-alter-autoinc.reject 2014-08-15 08:38:55.406751640 +0300
      @@ -29,17 +29,17 @@
      `id` int(11) NOT NULL AUTO_INCREMENT,
      PRIMARY KEY (`id`),
      KEY `id` (`id`,`a`)
      -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1
      +) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1
      BEGIN;
      INSERT INTO t1 VALUES(7,0);
      SELECT * FROM t1;
      a id
      -6 45
      -45 50
      -123 55
      -347 60
      -33101 65
      -7 70
      +6 42
      +45 43
      +123 44
      +347 45
      +33101 46
      +7 47
      ROLLBACK;
      SHOW CREATE TABLE t1;
      Table Create Table
      @@ -48,7 +48,7 @@
      `id` int(11) NOT NULL AUTO_INCREMENT,
      PRIMARY KEY (`id`),
      KEY `id` (`id`,`a`)
      -) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1
      +) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1
      ALTER TABLE t1 DROP PRIMARY KEY, ADD id INT AUTO_INCREMENT PRIMARY KEY,
      DROP COLUMN id, AUTO_INCREMENT = 42, LOCK=NONE;
      ERROR 0A000: LOCK=NONE is not supported. Reason: Adding an auto-increment column requires a lock. Try LOCK=SHARED.
      @@ -56,11 +56,11 @@
      DROP COLUMN id, AUTO_INCREMENT = 42, ALGORITHM=INPLACE;
      SELECT * FROM t1;
      a id
      -6 45
      -45 50
      -123 55
      -347 60
      -33101 65
      +6 42
      +45 43
      +123 44
      +347 45
      +33101 46
      SHOW CREATE TABLE t1;
      Table Create Table
      t1 CREATE TABLE `t1` (
      @@ -68,7 +68,7 @@
      `id` int(11) NOT NULL AUTO_INCREMENT,
      PRIMARY KEY (`id`),
      KEY `id` (`id`,`a`)
      -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1
      +) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1
      INSERT INTO t1 SET a=123;
      INSERT INTO t1 VALUES(-123,-45);
      ALTER TABLE t1 AUTO_INCREMENT = 75;
      @@ -76,12 +76,12 @@
      SELECT * FROM t1;
      a id
      -123 -45
      -6 45
      -45 50
      -123 55
      -347 60
      -33101 65
      -123 70
      +6 42
      +45 43
      +123 44
      +347 45
      +33101 46
      +123 47
      123 75
      SHOW CREATE TABLE t1;
      Table Create Table
      @@ -90,7 +90,7 @@
      `id` int(11) NOT NULL AUTO_INCREMENT,
      PRIMARY KEY (`id`),
      KEY `id` (`id`,`a`)
      -) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1
      +) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1
      DROP TABLE t1;
      CREATE TABLE t1 (a INT) ENGINE=InnoDB;
      INSERT INTO t1 VALUES(347),(33101),(123),(45),(6);
      @@ -112,17 +112,17 @@
      `id` int(11) NOT NULL AUTO_INCREMENT,
      PRIMARY KEY (`id`),
      KEY `id` (`id`,`a`)
      -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1
      +) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1
      BEGIN;
      INSERT INTO t1 VALUES(7,0);
      SELECT * FROM t1;
      a id
      -6 45
      -45 50
      -123 55
      -347 60
      -33101 65
      -7 70
      +6 42
      +45 43
      +123 44
      +347 45
      +33101 46
      +7 47
      ROLLBACK;
      SHOW CREATE TABLE t1;
      Table Create Table
      @@ -131,16 +131,16 @@
      `id` int(11) NOT NULL AUTO_INCREMENT,
      PRIMARY KEY (`id`),
      KEY `id` (`id`,`a`)
      -) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1
      +) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1
      ALTER TABLE t1 DROP PRIMARY KEY, ADD id INT AUTO_INCREMENT PRIMARY KEY,
      DROP COLUMN id, AUTO_INCREMENT = 42, ALGORITHM=COPY;
      SELECT * FROM t1;
      a id
      -6 45
      -45 50
      -123 55
      -347 60
      -33101 65
      +6 42
      +45 43
      +123 44
      +347 45
      +33101 46
      SHOW CREATE TABLE t1;
      Table Create Table
      t1 CREATE TABLE `t1` (
      @@ -148,7 +148,7 @@
      `id` int(11) NOT NULL AUTO_INCREMENT,
      PRIMARY KEY (`id`),
      KEY `id` (`id`,`a`)
      -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1
      +) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1
      INSERT INTO t1 SET a=123;
      INSERT INTO t1 VALUES(-123,-45);
      ALTER TABLE t1 AUTO_INCREMENT = 75;
      @@ -156,12 +156,12 @@
      SELECT * FROM t1;
      a id
      -123 -45
      -6 45
      -45 50
      -123 55
      -347 60
      -33101 65
      -123 70
      +6 42
      +45 43
      +123 44
      +347 45
      +33101 46
      +123 48
      123 75
      SHOW CREATE TABLE t1;
      Table Create Table
      @@ -170,5 +170,5 @@
      `id` int(11) NOT NULL AUTO_INCREMENT,
      PRIMARY KEY (`id`),
      KEY `id` (`id`,`a`)
      -) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1
      +) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1
      DROP TABLE t1;

      mysqltest: Result content mismatch

      • saving '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb-alter-autoinc/' to '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb-alter-autoinc/'

      Analysis:
      ---------
      Some setting regarding autoincrement must have failed so that there is a
      systematic bias in the results.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              krunal.bauskar Krunal Bauskar (Inactive)
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: