Debian Codegraph @

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

raw
1 Preamble
2 # restart
3 include/assert.inc [Mysqlx_connection_accept_errors should be 0]
4 include/assert.inc [Mysqlx_connection_errors should be 0]
5 include/assert.inc [Mysqlx_connections_accepted should be 0]
6 include/assert.inc [Mysqlx_connections_closed should be 0]
7 include/assert.inc [Mysqlx_connections_rejected should be 0]
8 SET GLOBAL mysqlx_connect_timeout = 4;
9 include/assert.inc [ should be 4]
10
11 ## Disconnect user on idle connection after timeout
12 #
13 # 1. Wait until user is disconnected
14 ok
15
16 ## Disconnect user without session after timeout
17 #
18 # 1. Connect to X Plugin
19 connecting...
20 active session is now 'idle_session'
21 # 2. Show that its valid X Protocol connection
22 send Mysqlx.Connection.CapabilitiesGet {
23 }
24
25 # 3. Generate long message flow, ignore all disconnect errors
26 #
27 # lets wait 30 seconds, for the disconnection
28 send/receive
29 Got expected error (one of: 0 2006 )
30 Got expected error (one of: 0 2006 )
31 send/receive
32 Got expected error (one of: 0 2006 )
33 Got expected error (one of: 0 2006 )
34 send/receive
35 Got expected error (one of: 0 2006 )
36 Got expected error (one of: 0 2006 )
37 send/receive
38 Got expected error (one of: 0 2006 )
39 Got expected error (one of: 0 2006 )
40 send/receive
41 Got expected error (one of: 0 2006 )
42 Got expected error (one of: 0 2006 )
43 send/receive
44 Got expected error (one of: 0 2006 )
45 Got expected error (one of: 0 2006 )
46 send/receive
47 Got expected error (one of: 0 2006 )
48 Got expected error (one of: 0 2006 )
49 send/receive
50 Got expected error (one of: 0 2006 )
51 Got expected error (one of: 0 2006 )
52 send/receive
53 Got expected error (one of: 0 2006 )
54 Got expected error (one of: 0 2006 )
55 send/receive
56 Got expected error (one of: 0 2006 )
57 Got expected error (one of: 0 2006 )
58 send/receive
59 Got expected error (one of: 0 2006 )
60 Got expected error (one of: 0 2006 )
61 send/receive
62 Got expected error (one of: 0 2006 )
63 Got expected error (one of: 0 2006 )
64 send/receive
65 Got expected error (one of: 0 2006 )
66 Got expected error (one of: 0 2006 )
67 send/receive
68 Got expected error (one of: 0 2006 )
69 Got expected error (one of: 0 2006 )
70 send/receive
71 Got expected error (one of: 0 2006 )
72 Got expected error (one of: 0 2006 )
73 send/receive
74 Got expected error (one of: 0 2006 )
75 Got expected error (one of: 0 2006 )
76 send/receive
77 Got expected error (one of: 0 2006 )
78 Got expected error (one of: 0 2006 )
79 send/receive
80 Got expected error (one of: 0 2006 )
81 Got expected error (one of: 0 2006 )
82 send/receive
83 Got expected error (one of: 0 2006 )
84 Got expected error (one of: 0 2006 )
85 send/receive
86 Got expected error (one of: 0 2006 )
87 Got expected error (one of: 0 2006 )
88 send/receive
89 Got expected error (one of: 0 2006 )
90 Got expected error (one of: 0 2006 )
91 send/receive
92 Got expected error (one of: 0 2006 )
93 Got expected error (one of: 0 2006 )
94 send/receive
95 Got expected error (one of: 0 2006 )
96 Got expected error (one of: 0 2006 )
97 send/receive
98 Got expected error (one of: 0 2006 )
99 Got expected error (one of: 0 2006 )
100 send/receive
101 Got expected error (one of: 0 2006 )
102 Got expected error (one of: 0 2006 )
103 send/receive
104 Got expected error (one of: 0 2006 )
105 Got expected error (one of: 0 2006 )
106 send/receive
107 Got expected error (one of: 0 2006 )
108 Got expected error (one of: 0 2006 )
109 send/receive
110 Got expected error (one of: 0 2006 )
111 Got expected error (one of: 0 2006 )
112 send/receive
113 Got expected error (one of: 0 2006 )
114 Got expected error (one of: 0 2006 )
115 send/receive
116 Got expected error (one of: 0 2006 )
117 Got expected error (one of: 0 2006 )
118 send Mysqlx.Connection.CapabilitiesGet {
119 }
120
121 Got expected error: MySQL server has gone away (code 2006)
122 # 4. Show that user is/was disconnected
123 Got expected error: MySQL server has gone away (code 2006)
124 aborting session idle_session
125 switched to session default
126 Mysqlx.Ok {
127 msg: "bye!"
128 }
129 ok
130
131 ## Inactivity timer disabled after session setup (commands executed after 1s should be processed)
132 #
133 Mysqlx.Ok {
134 msg: "bye!"
135 }
136 ok
137 include/assert.inc [Mysqlx_connection_accept_errors should be 0]
138 include/assert.inc [Mysqlx_connection_errors should be 2]
139 include/assert.inc [Mysqlx_connections_accepted should be 4]
140 include/assert.inc [Mysqlx_connections_closed should be 4]
141 include/assert.inc [Mysqlx_connections_rejected should be 0]
142 SET GLOBAL mysqlx_connect_timeout = 2;
143 include/assert.inc [ should be 2]
144
145 ## Disconnect user on idle connection after new timeout
146 #
147 # 1. Wait until user is disconnected
148 ok
149 SET GLOBAL mysqlx_connect_timeout = 4;
150 include/assert.inc [ should be 4]
151
152 ## Inactivity timer restarted with Session.Reset message
153 #
154 # 1. Connect to X Plugin and show that its a valid connection
155 Afert the Session_reset connection isn't considered a target for release
156
157 command ok
158 # 2. Trigger reset
159 send Mysqlx.Session.Reset {
160 keep_open: false
161 }
162
163 RUN recvok
164 # 3. Wait longer than Mysqlx_connection_timeout
165 # 4. Show that connection was not released, by authenticated and executing query
166 Login OK
167
168 command ok
169 Mysqlx.Ok {
170 msg: "bye!"
171 }
172 ok
173 include/assert.inc [Mysqlx_connection_accept_errors should be 0]
174 include/assert.inc [Mysqlx_connection_errors should be 3]
175 include/assert.inc [Mysqlx_connections_accepted should be 6]
176 include/assert.inc [Mysqlx_connections_closed should be 6]
177 include/assert.inc [Mysqlx_connections_rejected should be 0]
178 SET GLOBAL mysqlx_connect_timeout = DEFAULT;