Details
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;
|