| 1 |
call mtr.add_suppression("Plugin mysqlx reported: 'Unhandled network error: Bad file descriptor'"); |
| 2 |
create user sslcon@localhost identified by 'sslcon'; |
| 3 |
grant all on *.* to sslcon@localhost; |
| 4 |
RUN create user abc@localhost identified by 'abc', |
| 5 |
xplugin@localhost identified by 'xplugin', |
| 6 |
process@localhost identified by 'process', |
| 7 |
expire@localhost identified by 'expire' |
| 8 |
|
| 9 |
0 rows affected |
| 10 |
RUN grant all on *.* to xplugin@localhost, |
| 11 |
expire@localhost |
| 12 |
|
| 13 |
0 rows affected |
| 14 |
RUN grant process on *.* to process@localhost |
| 15 |
|
| 16 |
0 rows affected |
| 17 |
RUN alter user expire@localhost password expire |
| 18 |
|
| 19 |
0 rows affected |
| 20 |
RUN select sleep(1) |
| 21 |
sleep(1) |
| 22 |
0 |
| 23 |
0 rows affected |
| 24 |
Test data |
| 25 |
client_id user host sql_session |
| 26 |
1 x_root localhost $SESSION |
| 27 |
command ok |
| 28 |
expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0 |
| 29 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0] |
| 30 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1] |
| 31 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 32 |
create and activate new session |
| 33 |
connecting... |
| 34 |
active session is now 'aux' |
| 35 |
client_id user host |
| 36 |
1 x_root localhost |
| 37 |
2 x_root localhost |
| 38 |
command ok |
| 39 |
expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0 even with another new x_root session |
| 40 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0] |
| 41 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1] |
| 42 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 43 |
switch back to default session |
| 44 |
switched to session default |
| 45 |
client_id user host |
| 46 |
1 x_root localhost |
| 47 |
2 x_root localhost |
| 48 |
command ok |
| 49 |
expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=0 with default x_root session where list_clients already executed |
| 50 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0] |
| 51 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2] |
| 52 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 53 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 54 |
RUN [stmtadmin kill_client 2] |
| 55 |
|
| 56 |
command ok |
| 57 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 58 |
client_id user host |
| 59 |
1 x_root localhost |
| 60 |
command ok |
| 61 |
expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 3 times and kill_client once |
| 62 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1] |
| 63 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 3] |
| 64 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 65 |
create and activate new session abc |
| 66 |
expect only abc user session id |
| 67 |
connecting... |
| 68 |
active session is now 'abc' |
| 69 |
client_id user host |
| 70 |
3 abc localhost |
| 71 |
command ok |
| 72 |
killing x_root user session with unprivileged user 'abc' which should be unsuccessful |
| 73 |
RUN [stmtadmin kill_client 1] |
| 74 |
Got expected error: You are not owner of thread (code 1095) |
| 75 |
expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=1 with session abc where list_clients and kill_client executed once |
| 76 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1] |
| 77 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1] |
| 78 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 79 |
RUN select user(),current_user() |
| 80 |
user() current_user() |
| 81 |
abc@localhost abc@localhost |
| 82 |
0 rows affected |
| 83 |
RUN show grants |
| 84 |
Grants for abc@localhost |
| 85 |
GRANT USAGE ON *.* TO `abc`@`localhost` |
| 86 |
0 rows affected |
| 87 |
open another session of abc user and kill first session of abc user,which should be successful |
| 88 |
connecting... |
| 89 |
active session is now 'abc1' |
| 90 |
client_id user host |
| 91 |
3 abc localhost |
| 92 |
4 abc localhost |
| 93 |
command ok |
| 94 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 95 |
RUN [stmtadmin kill_client 3] |
| 96 |
|
| 97 |
command ok |
| 98 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 99 |
client_id user host |
| 100 |
4 abc localhost |
| 101 |
command ok |
| 102 |
expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with new session abc where list_clients executed twice and kill_client executed once |
| 103 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1] |
| 104 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2] |
| 105 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 106 |
RUN select user(),current_user() |
| 107 |
user() current_user() |
| 108 |
abc@localhost abc@localhost |
| 109 |
0 rows affected |
| 110 |
RUN show grants |
| 111 |
Grants for abc@localhost |
| 112 |
GRANT USAGE ON *.* TO `abc`@`localhost` |
| 113 |
0 rows affected |
| 114 |
killing abc user session with its own session 'abc' which should be successful |
| 115 |
expect right error instead of End of File |
| 116 |
Server disconnected |
| 117 |
closing session abc1 |
| 118 |
switched to session default |
| 119 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 120 |
switch back to default session |
| 121 |
switched to session default |
| 122 |
client_id user host |
| 123 |
1 x_root localhost |
| 124 |
command ok |
| 125 |
expect Mysqlx_stmt_list_clients=4 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 4 times and kill_client once |
| 126 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1] |
| 127 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 4] |
| 128 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 129 |
RUN select user(),current_user() |
| 130 |
user() current_user() |
| 131 |
x_root@localhost x_root@localhost |
| 132 |
0 rows affected |
| 133 |
RUN show grants |
| 134 |
Grants for x_root@localhost |
| 135 |
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `x_root`@`localhost` WITH GRANT OPTION |
| 136 |
GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `x_root`@`localhost` WITH GRANT OPTION |
| 137 |
0 rows affected |
| 138 |
open process only privileged user seession and kill x_root user session,expect error "You are not owner of thread" |
| 139 |
connecting... |
| 140 |
active session is now 'process' |
| 141 |
client_id user host |
| 142 |
5 process localhost |
| 143 |
command ok |
| 144 |
RUN [stmtadmin kill_client 1] |
| 145 |
Got expected error: You are not owner of thread (code 1095) |
| 146 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 147 |
checking list of clients after x_root user session killed by xplugin user |
| 148 |
client_id user host |
| 149 |
5 process localhost |
| 150 |
command ok |
| 151 |
expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with process user where list_clients executed 2 times and kill_client once |
| 152 |
RUN show status like 'Mysqlx_stmt%client%' |
| 153 |
Variable_name Value |
| 154 |
Mysqlx_stmt_kill_client 1 |
| 155 |
Mysqlx_stmt_list_clients 2 |
| 156 |
0 rows affected |
| 157 |
RUN select user(),current_user() |
| 158 |
user() current_user() |
| 159 |
process@localhost process@localhost |
| 160 |
0 rows affected |
| 161 |
RUN show grants |
| 162 |
Grants for process@localhost |
| 163 |
GRANT PROCESS ON *.* TO `process`@`localhost` |
| 164 |
0 rows affected |
| 165 |
open privileged user seession and kill x_root user session,expect success |
| 166 |
connecting... |
| 167 |
active session is now 'xplugin' |
| 168 |
client_id user host |
| 169 |
1 x_root localhost |
| 170 |
5 process localhost |
| 171 |
6 xplugin localhost |
| 172 |
command ok |
| 173 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 174 |
RUN [stmtadmin kill_client 1] |
| 175 |
|
| 176 |
command ok |
| 177 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 178 |
checking list of clients after x_root user session killed by xplugin user |
| 179 |
client_id user host |
| 180 |
5 process localhost |
| 181 |
6 xplugin localhost |
| 182 |
command ok |
| 183 |
expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with xplugin user where list_clients executed 2 times and kill_client once |
| 184 |
RUN show status like 'Mysqlx_stmt%client%' |
| 185 |
Variable_name Value |
| 186 |
Mysqlx_stmt_kill_client 1 |
| 187 |
Mysqlx_stmt_list_clients 2 |
| 188 |
0 rows affected |
| 189 |
RUN select user(),current_user() |
| 190 |
user() current_user() |
| 191 |
xplugin@localhost xplugin@localhost |
| 192 |
0 rows affected |
| 193 |
RUN show grants |
| 194 |
Grants for xplugin@localhost |
| 195 |
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `xplugin`@`localhost` |
| 196 |
GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `xplugin`@`localhost` |
| 197 |
0 rows affected |
| 198 |
Cleanup |
| 199 |
RUN drop schema if exists xtest |
| 200 |
|
| 201 |
0 rows affected |
| 202 |
closing session xplugin |
| 203 |
Mysqlx.Ok { |
| 204 |
msg: "bye!" |
| 205 |
} |
| 206 |
ok |
| 207 |
client_id user host |
| 208 |
7 x_root localhost |
| 209 |
command ok |
| 210 |
expect error while killing client with data type other than usinged int |
| 211 |
try killing xprotocol session with valid sql_session id once xprotocol connetion opened with kill_client,expect error |
| 212 |
RUN [stmtadmin kill_client 11] |
| 213 |
Got expected error: Unknown MySQLx client id 11 (code 1094) |
| 214 |
Got expected error: Invalid value for argument 'id' (code 5017) |
| 215 |
Got expected error: Invalid value for argument 'id' (code 5017) |
| 216 |
Got expected error: Invalid value for argument 'id' (code 5017) |
| 217 |
Got expected error: Invalid value for argument 'id' (code 5017) |
| 218 |
Got expected error: Invalid value for argument 'id' (code 5017) |
| 219 |
Got expected error: Invalid value for argument 'id' (code 5017) |
| 220 |
expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=11 with x_root user even though kill_client returns errors |
| 221 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 7] |
| 222 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1] |
| 223 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 224 |
Mysqlx.Ok { |
| 225 |
msg: "bye!" |
| 226 |
} |
| 227 |
ok |
| 228 |
NOTICE: Account password expired |
| 229 |
expect error if list_clients and kill_client executed from password expired user session |
| 230 |
RUN show processlist |
| 231 |
While executing show processlist: |
| 232 |
Got expected error: You must reset your password using ALTER USER statement before executing this statement. (code 1820) |
| 233 |
Got expected error: You must reset your password using ALTER USER statement before executing this statement. (code 1820) |
| 234 |
RUN [stmtadmin kill_client 8] |
| 235 |
Got expected error: You must reset your password using ALTER USER statement before executing this statement. (code 1820) |
| 236 |
Mysqlx.Ok { |
| 237 |
msg: "bye!" |
| 238 |
} |
| 239 |
ok |
| 240 |
checking list_clients and kill_client with mixed case, expect success as these commands are case insensitive |
| 241 |
client_id user host |
| 242 |
9 x_root localhost |
| 243 |
command ok |
| 244 |
Got expected error: Unknown MySQLx client id 998 (code 1094) |
| 245 |
expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=1 with x_root user when these commads executed with mixed case |
| 246 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1] |
| 247 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1] |
| 248 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 249 |
Mysqlx.Ok { |
| 250 |
msg: "bye!" |
| 251 |
} |
| 252 |
ok |
| 253 |
checking list_clients and kill_client with default 50 connections, expect success for both list and kill |
| 254 |
RUN set @@global.mysqlx_max_connections=60 |
| 255 |
|
| 256 |
0 rows affected |
| 257 |
RUN create user xconnection1@localhost identified by 'xconnection1', |
| 258 |
xconnection2@localhost identified by 'xconnection2', |
| 259 |
xconnection3@localhost identified by 'xconnection3', |
| 260 |
xconnection4@localhost identified by 'xconnection4', |
| 261 |
xconnection5@localhost identified by 'xconnection5', |
| 262 |
xconnection6@localhost identified by 'xconnection6', |
| 263 |
xconnection7@localhost identified by 'xconnection7', |
| 264 |
xconnection8@localhost identified by 'xconnection8', |
| 265 |
xconnection9@localhost identified by 'xconnection9', |
| 266 |
xconnection10@localhost identified by 'xconnection10', |
| 267 |
xconnection11@localhost identified by 'xconnection11', |
| 268 |
xconnection12@localhost identified by 'xconnection12', |
| 269 |
xconnection13@localhost identified by 'xconnection13', |
| 270 |
xconnection14@localhost identified by 'xconnection14', |
| 271 |
xconnection15@localhost identified by 'xconnection15', |
| 272 |
xconnection16@localhost identified by 'xconnection16', |
| 273 |
xconnection17@localhost identified by 'xconnection17', |
| 274 |
xconnection18@localhost identified by 'xconnection18', |
| 275 |
xconnection19@localhost identified by 'xconnection19', |
| 276 |
xconnection20@localhost identified by 'xconnection20', |
| 277 |
xconnection21@localhost identified by 'xconnection21', |
| 278 |
xconnection22@localhost identified by 'xconnection22', |
| 279 |
xconnection23@localhost identified by 'xconnection23', |
| 280 |
xconnection24@localhost identified by 'xconnection24', |
| 281 |
xconnection25@localhost identified by 'xconnection25', |
| 282 |
xconnection26@localhost identified by 'xconnection26', |
| 283 |
xconnection27@localhost identified by 'xconnection27', |
| 284 |
xconnection28@localhost identified by 'xconnection28', |
| 285 |
xconnection29@localhost identified by 'xconnection29', |
| 286 |
xconnection30@localhost identified by 'xconnection30', |
| 287 |
xconnection31@localhost identified by 'xconnection31', |
| 288 |
xconnection32@localhost identified by 'xconnection32', |
| 289 |
xconnection33@localhost identified by 'xconnection33', |
| 290 |
xconnection34@localhost identified by 'xconnection34', |
| 291 |
xconnection35@localhost identified by 'xconnection35', |
| 292 |
xconnection36@localhost identified by 'xconnection36', |
| 293 |
xconnection37@localhost identified by 'xconnection37', |
| 294 |
xconnection38@localhost identified by 'xconnection38', |
| 295 |
xconnection39@localhost identified by 'xconnection39', |
| 296 |
xconnection40@localhost identified by 'xconnection40', |
| 297 |
xconnection41@localhost identified by 'xconnection41', |
| 298 |
xconnection42@localhost identified by 'xconnection42', |
| 299 |
xconnection43@localhost identified by 'xconnection43', |
| 300 |
xconnection44@localhost identified by 'xconnection44', |
| 301 |
xconnection45@localhost identified by 'xconnection45', |
| 302 |
xconnection46@localhost identified by 'xconnection46', |
| 303 |
xconnection47@localhost identified by 'xconnection47', |
| 304 |
xconnection48@localhost identified by 'xconnection48', |
| 305 |
xconnection49@localhost identified by 'xconnection49', |
| 306 |
xconnection50@localhost identified by 'xconnection50' |
| 307 |
|
| 308 |
0 rows affected |
| 309 |
Test data |
| 310 |
client_id user host sql_session |
| 311 |
10 x_root localhost $SESSION |
| 312 |
command ok |
| 313 |
expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0 |
| 314 |
RUN show status like 'Mysqlx_stmt%client%' |
| 315 |
Variable_name Value |
| 316 |
Mysqlx_stmt_kill_client 0 |
| 317 |
Mysqlx_stmt_list_clients 1 |
| 318 |
0 rows affected |
| 319 |
create and activate new session xconnection1 |
| 320 |
connecting... |
| 321 |
active session is now 'xconnection1' |
| 322 |
connecting... |
| 323 |
active session is now 'xconnection2' |
| 324 |
connecting... |
| 325 |
active session is now 'xconnection3' |
| 326 |
connecting... |
| 327 |
active session is now 'xconnection4' |
| 328 |
connecting... |
| 329 |
active session is now 'xconnection5' |
| 330 |
connecting... |
| 331 |
active session is now 'xconnection6' |
| 332 |
connecting... |
| 333 |
active session is now 'xconnection7' |
| 334 |
connecting... |
| 335 |
active session is now 'xconnection8' |
| 336 |
connecting... |
| 337 |
active session is now 'xconnection9' |
| 338 |
connecting... |
| 339 |
active session is now 'xconnection10' |
| 340 |
connecting... |
| 341 |
active session is now 'xconnection11' |
| 342 |
connecting... |
| 343 |
active session is now 'xconnection12' |
| 344 |
connecting... |
| 345 |
active session is now 'xconnection13' |
| 346 |
connecting... |
| 347 |
active session is now 'xconnection14' |
| 348 |
connecting... |
| 349 |
active session is now 'xconnection15' |
| 350 |
connecting... |
| 351 |
active session is now 'xconnection16' |
| 352 |
connecting... |
| 353 |
active session is now 'xconnection17' |
| 354 |
connecting... |
| 355 |
active session is now 'xconnection18' |
| 356 |
connecting... |
| 357 |
active session is now 'xconnection19' |
| 358 |
connecting... |
| 359 |
active session is now 'xconnection20' |
| 360 |
connecting... |
| 361 |
active session is now 'xconnection21' |
| 362 |
connecting... |
| 363 |
active session is now 'xconnection22' |
| 364 |
connecting... |
| 365 |
active session is now 'xconnection23' |
| 366 |
connecting... |
| 367 |
active session is now 'xconnection24' |
| 368 |
connecting... |
| 369 |
active session is now 'xconnection25' |
| 370 |
connecting... |
| 371 |
active session is now 'xconnection26' |
| 372 |
connecting... |
| 373 |
active session is now 'xconnection27' |
| 374 |
connecting... |
| 375 |
active session is now 'xconnection28' |
| 376 |
connecting... |
| 377 |
active session is now 'xconnection29' |
| 378 |
connecting... |
| 379 |
active session is now 'xconnection30' |
| 380 |
connecting... |
| 381 |
active session is now 'xconnection31' |
| 382 |
connecting... |
| 383 |
active session is now 'xconnection32' |
| 384 |
connecting... |
| 385 |
active session is now 'xconnection33' |
| 386 |
connecting... |
| 387 |
active session is now 'xconnection34' |
| 388 |
connecting... |
| 389 |
active session is now 'xconnection35' |
| 390 |
connecting... |
| 391 |
active session is now 'xconnection36' |
| 392 |
connecting... |
| 393 |
active session is now 'xconnection37' |
| 394 |
connecting... |
| 395 |
active session is now 'xconnection38' |
| 396 |
connecting... |
| 397 |
active session is now 'xconnection39' |
| 398 |
connecting... |
| 399 |
active session is now 'xconnection40' |
| 400 |
connecting... |
| 401 |
active session is now 'xconnection41' |
| 402 |
connecting... |
| 403 |
active session is now 'xconnection42' |
| 404 |
connecting... |
| 405 |
active session is now 'xconnection43' |
| 406 |
connecting... |
| 407 |
active session is now 'xconnection44' |
| 408 |
connecting... |
| 409 |
active session is now 'xconnection45' |
| 410 |
connecting... |
| 411 |
active session is now 'xconnection46' |
| 412 |
connecting... |
| 413 |
active session is now 'xconnection47' |
| 414 |
connecting... |
| 415 |
active session is now 'xconnection48' |
| 416 |
connecting... |
| 417 |
active session is now 'xconnection49' |
| 418 |
connecting... |
| 419 |
active session is now 'xconnection50' |
| 420 |
client_id user host |
| 421 |
60 xconnection50 localhost |
| 422 |
command ok |
| 423 |
switched to session default |
| 424 |
list all connected clients |
| 425 |
client_id user host |
| 426 |
10 x_root localhost |
| 427 |
11 xconnection1 localhost |
| 428 |
12 xconnection2 localhost |
| 429 |
13 xconnection3 localhost |
| 430 |
14 xconnection4 localhost |
| 431 |
15 xconnection5 localhost |
| 432 |
16 xconnection6 localhost |
| 433 |
17 xconnection7 localhost |
| 434 |
18 xconnection8 localhost |
| 435 |
19 xconnection9 localhost |
| 436 |
20 xconnection10 localhost |
| 437 |
21 xconnection11 localhost |
| 438 |
22 xconnection12 localhost |
| 439 |
23 xconnection13 localhost |
| 440 |
24 xconnection14 localhost |
| 441 |
25 xconnection15 localhost |
| 442 |
26 xconnection16 localhost |
| 443 |
27 xconnection17 localhost |
| 444 |
28 xconnection18 localhost |
| 445 |
29 xconnection19 localhost |
| 446 |
30 xconnection20 localhost |
| 447 |
31 xconnection21 localhost |
| 448 |
32 xconnection22 localhost |
| 449 |
33 xconnection23 localhost |
| 450 |
34 xconnection24 localhost |
| 451 |
35 xconnection25 localhost |
| 452 |
36 xconnection26 localhost |
| 453 |
37 xconnection27 localhost |
| 454 |
38 xconnection28 localhost |
| 455 |
39 xconnection29 localhost |
| 456 |
40 xconnection30 localhost |
| 457 |
41 xconnection31 localhost |
| 458 |
42 xconnection32 localhost |
| 459 |
43 xconnection33 localhost |
| 460 |
44 xconnection34 localhost |
| 461 |
45 xconnection35 localhost |
| 462 |
46 xconnection36 localhost |
| 463 |
47 xconnection37 localhost |
| 464 |
48 xconnection38 localhost |
| 465 |
49 xconnection39 localhost |
| 466 |
50 xconnection40 localhost |
| 467 |
51 xconnection41 localhost |
| 468 |
52 xconnection42 localhost |
| 469 |
53 xconnection43 localhost |
| 470 |
54 xconnection44 localhost |
| 471 |
55 xconnection45 localhost |
| 472 |
56 xconnection46 localhost |
| 473 |
57 xconnection47 localhost |
| 474 |
58 xconnection48 localhost |
| 475 |
59 xconnection49 localhost |
| 476 |
60 xconnection50 localhost |
| 477 |
command ok |
| 478 |
expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=0 |
| 479 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0] |
| 480 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2] |
| 481 |
Verify [Global status variable "Mysqlx_sessions" needs to have a value of 51] |
| 482 |
killing all newly connected clients except x_root,one by one |
| 483 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 484 |
RUN [stmtadmin kill_client 11] |
| 485 |
|
| 486 |
command ok |
| 487 |
switched to session xconnection1 |
| 488 |
[ASSERT notice warning - ERROR, 3169] |
| 489 |
Server disconnected |
| 490 |
closing session xconnection1 |
| 491 |
switched to session default |
| 492 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 493 |
RUN [stmtadmin kill_client 12] |
| 494 |
|
| 495 |
command ok |
| 496 |
switched to session xconnection2 |
| 497 |
[ASSERT notice warning - ERROR, 3169] |
| 498 |
Server disconnected |
| 499 |
closing session xconnection2 |
| 500 |
switched to session default |
| 501 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 502 |
RUN [stmtadmin kill_client 13] |
| 503 |
|
| 504 |
command ok |
| 505 |
switched to session xconnection3 |
| 506 |
[ASSERT notice warning - ERROR, 3169] |
| 507 |
Server disconnected |
| 508 |
closing session xconnection3 |
| 509 |
switched to session default |
| 510 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 511 |
RUN [stmtadmin kill_client 14] |
| 512 |
|
| 513 |
command ok |
| 514 |
switched to session xconnection4 |
| 515 |
[ASSERT notice warning - ERROR, 3169] |
| 516 |
Server disconnected |
| 517 |
closing session xconnection4 |
| 518 |
switched to session default |
| 519 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 520 |
RUN [stmtadmin kill_client 15] |
| 521 |
|
| 522 |
command ok |
| 523 |
switched to session xconnection5 |
| 524 |
[ASSERT notice warning - ERROR, 3169] |
| 525 |
Server disconnected |
| 526 |
closing session xconnection5 |
| 527 |
switched to session default |
| 528 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 529 |
RUN [stmtadmin kill_client 16] |
| 530 |
|
| 531 |
command ok |
| 532 |
switched to session xconnection6 |
| 533 |
[ASSERT notice warning - ERROR, 3169] |
| 534 |
Server disconnected |
| 535 |
closing session xconnection6 |
| 536 |
switched to session default |
| 537 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 538 |
RUN [stmtadmin kill_client 17] |
| 539 |
|
| 540 |
command ok |
| 541 |
switched to session xconnection7 |
| 542 |
[ASSERT notice warning - ERROR, 3169] |
| 543 |
Server disconnected |
| 544 |
closing session xconnection7 |
| 545 |
switched to session default |
| 546 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 547 |
RUN [stmtadmin kill_client 18] |
| 548 |
|
| 549 |
command ok |
| 550 |
switched to session xconnection8 |
| 551 |
[ASSERT notice warning - ERROR, 3169] |
| 552 |
Server disconnected |
| 553 |
closing session xconnection8 |
| 554 |
switched to session default |
| 555 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 556 |
RUN [stmtadmin kill_client 19] |
| 557 |
|
| 558 |
command ok |
| 559 |
switched to session xconnection9 |
| 560 |
[ASSERT notice warning - ERROR, 3169] |
| 561 |
Server disconnected |
| 562 |
closing session xconnection9 |
| 563 |
switched to session default |
| 564 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 565 |
RUN [stmtadmin kill_client 20] |
| 566 |
|
| 567 |
command ok |
| 568 |
switched to session xconnection10 |
| 569 |
[ASSERT notice warning - ERROR, 3169] |
| 570 |
Server disconnected |
| 571 |
closing session xconnection10 |
| 572 |
switched to session default |
| 573 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 574 |
RUN [stmtadmin kill_client 21] |
| 575 |
|
| 576 |
command ok |
| 577 |
switched to session xconnection11 |
| 578 |
[ASSERT notice warning - ERROR, 3169] |
| 579 |
Server disconnected |
| 580 |
closing session xconnection11 |
| 581 |
switched to session default |
| 582 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 583 |
RUN [stmtadmin kill_client 22] |
| 584 |
|
| 585 |
command ok |
| 586 |
switched to session xconnection12 |
| 587 |
[ASSERT notice warning - ERROR, 3169] |
| 588 |
Server disconnected |
| 589 |
closing session xconnection12 |
| 590 |
switched to session default |
| 591 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 592 |
RUN [stmtadmin kill_client 23] |
| 593 |
|
| 594 |
command ok |
| 595 |
switched to session xconnection13 |
| 596 |
[ASSERT notice warning - ERROR, 3169] |
| 597 |
Server disconnected |
| 598 |
closing session xconnection13 |
| 599 |
switched to session default |
| 600 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 601 |
RUN [stmtadmin kill_client 24] |
| 602 |
|
| 603 |
command ok |
| 604 |
switched to session xconnection14 |
| 605 |
[ASSERT notice warning - ERROR, 3169] |
| 606 |
Server disconnected |
| 607 |
closing session xconnection14 |
| 608 |
switched to session default |
| 609 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 610 |
RUN [stmtadmin kill_client 25] |
| 611 |
|
| 612 |
command ok |
| 613 |
switched to session xconnection15 |
| 614 |
[ASSERT notice warning - ERROR, 3169] |
| 615 |
Server disconnected |
| 616 |
closing session xconnection15 |
| 617 |
switched to session default |
| 618 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 619 |
RUN [stmtadmin kill_client 26] |
| 620 |
|
| 621 |
command ok |
| 622 |
switched to session xconnection16 |
| 623 |
[ASSERT notice warning - ERROR, 3169] |
| 624 |
Server disconnected |
| 625 |
closing session xconnection16 |
| 626 |
switched to session default |
| 627 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 628 |
RUN [stmtadmin kill_client 27] |
| 629 |
|
| 630 |
command ok |
| 631 |
switched to session xconnection17 |
| 632 |
[ASSERT notice warning - ERROR, 3169] |
| 633 |
Server disconnected |
| 634 |
closing session xconnection17 |
| 635 |
switched to session default |
| 636 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 637 |
RUN [stmtadmin kill_client 28] |
| 638 |
|
| 639 |
command ok |
| 640 |
switched to session xconnection18 |
| 641 |
[ASSERT notice warning - ERROR, 3169] |
| 642 |
Server disconnected |
| 643 |
closing session xconnection18 |
| 644 |
switched to session default |
| 645 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 646 |
RUN [stmtadmin kill_client 29] |
| 647 |
|
| 648 |
command ok |
| 649 |
switched to session xconnection19 |
| 650 |
[ASSERT notice warning - ERROR, 3169] |
| 651 |
Server disconnected |
| 652 |
closing session xconnection19 |
| 653 |
switched to session default |
| 654 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 655 |
RUN [stmtadmin kill_client 30] |
| 656 |
|
| 657 |
command ok |
| 658 |
switched to session xconnection20 |
| 659 |
[ASSERT notice warning - ERROR, 3169] |
| 660 |
Server disconnected |
| 661 |
closing session xconnection20 |
| 662 |
switched to session default |
| 663 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 664 |
RUN [stmtadmin kill_client 31] |
| 665 |
|
| 666 |
command ok |
| 667 |
switched to session xconnection21 |
| 668 |
[ASSERT notice warning - ERROR, 3169] |
| 669 |
Server disconnected |
| 670 |
closing session xconnection21 |
| 671 |
switched to session default |
| 672 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 673 |
RUN [stmtadmin kill_client 32] |
| 674 |
|
| 675 |
command ok |
| 676 |
switched to session xconnection22 |
| 677 |
[ASSERT notice warning - ERROR, 3169] |
| 678 |
Server disconnected |
| 679 |
closing session xconnection22 |
| 680 |
switched to session default |
| 681 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 682 |
RUN [stmtadmin kill_client 33] |
| 683 |
|
| 684 |
command ok |
| 685 |
switched to session xconnection23 |
| 686 |
[ASSERT notice warning - ERROR, 3169] |
| 687 |
Server disconnected |
| 688 |
closing session xconnection23 |
| 689 |
switched to session default |
| 690 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 691 |
RUN [stmtadmin kill_client 34] |
| 692 |
|
| 693 |
command ok |
| 694 |
switched to session xconnection24 |
| 695 |
[ASSERT notice warning - ERROR, 3169] |
| 696 |
Server disconnected |
| 697 |
closing session xconnection24 |
| 698 |
switched to session default |
| 699 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 700 |
RUN [stmtadmin kill_client 35] |
| 701 |
|
| 702 |
command ok |
| 703 |
switched to session xconnection25 |
| 704 |
[ASSERT notice warning - ERROR, 3169] |
| 705 |
Server disconnected |
| 706 |
closing session xconnection25 |
| 707 |
switched to session default |
| 708 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 709 |
RUN [stmtadmin kill_client 36] |
| 710 |
|
| 711 |
command ok |
| 712 |
switched to session xconnection26 |
| 713 |
[ASSERT notice warning - ERROR, 3169] |
| 714 |
Server disconnected |
| 715 |
closing session xconnection26 |
| 716 |
switched to session default |
| 717 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 718 |
RUN [stmtadmin kill_client 37] |
| 719 |
|
| 720 |
command ok |
| 721 |
switched to session xconnection27 |
| 722 |
[ASSERT notice warning - ERROR, 3169] |
| 723 |
Server disconnected |
| 724 |
closing session xconnection27 |
| 725 |
switched to session default |
| 726 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 727 |
RUN [stmtadmin kill_client 38] |
| 728 |
|
| 729 |
command ok |
| 730 |
switched to session xconnection28 |
| 731 |
[ASSERT notice warning - ERROR, 3169] |
| 732 |
Server disconnected |
| 733 |
closing session xconnection28 |
| 734 |
switched to session default |
| 735 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 736 |
RUN [stmtadmin kill_client 39] |
| 737 |
|
| 738 |
command ok |
| 739 |
switched to session xconnection29 |
| 740 |
[ASSERT notice warning - ERROR, 3169] |
| 741 |
Server disconnected |
| 742 |
closing session xconnection29 |
| 743 |
switched to session default |
| 744 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 745 |
RUN [stmtadmin kill_client 40] |
| 746 |
|
| 747 |
command ok |
| 748 |
switched to session xconnection30 |
| 749 |
[ASSERT notice warning - ERROR, 3169] |
| 750 |
Server disconnected |
| 751 |
closing session xconnection30 |
| 752 |
switched to session default |
| 753 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 754 |
RUN [stmtadmin kill_client 41] |
| 755 |
|
| 756 |
command ok |
| 757 |
switched to session xconnection31 |
| 758 |
[ASSERT notice warning - ERROR, 3169] |
| 759 |
Server disconnected |
| 760 |
closing session xconnection31 |
| 761 |
switched to session default |
| 762 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 763 |
RUN [stmtadmin kill_client 42] |
| 764 |
|
| 765 |
command ok |
| 766 |
switched to session xconnection32 |
| 767 |
[ASSERT notice warning - ERROR, 3169] |
| 768 |
Server disconnected |
| 769 |
closing session xconnection32 |
| 770 |
switched to session default |
| 771 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 772 |
RUN [stmtadmin kill_client 43] |
| 773 |
|
| 774 |
command ok |
| 775 |
switched to session xconnection33 |
| 776 |
[ASSERT notice warning - ERROR, 3169] |
| 777 |
Server disconnected |
| 778 |
closing session xconnection33 |
| 779 |
switched to session default |
| 780 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 781 |
RUN [stmtadmin kill_client 44] |
| 782 |
|
| 783 |
command ok |
| 784 |
switched to session xconnection34 |
| 785 |
[ASSERT notice warning - ERROR, 3169] |
| 786 |
Server disconnected |
| 787 |
closing session xconnection34 |
| 788 |
switched to session default |
| 789 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 790 |
RUN [stmtadmin kill_client 45] |
| 791 |
|
| 792 |
command ok |
| 793 |
switched to session xconnection35 |
| 794 |
[ASSERT notice warning - ERROR, 3169] |
| 795 |
Server disconnected |
| 796 |
closing session xconnection35 |
| 797 |
switched to session default |
| 798 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 799 |
RUN [stmtadmin kill_client 46] |
| 800 |
|
| 801 |
command ok |
| 802 |
switched to session xconnection36 |
| 803 |
[ASSERT notice warning - ERROR, 3169] |
| 804 |
Server disconnected |
| 805 |
closing session xconnection36 |
| 806 |
switched to session default |
| 807 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 808 |
RUN [stmtadmin kill_client 47] |
| 809 |
|
| 810 |
command ok |
| 811 |
switched to session xconnection37 |
| 812 |
[ASSERT notice warning - ERROR, 3169] |
| 813 |
Server disconnected |
| 814 |
closing session xconnection37 |
| 815 |
switched to session default |
| 816 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 817 |
RUN [stmtadmin kill_client 48] |
| 818 |
|
| 819 |
command ok |
| 820 |
switched to session xconnection38 |
| 821 |
[ASSERT notice warning - ERROR, 3169] |
| 822 |
Server disconnected |
| 823 |
closing session xconnection38 |
| 824 |
switched to session default |
| 825 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 826 |
RUN [stmtadmin kill_client 49] |
| 827 |
|
| 828 |
command ok |
| 829 |
switched to session xconnection39 |
| 830 |
[ASSERT notice warning - ERROR, 3169] |
| 831 |
Server disconnected |
| 832 |
closing session xconnection39 |
| 833 |
switched to session default |
| 834 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 835 |
RUN [stmtadmin kill_client 50] |
| 836 |
|
| 837 |
command ok |
| 838 |
switched to session xconnection40 |
| 839 |
[ASSERT notice warning - ERROR, 3169] |
| 840 |
Server disconnected |
| 841 |
closing session xconnection40 |
| 842 |
switched to session default |
| 843 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 844 |
RUN [stmtadmin kill_client 51] |
| 845 |
|
| 846 |
command ok |
| 847 |
switched to session xconnection41 |
| 848 |
[ASSERT notice warning - ERROR, 3169] |
| 849 |
Server disconnected |
| 850 |
closing session xconnection41 |
| 851 |
switched to session default |
| 852 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 853 |
RUN [stmtadmin kill_client 52] |
| 854 |
|
| 855 |
command ok |
| 856 |
switched to session xconnection42 |
| 857 |
[ASSERT notice warning - ERROR, 3169] |
| 858 |
Server disconnected |
| 859 |
closing session xconnection42 |
| 860 |
switched to session default |
| 861 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 862 |
RUN [stmtadmin kill_client 53] |
| 863 |
|
| 864 |
command ok |
| 865 |
switched to session xconnection43 |
| 866 |
[ASSERT notice warning - ERROR, 3169] |
| 867 |
Server disconnected |
| 868 |
closing session xconnection43 |
| 869 |
switched to session default |
| 870 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 871 |
RUN [stmtadmin kill_client 54] |
| 872 |
|
| 873 |
command ok |
| 874 |
switched to session xconnection44 |
| 875 |
[ASSERT notice warning - ERROR, 3169] |
| 876 |
Server disconnected |
| 877 |
closing session xconnection44 |
| 878 |
switched to session default |
| 879 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 880 |
RUN [stmtadmin kill_client 55] |
| 881 |
|
| 882 |
command ok |
| 883 |
switched to session xconnection45 |
| 884 |
[ASSERT notice warning - ERROR, 3169] |
| 885 |
Server disconnected |
| 886 |
closing session xconnection45 |
| 887 |
switched to session default |
| 888 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 889 |
RUN [stmtadmin kill_client 56] |
| 890 |
|
| 891 |
command ok |
| 892 |
switched to session xconnection46 |
| 893 |
[ASSERT notice warning - ERROR, 3169] |
| 894 |
Server disconnected |
| 895 |
closing session xconnection46 |
| 896 |
switched to session default |
| 897 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 898 |
RUN [stmtadmin kill_client 57] |
| 899 |
|
| 900 |
command ok |
| 901 |
switched to session xconnection47 |
| 902 |
[ASSERT notice warning - ERROR, 3169] |
| 903 |
Server disconnected |
| 904 |
closing session xconnection47 |
| 905 |
switched to session default |
| 906 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 907 |
RUN [stmtadmin kill_client 58] |
| 908 |
|
| 909 |
command ok |
| 910 |
switched to session xconnection48 |
| 911 |
[ASSERT notice warning - ERROR, 3169] |
| 912 |
Server disconnected |
| 913 |
closing session xconnection48 |
| 914 |
switched to session default |
| 915 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 916 |
RUN [stmtadmin kill_client 59] |
| 917 |
|
| 918 |
command ok |
| 919 |
switched to session xconnection49 |
| 920 |
[ASSERT notice warning - ERROR, 3169] |
| 921 |
Server disconnected |
| 922 |
closing session xconnection49 |
| 923 |
switched to session default |
| 924 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 925 |
RUN [stmtadmin kill_client 60] |
| 926 |
|
| 927 |
command ok |
| 928 |
switched to session xconnection50 |
| 929 |
[ASSERT notice warning - ERROR, 3169] |
| 930 |
Server disconnected |
| 931 |
closing session xconnection50 |
| 932 |
switched to session default |
| 933 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 934 |
client_id user host |
| 935 |
10 x_root localhost |
| 936 |
command ok |
| 937 |
expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=50 |
| 938 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 50] |
| 939 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 3] |
| 940 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 941 |
Verify [Status variable "Mysqlx_sessions_accepted" needs to have a value of 60] |
| 942 |
Verify [Status variable "Mysqlx_sessions_closed" needs to have a value of 59] |
| 943 |
Verify [Status variable "Mysqlx_sessions_fatal_error" needs to have a value of 0] |
| 944 |
Verify [Status variable "Mysqlx_sessions_killed" needs to have a value of 54] |
| 945 |
Verify [Status variable "Mysqlx_sessions_rejected" needs to have a value of 0] |
| 946 |
RUN drop user xconnection1@localhost, |
| 947 |
xconnection2@localhost, |
| 948 |
xconnection3@localhost, |
| 949 |
xconnection4@localhost, |
| 950 |
xconnection5@localhost, |
| 951 |
xconnection6@localhost, |
| 952 |
xconnection7@localhost, |
| 953 |
xconnection8@localhost, |
| 954 |
xconnection9@localhost, |
| 955 |
xconnection10@localhost, |
| 956 |
xconnection11@localhost, |
| 957 |
xconnection12@localhost, |
| 958 |
xconnection13@localhost, |
| 959 |
xconnection14@localhost, |
| 960 |
xconnection15@localhost, |
| 961 |
xconnection16@localhost, |
| 962 |
xconnection17@localhost, |
| 963 |
xconnection18@localhost, |
| 964 |
xconnection19@localhost, |
| 965 |
xconnection20@localhost, |
| 966 |
xconnection21@localhost, |
| 967 |
xconnection22@localhost, |
| 968 |
xconnection23@localhost, |
| 969 |
xconnection24@localhost, |
| 970 |
xconnection25@localhost, |
| 971 |
xconnection26@localhost, |
| 972 |
xconnection27@localhost, |
| 973 |
xconnection28@localhost, |
| 974 |
xconnection29@localhost, |
| 975 |
xconnection30@localhost, |
| 976 |
xconnection31@localhost, |
| 977 |
xconnection32@localhost, |
| 978 |
xconnection33@localhost, |
| 979 |
xconnection34@localhost, |
| 980 |
xconnection35@localhost, |
| 981 |
xconnection36@localhost, |
| 982 |
xconnection37@localhost, |
| 983 |
xconnection38@localhost, |
| 984 |
xconnection39@localhost, |
| 985 |
xconnection40@localhost, |
| 986 |
xconnection41@localhost, |
| 987 |
xconnection42@localhost, |
| 988 |
xconnection43@localhost, |
| 989 |
xconnection44@localhost, |
| 990 |
xconnection45@localhost, |
| 991 |
xconnection46@localhost, |
| 992 |
xconnection47@localhost, |
| 993 |
xconnection48@localhost, |
| 994 |
xconnection49@localhost, |
| 995 |
xconnection50@localhost |
| 996 |
|
| 997 |
0 rows affected |
| 998 |
Mysqlx.Ok { |
| 999 |
msg: "bye!" |
| 1000 |
} |
| 1001 |
ok |
| 1002 |
execute list_clients,kill_client with sql namespace,expect error |
| 1003 |
change result file once error messages are fixed |
| 1004 |
send Mysqlx.Sql.StmtExecute { |
| 1005 |
stmt: "list_clients" |
| 1006 |
namespace: "sql" |
| 1007 |
} |
| 1008 |
|
| 1009 |
expect Mysqlx.Sql.StmtExecuteOk |
| 1010 |
Got expected error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'list_clients' at line 1 (code 1064) |
| 1011 |
send Mysqlx.Sql.StmtExecute { |
| 1012 |
stmt: "kill_client" |
| 1013 |
args { |
| 1014 |
type: SCALAR |
| 1015 |
scalar { |
| 1016 |
type: V_UINT |
| 1017 |
v_unsigned_int: 11 |
| 1018 |
} |
| 1019 |
} |
| 1020 |
namespace: "sql" |
| 1021 |
} |
| 1022 |
|
| 1023 |
expect Mysqlx.Sql.StmtExecuteOk |
| 1024 |
Got expected error: Too many arguments (code 5015) |
| 1025 |
send Mysqlx.Sql.StmtExecute { |
| 1026 |
stmt: "kill_client" |
| 1027 |
args { |
| 1028 |
type: SCALAR |
| 1029 |
scalar { |
| 1030 |
type: V_UINT |
| 1031 |
v_unsigned_int: 11 |
| 1032 |
} |
| 1033 |
} |
| 1034 |
namespace: "" |
| 1035 |
} |
| 1036 |
|
| 1037 |
expect Mysqlx.Sql.StmtExecuteOk |
| 1038 |
Got expected error: Unknown namespace (code 5162) |
| 1039 |
send Mysqlx.Sql.StmtExecute { |
| 1040 |
stmt: "kill_client" |
| 1041 |
args { |
| 1042 |
type: SCALAR |
| 1043 |
scalar { |
| 1044 |
type: V_UINT |
| 1045 |
v_unsigned_int: 11 |
| 1046 |
} |
| 1047 |
} |
| 1048 |
namespace: "invalid" |
| 1049 |
} |
| 1050 |
|
| 1051 |
expect Mysqlx.Sql.StmtExecuteOk |
| 1052 |
Got expected error: Unknown namespace invalid (code 5162) |
| 1053 |
expect Mysqlx_stmt_list_clients=0 and Mysqlx_stmt_kill_client=0 as these are not executed on right namespace |
| 1054 |
in main, line 62:ERROR: Undefined macro Assert_status_variable |
| 1055 |
in main, line 63:ERROR: Undefined macro Assert_status_variable |
| 1056 |
in main, line 64:ERROR: Undefined macro Assert_status_variable |
| 1057 |
Mysqlx.Ok { |
| 1058 |
msg: "bye!" |
| 1059 |
} |
| 1060 |
ok |
| 1061 |
open xconnection with ssl and kill,expect success |
| 1062 |
RUN create user con1@localhost identified by 'con1', |
| 1063 |
con2@localhost identified by 'con2' |
| 1064 |
|
| 1065 |
0 rows affected |
| 1066 |
RUN set @@global.mysqlx_max_connections=3 |
| 1067 |
|
| 1068 |
0 rows affected |
| 1069 |
Test data |
| 1070 |
client_id user host |
| 1071 |
62 sslcon localhost |
| 1072 |
command ok |
| 1073 |
expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0 |
| 1074 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0] |
| 1075 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1] |
| 1076 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 1077 |
create and activate new session con1 |
| 1078 |
connecting... |
| 1079 |
active session is now 'con1' |
| 1080 |
client_id user host |
| 1081 |
63 con1 localhost |
| 1082 |
command ok |
| 1083 |
expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0 |
| 1084 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0] |
| 1085 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1] |
| 1086 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 1087 |
open 3rd xprotocol connection where 2 sessions already opened |
| 1088 |
connecting... |
| 1089 |
active session is now 'con2' |
| 1090 |
expect Mysqlx_stmt_list_clients=0 and Mysqlx_stmt_kill_client=0 |
| 1091 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0] |
| 1092 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 0] |
| 1093 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 3] |
| 1094 |
switched to session default |
| 1095 |
client_id user host |
| 1096 |
62 sslcon localhost |
| 1097 |
63 con1 localhost |
| 1098 |
64 con2 localhost |
| 1099 |
command ok |
| 1100 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 1101 |
RUN [stmtadmin kill_client 63] |
| 1102 |
|
| 1103 |
command ok |
| 1104 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 1105 |
RUN [stmtadmin kill_client 64] |
| 1106 |
|
| 1107 |
command ok |
| 1108 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 1109 |
client_id user host |
| 1110 |
62 sslcon localhost |
| 1111 |
command ok |
| 1112 |
expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=2 |
| 1113 |
RUN drop user con1@localhost, |
| 1114 |
con2@localhost |
| 1115 |
|
| 1116 |
0 rows affected |
| 1117 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 2] |
| 1118 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 3] |
| 1119 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 1120 |
Mysqlx.Ok { |
| 1121 |
msg: "bye!" |
| 1122 |
} |
| 1123 |
ok |
| 1124 |
open xconnection with ssl x_root user kill,expect success |
| 1125 |
RUN create user con1@localhost identified by 'con1', |
| 1126 |
con2@localhost identified by 'con2' |
| 1127 |
|
| 1128 |
0 rows affected |
| 1129 |
RUN set @@global.mysqlx_max_connections=3 |
| 1130 |
|
| 1131 |
0 rows affected |
| 1132 |
Test data |
| 1133 |
client_id user host |
| 1134 |
65 x_root localhost |
| 1135 |
command ok |
| 1136 |
create and activate new session con1 |
| 1137 |
connecting... |
| 1138 |
active session is now 'con1 con1 con1' |
| 1139 |
client_id user host |
| 1140 |
65 x_root localhost |
| 1141 |
66 x_root localhost |
| 1142 |
command ok |
| 1143 |
open 3rd xprotocol connection where 2 sessions already opened |
| 1144 |
connecting... |
| 1145 |
active session is now 'con2 con2 con2' |
| 1146 |
switched to session default |
| 1147 |
client_id user host |
| 1148 |
65 x_root localhost |
| 1149 |
66 x_root localhost |
| 1150 |
67 x_root localhost |
| 1151 |
command ok |
| 1152 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 1153 |
RUN [stmtadmin kill_client 66] |
| 1154 |
|
| 1155 |
command ok |
| 1156 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 1157 |
RUN [stmtadmin kill_client 67] |
| 1158 |
|
| 1159 |
command ok |
| 1160 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 1161 |
client_id user host |
| 1162 |
65 x_root localhost |
| 1163 |
command ok |
| 1164 |
RUN drop user con1@localhost, |
| 1165 |
con2@localhost |
| 1166 |
|
| 1167 |
0 rows affected |
| 1168 |
Mysqlx.Ok { |
| 1169 |
msg: "bye!" |
| 1170 |
} |
| 1171 |
ok |
| 1172 |
show status like 'Mysqlx_stmt%client%'; |
| 1173 |
Variable_name Value |
| 1174 |
Mysqlx_stmt_kill_client 68 |
| 1175 |
Mysqlx_stmt_list_clients 26 |
| 1176 |
# restart: |
| 1177 |
drop user abc@localhost, |
| 1178 |
xplugin@localhost, |
| 1179 |
process@localhost, |
| 1180 |
expire@localhost; |
| 1181 |
set @@global.mysqlx_max_connections=100; |
| 1182 |
show status like 'Mysqlx_stmt%client%'; |
| 1183 |
Variable_name Value |
| 1184 |
Mysqlx_stmt_kill_client 0 |
| 1185 |
Mysqlx_stmt_list_clients 0 |
| 1186 |
select sleep(0.5); |
| 1187 |
sleep(0.5) |
| 1188 |
0 |
| 1189 |
RUN create user abc@localhost identified by 'abc', |
| 1190 |
xplugin@localhost identified by 'xplugin', |
| 1191 |
process@localhost identified by 'process', |
| 1192 |
expire@localhost identified by 'expire' |
| 1193 |
|
| 1194 |
0 rows affected |
| 1195 |
RUN grant all on *.* to xplugin@localhost, |
| 1196 |
expire@localhost |
| 1197 |
|
| 1198 |
0 rows affected |
| 1199 |
RUN grant process on *.* to process@localhost |
| 1200 |
|
| 1201 |
0 rows affected |
| 1202 |
RUN alter user expire@localhost password expire |
| 1203 |
|
| 1204 |
0 rows affected |
| 1205 |
Test data |
| 1206 |
client_id user host |
| 1207 |
1 x_root localhost |
| 1208 |
command ok |
| 1209 |
expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0 |
| 1210 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0] |
| 1211 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1] |
| 1212 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 1213 |
create and activate new session |
| 1214 |
connecting... |
| 1215 |
active session is now 'aux' |
| 1216 |
client_id user host |
| 1217 |
1 x_root localhost |
| 1218 |
2 x_root localhost |
| 1219 |
command ok |
| 1220 |
expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0 even with another new x_root session |
| 1221 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0] |
| 1222 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1] |
| 1223 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 1224 |
switch back to default session |
| 1225 |
switched to session default |
| 1226 |
client_id user host |
| 1227 |
1 x_root localhost |
| 1228 |
2 x_root localhost |
| 1229 |
command ok |
| 1230 |
expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=0 with default x_root session where list_clients already executed |
| 1231 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0] |
| 1232 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2] |
| 1233 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 1234 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 1235 |
RUN [stmtadmin kill_client 2] |
| 1236 |
|
| 1237 |
command ok |
| 1238 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 1239 |
client_id user host |
| 1240 |
1 x_root localhost |
| 1241 |
command ok |
| 1242 |
expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 3 times and kill_client once |
| 1243 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1] |
| 1244 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 3] |
| 1245 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 1246 |
create and activate new session abc |
| 1247 |
expect only abc user session id |
| 1248 |
connecting... |
| 1249 |
active session is now 'abc' |
| 1250 |
client_id user host |
| 1251 |
3 abc localhost |
| 1252 |
command ok |
| 1253 |
killing x_root user session with unprivileged user 'abc' which should be unsuccessful |
| 1254 |
RUN [stmtadmin kill_client 1] |
| 1255 |
Got expected error: You are not owner of thread (code 1095) |
| 1256 |
expect ERROR: SELECT command denied to user 'abc'@'localhost' for table 'session_status' (code 1142) for show status command |
| 1257 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1] |
| 1258 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1] |
| 1259 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 1260 |
open another session of abc user and kill first session of abc user,which should be successful |
| 1261 |
connecting... |
| 1262 |
active session is now 'abc1' |
| 1263 |
client_id user host |
| 1264 |
3 abc localhost |
| 1265 |
4 abc localhost |
| 1266 |
command ok |
| 1267 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 1268 |
RUN [stmtadmin kill_client 3] |
| 1269 |
|
| 1270 |
command ok |
| 1271 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 1272 |
client_id user host |
| 1273 |
4 abc localhost |
| 1274 |
command ok |
| 1275 |
expect ERROR: SELECT command denied to user 'abc'@'localhost' for table 'session_status' (code 1142) for show status command |
| 1276 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1] |
| 1277 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2] |
| 1278 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 1279 |
killing abc user session with its own session 'abc' which should be successful |
| 1280 |
expect right error instead of End of File |
| 1281 |
switch back to default session |
| 1282 |
Server disconnected |
| 1283 |
closing session abc1 |
| 1284 |
switched to session default |
| 1285 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 1286 |
client_id user host |
| 1287 |
1 x_root localhost |
| 1288 |
command ok |
| 1289 |
expect Mysqlx_stmt_list_clients=4 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 4 times and kill_client once |
| 1290 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1] |
| 1291 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 4] |
| 1292 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 1] |
| 1293 |
open process only privileged user seession and kill x_root user session,expect error "You are not owner of thread" |
| 1294 |
connecting... |
| 1295 |
active session is now 'process' |
| 1296 |
client_id user host |
| 1297 |
5 process localhost |
| 1298 |
command ok |
| 1299 |
RUN [stmtadmin kill_client 1] |
| 1300 |
Got expected error: You are not owner of thread (code 1095) |
| 1301 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 1302 |
checking list of clients after x_root user session killed by xplugin user |
| 1303 |
client_id user host |
| 1304 |
5 process localhost |
| 1305 |
command ok |
| 1306 |
expect ERROR: SELECT command denied to user 'process'@'localhost' for table 'session_status' (code 1142) for show command |
| 1307 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1] |
| 1308 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2] |
| 1309 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 1310 |
open privileged user seession and kill x_root user session,expect success |
| 1311 |
connecting... |
| 1312 |
active session is now 'xplugin' |
| 1313 |
client_id user host |
| 1314 |
1 x_root localhost |
| 1315 |
5 process localhost |
| 1316 |
6 xplugin localhost |
| 1317 |
command ok |
| 1318 |
WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active] |
| 1319 |
RUN [stmtadmin kill_client 1] |
| 1320 |
|
| 1321 |
command ok |
| 1322 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 1323 |
checking list of clients after x_root user session killed by xplugin user |
| 1324 |
client_id user host |
| 1325 |
5 process localhost |
| 1326 |
6 xplugin localhost |
| 1327 |
command ok |
| 1328 |
expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with xplugin user where list_clients executed 2 times and kill_client once |
| 1329 |
Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1] |
| 1330 |
Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2] |
| 1331 |
Verify [Status variable "Mysqlx_sessions" needs to have a value of 2] |
| 1332 |
Cleanup |
| 1333 |
RUN drop schema if exists xtest |
| 1334 |
|
| 1335 |
0 rows affected |
| 1336 |
closing session xplugin |
| 1337 |
Mysqlx.Ok { |
| 1338 |
msg: "bye!" |
| 1339 |
} |
| 1340 |
ok |
| 1341 |
show status like 'Mysqlx_stmt%client%'; |
| 1342 |
Variable_name Value |
| 1343 |
Mysqlx_stmt_kill_client 6 |
| 1344 |
Mysqlx_stmt_list_clients 12 |
| 1345 |
drop user abc@localhost, |
| 1346 |
xplugin@localhost, |
| 1347 |
process@localhost, |
| 1348 |
expire@localhost, |
| 1349 |
sslcon@localhost; |