Debian Codegraph @

mysql-test/suite/rpl/r/rpl_test_framework.result

raw
1 ==== Create t1 on all servers. ====
2 include/rpl_init.inc [topology=1->2->3->4->5->6->7->8->9]
3 CREATE TABLE t1 (a INT);
4 include/rpl_end.inc
5 ==== Test 3-server topologies ====
6 include/rpl_init.inc [topology=1 -> 2]
7 include/rpl_generate_sync_chain.inc
8 rpl_sync_chain= ' 12'
9 connection server_1;
10 DELETE FROM t1;
11 INSERT INTO t1 VALUES (1);
12 connection server_3;
13 DELETE FROM t1;
14 INSERT INTO t1 VALUES (1);
15 include/rpl_sync.inc
16 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1]
17 include/rpl_end.inc
18 include/rpl_init.inc [topology=2 -> 3]
19 include/rpl_generate_sync_chain.inc
20 rpl_sync_chain= ' 23'
21 connection server_1;
22 DELETE FROM t1;
23 INSERT INTO t1 VALUES (2);
24 connection server_2;
25 DELETE FROM t1;
26 INSERT INTO t1 VALUES (2);
27 include/rpl_sync.inc
28 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1]
29 include/rpl_end.inc
30 include/rpl_init.inc [topology=none]
31 include/rpl_generate_sync_chain.inc
32 rpl_sync_chain= ''
33 connection server_1;
34 DELETE FROM t1;
35 INSERT INTO t1 VALUES (3);
36 connection server_2;
37 DELETE FROM t1;
38 INSERT INTO t1 VALUES (3);
39 connection server_3;
40 DELETE FROM t1;
41 INSERT INTO t1 VALUES (3);
42 include/rpl_sync.inc
43 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1]
44 include/rpl_end.inc
45 include/rpl_init.inc [topology=1->2, 2->1]
46 include/rpl_generate_sync_chain.inc
47 rpl_sync_chain= ' 212'
48 connection server_1;
49 DELETE FROM t1;
50 INSERT INTO t1 VALUES (4);
51 connection server_3;
52 DELETE FROM t1;
53 INSERT INTO t1 VALUES (4);
54 include/rpl_sync.inc
55 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1]
56 include/rpl_end.inc
57 include/rpl_init.inc [topology=1->2->1]
58 include/rpl_generate_sync_chain.inc
59 rpl_sync_chain= ' 212'
60 connection server_2;
61 DELETE FROM t1;
62 INSERT INTO t1 VALUES (5);
63 connection server_3;
64 DELETE FROM t1;
65 INSERT INTO t1 VALUES (5);
66 include/rpl_sync.inc
67 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1]
68 include/rpl_end.inc
69 include/rpl_init.inc [topology=2->1->2]
70 include/rpl_generate_sync_chain.inc
71 rpl_sync_chain= ' 212'
72 connection server_1;
73 DELETE FROM t1;
74 INSERT INTO t1 VALUES (6);
75 connection server_3;
76 DELETE FROM t1;
77 INSERT INTO t1 VALUES (6);
78 include/rpl_sync.inc
79 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1]
80 include/rpl_end.inc
81 include/rpl_init.inc [topology=1->2->3]
82 include/rpl_generate_sync_chain.inc
83 rpl_sync_chain= ' 123'
84 connection server_1;
85 DELETE FROM t1;
86 INSERT INTO t1 VALUES (7);
87 include/rpl_sync.inc
88 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1]
89 include/rpl_end.inc
90 include/rpl_init.inc [topology=2->3->2->1]
91 include/rpl_generate_sync_chain.inc
92 rpl_sync_chain= ' 323 21'
93 connection server_3;
94 DELETE FROM t1;
95 INSERT INTO t1 VALUES (8);
96 include/rpl_sync.inc
97 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1]
98 include/rpl_end.inc
99 include/rpl_init.inc [topology=1->2,2->3,3->1]
100 include/rpl_generate_sync_chain.inc
101 rpl_sync_chain= ' 23123'
102 connection server_3;
103 DELETE FROM t1;
104 INSERT INTO t1 VALUES (9);
105 include/rpl_sync.inc
106 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1]
107 include/rpl_end.inc
108 include/rpl_init.inc [topology=1->3->2->1]
109 include/rpl_generate_sync_chain.inc
110 rpl_sync_chain= ' 13213'
111 connection server_3;
112 DELETE FROM t1;
113 INSERT INTO t1 VALUES (10);
114 include/rpl_sync.inc
115 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1]
116 include/rpl_end.inc
117 ==== Test 6-server topologies ====
118 include/rpl_init.inc [topology=1->2->3->4->1->5->6]
119 include/rpl_generate_sync_chain.inc
120 rpl_sync_chain= ' 341234156'
121 connection server_1;
122 DELETE FROM t1;
123 INSERT INTO t1 VALUES (11);
124 include/rpl_sync.inc
125 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1,server_4:t1,server_5:t1,server_6:t1]
126 include/rpl_end.inc
127 include/rpl_init.inc [topology=3->4->5->6->3->1->2]
128 include/rpl_generate_sync_chain.inc
129 rpl_sync_chain= ' 4563456 312'
130 connection server_4;
131 DELETE FROM t1;
132 INSERT INTO t1 VALUES (12);
133 include/rpl_sync.inc
134 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1,server_4:t1,server_5:t1,server_6:t1]
135 include/rpl_end.inc
136 include/rpl_init.inc [topology=6->5->4->3->2->1]
137 include/rpl_generate_sync_chain.inc
138 rpl_sync_chain= ' 65 54 43 32 21'
139 connection server_6;
140 DELETE FROM t1;
141 INSERT INTO t1 VALUES (13);
142 include/rpl_sync.inc
143 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1,server_4:t1,server_5:t1,server_6:t1]
144 include/rpl_end.inc
145 include/rpl_init.inc [topology=1->2->3->1,4->5->6]
146 include/rpl_generate_sync_chain.inc
147 rpl_sync_chain= ' 456 23123'
148 connection server_3;
149 DELETE FROM t1;
150 INSERT INTO t1 VALUES (14);
151 connection server_4;
152 DELETE FROM t1;
153 INSERT INTO t1 VALUES (14);
154 include/rpl_sync.inc
155 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1,server_4:t1,server_5:t1,server_6:t1]
156 include/rpl_end.inc
157 ==== Test 9-server topology ====
158 include/rpl_init.inc [topology=1->2, 2->3, 3->4, 4->5, 5->1, 1->6, 6->7, 6->8, 8->9]
159 include/rpl_generate_sync_chain.inc
160 rpl_sync_chain= ' 345123451689 67'
161 connection server_2;
162 DELETE FROM t1;
163 INSERT INTO t1 VALUES (15);
164 include/rpl_sync.inc
165 include/diff_tables.inc [server_1:t1,server_2:t1,server_3:t1,server_4:t1,server_5:t1,server_6:t1,server_7:t1,server_8:t1,server_9:t1]
166 include/rpl_end.inc
167 ==== Clean up ====
168 include/rpl_init.inc [topology=1->2->3->4->5->6->7->8->9]
169 connection server_1;
170 DROP TABLE t1;
171 include/rpl_end.inc