Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-5480

engines/funcs.ai_reset_by_truncate failure

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 5.7.x
    • Fix Version/s: None
    • Component/s: TokuDB
    • Labels:

      Description

      engines/funcs.ai_reset_by_truncate fails on below diff

      [ 30%] engines/funcs.ai_reset_by_truncate       w6 [ fail ]
              Test ended at 2019-03-12 01:43:48
      
      CURRENT_TEST: engines/funcs.ai_reset_by_truncate
      --- /tmp/results/PS/mysql-test/suite/engines/funcs/r/ai_reset_by_truncate.result	2019-03-12 02:17:49.000000000 +0300
      +++ /tmp/results/PS/mysql-test/var/6/log/ai_reset_by_truncate.reject	2019-03-12 04:43:48.021167725 +0300
      @@ -18,28 +18,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -60,28 +60,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` smallint(6) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -102,28 +102,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 INT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -144,28 +144,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` int(11) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -186,28 +186,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` int(11) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -228,28 +228,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` bigint(20) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -270,28 +270,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -312,28 +312,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` smallint(6) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -354,28 +354,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 INT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -396,28 +396,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` int(11) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -438,28 +438,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` int(11) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -480,28 +480,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` bigint(20) NOT NULL AUTO_INCREMENT,
         PRIMARY KEY (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -529,7 +529,7 @@
       t1	CREATE TABLE `t1` (
         `c1` tinyint(4) AUTO_INCREMENT,
         UNIQUE KEY `c1` (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
      @@ -571,7 +571,7 @@
       t1	CREATE TABLE `t1` (
         `c1` smallint(6) AUTO_INCREMENT,
         UNIQUE KEY `c1` (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
      @@ -613,7 +613,7 @@
       t1	CREATE TABLE `t1` (
         `c1` mediumint(9) AUTO_INCREMENT,
         UNIQUE KEY `c1` (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
      @@ -655,7 +655,7 @@
       t1	CREATE TABLE `t1` (
         `c1` int(11) AUTO_INCREMENT,
         UNIQUE KEY `c1` (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
      @@ -697,7 +697,7 @@
       t1	CREATE TABLE `t1` (
         `c1` int(11) AUTO_INCREMENT,
         UNIQUE KEY `c1` (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
      @@ -739,7 +739,7 @@
       t1	CREATE TABLE `t1` (
         `c1` bigint(20) AUTO_INCREMENT,
         UNIQUE KEY `c1` (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
      @@ -774,28 +774,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
         UNIQUE KEY `c1` (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
       TRUNCATE TABLE t1;
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +11
       DROP TABLE t1;
       CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
      @@ -816,28 +816,28 @@
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
      +10
       ALTER TABLE t1 AUTO_INCREMENT=10;
       SHOW CREATE TABLE t1;
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `c1` smallint(6) NOT NULL AUTO_INCREMENT,
         UNIQUE KEY `c1` (`c1`)
      -) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
      +) ENGINE=ENGINE AUTO_INCREMENT=11 DEFAULT CHARSET=latin1
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       INSERT INTO t1 VALUES(null);
       SELECT * FROM t1;
       c1
      -1
       10
       11
       12
      +13
      
      
      . . .
      
      mysqltest: Result content mismatch
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                marcelo.altmann Marcelo Altmann
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: