Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/r/MDEV-26707.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
4 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
5 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
6 connect node_3a, 127.0.0.1, root, , test, $NODE_MYPORT_3;
7 connection node_1;
8 connection node_2;
9 connection node_3;
10 connection node_1;
11 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
12 connection node_2;
13 SET SESSION wsrep_trx_fragment_size=1;
14 BEGIN;
15 INSERT INTO t1 VALUES (21);
16 connection node_1;
17 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_streaming_log;
18 EXPECT_1
19 1
20 connection node_2;
21 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_streaming_log;
22 EXPECT_1
23 1
24 connection node_3;
25 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_streaming_log;
26 EXPECT_1
27 1
28 connection node_3a;
29 SET GLOBAL wsrep_provider_options = 'gmcast.isolate = 1';
30 SET SESSION wsrep_sync_wait = 0;
31 SET SESSION wsrep_sync_wait = DEFAULT;
32 connection node_1a;
33 SET SESSION wsrep_sync_wait = 0;
34 SET SESSION wsrep_sync_wait = DEFAULT;
35 connection node_2a;
36 SET SESSION wsrep_sync_wait = 0;
37 SET SESSION wsrep_sync_wait = DEFAULT;
38 connection node_2;
39 SET DEBUG_SYNC = 'wsrep_before_certification SIGNAL before_cert WAIT_FOR continue';
40 COMMIT;
41 connection node_2a;
42 SET DEBUG_SYNC = 'now WAIT_FOR before_cert';
43 SET GLOBAL wsrep_provider_options = 'gmcast.isolate = 1';
44 SET SESSION wsrep_sync_wait = 0;
45 SET SESSION wsrep_sync_wait = DEFAULT;
46 SET DEBUG_SYNC = 'now SIGNAL continue';
47 connection node_2;
48 ERROR HY000: Error while appending streaming replication fragment(provider status: Not connected to Primary Component)
49 connection node_2a;
50 SET DEBUG_SYNC = 'RESET';
51 connection node_1a;
52 SET SESSION wsrep_sync_wait = 0;
53 SET SESSION wsrep_sync_wait = DEFAULT;
54 connection node_3a;
55 SET GLOBAL wsrep_provider_options = 'gmcast.isolate = 0';
56 SET SESSION wsrep_sync_wait = 0;
57 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_streaming_log;
58 EXPECT_1
59 1
60 SET SESSION wsrep_sync_wait = DEFAULT;
61 connection node_1a;
62 SET SESSION wsrep_sync_wait = 0;
63 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_streaming_log;
64 EXPECT_1
65 1
66 SET SESSION wsrep_sync_wait = DEFAULT;
67 connection node_2a;
68 SET GLOBAL wsrep_provider_options = 'gmcast.isolate = 0';
69 SET SESSION wsrep_sync_wait = DEFAULT;
70 connection node_1a;
71 SET SESSION wsrep_sync_wait = 0;
72 SET SESSION wsrep_sync_wait = DEFAULT;
73 connection node_3a;
74 SET SESSION wsrep_sync_wait = 0;
75 SET SESSION wsrep_sync_wait = DEFAULT;
76 connection node_1a;
77 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
78 EXPECT_0
79 0
80 connection node_2a;
81 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
82 EXPECT_0
83 0
84 connection node_3a;
85 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
86 EXPECT_0
87 0
88 connection node_1;
89 DROP TABLE t1;