Debian Codegraph @

mysql-test/suite/service_sys_var_registration/t/sys_var_service_cl.test

raw
1 # Verify that registered system variables can be set in config files.
2 # Actually not working.
3
4 --source ../include/have_component_test_sys_var_service.inc
5
6 call mtr.add_suppression("duplicate variable name");
7 call mtr.add_suppression("variable name.*not found");
8 call mtr.add_suppression("INNODB:");
9 call mtr.add_suppression("Failed to set up SSL");
10
11 INSTALL COMPONENT "file://component_test_sys_var_service";
12
13 SELECT VARIABLE_NAME, MIN_VALUE, MAX_VALUE FROM performance_schema.variables_info
14 WHERE VARIABLE_NAME LIKE '%component%'
15 ORDER BY VARIABLE_NAME;
16
17 SELECT @@test_component.str_sys_var;
18 SELECT @@test_component.uint_sys_var;
19
20 # Set variables to be used in parameters of mysqld.
21 let $MYSQLD_DATADIR= `SELECT @@datadir`;
22 let $MYSQL_BASEDIR= `SELECT @@basedir`;
23 let $MYSQL_SOCKET= `SELECT @@socket`;
24 let $MYSQL_PIDFILE= `SELECT @@pid_file`;
25 let $MYSQL_PORT= `SELECT @@port`;
26 let $MYSQL_MESSAGESDIR= `SELECT @@lc_messages_dir`;
27 let $MYSQL_HOME=`SELECT @@basedir`;
28 let $MYSQL_SERVER_ID= `SELECT @@server_id`;
29
30 --write_file $MYSQLTEST_VARDIR/tmp/sys_reg.cnf
31 [mysqld]
32 loose-test-component.uint-sys-var=1234
33 loose-test-component.str-sys-var="before restart"
34 EOF
35
36 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
37 --shutdown_server
38 --source include/wait_until_disconnected.inc
39
40 --exec echo "restart:--defaults-file=$MYSQLTEST_VARDIR/tmp/sys_reg.cnf --log-bin" --basedir=$MYSQL_BASEDIR --datadir=$MYSQLD_DATADIR --socket=$MYSQL_SOCKET --pid-file=$MYSQL_PIDFILE --port=$MYSQL_PORT --lc-messages-dir=$MYSQL_MESSAGESDIR --server-id=$MYSQL_SERVER_ID --sort_buffer_size=462144 --secure-file-priv="" --innodb_dedicated_server=OFF > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
41
42 --echo # restart mysqld
43 --enable_reconnect
44 --source include/wait_until_connected_again.inc
45
46 SELECT @@test_component.str_sys_var;
47 SELECT @@test_component.uint_sys_var;
48
49 --write_file $MYSQLTEST_VARDIR/tmp/sys_reg_2.cnf
50 [mysqld]
51 loose-test-component.uint-sys-var=1234
52 loose-test-component.str-sys-var="before 2nd restart"
53 EOF
54
55 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
56 --shutdown_server
57 --source include/wait_until_disconnected.inc
58
59 --exec echo "restart:--defaults-file=$MYSQLTEST_VARDIR/tmp/sys_reg_2.cnf --log-bin" --basedir=$MYSQL_BASEDIR --datadir=$MYSQLD_DATADIR --socket=$MYSQL_SOCKET --pid-file=$MYSQL_PIDFILE --port=$MYSQL_PORT --lc-messages-dir=$MYSQL_MESSAGESDIR --server-id=$MYSQL_SERVER_ID --sort_buffer_size=462144 --secure-file-priv="" --innodb_dedicated_server=OFF > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
60
61 --echo # restart mysqld
62 --enable_reconnect
63 --source include/wait_until_connected_again.inc
64
65 SELECT @@test_component.str_sys_var;
66 SELECT @@test_component.uint_sys_var;
67
68 --write_file $MYSQLTEST_VARDIR/tmp/sys_reg_3.cnf
69 [mysqld]
70 loose-test-component.uint-sys-var=5678
71 loose-test-component.str-sys-var=9999
72 EOF
73
74 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
75 --shutdown_server
76 --source include/wait_until_disconnected.inc
77
78 --exec echo "restart:--defaults-file=$MYSQLTEST_VARDIR/tmp/sys_reg_3.cnf --log-bin" --basedir=$MYSQL_BASEDIR --datadir=$MYSQLD_DATADIR --socket=$MYSQL_SOCKET --pid-file=$MYSQL_PIDFILE --port=$MYSQL_PORT --lc-messages-dir=$MYSQL_MESSAGESDIR --server-id=$MYSQL_SERVER_ID --sort_buffer_size=462144 --secure-file-priv="" --innodb_dedicated_server=OFF > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
79
80 --echo # restart mysqld
81 --enable_reconnect
82 --source include/wait_until_connected_again.inc
83
84 SELECT @@test_component.str_sys_var;
85 SELECT @@test_component.uint_sys_var;
86
87 UNINSTALL COMPONENT "file://component_test_sys_var_service";
88 let $MYSQLD_DATADIR= `select @@datadir`;
89 remove_file $MYSQLD_DATADIR/test_component_sys_var_service.log;
90
91 # Restore default settings
92 let $restart_parameters = restart:;
93 --source include/restart_mysqld.inc
94
95 --remove_file $MYSQLTEST_VARDIR/tmp/sys_reg.cnf
96 --remove_file $MYSQLTEST_VARDIR/tmp/sys_reg_2.cnf
97 --remove_file $MYSQLTEST_VARDIR/tmp/sys_reg_3.cnf