Debian Codegraph @

mysql-test/suite/x/r/input_queue.result

raw
1 call mtr.add_suppression("Message of size .* received, exceeding the limit of");
2 Setup
3 USE `test`;
4 SET GLOBAL Mysqlx_max_allowed_packet=1024;
5 CREATE TABLE IF NOT EXISTS `first_table`(`column_name` INTEGER DEFAULT 0 NOT NULL);
6 Test case
7 RUN USE test
8
9 0 rows affected
10 Limits are less then page size
11 switched to session default
12 RUN SET GLOBAL Mysqlx_max_allowed_packet=1024
13
14 0 rows affected
15 connecting...
16 active session is now 'test1'
17 send Mysqlx.Sql.StmtExecute {
18 stmt: "LOCK TABLES `first_table` READ;"
19 namespace: "sql"
20 }
21
22 Test sends 4 messages
23 LOCK TABLE stops processing of following commands
24 switched to session test1
25
26 0 rows affected
27 First query
28 1
29 0 rows affected
30 Second query
31 2
32 0 rows affected
33 Third query
34 3
35 0 rows affected
36 Fourth query
37 4
38 0 rows affected
39 Bug 21811192 (fixed)
40 Lets try if plugin is processing new data
41
42 command ok
43 closing session test1
44 Mysqlx.Ok {
45 msg: "bye!"
46 }
47 switched to session default
48 Multiple messages fill the buffer (last one uses extra page)
49 switched to session default
50 RUN SET GLOBAL Mysqlx_max_allowed_packet=4094
51
52 0 rows affected
53 connecting...
54 active session is now 'test2'
55 send Mysqlx.Sql.StmtExecute {
56 stmt: "LOCK TABLES `first_table` READ;"
57 namespace: "sql"
58 }
59
60 Test sends 4 messages
61 LOCK TABLE stops processing of following commands
62 switched to session test2
63
64 0 rows affected
65 First query
66 1
67 0 rows affected
68 Second query
69 2
70 0 rows affected
71 Third query
72 3
73 0 rows affected
74 Fourth query
75 4
76 0 rows affected
77 Bug 21811192 (fixed)
78 Lets try if plugin is processing new data
79
80 command ok
81 closing session test2
82 Mysqlx.Ok {
83 msg: "bye!"
84 }
85 switched to session default
86 connecting...
87 active session is now 'test3'
88 send Mysqlx.Sql.StmtExecute {
89 stmt: "LOCK TABLES `first_table` READ;"
90 namespace: "sql"
91 }
92
93 Test sends 4 messages
94 LOCK TABLE stops processing of following commands
95 switched to session test3
96
97 0 rows affected
98 First query
99 1
100 0 rows affected
101 Second query
102 2
103 0 rows affected
104 Third query
105 3
106 0 rows affected
107 Fourth query
108 4
109 0 rows affected
110 Bug 21811192 (fixed)
111 Lets try if plugin is processing new data
112
113 command ok
114 closing session test3
115 Mysqlx.Ok {
116 msg: "bye!"
117 }
118 switched to session default
119 connecting...
120 active session is now 'test4'
121 send Mysqlx.Sql.StmtExecute {
122 stmt: "LOCK TABLES `first_table` READ;"
123 namespace: "sql"
124 }
125
126 Test sends 4 messages
127 LOCK TABLE stops processing of following commands
128 switched to session test4
129
130 0 rows affected
131 First query
132 1
133 0 rows affected
134 Second query
135 2
136 0 rows affected
137 Third query
138 3
139 0 rows affected
140 Fourth query
141 4
142 0 rows affected
143 Bug 21811192 (fixed)
144 Lets try if plugin is processing new data
145
146 command ok
147 closing session test4
148 Mysqlx.Ok {
149 msg: "bye!"
150 }
151 switched to session default
152 Use 2 page for single message, while receiving second packet wait for first to be processed
153 Extra page is used in case of not full loaded first page
154 switched to session default
155 RUN SET GLOBAL Mysqlx_max_allowed_packet=8188
156
157 0 rows affected
158 connecting...
159 active session is now 'test5'
160 send Mysqlx.Sql.StmtExecute {
161 stmt: "LOCK TABLES `first_table` READ;"
162 namespace: "sql"
163 }
164
165 Test sends 4 messages
166 LOCK TABLE stops processing of following commands
167 switched to session test5
168
169 0 rows affected
170 First query
171 1
172 0 rows affected
173 Second query
174 2
175 0 rows affected
176 Third query
177 3
178 0 rows affected
179 Fourth query
180 4
181 0 rows affected
182 Bug 21811192 (fixed)
183 Lets try if plugin is processing new data
184
185 command ok
186 closing session test5
187 Mysqlx.Ok {
188 msg: "bye!"
189 }
190 switched to session default
191 switched to session default
192 RUN SET GLOBAL Mysqlx_max_allowed_packet=2024
193
194 0 rows affected
195 connecting...
196 active session is now 'test6'
197 Sending 1115 bytes raw data...
198 wait for first
199 First query
200 1
201 0 rows affected
202 wait for second
203 Second query
204 2
205 0 rows affected
206 Bug 21811192 (fixed)
207 Lets try if plugin is processing new data
208
209 command ok
210 closing session test6
211 Mysqlx.Ok {
212 msg: "bye!"
213 }
214 switched to session default
215 Bug 21839782 (fixed) - no data in buffer for incoming message (infinite loop)
216 connecting...
217 active session is now 'invalid_1'
218 RUN SET GLOBAL mysqlx_max_allowed_packet=1048597
219
220 0 rows affected
221 While sending client could receive CR_BROKEN_PIPE network which could occur
222 because xplugin stopped read ops
223 Got expected error (one of: 0 2007 )
224 1
225 1
226 0 rows affected
227 closing session invalid_1
228 Mysqlx.Ok {
229 msg: "bye!"
230 }
231 ok
232 SET GLOBAL Mysqlx_max_allowed_packet=DEFAULT;
233 DROP TABLE `first_table`;