Running mysql standard test suite mtr against a standalone mysql with codership patches: ./mtr -mysqld=--wsrep_auto_increment_control=0,--auto_increment_offset=1,--auto_increment_increment=1 --reorder --report-features --comment="Trying reorder, report-features and mysqld parameters" --mem --suite innodb --debug-server --no-warnings --force --max-test-fail=100 | tee /home/egge/mtr-run-2014-08-07-b.txt We find the following bugs: innodb.innodb-autoinc innodb.innodb_prefix_index_restart_server Documented here: innodb.innodb-autoinc Test Fail Description: --- /home/egge/aug/codership-mysql/mysql-test/suite/innodb/r/innodb-autoinc.result 2014-08-04 18:49:21.263878000 +0300 +++ /home/egge/aug/codership-mysql/mysql-test/var/log/innodb-autoinc.reject 2014-08-07 14:54:31.123659708 +0300 @@ -201,7 +201,7 @@ Variable_name Value auto_increment_increment 100 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -235,7 +235,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -275,7 +275,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -289,7 +289,7 @@ Variable_name Value auto_increment_increment 100 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (-2), (NULL),(2),(NULL); INSERT INTO t1 VALUES (250),(NULL); SELECT * FROM t1; @@ -323,7 +323,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -339,7 +339,7 @@ Variable_name Value auto_increment_increment 100 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (-2); Warnings: Warning 1264 Out of range value for column 'c1' at row 1 @@ -380,7 +380,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -396,7 +396,7 @@ Variable_name Value auto_increment_increment 100 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (-2),(NULL),(2),(NULL); Warnings: Warning 1264 Out of range value for column 'c1' at row 1 @@ -431,7 +431,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -447,7 +447,7 @@ Variable_name Value auto_increment_increment 2 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL); SELECT * FROM t1; c1 @@ -466,7 +466,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -482,7 +482,7 @@ Variable_name Value auto_increment_increment 2 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL); ERROR HY000: Failed to read auto-increment value from storage engine SELECT * FROM t1; @@ -496,7 +496,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -512,7 +512,7 @@ Variable_name Value auto_increment_increment 5 auto_increment_offset 7 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (NULL),(NULL), (NULL); ERROR HY000: Failed to read auto-increment value from storage engine SELECT * FROM t1; @@ -526,7 +526,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -546,7 +546,7 @@ Variable_name Value auto_increment_increment 3 auto_increment_offset 3 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (NULL),(NULL), (NULL); SELECT * FROM t1; c1 @@ -564,7 +564,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -583,7 +583,7 @@ Variable_name Value auto_increment_increment 65535 auto_increment_offset 65535 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (NULL),(NULL); ERROR 22003: Out of range value for column 't1' at row 167 SELECT * FROM t1; @@ -597,7 +597,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF CREATE TABLE t1 (c1 DOUBLE NOT NULL AUTO_INCREMENT, c2 INT, PRIMARY KEY (c1)) ENGINE=InnoDB; INSERT INTO t1 VALUES(NULL, 1); INSERT INTO t1 VALUES(NULL, 2); @@ -885,7 +885,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF CREATE TABLE t1 (c1 TINYINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB; INSERT INTO t1 VALUES (1, NULL); INSERT INTO t1 VALUES (-1, 'innodb'); @@ -1276,6 +1276,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 256 +wsrep_auto_increment_control OFF CREATE TABLE t1 (c1 TINYINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB; INSERT INTO t1 VALUES (1, NULL); SHOW CREATE TABLE t1; @@ -1294,6 +1295,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 +wsrep_auto_increment_control OFF CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB; INSERT INTO t1 VALUES (2147483648, 'a'); SHOW CREATE TABLE t1; Analysis wsrep_auto_increment_control=0,--auto_increment_offset=1,--auto_increment_increment=1 --reorder --report-features --comment="Trying reorder, report-features and mysqld parameters" --mem --suite innodb --debug-server --no-warnings --force --max-test-fail=100 | tee /home/egge/mtr-run-2014-08-07-b.txt We find the following bugs: innodb.innodb-autoinc innodb.innodb_prefix_index_restart_server Documented here: innodb.innodb-autoinc Test Fail Description: --- /home/egge/aug/codership-mysql/mysql-test/suite/innodb/r/innodb-autoinc.result 2014-08-04 18:49:21.263878000 +0300 +++ /home/egge/aug/codership-mysql/mysql-test/var/log/innodb-autoinc.reject 2014-08-07 14:54:31.123659708 +0300 @@ -201,7 +201,7 @@ Variable_name Value auto_increment_increment 100 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -235,7 +235,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -275,7 +275,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -289,7 +289,7 @@ Variable_name Value auto_increment_increment 100 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (-2), (NULL),(2),(NULL); INSERT INTO t1 VALUES (250),(NULL); SELECT * FROM t1; @@ -323,7 +323,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -339,7 +339,7 @@ Variable_name Value auto_increment_increment 100 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (-2); Warnings: Warning 1264 Out of range value for column 'c1' at row 1 @@ -380,7 +380,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -396,7 +396,7 @@ Variable_name Value auto_increment_increment 100 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (-2),(NULL),(2),(NULL); Warnings: Warning 1264 Out of range value for column 'c1' at row 1 @@ -431,7 +431,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -447,7 +447,7 @@ Variable_name Value auto_increment_increment 2 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL); SELECT * FROM t1; c1 @@ -466,7 +466,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -482,7 +482,7 @@ Variable_name Value auto_increment_increment 2 auto_increment_offset 10 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL); ERROR HY000: Failed to read auto-increment value from storage engine SELECT * FROM t1; @@ -496,7 +496,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -512,7 +512,7 @@ Variable_name Value auto_increment_increment 5 auto_increment_offset 7 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (NULL),(NULL), (NULL); ERROR HY000: Failed to read auto-increment value from storage engine SELECT * FROM t1; @@ -526,7 +526,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -546,7 +546,7 @@ Variable_name Value auto_increment_increment 3 auto_increment_offset 3 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (NULL),(NULL), (NULL); SELECT * FROM t1; c1 @@ -564,7 +564,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' @@ -583,7 +583,7 @@ Variable_name Value auto_increment_increment 65535 auto_increment_offset 65535 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF INSERT INTO t1 VALUES (NULL),(NULL); ERROR 22003: Out of range value for column 't1' at row 167 SELECT * FROM t1; @@ -597,7 +597,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF CREATE TABLE t1 (c1 DOUBLE NOT NULL AUTO_INCREMENT, c2 INT, PRIMARY KEY (c1)) ENGINE=InnoDB; INSERT INTO t1 VALUES(NULL, 1); INSERT INTO t1 VALUES(NULL, 2); @@ -885,7 +885,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 -wsrep_auto_increment_control ON +wsrep_auto_increment_control OFF CREATE TABLE t1 (c1 TINYINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB; INSERT INTO t1 VALUES (1, NULL); INSERT INTO t1 VALUES (-1, 'innodb'); @@ -1276,6 +1276,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 256 +wsrep_auto_increment_control OFF CREATE TABLE t1 (c1 TINYINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB; INSERT INTO t1 VALUES (1, NULL); SHOW CREATE TABLE t1; @@ -1294,6 +1295,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 +wsrep_auto_increment_control OFF CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB; INSERT INTO t1 VALUES (2147483648, 'a'); SHOW CREATE TABLE t1; Analysis Setting wsrep_auto_increment_control=0 seems to fail, and yet it is expected to set to zero.