Debian Codegraph @

mysql-test/suite/sys_vars/t/admin_port_basic.test

raw
1 --disable_query_log
2 CALL mtr.add_suppression("Failed to initialize TLS for channel: mysql_admin");
3 CALL mtr.add_suppression("Failed to set up SSL because of the following SSL library error");
4 --enable_query_log
5
6 #
7 # only global
8 #
9 --replace_result $MASTER_ADMINPORT ADMIN_PORT
10 select @@global.admin_port;
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 select @@session.admin_port;
13 --replace_result $MASTER_ADMINPORT ADMIN_PORT
14 show global variables like 'admin_port';
15 --replace_result $MASTER_ADMINPORT ADMIN_PORT
16 show session variables like 'admin_port';
17 --disable_warnings
18 --replace_result $MASTER_ADMINPORT ADMIN_PORT
19 select * from performance_schema.global_variables where variable_name='admin_port';
20 --replace_result $MASTER_ADMINPORT ADMIN_PORT
21 select * from performance_schema.session_variables where variable_name='admin_port';
22 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
23 select variable_name, min_value, max_value from performance_schema.variables_info where variable_name='admin_port';
24 --enable_warnings
25
26 #
27 # show that it's read-only
28 #
29 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
30 set global admin_port=1000;
31 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
32 set session admin_port=1000;
33 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
34 set persist admin_port=1000;
35
36 #
37 # Set the option and verify that it is reflected
38 #
39 --let $restart_parameters=restart: --skip-name-resolve --admin-address=127.0.0.1 --admin_port=$MASTER_ADMINPORT
40 --replace_result $MASTER_ADMINPORT ADMIN_PORT
41 --source include/restart_mysqld.inc
42
43 --disable_warnings
44 --replace_result $MASTER_ADMINPORT ADMIN_PORT
45 select * from performance_schema.global_variables where variable_name='admin_port';
46 --replace_result $MASTER_ADMINPORT ADMIN_PORT
47 select * from performance_schema.session_variables where variable_name='admin_port';
48 --enable_warnings
49
50 --let $restart_parameters=restart: --skip-name-resolve --admin_port=66000
51 --source include/restart_mysqld.inc
52 --disable_query_log ONCE
53 call mtr.add_suppression("Warning.* option 'admin_port': unsigned value 66000 adjusted to 65535");
54 SELECT @@admin_port;
55
56 --let $restart_parameters=restart: --skip-name-resolve --admin_port=-1
57 --source include/restart_mysqld.inc
58 call mtr.add_suppression("Warning.* option 'admin_port': value -1 adjusted to 0");
59 SELECT @@admin_port;
60
61 --echo #
62 --echo # Starting mysqld in the regular mode...
63 --echo #
64 --let $restart_parameters=
65 --source include/restart_mysqld.inc