galera_3nodes.galera_var_dirty_reads2 MTR failed: 1047: WSREP has not yet prepared node for application use

galera_3nodes.galera_var_dirty_reads2 'innodb' w1 [ fail ]

        Test ended at 2020-08-26 00:30:29

CURRENT_TEST: galera_3nodes.galera_var_dirty_reads2

mysqltest: At line 123: query 'DROP TABLE t1' failed: 1047: WSREP has not yet prepared node for application use

The result from queries just before the failure was:

< snip >

DELETE FROM t1;

ERROR 08S01: WSREP has not yet prepared node for application use

UPDATE t1 SET f1 = f1 + 1;

ERROR 08S01: WSREP has not yet prepared node for application use

DROP TABLE t1;

ERROR 08S01: WSREP has not yet prepared node for application use

EXECUTE stmt_update;

ERROR 08S01: WSREP has not yet prepared node for application use

SET SESSION wsrep_dirty_reads = 0;

SELECT * FROM t1;

ERROR 08S01: WSREP has not yet prepared node for application use

EXECUTE stmt_select;

ERROR 08S01: WSREP has not yet prepared node for application use

SELECT COUNT(*) > 0 FROM INFORMATION_SCHEMA.PROCESSLIST;

COUNT(*) > 0

1

SET GLOBAL wsrep_provider_options='gmcast.isolate=0';

connection node_1;

connection node_2;

DROP TABLE t1;

galera_3nodes.galera_var_dirty_reads2 'innodb' w2 [ fail ]

        Test ended at 2020-08-25 01:50:22

CURRENT_TEST: galera_3nodes.galera_var_dirty_reads2

--- /usr/share/mysql/mysql-test/suite/galera_3nodes/r/galera_var_dirty_reads2.result	2020-08-24 23:06:12.000000000 -0400

+++ /dev/shm/var/2/log/galera_var_dirty_reads2.reject	2020-08-25 01:50:22.206412755 -0400

@@ -14,7 +14,6 @@

 SET SESSION wsrep_dirty_reads = 1;

 SELECT f1 FROM t1;

 f1

-1

 USE test;

 SHOW CREATE TABLE t1;

 Table	Create Table

@@ -28,7 +27,6 @@

 PREPARE stmt_select FROM 'SELECT f1 FROM t1';

 EXECUTE stmt_select;

 f1

-1

 PREPARE stmt_update FROM 'UPDATE t1 SET f1 = f1 + f1';

 SET GLOBAL wsrep_dirty_reads = 1;

 SET GLOBAL wsrep_sync_wait = 0;

mysqltest: Result length mismatch