Debian Codegraph @

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

raw
1 # restart
2 call mtr.add_suppression('Message of size 4294967040 received, exceeding the limit of 1048576');
3 select sleep(1);
4 sleep(1)
5 0
6 SELECT `user`,`host`,`db`,`command`,`state`,`info` FROM INFORMATION_SCHEMA.PROCESSLIST WHERE `state` != 'cleaning up' ORDER BY `user`;
7 user host db command state info
8 event_scheduler localhost NULL Daemon Waiting on empty queue NULL
9 root localhost test Query executing SELECT `user`,`host`,`db`,`command`,`state`,`info` FROM INFORMATION_SCHEMA.PROCESSLIST WHERE `state` != 'cleaning up' ORDER BY `user`
10 Warnings:
11 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
12
13 Close in a pipeline and try to do something after close
14 -------------------------------------------------------
15 connecting...
16 active session is now 'sess'
17 send Mysqlx.Sql.StmtExecute {
18 stmt: "select 4.1"
19 }
20
21 send Mysqlx.Sql.StmtExecute {
22 stmt: "select 4.2"
23 }
24
25 send Mysqlx.Session.Close {
26 }
27
28 send Mysqlx.Sql.StmtExecute {
29 stmt: "select \'fail\'"
30 }
31
32 4.1
33 4.1
34 0 rows affected
35 4.2
36 4.2
37 0 rows affected
38 RUN recvok
39 Got expected error:
40 Mysqlx.Error {
41 severity: FATAL
42 code: 5000
43 msg: "Invalid message"
44 sql_state: "HY000"
45 }
46
47 aborting session sess
48 switched to session default
49 Mysqlx.Ok {
50 msg: "bye!"
51 }
52 ok
53 select sleep(1);
54 sleep(1)
55 0
56 show global status like 'mysqlx_sessions';
57 Variable_name Value
58 Mysqlx_sessions 0
59 show global status like 'mysqlx_connections_%';
60 Variable_name Value
61 Mysqlx_connections_accepted 2
62 Mysqlx_connections_closed 2
63 Mysqlx_connections_rejected 0
64 SELECT `user`,`host`,`db`,`command`,`state`,`info` FROM INFORMATION_SCHEMA.PROCESSLIST WHERE `state` != 'cleaning up' ORDER BY `user`;
65 user host db command state info
66 event_scheduler localhost NULL Daemon Waiting on empty queue NULL
67 root localhost test Query executing SELECT `user`,`host`,`db`,`command`,`state`,`info` FROM INFORMATION_SCHEMA.PROCESSLIST WHERE `state` != 'cleaning up' ORDER BY `user`
68 Warnings:
69 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead