Details
Major Description
galera.lp1376747-4 failed on BB 10.3 CS: "Result length mismatch".
|
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
|
Attachments
Activity
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"
|
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
|
galera.lp1376747-4 failed also on BB 10.5 CS and BB 10.6 CS with the same output: "Result length mismatch".