[MDEV-23920] main.repair_symlink-5543 fails with "Errcode: 249" when " Errcode: 20" is expected on some platforms Created: 2020-10-08  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.5.5, 10.3, 10.4
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Minor
Reporter: Otto Kekäläinen Assignee: VicenČ›iu Ciorbaru
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-27726 main.repair_symlink-5543 fails on Fre... Closed
Relates
relates to MDEV-12215 main.repair_symlink-5543 fails in bui... Closed

 Description   

While importing MariaDB 10.5.5 to Debian I saw this failure on archs and hppa:

main.repair_symlink-5543                 [ fail ]
 
        Test ended at 2020-10-08 13:29:05
 
 
 
CURRENT_TEST: main.repair_symlink-5543
 
--- /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.result	2020-08-07 12:57:35.000000000 +0000
 
+++ /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.reject	2020-10-08 13:29:05.319051025 +0000
 
@@ -4,15 +4,15 @@
 
 # while others don't have openat and fail with errcode 20.
 
 repair table t1;
 
 Table	Op	Msg_type	Msg_text
 
-test.t1	repair	error	20 for record at pos 0
 
-test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 20 "<errmsg>")
 
+test.t1	repair	error	249 for record at pos 0
 
+test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 249 "<errmsg>")
 
 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	20 for record at pos 256
 
-test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "<errmsg>")
 
+test.t2	repair	error	249 for record at pos 256
 
+test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 249 "<errmsg>")
 
 test.t2	repair	status	Operation failed
 
 drop table t2;

Full log at https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.5&arch=hppa&ver=1%3A10.5.5-3%7Eexp2&stamp=1602164461&raw=0 (hppa)

This also occured on arch alpha:

main.repair_symlink-5543                 w2 [ fail ]
 
        Test ended at 2020-10-07 04:52:40
 
 
 
CURRENT_TEST: main.repair_symlink-5543
 
--- /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.result	2020-08-07 12:57:35.000000000 +0000
 
+++ /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.reject	2020-10-07 04:52:40.440837468 +0000
 
@@ -4,15 +4,15 @@
 
 # while others don't have openat and fail with errcode 20.
 
 repair table t1;
 
 Table	Op	Msg_type	Msg_text
 
-test.t1	repair	error	20 for record at pos 0
 
-test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 20 "<errmsg>")
 
+test.t1	repair	error	62 for record at pos 0
 
+test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 62 "<errmsg>")
 
 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	20 for record at pos 256
 
-test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "<errmsg>")
 
+test.t2	repair	error	62 for record at pos 256
 
+test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 62 "<errmsg>")
 
 test.t2	repair	status	Operation failed
 
 drop table t2;

Full log at https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.5&arch=alpha&ver=1%3A10.5.5-2&stamp=1602049326&raw=0 (alpha).

This is very similar to MDEV-12215 (fixed by cvicentiu), the number is just different.

 Comments   
Comment by Otto Kekäläinen [ 2020-10-11 ]

I filed this downstream in Debian as https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=972055 and https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=972060 in case some hppa or alpha experts from Debian could help out.

Comment by Otto Kekäläinen [ 2022-02-26 ]

While reviewing 10.6.7 build status in Debian I saw this failure on sparc64:

main.repair_symlink-5543                 w11 [ fail ]
 
        Test ended at 2022-02-25 11:03:12
 
 
 
CURRENT_TEST: main.repair_symlink-5543
 
--- /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.result	2022-02-10 20:07:03.000000000 +0000
 
+++ /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.reject	2022-02-25 11:03:11.794236299 +0000
 
@@ -4,15 +4,15 @@
 
 # while others don't have openat and fail with errcode 20.
 
 repair table t1;
 
 Table	Op	Msg_type	Msg_text
 
-test.t1	repair	error	20 for record at pos 0
 
-test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 20 "<errmsg>")
 
+test.t1	repair	error	62 for record at pos 0
 
+test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 62 "<errmsg>")
 
 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	20 for record at pos 256
 
-test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "<errmsg>")
 
+test.t2	repair	error	62 for record at pos 256
 
+test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 62 "<errmsg>")
 
 test.t2	repair	status	Operation failed
 
 drop table t2;

Full log at https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.6&arch=sparc64&ver=1%3A10.6.7-2%7Eexp1&stamp=1645787355&raw=0

Comment by Elena Stepanova [ 2022-04-13 ]

Also fails on FreeBSD 10.3+

10.4 3327bb609

 
main.repair_symlink-5543                 w3 [ fail ]
 
        Test ended at 2022-04-12 14:12:13
 
 
 
CURRENT_TEST: main.repair_symlink-5543
 
--- /usr/local/share/mysql-test/main/repair_symlink-5543.result	2022-04-12 13:31:00.404936000 +0000
 
+++ /tmp/var/3/log/repair_symlink-5543.reject	2022-04-12 14:12:13.002811000 +0000
 
@@ -4,15 +4,15 @@
 
 # while others don't have openat and fail with errcode 20.
 
 repair table t1;
 
 Table	Op	Msg_type	Msg_text
 
-test.t1	repair	error	20 for record at pos 0
 
-test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 20 "<errmsg>")
 
+test.t1	repair	error	31 for record at pos 0
 
+test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 31 "<errmsg>")
 
 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	20 for record at pos 256
 
-test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "<errmsg>")
 
+test.t2	repair	error	31 for record at pos 256
 
+test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 31 "<errmsg>")
 
 test.t2	repair	status	Operation failed
 
 drop table t2;
 
 
 
mysqltest: Result content mismatch

Generated at Thu Feb 08 09:26:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.