innodb.innodb-mdev7046 fails in various ways on buildbot

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.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 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

Environment

None

Status

Assignee

Jan Lindström

Reporter

Elena Stepanova

Labels

External issue ID

None

External issue ID

None

Components

Fix versions

Affects versions

10.0

Priority

Critical
Configure