53 lines
2.1 KiB
Plaintext
53 lines
2.1 KiB
Plaintext
--echo # Verify that restarting the server in --read-only mode skips
|
|
--echo # re-populating character sets and collations. Also verify the
|
|
--echo # same for --innodb-read-only.
|
|
|
|
--echo # 1. Server restart with --read-only:
|
|
|
|
--echo # 1.1 Request shutdown and wait for disconnect.
|
|
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
--send_shutdown
|
|
--source include/wait_until_disconnected.inc
|
|
|
|
--echo # 1.2 Restart the server with --read-only and wait for reconnect.
|
|
--exec echo "restart:--read-only" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
--disable_reconnect
|
|
|
|
--echo # 2. Server restart with --innodb-read-only:
|
|
|
|
--echo # 2.1 Request shutdown and wait for disconnect.
|
|
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
--send_shutdown
|
|
--source include/wait_until_disconnected.inc
|
|
|
|
--echo # 2.2 Restart the server with --innodb-read-only and wait for reconnect.
|
|
--exec echo "restart:--innodb-read-only" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
--disable_reconnect
|
|
|
|
--echo # 2.3 Search for the expected warning in the log file.
|
|
--let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err
|
|
--let SEARCH_PATTERN= Skip re-populating collations and character sets tables in InnoDB read-only mode.
|
|
--source include/search_pattern.inc
|
|
--let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err
|
|
--let SEARCH_PATTERN= Skip updating information_schema metadata in InnoDB read-only mode.
|
|
--source include/search_pattern.inc
|
|
--let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err
|
|
--let SEARCH_PATTERN= Skipped updating resource group metadata in InnoDB read only mode.
|
|
|
|
--echo # 3. Clean server restart.
|
|
|
|
--echo # 3.1 Request shutdown and wait for disconnect.
|
|
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
--send_shutdown
|
|
--source include/wait_until_disconnected.inc
|
|
|
|
--echo # 3.2 Restart the server with no additional options.
|
|
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
--disable_reconnect
|