[MDEV-28953] sporadic failures with galera_sr.mysql-wsrep-features#165 test Created: 2022-06-27  Updated: 2023-12-22  Resolved: 2023-12-22

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3

Type: Bug Priority: Major
Reporter: Seppo Jaakola Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
Labels: None


 Description   

galera_sr.mysql-wsrep-features#165 test test fails sporadically in Codership jenkins testing.
The failure is due to debug sync point wait timeout. The test itself has two sequential SQL statements being asynchronously sent for execution (--send), without later checking the progress of the execution, and this is likely the cause for the failures, The failing test case output looks like the following:

CURRENT_TEST: galera_sr.mysql-wsrep-features#165
— /home/jenkins/workspace/mtr-galera-4.x-mariadb-10.4-master/mysql-wsrep/mysql-test/suite/galera_sr/r/mysql-wsrep-features#165.result 2022-06-14 00:02:36.743397840 +0200
+++ /home/jenkins/workspace/mtr-galera-4.x-mariadb-10.4-master/mysql-wsrep/mysql-test/suite/galera_sr/r/mysql-wsrep-features#165.reject 2022-06-14 00:39:22.078665000 +0200
@@ -366,6 +366,8 @@
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
+Warnings:
+Warning 1639 debug sync point wait timed out
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;

mysqltest: Result length mismatch

The problem persists in 10.4 and later versions


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