| Server IP : 172.67.216.182 / Your IP : 162.158.88.82 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/mysql-test/suite/group_replication/t/ |
Upload File : |
################################################################################ # 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 ../inc/have_group_replication_plugin.inc --let $rpl_skip_group_replication_start= 1 --source ../inc/group_replication.inc --let $debug_save_timeout= `SELECT @@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 ../inc/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 --eval SET GLOBAL group_replication_components_stop_timeout= $debug_save_timeout --source ../inc/group_replication_end.inc