87 lines
3.4 KiB
Plaintext
87 lines
3.4 KiB
Plaintext
# ==== Purpose ====
|
|
#
|
|
# Test verifies that there is no deadlock when below threads are executed parallely
|
|
# on a keyring installed slave.
|
|
#
|
|
# 1. Server thread executing start slave.
|
|
# 2. Server thread executing handle_slave_io (child thread of start slave thread).
|
|
# 3. Server thread executing "SET GLOBAL binlog_encryption=ON".
|
|
#
|
|
# ==== Implementation ====
|
|
#
|
|
# 1. start master slave servers with keyring installed.
|
|
# 2. verify that slave has binlog_encryption = ON.
|
|
# 3. on slave connection server_2_1:
|
|
# a. set debug sync point after_locking_global_sys_var_set_binlog_enc.
|
|
# b. send 'set binlog_encryption=OFF'.
|
|
# 4. wait for 'set binlog_encryption=OFF' executing thread to reach the debug point.
|
|
# 5. on slave connection server_2_2:
|
|
# a. set debug sync point after_locking_channel_map_in_start_slave.
|
|
# b. send 'start slave'.
|
|
# 6. wait for start slave executing thread to reach the debug point, set in 5.(a).
|
|
# 7. signal debug points, one on each threads, set in 3.(a), and 5.(a).
|
|
# 8. reap the commands on connections slave1, and slave2.
|
|
#
|
|
# ==== References ====
|
|
#
|
|
# BUG#29515210 SLAVE SERVER HANGS WHEN WE CHANGE BINLOG_ENCRYPTION + EXECUTE START SLAVE
|
|
#
|
|
|
|
# 1. start master slave servers with keyring installed.
|
|
--source include/have_debug.inc
|
|
--source include/have_debug_sync.inc
|
|
--source include/have_binlog_format_row.inc
|
|
--let $rpl_skip_start_slave= 1
|
|
--let $rpl_extra_connections_per_server= 2
|
|
--source include/master-slave.inc
|
|
|
|
# 2. verify that slave has binlog_encryption = ON.
|
|
--source include/rpl_connection_slave.inc
|
|
--let $assert_text=binlog_encryption option shall be ON
|
|
--let $option_value = `SELECT variable_value FROM performance_schema.global_variables WHERE variable_name = "binlog_encryption"`
|
|
--let $assert_cond= "$option_value" = "ON"
|
|
--source include/assert.inc
|
|
|
|
# 3. on slave connection server_2_1:
|
|
# a. set debug sync point after_locking_global_sys_var_set_binlog_enc.
|
|
# b. send 'set binlog_encryption=OFF'.
|
|
--let $rpl_connection_name= server_2_1
|
|
--source include/rpl_connection.inc
|
|
SET DEBUG_SYNC='after_locking_global_sys_var_set_binlog_enc SIGNAL sysvar_before_unlock WAIT_FOR cont_set_binlog_enc';
|
|
--send SET GLOBAL binlog_encryption=OFF
|
|
|
|
# 4. wait for 'set binlog_encryption=OFF' executing thread to reach the debug point, set in 3.(a).
|
|
# this ensures that thread has locked Lock_global_system_variables.
|
|
--source include/rpl_connection_slave.inc
|
|
SET DEBUG_SYNC='now WAIT_FOR sysvar_before_unlock';
|
|
|
|
# 5. on slave connection server_2_2:
|
|
# a. set debug sync point after_locking_channel_map_in_start_slave.
|
|
# b. send 'start slave'.
|
|
--let $rpl_connection_name= server_2_2
|
|
--source include/rpl_connection.inc
|
|
SET DEBUG_SYNC='after_locking_channel_map_in_start_slave SIGNAL after_channelmap_lock WAIT_FOR cont_start_slave';
|
|
--send START SLAVE
|
|
|
|
# 6. wait for start slave executing thread to reach the debug point, set in 5.(a).
|
|
--source include/rpl_connection_slave.inc
|
|
SET DEBUG_SYNC='now WAIT_FOR after_channelmap_lock';
|
|
|
|
# 7. signal debug points, one on each threads, set in 3.(a), and 5.(a).
|
|
SET DEBUG_SYNC='now SIGNAL cont_set_binlog_enc';
|
|
SET DEBUG_SYNC='now SIGNAL cont_start_slave';
|
|
|
|
# 8. reap the commands on connections server_2_1, and server_2_2.
|
|
--let $rpl_connection_name= server_2_1
|
|
--source include/rpl_connection.inc
|
|
--reap
|
|
--let $rpl_connection_name= server_2_2
|
|
--source include/rpl_connection.inc
|
|
--reap
|
|
|
|
# restore binlog_encryption.
|
|
--source include/rpl_connection_slave.inc
|
|
SET GLOBAL binlog_encryption=ON;
|
|
|
|
source include/rpl_end.inc;
|