Debian Codegraph @

mysql-test/suite/test_service_sql_api/r/test_sql_shutdown.result

raw
1 ##########################################
2 # Run plugin
3 ##########################################
4 INSTALL PLUGIN test_sql_shutdown SONAME 'TEST_SQL_SHUTDOWN';
5 SELECT count(*) FROM information_schema.processlist WHERE info LIKE 'PLUGIN%';
6 count(*)
7 1
8 Warnings:
9 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
10 ##########################################
11 # Shutdown
12 ##########################################
13 ======================================================
14 Opening a Session
15 ======================================================
16 Apparently the server is shutting down
17 SELECT 1, 2, 3 FROM DUAL
18 ERROR 3169 : Session was killed
19
20 Closing Session. Plugin init cycle = 1
21
22 SERVER SHUTDOWN
23 ##########################################
24 # Restart
25 ##########################################
26 ======================================================
27 Opening a Session
28 ERROR 3168 : Server isn't available
29 ======================================================
30 SELECT 1, 2, 3 FROM DUAL
31
32 Closing Session. Plugin init cycle = 2
33
34 SELECT plugin_name, plugin_status, plugin_type,
35 plugin_description, load_option
36 FROM information_schema.plugins
37 WHERE plugin_name LIKE "test_sql_shutdown";
38 plugin_name plugin_status plugin_type plugin_description load_option
39 test_sql_shutdown ACTIVE DAEMON Test SQL shutdown ON
40 ##########################################
41 # Stop plugin
42 ##########################################
43 UNINSTALL PLUGIN test_sql_shutdown;