| Server IP : 172.67.216.182 / Your IP : 104.23.176.7 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 : |
include/group_replication.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection server1]
set session sql_log_bin=0;
call mtr.add_suppression("The member with address.*has already sent the stable set. Therefore discarding the second message.");
set session sql_log_bin=1;
SET @debug_save= @@GLOBAL.DEBUG;
SET @@GLOBAL.DEBUG= '+d,certifier_inject_duplicate_certifier_data_message';
include/start_and_bootstrap_group_replication.inc
include/start_group_replication.inc
############################################################
# Execute a transaction on the server1 which is propagated to the
# second server and applied on both of them.
CREATE TABLE t1(i INT PRIMARY KEY);
include/rpl_sync.inc
# Start the first round of garbage collection here. Since we have set the DBUG
# flag on the second server we expect a message to be logged in the error log
# as the same member sent the message.
# Transactions_committed_all_members has 1 transaction from when server 2 joined
# No more info should have been received.
include/assert.inc [Transactions committed on all members should only contain 1 transaction]
# Asserting that the warning was indeed thrown.
Occurrences of 'Therefore discarding the second message' in the input file: 1
INSERT INTO t1 VALUES(1);
# Checking that the garbage collection is working fine.
SET @@GLOBAL.DEBUG= @debug_save;
DROP TABLE t1;
include/group_replication_end.inc