Debian Codegraph @

mysql-test/suite/group_replication/r/gr_xplugin_basic_dml.result

raw
1 include/group_replication.inc [rpl_server_count=3]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 [connection server1]
7 [connection server2]
8 [connection server3]
9 Starting GR on server 1
10 RUN SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-dddd-aaaa-aaaa-aaaaaaaaaaaa'
11
12 0 rows affected
13 RUN SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=1
14
15 0 rows affected
16 RUN START GROUP_REPLICATION
17
18 0 rows affected
19 RUN SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=0
20
21 0 rows affected
22 Mysqlx.Ok {
23 msg: "bye!"
24 }
25 ok
26 Starting GR on server 2
27 RUN SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-dddd-aaaa-aaaa-aaaaaaaaaaaa'
28
29 0 rows affected
30 RUN CHANGE REPLICATION SOURCE TO SOURCE_USER='root' FOR CHANNEL 'group_replication_recovery'
31
32 0 rows affected
33 RUN START GROUP_REPLICATION
34
35 0 rows affected
36 Mysqlx.Ok {
37 msg: "bye!"
38 }
39 ok
40 Starting GR on server 3
41 RUN SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-dddd-aaaa-aaaa-aaaaaaaaaaaa'
42
43 0 rows affected
44 RUN CHANGE REPLICATION SOURCE TO SOURCE_USER='root' FOR CHANNEL 'group_replication_recovery'
45
46 0 rows affected
47 RUN START GROUP_REPLICATION
48
49 0 rows affected
50 Mysqlx.Ok {
51 msg: "bye!"
52 }
53 ok
54 Waiting for GR members to come online.
55 RUN USE test
56
57 0 rows affected
58 RUN CREATE TABLE T1 (C1 INT PRIMARY KEY, C2 INT )
59
60 0 rows affected
61 RUN INSERT INTO T1 VALUES (1,12)
62
63 1 rows affected
64 RUN INSERT INTO T1 VALUES (2,1234)
65
66 1 rows affected
67 RUN INSERT INTO T1 VALUES (3,98765)
68
69 1 rows affected
70 RUN UPDATE T1 SET C2 = C2 - 98765
71
72 3 rows affected
73 Rows matched: 3 Changed: 3 Warnings: 0
74 RUN DELETE FROM T1 WHERE C2 = 0
75
76 1 rows affected
77 Mysqlx.Ok {
78 msg: "bye!"
79 }
80 ok
81 include/rpl_sync.inc
82 RUN USE test
83
84 0 rows affected
85 RUN CREATE TABLE T2 (C1 CHAR(20) PRIMARY KEY, C2 INT )
86
87 0 rows affected
88 RUN INSERT INTO T2 VALUES ('ABC',23)
89
90 1 rows affected
91 RUN UPDATE T2 SET C2 = C2 + 27
92
93 1 rows affected
94 Rows matched: 1 Changed: 1 Warnings: 0
95 RUN INSERT INTO T1 VALUES (4,34)
96
97 1 rows affected
98 RUN INSERT INTO T2 VALUES ('ABCDEF',23)
99
100 1 rows affected
101 RUN INSERT INTO T1 VALUES (5,1234)
102
103 1 rows affected
104 RUN INSERT INTO T2 VALUES ('ABCDEFGHIJ',23)
105
106 1 rows affected
107 RUN DELETE FROM T2 WHERE C1 = 'ABC'
108
109 1 rows affected
110 Mysqlx.Ok {
111 msg: "bye!"
112 }
113 ok
114 include/rpl_sync.inc
115 RUN USE test
116
117 0 rows affected
118 RUN CREATE TABLE T3 (C1 INT PRIMARY KEY, C2 VARCHAR(20) )
119
120 0 rows affected
121 RUN DELETE FROM T1
122
123 4 rows affected
124 RUN INSERT INTO T1 VALUES (1,12345)
125
126 1 rows affected
127 RUN INSERT INTO T3 VALUES (1,'1234')
128
129 1 rows affected
130 RUN INSERT INTO T2 VALUES ('1234',1234)
131
132 1 rows affected
133 RUN INSERT INTO T1 VALUES (7,98765)
134
135 1 rows affected
136 RUN INSERT INTO T2 VALUES ('XYZ',23)
137
138 1 rows affected
139 RUN UPDATE T2 SET C1 = 'ABC' WHERE C1 ='XYZ'
140
141 1 rows affected
142 Rows matched: 1 Changed: 1 Warnings: 0
143 RUN INSERT INTO T3 VALUES (2,'23')
144
145 1 rows affected
146 RUN INSERT INTO T3 VALUES (3,'234')
147
148 1 rows affected
149 RUN DELETE FROM T3 WHERE C1 > 0
150
151 3 rows affected
152 Mysqlx.Ok {
153 msg: "bye!"
154 }
155 ok
156 include/rpl_sync.inc
157 Checking the Value on T1
158 RUN SELECT C2 FROM test.T1 WHERE C1=1
159 Checking the row_count on T2
160 RUN SELECT C2 FROM test.T2 WHERE C1="ABC"
161 Mysqlx.Ok {
162 msg: "bye!"
163 }
164 ok
165 RUN USE test
166
167 0 rows affected
168 RUN DROP TABLE T1
169
170 0 rows affected
171 RUN DROP TABLE T2
172
173 0 rows affected
174 RUN DROP TABLE T3
175
176 0 rows affected
177 Mysqlx.Ok {
178 msg: "bye!"
179 }
180 ok
181 include/rpl_sync.inc
182 Stopping GR on server 1
183 RUN STOP GROUP_REPLICATION;
184
185 0 rows affected
186 Mysqlx.Ok {
187 msg: "bye!"
188 }
189 ok
190 Stopping GR on server 2
191 RUN STOP GROUP_REPLICATION;
192
193 0 rows affected
194 Mysqlx.Ok {
195 msg: "bye!"
196 }
197 ok
198 Stopping GR on server 3
199 RUN STOP GROUP_REPLICATION;
200
201 0 rows affected
202 Mysqlx.Ok {
203 msg: "bye!"
204 }
205 ok
206 [connection server1]
207 include/gr_wait_for_member_state.inc
208 include/assert_and_disable_read_only.inc
209 [connection server2]
210 include/gr_wait_for_member_state.inc
211 include/assert_and_disable_read_only.inc
212 [connection server3]
213 include/gr_wait_for_member_state.inc
214 include/assert_and_disable_read_only.inc
215 include/group_replication_end.inc