Debian Codegraph @

mysql-test/suite/x/t/connection_timeout_local.test

raw
1 --echo Preamble
2 --source include/xplugin_preamble.inc
3 --source include/xplugin_create_user.inc
4 --source include/restart_mysqld.inc
5
6
7 ## Show that Mysqlx_connection_timeout works
8 #
9 # 1. Wait until user is disconnected
10 --write_file $MYSQL_TMP_DIR/mysqlx-idle-disconnect.xpl
11 -->import wait_until_disconnect.macro
12 -->import connection.macro
13 -->callmacro Verify_its_xprotocol_connection
14
15 echo # 1. Wait until user is disconnected;
16 -->callmacro Wait_until_disconnect
17
18 EOF
19
20
21 ## Constant message exchange doesn't prolong mysqlx_connection_timeout
22 #
23 # 1. Connect to X Plugin (without authentication)
24 # 2. Show that user is in prepareation state (CapSet works)
25 # 3. Make message exchange and ignore all connection error
26 # 4. Show that after the exchange user was in middle of it disconnected
27 #
28 --write_file $MYSQL_TMP_DIR/mysqlx-idle-disconnect-no-prolong.xpl
29 -->import wait_until_disconnect.macro
30 -->import connection.macro
31
32 echo # 1. Connect to X Plugin;
33 -->newsession idle_session -
34 -->callmacro Verify_its_xprotocol_connection
35
36 -->noquery_result
37 echo # 2. Show that its valid X Protocol connection;
38 Mysqlx.Connection.CapabilitiesGet {
39 }
40 -->recvtype Mysqlx.Connection.Capabilities
41
42 echo # 3. Generate long message flow, ignore all disconnect errors;
43 echo #;
44 echo # lets wait 30 seconds, for the disconnection;
45 -->quiet
46 -->repeat 30
47 echo send/receive;
48 expecterror 0, CR_SERVER_GONE_ERROR;
49 Mysqlx.Connection.CapabilitiesGet {
50 }
51 expecterror 0, CR_SERVER_GONE_ERROR;
52 -->recv
53 -->sleep 1
54 -->endrepeat
55 -->noquiet
56 -->query_result
57
58 expecterror CR_SERVER_GONE_ERROR;
59 Mysqlx.Connection.CapabilitiesGet {
60 }
61
62 echo # 4. Show that user is/was disconnected;
63 expecterror CR_SERVER_GONE_ERROR;
64 -->recv
65 -->closesession abort
66
67 EOF
68
69
70 ## Show that Mysqlx_connection_timeout is deactivate after auth
71 #
72 # 1. Connect to X Plugin and show that its valid connection
73 # 2. Wait longer than Mysqlx_connection_timeout
74 # 3. Show that connection is still valid
75
76 --write_file $MYSQL_TMP_DIR/mysqlx-idle-no-disconnect-after-auth.xpl
77 echo # 1. Show that new connection is valid
78 -->stmtadmin ping
79 -->recvresult
80
81 echo # 2. sleep 12 which is much longer than mysqlx_connection_timeout
82 -->sleep 12
83 echo # 3. Show that connection is still there, mysqlx_connection_timeout was deactivated
84 -->stmtadmin ping
85 -->recvresult
86
87 EOF
88
89 ## Show that after specific kind of "reset" connection is not considered for mysqlx-connection-timeout
90 #
91 # 1. Connect to X Plugin and show that its a valid connection
92 # 2. Trigger reset
93 # 3. Wait longer than Mysqlx_connection_timeout
94 # 4. Show that connection was not released, by authenticated and executing query
95 --write_file $MYSQL_TMP_DIR/mysqlx-reset-session-after-auth.xpl
96 -->import mysqlx_session.macro
97
98 echo # 1. Connect to X Plugin and show that its a valid connection;
99 -->echo Afert the %SESSION_CLOSE_SCENARIO% connection isn't considered a target for release
100 -->stmtadmin ping
101 -->recvresult
102
103 echo # 2. Trigger reset;
104 -->callmacro %SESSION_CLOSE_SCENARIO%
105 -->recvok
106
107 echo # 3. Wait longer than Mysqlx_connection_timeout;
108 -->sleep 6
109
110 echo # 4. Show that connection was not released, by authenticated and executing query;
111 -->login x_root
112 -->stmtadmin ping
113 -->recvresult
114 EOF
115
116
117 --let $assert_status_name= Mysqlx_connection_accept_errors
118 --let $assert_status_value= 0
119 --source include/assert_status.inc
120 --let $assert_status_name= Mysqlx_connection_errors
121 --let $assert_status_value= 0
122 --source include/assert_status.inc
123 --let $assert_status_name= Mysqlx_connections_accepted
124 --let $assert_status_value= 0
125 --source include/assert_status.inc
126 --let $assert_status_name= Mysqlx_connections_closed
127 --let $assert_status_value= 0
128 --source include/assert_status.inc
129 --let $assert_status_name= Mysqlx_connections_rejected
130 --let $assert_status_value= 0
131 --source include/assert_status.inc
132
133 SET GLOBAL mysqlx_connect_timeout = 4;
134
135 --let $assert_variable_name= mysqlx_connect_timeout
136 --let $assert_variable_value= 4
137 --source include/assert_variable.inc
138
139 --echo
140 --echo ## Disconnect user on idle connection after timeout
141 --echo #
142 exec $MYSQLXTEST
143 -u x_root --password='' -h127.0.0.1 --no-auth
144 --file=$MYSQL_TMP_DIR/mysqlx-idle-disconnect.xpl 2>&1;
145
146 --echo
147 --echo ## Disconnect user without session after timeout
148 --echo #
149 exec $MYSQLXTEST
150 -u x_root --password='' -h127.0.0.1
151 --file=$MYSQL_TMP_DIR/mysqlx-idle-disconnect-no-prolong.xpl 2>&1;
152
153 --echo
154 --echo ## Inactivity timer disabled after session setup (commands executed after 1s should be processed)
155 --echo #
156 exec $MYSQLXTEST
157 -u x_root --password='' -h127.0.0.1
158 --file=$MYSQL_TMP_DIR/mysqlx-idle-no-disconnect-after-auth.xpl 2>&1;
159
160
161 --let $assert_status_name= Mysqlx_connection_accept_errors
162 --let $assert_status_value= 0
163 --source include/assert_status.inc
164 --let $assert_status_name= Mysqlx_connection_errors
165 --let $assert_status_value= 2
166 --source include/assert_status.inc
167 --let $assert_status_name= Mysqlx_connections_accepted
168 --let $assert_status_value= 4
169 --source include/assert_status.inc
170 --let $assert_status_name= Mysqlx_connections_closed
171 --let $assert_status_value= 4
172 --source include/assert_status.inc
173 --let $assert_status_name= Mysqlx_connections_rejected
174 --let $assert_status_value= 0
175 --source include/assert_status.inc
176
177 SET GLOBAL mysqlx_connect_timeout = 2;
178
179 --let $assert_variable_name= mysqlx_connect_timeout
180 --let $assert_variable_value= 2
181 --source include/assert_variable.inc
182
183
184 --echo
185 --echo ## Disconnect user on idle connection after new timeout
186 --echo #
187 exec $MYSQLXTEST
188 -u x_root --password='' -h127.0.0.1 --no-auth
189 --file=$MYSQL_TMP_DIR/mysqlx-idle-disconnect.xpl 2>&1;
190
191 SET GLOBAL mysqlx_connect_timeout = 4;
192 --let $assert_variable_name= mysqlx_connect_timeout
193 --let $assert_variable_value= 4
194 --source include/assert_variable.inc
195
196 --echo
197 --echo ## Inactivity timer restarted with Session.Reset message
198 --echo #
199 exec $MYSQLXTEST
200 -u x_root --password='' -h127.0.0.1
201 -v%SESSION_CLOSE_SCENARIO%=Session_reset
202 --file=$MYSQL_TMP_DIR/mysqlx-reset-session-after-auth.xpl 2>&1;
203
204 --let $assert_status_name= Mysqlx_connection_accept_errors
205 --let $assert_status_value= 0
206 --source include/assert_status.inc
207 --let $assert_status_name= Mysqlx_connection_errors
208 --let $assert_status_value= 3
209 --source include/assert_status.inc
210 --let $assert_status_name= Mysqlx_connections_accepted
211 --let $assert_status_value= 6
212 --source include/assert_status.inc
213 --let $assert_status_name= Mysqlx_connections_closed
214 --let $assert_status_value= 6
215 --source include/assert_status.inc
216 --let $assert_status_name= Mysqlx_connections_rejected
217 --let $assert_status_value= 0
218 --source include/assert_status.inc
219
220
221 ## Cleanup
222 SET GLOBAL mysqlx_connect_timeout = DEFAULT;
223 --source ../include/xplugin_cleanup.inc