Debian Codegraph @

mysql-test/suite/galera/t/galera_var_dirty_reads.test

raw
1 #
2 # Check the handling of @@wsrep_dirty_reads
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_perfschema.inc
7
8 call mtr.add_suppression("WSREP has not yet prepared node for application use");
9
10 # Save original auto_increment_offset values.
11 --let $node_1=node_1
12 --let $node_2=node_2
13 --source include/auto_increment_offset_save.inc
14
15 --connection node_2
16 --let $wsrep_cluster_address_saved = `SELECT @@global.wsrep_cluster_address`
17
18 CREATE TABLE t1(i INT) ENGINE=INNODB;
19 INSERT INTO t1 VALUES(1);
20 SELECT * FROM t1;
21
22 SET @@global.wsrep_cluster_address = '';
23 SET @@session.wsrep_dirty_reads=OFF;
24
25 # Set wsrep_sync_wait to avoid ER_LOCK_WAIT_TIMEOUT.
26 SET SESSION wsrep_sync_wait=0;
27
28 # Must return 'OFF'
29 SHOW STATUS LIKE 'wsrep_ready';
30
31 # Must return 'Disconnected'
32 SHOW STATUS LIKE 'wsrep_cluster_status';
33
34 --error ER_UNKNOWN_COM_ERROR
35 SELECT * FROM t1;
36
37 --error ER_UNKNOWN_COM_ERROR
38 SELECT 1 FROM t1;
39
40 SET @@session.wsrep_dirty_reads=ON;
41
42 SELECT * FROM t1;
43 SELECT 1 FROM t1;
44
45 SELECT i, variable_name, variable_value FROM t1, information_schema.session_variables WHERE variable_name LIKE "wsrep_dirty_reads" AND i = 1;
46
47 SET @@session.wsrep_dirty_reads=OFF;
48
49 --error ER_UNKNOWN_COM_ERROR
50 SELECT i, variable_name, variable_value FROM t1, information_schema.session_variables WHERE variable_name LIKE "wsrep_dirty_reads" AND i = 1;
51
52
53 SELECT 1;
54
55 USE information_schema;
56
57 SELECT * FROM information_schema.session_variables WHERE variable_name LIKE "wsrep_dirty_reads";
58
59 SELECT COUNT(*) >= 10 FROM performance_schema.events_statements_history;
60
61 --disable_query_log
62 --eval SET @@global.wsrep_cluster_address = '$wsrep_cluster_address_saved'
63 --enable_query_log
64 --source include/wait_until_connected_again.inc
65 --source include/galera_wait_ready.inc
66
67 --connection node_1
68 USE test;
69 SELECT * FROM t1;
70 # Cleanup
71 DROP TABLE t1;
72
73 # Restore original auto_increment_offset values.
74 --source include/auto_increment_offset_restore.inc
75
76 --source include/galera_end.inc