[MDEV-24443] galera.lp1376747-4 MTR fails: Result length mismatch Created: 2020-12-18  Updated: 2021-01-21  Resolved: 2021-01-15

Status: Closed
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.2.37, 10.3.28, 10.4.18, 10.5.9, 10.6.0

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

kvm-deb-stretch-x86


Attachments: Zip Archive MDEV-24443_102_logs_201228.zip    

 Description   

galera.lp1376747-4 failed on BB 10.3 CS: "Result length mismatch".

stdio.log:

10.3.28, c742346e5041d85caaf30d2d6c10369603ad09ad, kvm-deb-stretch-x86

galera.lp1376747-4 'innodb'              w2 [ fail ]
        Test ended at 2020-12-16 13:42:31
 
CURRENT_TEST: galera.lp1376747-4
--- /usr/share/mysql/mysql-test/suite/galera/r/lp1376747-4.result	2020-12-16 11:35:54.000000000 -0500
+++ /dev/shm/var/2/log/lp1376747-4.reject	2020-12-16 13:42:31.221139296 -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



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2020-12-29 ]

galera.lp1376747-4 failed also on BB 10.5 CS and BB 10.6 CS with the same output: "Result length mismatch".

Comment by Stepan Patryshev (Inactive) [ 2020-12-29 ]

But sometimes galera.lp1376747-4 failed on BB 10.2 CS, BB 10.3 CS and BB 10.4 CS with another output: "query 'SHOW CREATE TABLE t1' failed: 2000: Unknown MySQL error"

stdio.log:

10.2.37, 5b9ee8d8193a8c7a8ebdd35eedcadc3ae78e7fc1, kvm-rpm-centos73-ppc64

galera.lp1376747-4 'innodb'              w2 [ fail ]
        Test ended at 2020-12-28 11:42:25
 
CURRENT_TEST: galera.lp1376747-4
mysqltest: At line 39: query 'SHOW CREATE TABLE t1' failed: 2000: Unknown MySQL error
 
The result from queries just before the failure was:
< snip >
Warning	1287	'@@wsrep_causal_reads' is deprecated and will be removed in a future release. Please use '@@wsrep_sync_wait=1' instead
FLUSH TABLE WITH READ LOCK;
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;
SET session wsrep_causal_reads=OFF;
Warnings:
Warning	1287	'@@wsrep_causal_reads' is deprecated and will be removed in a future release. Please use '@@wsrep_sync_wait=1' instead
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;
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

10.2 Server logs.

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