[MDEV-24458] Test main.myisampack fails sporadically on i686/i386 on missing quotation marks Created: 2020-12-21  Updated: 2023-04-22

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - MyISAM
Affects Version/s: 10.5.8, 10.11.2
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Marius Bakke Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

32-bit GNU/Linux (i686)


 Description   

Hello,

The "main.myisampack" test fails on i686:

--- /tmp/guix-build-mariadb-10.5.8.drv-0/mariadb-10.5.8/mysql-test/main/myisampack.result1970-01-01 00:00:01.000000000 +0000
 
+++ /tmp/guix-build-mariadb-10.5.8.drv-0/mariadb-10.5.8/mysql-test/main/myisampack.reject2020-12-21 10:28:11.756742953 +0000
 
@@ -113,7 +113,7 @@
 
 # ===== myisampack.4 =====
 
 #Tests the myisampack join operation with an existing destination .frm,.MYI,.MDI
 
 #the command should fail with exit status 2
 
-myisampack: Can't create/write to file (Errcode: 17 "File exists")
 
+myisampack: Can't create/write to file (Errcode: 17 "File exists)
 
 Aborted: file is not compressed
 
 DROP TABLE t1,t2,t3;
 
 DROP TABLE mysql_db1.t1;
 
 
 
mysqltest: Result length mismatch
 
 
 
safe_process[88380]: Got signal 17, child_pid: 88383
 
safe_process[88380]: Killing child: 88383
 
safe_process[88380]: Child exit: 1
 
 
 
 - saving '/tmp/guix-build-mariadb-10.5.8.drv-0/build/mysql-test/var/13/log/main.myisampack/' to '/tmp/guix-build-mariadb-10.5.8.drv-0/build/mysql-test/var/log/main.myisampack/'
 
worker[13] > Stopping all servers...
 
 
 
Only  5346  of 5662 completed.
 
--------------------------------------------------------------------------
 
The servers were restarted 733 times
 
Spent 1300.257 of 166 seconds executing testcases
 
 
 
Check of testcase failed for: main.mysql_upgrade_to_100502 main.upgrade_MDEV-23102-2 main.upgrade_MDEV-23102-1
 
 
 
Failure: Failed 1/3561 tests, 99.97% were successful.
 
 
 
Failing test(s): main.myisampack

Somehow the trailing " is missing in the error output from myisampack.

It's not deterministic: when running "myisampack --join=foo/t3 foo/t1 foo/t2" in a loop it gives the same error about 1/240 times; however during an mtr run it almost always fails.

 Comments   
Comment by Marius Bakke [ 2020-12-21 ]

I should mention that this is not a new issue. I saw this way back on 10.1, but wanted to confirm it was present in 10.5 before reporting.

Comment by Otto Kekäläinen [ 2023-04-22 ]

Seen on latest MariaDB 10.11.2 on Debian build at https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=i386&ver=1%3A10.11.2-3&stamp=1682058786&raw=0. The issue seems sporadic as a re-run of the i386 build+mtr passed.

main.myisampack                          w4 [ fail ]
 
        Test ended at 2023-04-21 06:31:20
 
 
 
CURRENT_TEST: main.myisampack
 
--- /<<PKGBUILDDIR>>/mysql-test/main/myisampack.result	2023-02-01 17:28:03.000000000 +0000
 
+++ /<<PKGBUILDDIR>>/mysql-test/main/myisampack.reject	2023-04-21 06:31:20.295197854 +0000
 
@@ -113,7 +113,7 @@
 
 # ===== myisampack.4 =====
 
 #Tests the myisampack join operation with an existing destination .frm,.MYI,.MDI 
 #the command should fail with exit status 2
 
-myisampack: Can't create/write to file (Errcode: 17 "File exists")
 
+myisampack: Can't create/write to file (Errcode: 17 "File exists)
 
 Aborted: file is not compressed
 
 DROP TABLE t1,t2,t3;
 
 DROP TABLE mysql_db1.t1;
 
 
 
mysqltest: Result length mismatch

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