Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16652

heap.heap_auto_increment, main.auto_increment fail, maria.maria-autoinc in buildbot with out-of-range error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.2, 10.3
    • N/A
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-aarch64/builds/448

      10.3 46857a860c90a643a8859e1bea81c727

      heap.heap_auto_increment                 w3 [ fail ]
              Test ended at 2018-06-30 12:42:55
       
      CURRENT_TEST: heap.heap_auto_increment
      mysqltest: In included file "./include/autoinc_mdev15353.inc": 
      included from /usr/share/mysql/mysql-test/suite/heap/heap_auto_increment.test at line 43:
      At line 21: query 'CALL autoinc_mdev15353_one(@engine, 'tinyint')' failed: 167: Out of range value for column 'id' at row 1
       
      The result from queries just before the failure was:
      < snip >
      #
      SET @engine='MEMORY';
      CREATE PROCEDURE autoinc_mdev15353_one(engine VARCHAR(64), t VARCHAR(64))
      BEGIN
      DECLARE query TEXT DEFAULT 'CREATE TABLE t1 ('
                                   '  id TTT NOT NULL AUTO_INCREMENT,'
                                   '  name CHAR(30) NOT NULL,'
                                   '  PRIMARY KEY (id)) ENGINE=EEE';
      EXECUTE IMMEDIATE REPLACE(REPLACE(query,'TTT', t), 'EEE', engine);
      SHOW CREATE TABLE t1;
      INSERT INTO t1 (name) VALUES ('dog');
      SELECT * FROM t1;
      UPDATE t1 SET id=-1 WHERE id=1;
      SELECT * FROM t1;
      INSERT INTO t1 (name) VALUES ('cat');
      SELECT * FROM t1;
      DROP TABLE t1;
      END;
      $$
      CALL autoinc_mdev15353_one(@engine, 'tinyint');
       
      More results from queries before failure can be found in /dev/shm/var/3/log/heap_auto_increment.log
       
      Warnings from just before the error:
      Error 167 Out of range value for column 'id' at row 1
      

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.