[MDEV-24871] galera.lp1376747-4 MTR fails differently on various branches Created: 2021-02-15  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9, 10.6.0
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Julius Goryavsky
Resolution: Unresolved Votes: 0
Labels: None
Environment:

kvm-rpm-centos74-amd64-debug, kvm-deb-focal-amd64, kvm-deb-stretch-aarch64, kvm-rpm-centos74-aarch64, kvm-rpm-centos73-ppc64


Issue Links:
Blocks
blocks MDEV-19937 Galera test failures on 10.2/10.3 Closed

 Description   

galera.lp1376747-4 fails on BB 10.3 CS, BB 10.4 CS and BB 10.5 CS: Result length mismatch

stdio.log:

10.3.28, da88e1ec12b0ba39552bf54367c1bb3b89eac4a8,

galera.lp1376747-4 'innodb'              w2 [ fail ]
        Test ended at 2021-02-11 22:40:42
 
CURRENT_TEST: galera.lp1376747-4
--- /usr/share/mysql/mysql-test/suite/galera/r/lp1376747-4.result	2021-02-11 12:21:08.000000000 -0500
+++ /dev/shm/var/2/log/lp1376747-4.reject	2021-02-11 22:40:42.084747929 -0500
@@ -24,6 +24,7 @@
 Table	Create Table
 t1	CREATE TABLE `t1` (
   `id` int(11) NOT NULL,
+  `f2` int(11) DEFAULT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
 connection node_2a;
 
mysqltest: Result length mismatch
 
 - saving '/dev/shm/var/2/log/galera.lp1376747-4-innodb/' to '/dev/shm/var/log/galera.lp1376747-4-innodb/'
 
Retrying test galera.lp1376747-4, attempt(2/3)...
 
worker[2] > Restart  - not started
worker[2] > Restart  - not started

galera.lp1376747-4 failed on BB 10.2 CS with another ouput: Result length mismatch: +Warning 1639 debug sync point wait timed out.

stdio.log:

10.2.37, 95003eab451cac2fd2c0552f374a85842f2773f2, kvm-rpm-centos74-amd64-debug

galera.lp1376747-4 'innodb'              w1 [ fail ]
        Test ended at 2021-02-11 15:34:52
 
CURRENT_TEST: galera.lp1376747-4
--- /usr/share/mysql-test/suite/galera/r/lp1376747-4.result	2021-02-11 12:47:20.000000000 +0000
+++ /dev/shm/var/1/log/lp1376747-4.reject	2021-02-11 15:34:51.270402200 +0000
@@ -29,6 +29,8 @@
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
 set debug_sync= 'RESET';
 connection node_2a;
+Warnings:
+Warning	1639	debug sync point wait timed out
 UNLOCK TABLES;
 SET SESSION wsrep_sync_wait = DEFAULT;
 SHOW CREATE TABLE t1;
 
mysqltest: Result length mismatch
 
 - saving '/dev/shm/var/1/log/galera.lp1376747-4-innodb/' to '/dev/shm/var/log/galera.lp1376747-4-innodb/'
 
Retrying test galera.lp1376747-4, attempt(2/3)...
 
worker[1] > Restart  - not started
worker[1] > Restart  - not started

And galera.lp1376747-4 failed on BB 10.6 CS with another ouput:

stdio.log: query 'SHOW CREATE TABLE t1' failed: 2000: Unknown MySQL error

10.6.0, 4df0249b9acc2c79c450c3836ae60f3e9076ae6e, kvm-deb-focal-amd64

galera.lp1376747-4 'innodb'              w2 [ fail ]
        Test ended at 2021-02-15 11:31:34
 
CURRENT_TEST: galera.lp1376747-4
mysqltest: At line 41: query 'SHOW CREATE TABLE t1' failed: 2000: Unknown MySQL error
 
The result from queries just before the failure was:
< snip >
connection node_1;
ALTER TABLE t1 ADD COLUMN f2 INTEGER;
INSERT INTO t1 VALUES (2,3);
connection node_2a;
SET session wsrep_sync_wait=0;
# node_1 DDL should not yet be applied
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
FLUSH TABLES t1 WITH READ LOCK;;
connection node_2;
UNLOCK TABLES;
# node_1 DDL should not yet be applied 2
SHOW CREATE TABLE t1;
 
More results from queries before failure can be found in /dev/shm/var/2/log/lp1376747-4.log
 
 - saving '/dev/shm/var/2/log/galera.lp1376747-4-innodb/' to '/dev/shm/var/log/galera.lp1376747-4-innodb/'
 
Retrying test galera.lp1376747-4, attempt(2/3)...
 
worker[2] > Restart  - not started
worker[2] > Restart  - not started


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