[MDEV-31452] Test main.public_privileges sporadic failure on Debian buildd armhf build Created: 2023-06-10  Updated: 2023-06-12

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Otto Kekäläinen Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

After uploading MariaDB 10.11.4 to Debian I noticed the armhf build failed in https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=armhf&ver=1%3A10.11.4-1&stamp=1686362815&raw=0 with:

main.public_privileges                   w1 [ fail ]
 
        Test ended at 2023-06-10 02:03:47
 
 
 
CURRENT_TEST: main.public_privileges
 
--- /<<PKGBUILDDIR>>/mysql-test/main/public_privileges.result	2023-06-05 17:04:58.000000000 +0000
 
+++ /<<PKGBUILDDIR>>/mysql-test/main/public_privileges.reject	2023-06-10 02:03:47.489695706 +0000
 
@@ -95,7 +95,7 @@
 
 connect  testuser,localhost,testuser,,;
 
 select user,db from information_schema.processlist where user='root';
 
 user	db
 
-root	testdb
 
+root	NULL
 
 call testdb.p1();
 
 1
 
 1
 
mysqltest: Result length mismatch

The same test however passed for the exact same Debian package source code on Ubuntu Launchpad builder at https://launchpadlibrarian.net/671462179/buildlog_ubuntu-mantic-armhf.mariadb_1%3A10.11.4-1~ubuntu23.10.1~1686356098.b14ddfab21c.debian.latest_BUILDING.txt.gz:

main.public_privileges                   w2 [ pass ]    210

Also on this same Debian buildd a rebuild and new MTR passed.

Perhaps there is some race condition and timing issue?
Generated at Thu Feb 08 10:23:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.