Test sys_queue_expand.sql (id 90b5cb418b8e) (err)
sys_queue_expand.stable.out.FILTERED 2020-08-01 03:04:09.793767900 +0200sys_queue_expand.test.out.FILTERED 2020-08-01 03:04:09.793767900 +0200
1 Statistics about stdout of test 'sys_queue_expand` in directory 'sql/test/sysmon`: 1 1 Statistics about stdout of test 'sys_queue_expand` in directory 'sql/test/sysmon`: 1
2 169 lines, 1227 words, 6395 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 170 lines, 1304 words, 7042 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 169 lines, 1227 words, 6395 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 170 lines, 1304 words, 7042 chars in lines not matching '^$|^(\| |)#` 3
4 # 243 lines, 1542 words, 8100 chars in all lines 4 ! 4 # 244 lines, 1619 words, 8732 chars in all lines 4
5 5 5 5
..................
# %2, username, status, query #
92 % 1, 7, 8, 51 # length 92 92 % 1, 7, 8, 51 # length 92
+ 93 [ 0, "monetdb", "finished", "select username, status, query from sys.queue();" ] 93
93 [ 0, "monetdb", "finished", "exec 0();" ] 93 94 [ 0, "monetdb", "finished", "exec 0();" ] 94
..................
# %2, username, status, query #
110 % 1, 7, 8, 51 # length 110 111 % 1, 7, 8, 51 # length 111
111 [ 1, "monetdb", "running", "prepare select 0;" ] 111 ! 112 [ 1, "monetdb", "finished", "select username, status, query from sys.queue();" ] 112
[ 1, "monetdb", "finished", " + 113 [ 1, "monetdb", "finished", "exec 0();" ] 113
+ 114 [ 1, "monetdb", "finished", "prepare select 0;" ] 114
112 select 0, username, status, query from sys.queue();" ] 112 + 115 [ 1, "monetdb", "running", "select 0, username, status, query from sys.queue();" ] 115
113 [ 1, "monetdb", "finished", "exec 1();" ] 113 116 [ 1, "monetdb", "finished", "exec 1();" ] 116
..................
# %2, username, status, query #
130 % 1, 7, 8, 51 # length 130 133 % 1, 7, 8, 51 # length 133
+ 134 [ 2, "monetdb", "running", "select 0, username, status, query from sys.queue();" ] 134
131 [ 2, "monetdb", "finished", "exec 1();" ] 131 135 [ 2, "monetdb", "finished", "exec 1();" ] 135
132 [ 2, "monetdb", "running", "prepare select 1;" ] 132 ! 136 [ 2, "monetdb", "finished", "prepare select 1;" ] 136
133 [ 2, "monetdb", "finished", "select 1, username, status, query from sys.queue();" ] 133 ! 137 [ 2, "monetdb", "running", "select 1, username, status, query from sys.queue();" ] 137
134 [ 2, "monetdb", "finished", "exec 2();" ] 134 138 [ 2, "monetdb", "finished", "exec 2();" ] 138
..................
# %2, username, status, query #
136 [ 2, "monetdb", "running", "select 2, username, status, query from sys.queue();" ] 136 140 [ 2, "monetdb", "running", "select 2, username, status, query from sys.queue();" ] 140
137 [ 2, "monetdb", "running", "prepare select 0;" ] 137 -
138 #exec 3(); 138 141 #exec 3(); 141
..................
# %2, username, status, query #
152 % 1, 7, 8, 51 # length 152 155 % 1, 7, 8, 51 # length 155
153 [ 3, "monetdb", "running", "prepare select 2;" ] 153 ! 156 [ 3, "monetdb", "finished", "prepare select 2;" ] 156
154 [ 3, "monetdb", "finished", "select 2, username, status, query from sys.queue();" ] 154 ! 157 [ 3, "monetdb", "running", "select 2, username, status, query from sys.queue();" ] 157
+ 158 [ 3, "monetdb", "finished", "exec 3();" ] 158
155 [ 3, "monetdb", "running", "prepare select 0;" ] 155 ! 159 [ 3, "monetdb", "running", "select 0, username, status, query from sys.queue();" ] 159
156 [ 3, "monetdb", "finished", "exec 3();" ] 156 -
157 [ 3, "monetdb", "running", "prepare select 3;" ] 157 160 [ 3, "monetdb", "running", "prepare select 3;" ] 160
+ 161 [ 3, "monetdb", "running", "select 3, username, status, query from sys.queue();" ] 161
158 [ 3, "monetdb", "running", "prepare select 1;" ] 158 ! 162 [ 3, "monetdb", "running", "select 1, username, status, query from sys.queue();" ] 162
159 [ 3, "monetdb", "running", "select 3, username, status, query from sys.queue();" ] 159 -
160 #exec 4(); 160 163 #exec 4(); 163
..................
# %2, username, status, query #
174 % 1, 7, 8, 51 # length 174 177 % 1, 7, 8, 51 # length 177
175 [ 4, "monetdb", "running", "prepare select 0;" ] 175 ! 178 [ 4, "monetdb", "running", "select 3, username, status, query from sys.queue();" ] 178
176 [ 4, "monetdb", "finished", "exec 3();" ] 176 ! 179 [ 4, "monetdb", "running", "select 1, username, status, query from sys.queue();" ] 179
177 [ 4, "monetdb", "running", "prepare select 3;" ] 177 ! 180 [ 4, "monetdb", "finished", "exec 4();" ] 180
178 [ 4, "monetdb", "running", "prepare select 1;" ] 178 ! 181 [ 4, "monetdb", "running", "prepare select 4;" ] 181
179 [ 4, "monetdb", "finished", "select 3, username, status, query from sys.queue();" ] 179 ! 182 [ 4, "monetdb", "running", "select 2, username, status, query from sys.queue();" ] 182
180 [ 4, "monetdb", "finished", "exec 4();" ] 180 ! 183 [ 4, "monetdb", "running", "select 4, username, status, query from sys.queue();" ] 183
181 [ 4, "monetdb", "running", "prepare select 2;" ] 181 ! 184 [ 4, "monetdb", "running", "select 0, username, status, query from sys.queue();" ] 184
182 [ 4, "monetdb", "running", "prepare select 4;" ] 182 -
183 [ 4, "monetdb", "running", "select 4, username, status, query from sys.queue();" ] 183 -
184 #exec 5(); 184 185 #exec 5(); 185
..................
# %2, username, status, query #
214 % 1, 7, 8, 51 # length 214 215 % 1, 7, 8, 51 # length 215
215 [ 7, "monetdb", "running", "prepare select 5;" ] 215 ! 216 [ 7, "monetdb", "running", "select 3, username, status, query from sys.queue();" ] 216
+ 217 [ 7, "monetdb", "running", "select 1, username, status, query from sys.queue();" ] 217
216 [ 7, "monetdb", "finished", "exec 6();" ] 216 -
217 [ 7, "monetdb", "running", "prepare select 0;" ] 217 ! 218 [ 7, "monetdb", "finished", "prepare select 5;" ] 218
+ 219 [ 7, "monetdb", "finished", "exec 6();" ] 219
218 [ 7, "monetdb", "running", "prepare select 6;" ] 218 220 [ 7, "monetdb", "running", "prepare select 6;" ] 220
219 [ 7, "monetdb", "running", "prepare select 3;" ] 219 ! 221 [ 7, "monetdb", "running", "exec 7();" ] 221
+ 222 [ 7, "monetdb", "running", "prepare select 7;" ] 222
+ 223 [ 7, "monetdb", "running", "select 7, username, status, query from sys.queue();" ] 223
220 [ 7, "monetdb", "running", "prepare select 1;" ] 220 ! 224 [ 7, "monetdb", "running", "select 2, username, status, query from sys.queue();" ] 224
221 [ 7, "monetdb", "finished", "exec 7();" ] 221 -
222 [ 7, "monetdb", "running", "prepare select 7;" ] 222 -
223 [ 7, "monetdb", "running", "prepare select 2;" ] 223 ! 225 [ 7, "monetdb", "running", "select 4, username, status, query from sys.queue();" ] 225
224 [ 7, "monetdb", "running", "prepare select 4;" ] 224 ! 226 [ 7, "monetdb", "running", "select 0, username, status, query from sys.queue();" ] 226
225 [ 7, "monetdb", "running", "select 7, username, status, query from sys.queue();" ] 225 -
226 #select 8, username, status, query from sys.queue(); 226 227 #select 8, username, status, query from sys.queue(); 227
..................
# %2, username, status, query #
232 % 1, 7, 8, 51 # length 232 233 % 1, 7, 8, 51 # length 233
233 [ 8, "monetdb", "running", "prepare select 0;" ] 233 ! 234 [ 8, "monetdb", "finished", "exec 6();" ] 234
234 [ 8, "monetdb", "running", "prepare select 6;" ] 234 ! 235 [ 8, "monetdb", "finished", "prepare select 6;" ] 235
235 [ 8, "monetdb", "running", "prepare select 3;" ] 235 ! 236 [ 8, "monetdb", "running", "exec 7();" ] 236
236 [ 8, "monetdb", "running", "prepare select 1;" ] 236 -
237 [ 8, "monetdb", "finished", "exec 7();" ] 237 -
238 [ 8, "monetdb", "running", "prepare select 7;" ] 238 237 [ 8, "monetdb", "running", "prepare select 7;" ] 237
239 [ 8, "monetdb", "running", "prepare select 2;" ] 239 ! 238 [ 8, "monetdb", "running", "select 7, username, status, query from sys.queue();" ] 238
240 [ 8, "monetdb", "running", "prepare select 4;" ] 240 ! 239 [ 8, "monetdb", "running", "select 2, username, status, query from sys.queue();" ] 239
241 [ 8, "monetdb", "finished", "select 7, username, status, query from sys.queue();" ] 241 ! 240 [ 8, "monetdb", "running", "select 4, username, status, query from sys.queue();" ] 240
+ 241 [ 8, "monetdb", "running", "select 0, username, status, query from sys.queue();" ] 241
242 [ 8, "monetdb", "running", "select 8, username, status, query from sys.queue();" ] 242 242 [ 8, "monetdb", "running", "select 8, username, status, query from sys.queue();" ] 242
243 [ 8, "monetdb", "running", "prepare select 5;" ] 243 ! 243 [ 8, "monetdb", "running", "select 3, username, status, query from sys.queue();" ] 243
+ 244 [ 8, "monetdb", "running", "select 1, username, status, query from sys.queue();" ] 244
244 244 245 245