Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1714

LP #1356859: Mtr against a standalone mysql-codership: innodb.innodb-autoinc

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Esa Kettunen last update 09-02-2015 22:58:20

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

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: