################################################################################ # This test checks that the value of the group_replication_components_stop_timeout # is settable even without group replication running. # # Test: # 0. The test requires one server. # 1. Test that group_replication_components_stop_timeout variable doesn't accept # invalid inputs and truncates out of range values. # 2. Set the timeout to the value without starting group replication. This # should work without failure. # 3. Set the timeout to the value but after starting group replication. This # should work without failure. ################################################################################ --let $group_replication_group_name= 2d249320-2e06-11e3-aa6e-0800200c9a66 --source include/have_group_replication_plugin.inc --let $rpl_skip_group_replication_start= 1 --source include/group_replication.inc SET @group_replication_components_stop_timeout_save = @@GLOBAL.group_replication_components_stop_timeout; --eval SET GLOBAL group_replication_group_name= "$group_replication_group_name" # Set invalid values. These should fail. --error ER_WRONG_TYPE_FOR_VAR SET GLOBAL group_replication_components_stop_timeout= NULL; --error ER_WRONG_TYPE_FOR_VAR SET GLOBAL group_replication_components_stop_timeout= "a"; --error ER_WRONG_TYPE_FOR_VAR SET GLOBAL group_replication_components_stop_timeout= 1.2; # Set out of range values. These must truncate. --disable_warnings SET GLOBAL group_replication_components_stop_timeout= -1; --enable_warnings --let $assert_text= The value for group_replication_components_stop_timeout should be 2 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_components_stop_timeout]" = 2 --source include/assert.inc --disable_warnings SET GLOBAL group_replication_components_stop_timeout= 1; --enable_warnings --let $assert_text= The value for group_replication_components_stop_timeout should be 2 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_components_stop_timeout]" = 2 --source include/assert.inc --disable_warnings SET GLOBAL group_replication_components_stop_timeout= 31536001; --enable_warnings --let $assert_text= The value for group_replication_components_stop_timeout should be 31536000 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_components_stop_timeout]" = 31536000 --source include/assert.inc # Set the timeout to the value without starting group replication. This should work without failure. SET GLOBAL group_replication_components_stop_timeout= 31536; --let $assert_text= The value for group_replication_components_stop_timeout should be 31536 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_components_stop_timeout]" = 31536 --source include/assert.inc # Set the timeout to the value but after starting group replication. This should work without failure. --source include/start_and_bootstrap_group_replication.inc SET GLOBAL group_replication_components_stop_timeout= 3153; --let $assert_text= The value for group_replication_components_stop_timeout should be 3153 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_components_stop_timeout]" = 3153 --source include/assert.inc SET GLOBAl group_replication_components_stop_timeout = @group_replication_components_stop_timeout_save; --source include/group_replication_end.inc