summaryrefslogtreecommitdiff
path: root/mysql-test/main/shutdown.test
blob: 13b7ac3f67227ae4ff34b9bf0ad2ecea33eaa039 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
--source include/not_embedded.inc

--disable_service_connection
#
# SHUTDOWN statement
#
create user user1@localhost;

connect (c1,localhost,user1,,);

--error ER_SPECIFIC_ACCESS_DENIED_ERROR
shutdown;

connection default;
disconnect c1;
--connect (c1,localhost,root,,)

create procedure try_shutdown() shutdown;
drop procedure try_shutdown;

--let $_server_id= `SELECT @@server_id`
--let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/mysqld.$_server_id.expect
--exec echo "wait" > $_expect_file_name

--send shutdown
--connection default
--source include/wait_until_disconnected.inc

--exec echo "restart" > $_expect_file_name
--enable_reconnect
--source include/wait_until_connected_again.inc

drop user user1@localhost;

--echo #
--echo # MDEV-8491 - On shutdown, report the user and the host executed that.
--echo #
--let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err
--let SEARCH_PATTERN=(mysqld|mariadbd)(\.exe)? \(initiated by: root\[root\] @ localhost \[(::1)?\]\): Normal shutdown
--source include/search_pattern_in_file.inc
--enable_service_connection