Debian Codegraph @

mysql-test/suite/galera/r/galera_query_cache_invalidate.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
4 connect node_4, 127.0.0.1, root, , test, $NODE_MYPORT_4;
5 connection node_2;
6 call mtr.add_suppression("WSREP: Ignoring server id .* for non bootstrap node");
7 connection node_4;
8 call mtr.add_suppression("WSREP: Ignoring server id .* for non bootstrap node");
9 connection node_3;
10 START SLAVE;
11 include/wait_for_slave_to_start.inc
12 connection node_1;
13 CREATE TABLE t1 (id bigint primary key, msg varchar(100)) engine=innodb;
14 SET AUTOCOMMIT=1;
15 INSERT INTO t1 VALUES (4000000, 'foobar');
16 SELECT COUNT(*) FROM t1;
17 COUNT(*)
18 50001
19 connection node_3;
20 connection node_1;
21 # node_1
22 SELECT * FROM t1 WHERE msg='foobar';
23 id msg
24 4000000 foobar
25 SELECT * FROM t1 WHERE msg='foobar';
26 id msg
27 4000000 foobar
28 connection node_2;
29 # node_2
30 SELECT * FROM t1 WHERE msg='foobar';
31 id msg
32 4000000 foobar
33 SELECT * FROM t1 WHERE msg='foobar';
34 id msg
35 4000000 foobar
36 connection node_3;
37 # node_3
38 SELECT * FROM t1 WHERE msg='foobar';
39 id msg
40 4000000 foobar
41 SELECT * FROM t1 WHERE msg='foobar';
42 id msg
43 4000000 foobar
44 connection node_4;
45 # node_4
46 SELECT * FROM t1 WHERE msg='foobar';
47 id msg
48 4000000 foobar
49 SELECT * FROM t1 WHERE msg='foobar';
50 id msg
51 4000000 foobar
52 connection node_1;
53 # node_1 insert new
54 INSERT INTO t1 values (5000000, 'foobar');
55 connection node_3;
56 SELECT * FROM t1 WHERE msg='foobar';
57 id msg
58 4000000 foobar
59 5000000 foobar
60 SELECT * FROM t1 WHERE msg='foobar';
61 id msg
62 4000000 foobar
63 5000000 foobar
64 connection node_2;
65 # node_2
66 SELECT * FROM t1 WHERE msg='foobar';
67 id msg
68 4000000 foobar
69 5000000 foobar
70 SELECT * FROM t1 WHERE msg='foobar';
71 id msg
72 4000000 foobar
73 5000000 foobar
74 connection node_3;
75 # node_3
76 SELECT * FROM t1 WHERE msg='foobar';
77 id msg
78 4000000 foobar
79 5000000 foobar
80 SELECT * FROM t1 WHERE msg='foobar';
81 id msg
82 4000000 foobar
83 5000000 foobar
84 connection node_4;
85 # node_4
86 SELECT * FROM t1 WHERE msg='foobar';
87 id msg
88 4000000 foobar
89 5000000 foobar
90 SELECT * FROM t1 WHERE msg='foobar';
91 id msg
92 4000000 foobar
93 5000000 foobar
94 connection node_2;
95 # node_3 different query same table
96 SELECT id, msg FROM t1 WHERE msg='foobar';
97 id msg
98 4000000 foobar
99 5000000 foobar
100 connection node_4;
101 # node_6 different query same table
102 SELECT id, msg FROM t1 WHERE msg='foobar';
103 id msg
104 4000000 foobar
105 5000000 foobar
106 connection node_1;
107 drop table t1;
108 connection node_3;
109 connection node_3;
110 STOP SLAVE;
111 RESET SLAVE ALL;
112 Warnings:
113 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'Current_Pos' to 'Slave_Pos'
114 connection node_1;
115 SET SESSION WSREP_ON=OFF;
116 RESET MASTER;
117 SET SESSION WSREP_ON=ON;
118 disconnect node_2;
119 disconnect node_1;
120 # End of test