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

innodb.innodb-mdev7046 fails in various ways on buildbot

    Details

      Description

      Failure on a valgrind build:
      http://buildbot.askmonty.org/buildbot/builders/work-amd64-valgrind/builds/6398/steps/test/logs/stdio

      Apparently because the valgrind build has symlinks disabled.

      innodb.innodb-mdev7046 'xtradb'          w2 [ fail ]
              Test ended at 2014-11-28 20:46:45
       
      CURRENT_TEST: innodb.innodb-mdev7046
      mysqltest: At line 27: query 'CREATE TABLE t1(id INT,purchased DATE)PARTITION BY RANGE(YEAR(purchased)) SUBPARTITION BY HASH(TO_DAYS(purchased)) SUBPARTITIONS 2 (PARTITION p0 VALUES LESS THAN MAXVALUE (SUBPARTITION sp0 DATA DIRECTORY='/tmp/not-existing' INDEX DIRECTORY='/tmp/not-existing',SUBPARTITION sp1))' succeeded - should have failed with errno 1...
       
      The result from queries just before the failure was:
      call mtr.add_suppression("InnoDB: File ./test/t1*");
      call mtr.add_suppression("nnoDB: Error number*");
      USE test;
      create table t1(f1 INT,f2 INT,f3 CHAR (10),primary key(f1,f2)) partition by range(f1) subpartition by hash(f2) subpartitions 2 (partition p1 values less than (0),partition p2 values less than (2),partition p3 values less than (2147483647));
      RENAME TABLE t1 TO `t2_new..............................................end`;
      ERROR HY000: Error on rename of 't2_new' (Errcode: 36 "File name too long")
      alter table t1 engine=innodb;
      RENAME TABLE t1 TO `t2_new..............................................end`;
      ERROR HY000: Error on rename of 't2_new' (errno: -1 "Internal error < 0 (Not system error)")
      show warnings;
      Level	Code	Message
      Error	1025	Error on rename of 't2_new' (errno: -1 "Internal error < 0 (Not system error)")
      drop table t1;
      DROP DATABASE test;
      CREATE DATABASE test;
      USE test;
      SET @@session.storage_engine=MYISAM;
      CREATE TABLE t1(id INT,purchased DATE)PARTITION BY RANGE(YEAR(purchased)) SUBPARTITION BY HASH(TO_DAYS(purchased)) SUBPARTITIONS 2 (PARTITION p0 VALUES LESS THAN MAXVALUE (SUBPARTITION sp0 DATA DIRECTORY='/tmp/not-existing' INDEX DIRECTORY='/tmp/not-existing',SUBPARTITION sp1));
       
      Warnings from just before the error:
      Warning 1618 <DATA DIRECTORY> option ignored

      -----------------

      Failure on Windows
      http://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/6619/steps/test/logs/stdio

      innodb.innodb-mdev7046 'xtradb'          [ fail ]
              Test ended at 2014-11-28 09:40:08
       
      CURRENT_TEST: innodb.innodb-mdev7046
      mysqltest: At line 27: query 'CREATE TABLE t1(id INT,purchased DATE)PARTITION BY RANGE(YEAR(purchased)) SUBPARTITION BY HASH(TO_DAYS(purchased)) SUBPARTITIONS 2 (PARTITION p0 VALUES LESS THAN MAXVALUE (SUBPARTITION sp0 DATA DIRECTORY='/tmp/not-existing' INDEX DIRECTORY='/tmp/not-existing',SUBPARTITION sp1))' failed with wrong errno 1103: 'Incorrect table name '/tmp/not-existing'', instead of 1...
       
      The result from queries just before the failure was:
      call mtr.add_suppression("InnoDB: File ./test/t1*");
      call mtr.add_suppression("nnoDB: Error number*");
      USE test;
      create table t1(f1 INT,f2 INT,f3 CHAR (10),primary key(f1,f2)) partition by range(f1) subpartition by hash(f2) subpartitions 2 (partition p1 values less than (0),partition p2 values less than (2),partition p3 values less than (2147483647));
      RENAME TABLE t1 TO `t2_new..............................................end`;
      ERROR HY000: Error on rename of 't2_new' (Errcode: 2 "No such file or directory")
      alter table t1 engine=innodb;
      RENAME TABLE t1 TO `t2_new..............................................end`;
      ERROR HY000: Error on rename of 't2_new' (errno: -1 "Internal error < 0 (Not system error)")
      show warnings;
      Level	Code	Message
      Error	1025	Error on rename of 't2_new' (errno: -1 "Internal error < 0 (Not system error)")
      drop table t1;
      DROP DATABASE test;
      CREATE DATABASE test;
      USE test;
      SET @@session.storage_engine=MYISAM;
      CREATE TABLE t1(id INT,purchased DATE)PARTITION BY RANGE(YEAR(purchased)) SUBPARTITION BY HASH(TO_DAYS(purchased)) SUBPARTITIONS 2 (PARTITION p0 VALUES LESS THAN MAXVALUE (SUBPARTITION sp0 DATA DIRECTORY='/tmp/not-existing' INDEX DIRECTORY='/tmp/not-existing',SUBPARTITION sp1));

      ------------------

      Failure on labrador
      http://buildbot.askmonty.org/buildbot/builders/labrador/builds/4232/steps/test/logs/stdio

      innodb.innodb-mdev7046 'innodb_plugin'   [ fail ]
              Test ended at 2014-11-27 12:20:36
       
      CURRENT_TEST: innodb.innodb-mdev7046
      --- /private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/suite/innodb/r/innodb-mdev7046.result	2014-11-27 10:38:48.000000000 +0200
      +++ /private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/suite/innodb/r/innodb-mdev7046.reject	2014-11-27 12:20:36.000000000 +0200
      @@ -3,7 +3,7 @@
       USE test;
       create table t1(f1 INT,f2 INT,f3 CHAR (10),primary key(f1,f2)) partition by range(f1) subpartition by hash(f2) subpartitions 2 (partition p1 values less than (0),partition p2 values less than (2),partition p3 values less than (2147483647));
       RENAME TABLE t1 TO `t2_new..............................................end`;
      -ERROR HY000: Error on rename of 't2_new' (Errcode: 36 "File name too long")
      +ERROR HY000: Error on rename of 't2_new' (Errcode: 63 "File name too long")
       alter table t1 engine=innodb;
       RENAME TABLE t1 TO `t2_new..............................................end`;
       ERROR HY000: Error on rename of 't2_new' (errno: -1 "Internal error < 0 (Not system error)")
       
      mysqltest: Result content mismatch

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jplindst Jan Lindström
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: