MySQL patches by Codership

  1. Series 5.5
  2. Bug #1356859
  3. Activity log

Activity log for bug #1356859

Date Who What changed Old value New value Message
2014-08-14 12:43:19 Esa Kettunen bug added bug
2014-08-14 12:44:00 Esa Kettunen tags mtr
2014-08-14 13:12:58 Esa Kettunen description 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. [NOTE: Ignore the following. The bug description is faulty. I will provide a correction as soon as possible.] 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.
2014-08-15 08:52:48 Esa Kettunen description [NOTE: Ignore the following. The bug description is faulty. I will provide a correction as soon as possible.] 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. [Edit: Bug description now fixed.] 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-14-a.txt Amongst the bugs we find the following: CURRENT_TEST: innodb.innodb-autoinc --- /home/egge/aug/codership-mysql/mysql-test/suite/innodb/r/innodb-autoinc.result 2014-08-05 14:51:52.924766000 +0300 +++ /home/egge/aug/codership-mysql/mysql-test/var/log/innodb-autoinc.reject 2014-08-15 08:36:06.978754553 +0300 @@ -1276,6 +1276,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 256 +wsrep_auto_increment_control ON 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 ON 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: --------- The variable wsrep_auto_increment_control = ON is not part of standard MySQL and the mtr test suite needs to be patched accordingly.
2014-08-15 08:54:21 Esa Kettunen attachment added mtr-run-2014-08-14-a.txt https://bugs.launchpad.net/codership-mysql/+bug/1356859/+attachment/4178241/+files/mtr-run-2014-08-14-a.txt
2014-08-15 09:13:51 Esa Kettunen codership-mysql: milestone 5.6.20-25.6 5.5.38-25.11
2014-08-15 09:14:36 Esa Kettunen codership-mysql: milestone 5.5.38-25.11 5.6.20-25.6
2014-08-15 13:23:48 Esa Kettunen codership-mysql: milestone 5.6.20-25.6 5.5.38-25.11
2014-08-15 13:24:06 Esa Kettunen codership-mysql: milestone 5.5.38-25.11 5.6.20-25.6
2014-08-15 14:34:04 Esa Kettunen nominated for series codership-mysql/5.6
2014-08-15 14:34:04 Esa Kettunen bug task added codership-mysql/5.6
2014-08-15 14:34:04 Esa Kettunen nominated for series codership-mysql/5.5
2014-08-15 14:34:04 Esa Kettunen bug task added codership-mysql/5.5
2014-08-15 14:35:29 Esa Kettunen codership-mysql/5.5: importance Undecided Medium
2014-08-15 14:35:33 Esa Kettunen codership-mysql/5.5: assignee Esa Kettunen (egge)
2014-08-15 14:35:45 Esa Kettunen codership-mysql/5.5: milestone 5.5.38-25.11
2014-09-22 14:25:04 Philip Stoev codership-mysql/5.6: status New Confirmed
2014-09-22 14:25:11 Philip Stoev codership-mysql/5.6: status Confirmed Fix Committed
2014-09-22 14:25:17 Philip Stoev codership-mysql/5.6: assignee Esa Kettunen (egge)
2014-09-22 14:25:22 Philip Stoev codership-mysql/5.5: assignee Esa Kettunen (egge) Philip Stoev (philip-stoev-f)
2014-10-03 22:42:57 Raghavendra D Prabhu bug task added percona-xtradb-cluster
2014-10-03 22:43:46 Raghavendra D Prabhu nominated for series percona-xtradb-cluster/5.5
2014-10-03 22:43:46 Raghavendra D Prabhu bug task added percona-xtradb-cluster/5.5
2014-10-03 22:43:46 Raghavendra D Prabhu nominated for series percona-xtradb-cluster/5.6
2014-10-03 22:43:46 Raghavendra D Prabhu bug task added percona-xtradb-cluster/5.6
2014-10-03 22:44:03 Raghavendra D Prabhu percona-xtradb-cluster/5.6: milestone 5.6.21-25.8
2014-10-03 22:44:06 Raghavendra D Prabhu percona-xtradb-cluster/5.6: status New Fix Committed
2014-10-03 22:44:09 Raghavendra D Prabhu percona-xtradb-cluster/5.5: milestone future-5.5
2014-11-25 15:53:52 Hrvoje Matijakovic percona-xtradb-cluster/5.6: status Fix Committed Fix Released
2015-02-09 22:58:10 Alex Yurchenko codership-mysql/5.6: status Fix Committed Fix Released
2015-02-09 22:58:18 Alex Yurchenko codership-mysql/5.6: milestone 5.6.20-25.6 5.6.21-25.9