| Server IP : 104.21.38.3 / Your IP : 162.158.170.173 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/r/ |
Upload File : |
############################################################
# 1. Start servers, on which server2 has applier stopped so
# that all remote transactions are only queued on relay log.
# Execute some transactions on server1.
include/start_and_bootstrap_group_replication.inc
set session sql_log_bin=0;
call mtr.add_suppression("The member lost contact with a majority of the members in the group. Until the network is restored.*");
call mtr.add_suppression("The member resumed contact with a majority of the members in the group.*");
set session sql_log_bin=1;
SET @debug_saved= @@GLOBAL.DEBUG;
include/start_group_replication.inc
STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
include/rpl_gr_wait_for_number_of_members.inc
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);
#####################################################################
# 2. Restart server2 and verify that certifier sequence number is set
# from relay log certified transactions and view change transactions
# restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_ip_whitelist=GROUP_REPLICATION_GROUP_WHITELIST
SET @@GLOBAL.DEBUG= '+d,certifier_assert_next_seqno_equal_5';
include/start_group_replication.inc
SET @@GLOBAL.DEBUG= @debug_saved;
############################################################
# 3. Insert must fail with duplicate entry.
INSERT INTO t1 VALUES (1);
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
INSERT INTO t1 VALUES (2);
############################################################
# 4. Kill server2 again and verify that certifier sequence
# number is set from GTID_EXECUTED.
# Kill and restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_ip_whitelist=GROUP_REPLICATION_GROUP_WHITELIST
[connection server2]
[connection server1]
include/gr_wait_for_member_state.inc
include/rpl_gr_wait_for_number_of_members.inc
[connection server2]
SET @@GLOBAL.DEBUG= '+d,certifier_assert_next_seqno_equal_7';
include/start_group_replication.inc
SET @@GLOBAL.DEBUG= @debug_saved;
############################################################
# 5. Shutdown.
include/rpl_gr_wait_for_number_of_members.inc
DROP TABLE t1;
include/sync_slave_sql_with_master.inc
include/stop_group_replication.inc
RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
RESET MASTER;
include/stop_group_replication.inc
RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
RESET MASTER;