[MDEV-12215] main.repair_symlink-5543 fails in buildbot Created: 2017-03-09  Updated: 2020-10-08  Resolved: 2017-10-11

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 5.5, 10.0, 10.1
Fix Version/s: 5.5.56, 10.1.23, 10.0.31, 10.2.6

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Vicențiu Ciorbaru
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-23920 main.repair_symlink-5543 fails with "... Open
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

https://internal.askmonty.org/buildbot/builders/kvm-bintar-centos5-x86/builds/6477/steps/test/logs/stdio

main.repair_symlink-5543                 w2 [ fail ]
        Test ended at 2017-03-09 11:56:40
 
CURRENT_TEST: main.repair_symlink-5543
--- /usr/local/mariadb-10.1.22-linux-i686/mysql-test/r/repair_symlink-5543.result	2017-03-09 08:02:14.000000000 +0100
+++ /usr/local/mariadb-10.1.22-linux-i686/mysql-test/r/repair_symlink-5543.reject	2017-03-09 11:56:40.000000000 +0100
@@ -2,15 +2,15 @@
 insert t1 values (1);
 repair table t1;
 Table	Op	Msg_type	Msg_text
-test.t1	repair	error	40 for record at pos 0
-test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 40 "Too many levels of symbolic links")
+test.t1	repair	error	20 for record at pos 0
+test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 20 "Not a directory")
 test.t1	repair	status	Operation failed
 drop table t1;
 create table t2 (a int) engine=aria data directory='MYSQL_TMP_DIR';
 insert t2 values (1);
 repair table t2;
 Table	Op	Msg_type	Msg_text
-test.t2	repair	error	40 for record at pos 256
-test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 40 "Too many levels of symbolic links")
+test.t2	repair	error	20 for record at pos 256
+test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "Not a directory")
 test.t2	repair	status	Operation failed
 drop table t2;
 
mysqltest: Result length mismatch



 Comments   
Comment by Elena Stepanova [ 2017-03-11 ]

It fails again on the latest 10.1 build:
https://internal.askmonty.org/buildbot/builders/kvm-deb-wheezy-amd64/builds/8062/steps/mtr/logs/stdio

main.repair_symlink-5543                 w4 [ fail ]
        Test ended at 2017-03-10 22:21:07
 
CURRENT_TEST: main.repair_symlink-5543
--- /usr/share/mysql/mysql-test/r/repair_symlink-5543.result	2017-03-10 13:03:35.000000000 -0500
+++ /run/shm/var/4/log/repair_symlink-5543.reject	2017-03-10 22:21:07.628462570 -0500
@@ -12,7 +12,7 @@
 insert t2 values (1);
 repair table t2;
 Table	Op	Msg_type	Msg_text
-test.t2	repair	error	40 for record at pos 256
-test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 40 "Too many levels of symbolic links")
+test.t2	repair	error	20 for record at pos 256
+test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "Not a directory")
 test.t2	repair	status	Operation failed
 drop table t2;

Here are more:
http://buildbot.askmonty.org/buildbot/builders/p8-rhel6-bintar-debug/builds/707/steps/test/logs/stdio

main.symlink-aria-11902                  w4 [ fail ]
        Test ended at 2017-03-10 16:54:03
 
CURRENT_TEST: main.symlink-aria-11902
mysqltest: In included file "/home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/t/symlink-myisam-11902.test": 
included from /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/t/symlink-aria-11902.test at line 6:
At line 54: query 'reap' failed with wrong errno 1030: 'Got error 40 "Too many levels of symbolic links" from storage engine Aria', instead of 1017...
 
The result from queries just before the failure was:
< snip >
set debug_sync='now WAIT_FOR ok';
set debug_sync='now SIGNAL go';
ERROR HY000: File 'MYSQLTEST_VARDIR/tmp/foo/t1.MAD' not found (Errcode: 40 "Too many levels of symbolic links")
flush tables;
drop table if exists t1;
create table t1 (a int, b char(16), index (a))
index directory="MYSQLTEST_VARDIR/tmp/foo";
insert t1 values (200, 'some'),(201,'some');
explain select a from t1;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	index	NULL	a	5	NULL	2	Using index
select a from t1;
a
200
201
flush tables;
set debug_sync='mi_open_kfile SIGNAL waiting WAIT_FOR run';
select a from t1;
set debug_sync='now WAIT_FOR waiting';
set debug_sync='now SIGNAL run';

main.symlink-myisam-11902                w4 [ fail ]
        Test ended at 2017-03-10 16:54:04
 
CURRENT_TEST: main.symlink-myisam-11902
mysqltest: At line 54: query 'reap' failed with wrong errno 1030: 'Got error 40 "Too many levels of symbolic links" from storage engine MyISAM', instead of 1017...
 
The result from queries just before the failure was:
< snip >
set debug_sync='now WAIT_FOR ok';
set debug_sync='now SIGNAL go';
ERROR HY000: File 'MYSQLTEST_VARDIR/tmp/foo/t1.MYD' not found (Errcode: 40 "Too many levels of symbolic links")
flush tables;
drop table if exists t1;
create table t1 (a int, b char(16), index (a))
index directory="MYSQLTEST_VARDIR/tmp/foo";
insert t1 values (200, 'some'),(201,'some');
explain select a from t1;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	index	NULL	a	5	NULL	2	Using index
select a from t1;
a
200
201
flush tables;
set debug_sync='mi_open_kfile SIGNAL waiting WAIT_FOR run';
select a from t1;
set debug_sync='now WAIT_FOR waiting';
set debug_sync='now SIGNAL run';

Comment by Sergei Golubchik [ 2017-03-11 ]

I've pushed the fix for main.repair_symlink-5543

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