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

[Esa Kettunen]

[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.

[Esa Kettunen (egge)]

Listing of mtr run output as an attachment.

[Philip Stoev (philip-stoev-f)]

This was fixed in 5.6 by changing the test so that wsrep_auto_increment_control is not printed out.

[Philip Stoev (philip-stoev-f)]

http://bazaar.launchpad.net/~codership/codership-mysql/5.6/revision/4137

[Shahriyar Rzayev (rzayev-sehriyar)]

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