Comment 8 for bug 1594964

Revision history for this message
Vlad Lesin (vlad-lesin) wrote :

The simple mtr test to repeat it:

*.test:
=======================
--source include/have_binlog_format_row.inc
--source include/have_gtid.inc

--echo *** Set up master (server_1) <-> master (server_2) replication ***
--let $rpl_topology= 1->2->1
--source include/rpl_init.inc
--echo

--connection server_2
--let $s2b=`select * from sys.memory_global_total`
--connection server_1
--let $s1b=`select * from sys.memory_global_total`

--disable_query_log
CREATE TABLE t1(a INT);
--let $i=3000
while($i)
{
--eval INSERT INTO t1 VALUES ($i)
--dec $i
}
DROP TABLE t1;
--enable_query_log

--source include/rpl_sync.inc
--connection server_2
--let $s2a=`select * from sys.memory_global_total`
--connection server_1
--let $s1a=`select * from sys.memory_global_total`
=================================

*.cnf:
=================================
!include ../my.cnf

[mysqld.1]
sync_relay_log_info=1
enforce-gtid-consistency=ON
gtid-mode=ON
master-info-repository=TABLE
relay-log-info-repository=TABLE
log-slave-updates

[mysqld.2]
sync_relay_log_info=1
enforce-gtid-consistency=ON
gtid-mode=ON
master-info-repository=TABLE
relay-log-info-repository=TABLE
log-slave-updates

--echo "server_1: $s1b $s1a"
--echo "server_2: $s2b $s2a"

# Cleanup
--source include/rpl_end.inc
==================================

can be placed in "mysql-test/suite/rpl/t" .