[MDEV-7242] innodb.innodb-mdev7046 fails in various ways on buildbot Created: 2014-12-01  Updated: 2014-12-02  Resolved: 2014-12-02

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0
Fix Version/s: 10.0.16

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: buildbot, tests

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled

 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



 Comments   
Comment by Jan Lindström (Inactive) [ 2014-12-02 ]

------------------------------------------------------------
revno: 4522
committer: Jan Lindström <jplindst@mariadb.org>
branch nick: 10.0-bugs
timestamp: Tue 2014-12-02 13:26:45 +0200
message:
MDEV-7242: innodb.innodb-mdev7046 fails in various ways on buildbot

Problem with test is that test causes OS failures that change.
Idea with test is just to test that server does not crash, no other
output is necessary.

Generated at Thu Feb 08 07:18:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.