[MDEV-30892] test galera.galera_log_bin is not deterministic Created: 2023-03-21  Updated: 2023-06-07  Resolved: 2023-05-03

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4
Fix Version/s: 10.4.31, 10.5.22, 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.1.2

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


 Description   

Sporadic, although apparently very rare, occasion when the test fails for non existent table error in node 1:

galera.galera_log_bin 'innodb'           w1 [ fail ]
        Test ended at 2023-01-11 22:41:03
 
CURRENT_TEST: galera.galera_log_bin
mysqltest: In included file "/usr/share/mysql-test/suite/galera/t/galera_log_bin.inc": 
included from /usr/share/mysql-test/suite/galera/t/galera_log_bin.test at line 2:
At line 31: query 'ALTER TABLE t1 ADD COLUMN f2 INTEGER' failed: 1146: Table 'test.t1' doesn't exist
 
The result from queries just before the failure was:
< snip >
reset master;
set global wsrep_on=ON;
connection node_2;
set global wsrep_on=OFF;
reset master;
set global wsrep_on=ON;
CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);
CREATE TABLE t2 (id INT) ENGINE=InnoDB;
INSERT INTO t2 VALUES (1);
INSERT INTO t2 VALUES (1);
connection node_2;
SELECT COUNT(*) = 1 FROM t1;
COUNT(*) = 1
1
SELECT COUNT(*) = 2 FROM t2;
COUNT(*) = 2
1
connection node_1;
ALTER TABLE t1 ADD COLUMN f2 INTEGER;



 Comments   
Comment by Jan Lindström [ 2023-04-17 ]

https://github.com/MariaDB/server/pull/2564

Comment by Julius Goryavsky [ 2023-05-03 ]

Slightly modified fix merged with head revision as https://github.com/MariaDB/server/commit/9b6f87b62afb32ea238e39b362b8e761f53e541c

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