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

[Esa Kettunen]

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.

[Seppo Jaakola (seppo-jaakola)]

TO isolation was run even when wsrep plugin was not loaded. This problem has been fixed in wsrep-5.6 revision:
http://bazaar.launchpad.net/~codership/codership-mysql/5.6/revision/4124

[Esa Kettunen (egge)]

5.6 fix verified by testing.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1716