[MDEV-29266] galera.galera_fk_lock_wait fails regularly in CIs with wrong result Created: 2022-08-07  Updated: 2023-04-27

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

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Julius Goryavsky
Resolution: Unresolved Votes: 0
Labels: None


 Description   

https://buildbot.askmonty.org/buildbot/builders/kvm-rpm-rhel8-amd64/builds/6205/steps/mtr-galera/logs/stdio

10.6 30914389fe9ca13cf29470dd033a5cf6

galera.galera_fk_lock_wait 'innodb'      w1 [ fail ]
        Test ended at 2022-07-27 17:57:16
 
CURRENT_TEST: galera.galera_fk_lock_wait
--- /usr/share/mysql-test/suite/galera/r/galera_fk_lock_wait.result	2022-07-27 15:37:10.000000000 +0000
+++ /dev/shm/var/1/log/galera_fk_lock_wait.reject	2022-07-27 17:57:16.179649442 +0000
@@ -31,11 +31,11 @@
 4	tmp
 SELECT * FROM child;
 child_id	child_name	child_parent_id
-1	first_child	1
-3	second_child	1
-5	first_child2	2
-7	first_child3	2
-9	first_child4	3
+2	first_child	1
+4	second_child	1
+6	first_child2	2
+8	first_child3	2
+10	first_child4	3
 connection node_2;
 SELECT * FROM parent;
 parent_id	parent_name
@@ -45,10 +45,10 @@
 4	tmp
 SELECT * FROM child;
 child_id	child_name	child_parent_id
-1	first_child	1
-3	second_child	1
-5	first_child2	2
-7	first_child3	2
-9	first_child4	3
+2	first_child	1
+4	second_child	1
+6	first_child2	2
+8	first_child3	2
+10	first_child4	3
 DROP TABLE child, parent;
 disconnect node_1a;
 
mysqltest: Result length mismatch


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