Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6
-
None
Description
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
|