| Server IP : 172.67.216.182 / Your IP : 172.70.208.81 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/src/mysql-test/suite/rpl/r/ |
Upload File : |
include/master-slave.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 master]
CALL mtr.add_suppression(".*slave coordinator and worker threads are stopped.*");
CALL mtr.add_suppression("Could not execute Write_rows event on table test.*");
CALL mtr.add_suppression("Worker .* failed executing transaction");
CALL mtr.add_suppression("Slave worker has stopped since one or more of the
previous worker(s) have encountered an error and slave-preserve-commit-order
is enabled.*");
SET @save_debug = @@GLOBAL.debug;
SET GLOBAL debug = "d,set_commit_parent_100";
CREATE TABLE t_w1 (c1 int PRIMARY KEY) ENGINE = InnoDB;
CREATE TABLE t_w2 (c1 int PRIMARY KEY) ENGINE = InnoDB;
CREATE TABLE t_w3 (c1 int PRIMARY KEY) ENGINE = InnoDB;
CREATE TABLE t_w4 (c1 int PRIMARY KEY) ENGINE = InnoDB;
include/sync_slave_sql_with_master.inc
INSERT INTO t_w2 VALUES(1);
LOCK TABLES t_w1 WRITE, t_w2 WRITE, t_w3 WRITE, t_w4 WRITE;
[connection master]
BEGIN;
INSERT INTO t_w1 VALUES(1);
INSERT INTO t_w1 VALUES(2);
INSERT INTO t_w1 VALUES(3);
INSERT INTO t_w1 VALUES(4);
INSERT INTO t_w1 VALUES(5);
COMMIT;
BEGIN;
INSERT INTO t_w2 VALUES(1);
INSERT INTO t_w2 VALUES(2);
COMMIT;
BEGIN;
INSERT INTO t_w3 VALUES(1);
INSERT INTO t_w3 VALUES(2);
INSERT INTO t_w3 VALUES(3);
INSERT INTO t_w3 VALUES(4);
COMMIT;
INSERT INTO t_w4 VALUES(1);
SET GLOBAL debug = @save_debug;
include/save_master_pos.inc
[connection slave]
UNLOCK TABLES;
include/wait_for_slave_sql_error.inc [errno=1062]
include/assert.inc ['Rows have been inserted to table t_w1']
include/assert.inc ['No rows have been inserted to table t_w2']
include/assert.inc ['No rows have been inserted to table t_w3']
include/assert.inc ['No rows have been inserted to table t_w4']
DELETE FROM t_w2 WHERE c1 = 1;
include/start_slave_sql.inc
include/sync_slave_sql.inc
include/rpl_diff.inc
include/rpl_diff.inc
include/rpl_diff.inc
include/rpl_diff.inc
[connection master]
DROP TABLE t_w1, t_w2, t_w3, t_w4;
include/rpl_end.inc