diff options
author | Kristian Nielsen <knielsen@knielsen-hq.org> | 2015-09-11 10:51:56 +0200 |
---|---|---|
committer | Kristian Nielsen <knielsen@knielsen-hq.org> | 2015-09-11 10:51:56 +0200 |
commit | 51eaa7fe53eb017ffb3f4dc2f318cb0511b7cd26 (patch) | |
tree | 48a3c4a39f74607b083594e3de78e190dc10dd17 /mysql-test/suite/rpl/r/rpl_mdev8193.result | |
parent | 09bfaf3a13dabad936198633b968451c17d409b2 (diff) | |
download | mariadb-git-51eaa7fe53eb017ffb3f4dc2f318cb0511b7cd26.tar.gz |
MDEV-8193: UNTIL clause in START SLAVE is sporadically disobeyed by parallel replication
The code was using the wrong variable when comparing the binlog name
for the UNTIL position. This could cause the comparison to fail after
binlog rotation, in turn causing the UNTIL clause to not trigger slave
stop.
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_mdev8193.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_mdev8193.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_mdev8193.result b/mysql-test/suite/rpl/r/rpl_mdev8193.result new file mode 100644 index 00000000000..ad92d32e7d4 --- /dev/null +++ b/mysql-test/suite/rpl/r/rpl_mdev8193.result @@ -0,0 +1,24 @@ +include/master-slave.inc +[connection master] +include/stop_slave_sql.inc +CALL mtr.add_suppression("Statement is unsafe because it uses a system function that may return a different value on the slave"); +create table t1 (i int); +insert into t1 values (1),(2); +insert into t1 values (3),(4); +insert into t1 select i+20+0*sleep(1) from t1 where i=1; +Warnings: +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. +flush logs; +insert into t1 values (5),(6); +insert into t1 values (7),(8); +insert into t1 values (9),(10); +insert into t1 values (11),(12); +insert into t1 values (13),(14); +insert into t1 values (15),(16); +set global slave_parallel_threads = 1; +start slave until master_log_file='MASTER_FILE', master_log_pos=MASTER_POS; +drop table t1; +include/stop_slave_io.inc +set global slave_parallel_threads = DEFAULT; +drop table t1; +include/rpl_end.inc |