galera.galera_var_dirty_reads 'innodb'   w1 [ fail ]

        Test ended at 2021-05-06 16:48:01

CURRENT_TEST: galera.galera_var_dirty_reads

mysqltest: In included file "./include/galera_wait_ready.inc": 

included from ./include/wait_wsrep_ready.inc at line 14:

included from ./include/wait_until_connected_again.inc at line 27:

included from /usr/share/mysql/mysql-test/suite/galera/t/galera_var_dirty_reads.test at line 65:

At line 28: "Server did not transition to READY state"

The result from queries just before the failure was:

< snip >

1

SELECT 1 FROM t1;

1

1

SELECT i, variable_name, variable_value FROM t1, information_schema.session_variables WHERE variable_name LIKE "wsrep_dirty_reads" AND i = 1;

i	variable_name	variable_value

1	WSREP_DIRTY_READS	ON

SET @@session.wsrep_dirty_reads=OFF;

SELECT i, variable_name, variable_value FROM t1, information_schema.session_variables WHERE variable_name LIKE "wsrep_dirty_reads" AND i = 1;

Got one of the listed errors

SELECT 1;

1

1

USE information_schema;

SELECT * FROM information_schema.session_variables WHERE variable_name LIKE "wsrep_dirty_reads";

VARIABLE_NAME	VARIABLE_VALUE

WSREP_DIRTY_READS	OFF

SELECT COUNT(*) >= 10 FROM performance_schema.events_statements_history;

COUNT(*) >= 10

1