mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 00:04:31 +03:00
588f7a5af7
MDEV-27037 added functionality to warn users that a specified stop-position or stop-datetime was never reached. It only worked for local files though. The patch in MDEV-35528 changed the implementation for stop-datetime to work to provide the warning also when using --read-from-remote-server. The PR for that MDEV (#3670) was limited to only the stop-datetime field. This patch updates the --stop-position warning to also work with --read-from-remote-server. Reviewed By: ============ Andrei Elkin <andrei.elkin@mariadb.com> Jimmy Hu <jimmy.hu@mariadb.com>
111 lines
5.2 KiB
Plaintext
111 lines
5.2 KiB
Plaintext
#
|
|
# Clear the existing binary log state.
|
|
#
|
|
RESET MASTER;
|
|
create table t1 (a int);
|
|
insert into t1 values (1);
|
|
insert into t1 values (2);
|
|
flush binary logs;
|
|
insert into t1 values (3);
|
|
# Tag binlog_f2_mid
|
|
insert into t1 values (4);
|
|
insert into t1 values (5);
|
|
insert into t1 values (6);
|
|
insert into t1 values (7);
|
|
flush binary logs;
|
|
drop table t1;
|
|
# Ensuring binary log order is correct
|
|
# Ensuring file offset of binlog_f2_mid < binlog_f1_end
|
|
#
|
|
#
|
|
# Test using --read-from-remote-server
|
|
#
|
|
connection default;
|
|
#
|
|
# --stop-position tests
|
|
#
|
|
# Case 1.a) With one binlog file, a --stop-position before the end of
|
|
# the file should not result in a warning
|
|
# MYSQL_BINLOG --read-from-remote-server --stop-position=binlog_f1_pre_rotate binlog_f1_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
#
|
|
# Case 1.b) With one binlog file, a --stop-position at the exact end of
|
|
# the file should not result in a warning
|
|
# MYSQL_BINLOG --read-from-remote-server --stop-position=binlog_f1_end binlog_f1_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
#
|
|
# Case 1.c) With one binlog file, a --stop-position past the end of the
|
|
# file should(!) result in a warning
|
|
# MYSQL_BINLOG --read-from-remote-server --short-form --stop-position=binlog_f1_over_eof binlog_f1_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
WARNING: Did not reach stop position <BINLOG_F1_OVER_EOF> before end of input
|
|
#
|
|
# Case 2.a) With two binlog files, a --stop-position targeting b2 which
|
|
# exists in the size of b1 should:
|
|
# 1) not provide any warnings
|
|
# 2) not prevent b2 from outputting its desired events before the
|
|
# stop position
|
|
# MYSQL_BINLOG --read-from-remote-server --stop-position=binlog_f2_mid binlog_f1_full binlog_f2_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
include/assert_grep.inc [Ensure all intended GTIDs are present]
|
|
include/assert_grep.inc [Ensure the next GTID binlogged is _not_ present]
|
|
#
|
|
# Case 2.b) With two binlog files, a --stop-position targeting the end
|
|
# of binlog 2 should:
|
|
# 1) not provide any warnings
|
|
# 2) not prevent b2 from outputting its entire binary log
|
|
# MYSQL_BINLOG --read-from-remote-server --stop-position=binlog_f2_end binlog_f1_full binlog_f2_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
include/assert_grep.inc [Ensure a GTID exists for each transaction]
|
|
include/assert_grep.inc [Ensure the last GTID binlogged is present]
|
|
#
|
|
# Case 2.c) With two binlog files, a --stop-position targeting beyond
|
|
# the eof of binlog 2 should:
|
|
# 1) provide a warning that the stop position was not reached
|
|
# 2) not prevent b2 from outputting its entire binary log
|
|
# MYSQL_BINLOG --read-from-remote-server --stop-position=binlog_f2_over_eof binlog_f1_full binlog_f2_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
WARNING: Did not reach stop position <BINLOG_F2_OVER_EOF> before end of input
|
|
include/assert_grep.inc [Ensure a GTID exists for each transaction]
|
|
#
|
|
#
|
|
# Test using local binlog files
|
|
#
|
|
connection default;
|
|
#
|
|
# --stop-position tests
|
|
#
|
|
# Case 1.a) With one binlog file, a --stop-position before the end of
|
|
# the file should not result in a warning
|
|
# MYSQL_BINLOG --stop-position=binlog_f1_pre_rotate binlog_f1_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
#
|
|
# Case 1.b) With one binlog file, a --stop-position at the exact end of
|
|
# the file should not result in a warning
|
|
# MYSQL_BINLOG --stop-position=binlog_f1_end binlog_f1_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
#
|
|
# Case 1.c) With one binlog file, a --stop-position past the end of the
|
|
# file should(!) result in a warning
|
|
# MYSQL_BINLOG --short-form --stop-position=binlog_f1_over_eof binlog_f1_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
WARNING: Did not reach stop position <BINLOG_F1_OVER_EOF> before end of input
|
|
#
|
|
# Case 2.a) With two binlog files, a --stop-position targeting b2 which
|
|
# exists in the size of b1 should:
|
|
# 1) not provide any warnings
|
|
# 2) not prevent b2 from outputting its desired events before the
|
|
# stop position
|
|
# MYSQL_BINLOG --stop-position=binlog_f2_mid binlog_f1_full binlog_f2_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
include/assert_grep.inc [Ensure all intended GTIDs are present]
|
|
include/assert_grep.inc [Ensure the next GTID binlogged is _not_ present]
|
|
#
|
|
# Case 2.b) With two binlog files, a --stop-position targeting the end
|
|
# of binlog 2 should:
|
|
# 1) not provide any warnings
|
|
# 2) not prevent b2 from outputting its entire binary log
|
|
# MYSQL_BINLOG --stop-position=binlog_f2_end binlog_f1_full binlog_f2_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
include/assert_grep.inc [Ensure a GTID exists for each transaction]
|
|
include/assert_grep.inc [Ensure the last GTID binlogged is present]
|
|
#
|
|
# Case 2.c) With two binlog files, a --stop-position targeting beyond
|
|
# the eof of binlog 2 should:
|
|
# 1) provide a warning that the stop position was not reached
|
|
# 2) not prevent b2 from outputting its entire binary log
|
|
# MYSQL_BINLOG --stop-position=binlog_f2_over_eof binlog_f1_full binlog_f2_full --result-file=tmp/warn_position_test_file.out 2>&1
|
|
WARNING: Did not reach stop position <BINLOG_F2_OVER_EOF> before end of input
|
|
include/assert_grep.inc [Ensure a GTID exists for each transaction]
|
|
#
|
|
# End of binlog_mysqlbinlog_warn_stop_position.test
|