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

Bug #1356859 reported by Esa Kettunen on 2014-08-14
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Status tracked in 5.6
5.5
Medium
Philip Stoev
5.6
Medium
Unassigned
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Status tracked in 5.6
5.5
New
Undecided
Unassigned
5.6
Fix Released
Undecided
Unassigned

Bug Description

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

Tags: mtr Edit Tag help
Esa Kettunen (egge) on 2014-08-14
tags: added: mtr
Esa Kettunen (egge) on 2014-08-14
description: updated
Esa Kettunen (egge) wrote :

Listing of mtr run output as an attachment.

description: updated
Esa Kettunen (egge) on 2014-08-15
Changed in codership-mysql:
milestone: 5.6.20-25.6 → 5.5.38-25.11
milestone: 5.5.38-25.11 → 5.6.20-25.6
Esa Kettunen (egge) on 2014-08-15
Changed in codership-mysql:
milestone: 5.6.20-25.6 → 5.5.38-25.11
milestone: 5.5.38-25.11 → 5.6.20-25.6
Philip Stoev (philip-stoev-f) wrote :

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

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers