Debian Codegraph @

mysql-test/suite/galera_3nodes/r/galera_ist_gcache_rollover.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_3;
6 connection node_1;
7 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
8 INSERT INTO t1 VALUES (01), (02), (03), (04), (05);
9 connection node_2;
10 Unloading wsrep provider ...
11 SET GLOBAL wsrep_cluster_address = '';
12 connection node_1;
13 connection node_3;
14 Unloading wsrep provider ...
15 SET GLOBAL wsrep_cluster_address = '';
16 connection node_1;
17 INSERT INTO t1 VALUES (11), (12), (13), (14), (15);
18 INSERT INTO t1 VALUES (21), (22), (23), (24), (25);
19 SET GLOBAL wsrep_provider_options = 'dbug=d,ist_sender_send_after_get_buffers';
20 connection node_2;
21 connection node_1;
22 INSERT INTO t1 VALUES (31), (32), (33), (34), (35);
23 connection node_3;
24 connection node_1;
25 SHOW STATUS LIKE 'wsrep_debug_sync_waiters';
26 Variable_name Value
27 wsrep_debug_sync_waiters ist_sender_send_after_get_buffers ist_sender_send_after_get_buffers
28 INSERT INTO t1 VALUES (41), (42), (43), (44), (45);
29 CREATE TABLE t2 (f1 LONGTEXT);
30 INSERT INTO t2 VALUES (REPEAT('x', 512 * 1024));
31 INSERT INTO t2 VALUES (REPEAT('x', 512 * 1024));
32 INSERT INTO t2 VALUES (REPEAT('x', 512 * 1024));
33 SET GLOBAL wsrep_provider_options = 'dbug=';
34 SET GLOBAL wsrep_provider_options = 'signal=ist_sender_send_after_get_buffers';
35 INSERT INTO t1 VALUES (51), (52), (53), (54), (55);
36 connection node_2;
37 connection node_1;
38 connection node_3;
39 connection node_1;
40 connection node_2;
41 SELECT COUNT(*) AS EXPECT_30 FROM t1;
42 EXPECT_30
43 30
44 SELECT COUNT(*) AS EXPECT_3 FROM t2;
45 EXPECT_3
46 3
47 SELECT LENGTH(f1) = 512 * 1024 FROM t2;
48 LENGTH(f1) = 512 * 1024
49 1
50 1
51 1
52 CALL mtr.add_suppression("WSREP: Unsupported protocol downgrade: incremental data collection disabled");
53 connection node_3;
54 SELECT COUNT(*) AS EXPECT_30 FROM t1;
55 EXPECT_30
56 30
57 SELECT COUNT(*) AS EXPECT_3 FROM t2;
58 EXPECT_3
59 3
60 SELECT LENGTH(f1) = 512 * 1024 FROM t2;
61 LENGTH(f1) = 512 * 1024
62 1
63 1
64 1
65 CALL mtr.add_suppression("WSREP: Unsupported protocol downgrade: incremental data collection disabled");
66 DROP TABLE t1, t2;
67 disconnect node_3;
68 disconnect node_2;
69 disconnect node_1;