mariadb/mysql-test/suite/binlog/r
Xiaochuan Cui 6e86fe0063 MDEV-35528: mariadb-binlog cannot process more than 1 logfiles when --stop-datetime is specified
Fix regression introduced by commits 9588526 which attempted to address
MDEV-27037. With the regression, mariadb-binlog cannot process multiple
log files when --stop-datetime is specified.

The change is to keep recording timestamp of last processed event, and
after all log files are processed, if the last recorded timestamp has not
reached specified --stop-datetime, it will emit a warning. This applies
when processing local log files, or log files from remote servers.

All new code of the whole pull request, including one or several files that are
either new files or modified ones, are contributed under the BSD-new license. I
am contributing on behalf of my employer Amazon Web Services, Inc.

Co-authored-by: Brandon Nesterenko <brandon.nesterenko@mariadb.com>
Reviewed-by: Brandon Nesterenko <brandon.nesterenko@mariadb.com>
2025-01-12 11:03:10 -07:00
..
backup.result Fix that BACKUP STAGE BLOCK_COMMIT flushes binary log 2019-11-01 10:22:30 +02:00
binlog_1pc.result MDEV-28948 FLUSH BINARY LOGS waits/hangs on mysql_mutex_unlock(&LOCK_index) 2022-07-26 10:46:01 +03:00
binlog_admin_cmd_kill.result MDEV-22530: Aborting OPTIMIZE TABLE still logs in binary log and replicates to the Slave server. 2021-05-19 14:21:49 +05:30
binlog_autocommit_off_no_hang.result DBAAS-7828: Primary/replica: configuration change of autocommit=0 can not be applied 2022-03-24 12:00:40 -06:00
binlog_base64_flag.result [MDEV-30824] Fix binlog to use 'String' for setting 'character_set_client' 2023-03-21 17:19:44 +04:00
binlog_bug23533.result Merge 10.4 into 10.5 2022-07-27 17:17:24 +03:00
binlog_bug36391.result WL#5867, reorganize test cases of bugs suite 2011-04-14 00:18:08 +04:00
binlog_checkpoint.result MDEV-29607: binlog.binlog_checkpoint fails in buildbot with result content mismatch 2022-11-25 12:45:35 -07:00
binlog_checkpoint_flush_logs.result Merge 10.3 into 10.4 2021-04-22 07:51:33 +03:00
binlog_checksum.result Merge 10.0-base -> 10.0 (GTID). 2013-04-17 15:17:01 +02:00
binlog_commit_wait.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
binlog_database.result MDEV-7635: Part 1 2017-02-10 06:30:42 -05:00
binlog_delete_and_flush_index.result Merge 10.0-base -> 10.0 (GTID). 2013-04-17 15:17:01 +02:00
binlog_dmls_on_tmp_tables_readonly.result Merge branch '10.0' into 10.1 2016-08-25 12:40:09 +02:00
binlog_drop_if_exists.result Merge remote-tracking branch 'origin/10.4' into 10.5 2022-09-14 16:24:51 +04:00
binlog_empty_xa_prepared.result MDEV-28970: Add RESET MASTER to clear possible remaining binlog from previous test 2022-11-09 11:59:28 +00:00
binlog_flush_binlogs_delete_domain.result MDEV-14431 binlog.binlog_flush_binlogs_delete_domain failed in buildbot 2018-10-16 12:42:57 +03:00
binlog_format_switch_in_tmp_table.result
binlog_gis_user_var_stm.result MDEV-27666 User variable not parsed as geometry variable in geometry function 2024-01-16 18:53:23 +04:00
binlog_grant.result MDEV-21975: Fix the result 2020-03-19 05:43:57 +02:00
binlog_gtid_delete_domain_debug.result never add new error messages to old GA releases! 2017-11-19 14:43:17 +01:00
binlog_implicit_commit.result MDEV-7635: Part 1 2017-02-10 06:30:42 -05:00
binlog_incident.result
binlog_index.result Merge branch '10.3' into 10.4 2020-01-24 14:50:23 +01:00
binlog_innodb.result MDEV-11937: InnoDB flushes redo log too often 2017-08-07 18:23:55 +02:00
binlog_innodb_row.result MDEV-7635: Part 1 2017-02-10 06:30:42 -05:00
binlog_innodb_stm.result MDEV-18466 Unsafe to log updates on tables referenced by foreign keys with triggers in statement format 2019-03-27 22:51:37 +01:00
binlog_invalid_read_in_rotate.result After-merge fix: Actually apply the changes 2020-01-08 17:09:31 +05:30
binlog_ioerr.result MDEV-21360 global debug_dbug pre-test value restoration issues 2020-01-15 18:06:24 +01:00
binlog_killed.result MDEV-14822 binlog.binlog_killed fails with wrong result 2018-01-10 14:41:10 +02:00
binlog_killed_simulate.result cleanup: binlog.binlog_killed_simulate 2016-12-29 13:23:42 +01:00
binlog_max_binlog_stmt_cache_size.result Mdev-4774- Fix tests cases 2017-01-31 10:12:22 +05:30
binlog_max_extension.result enforce no trailing \n in Diagnostic_area messages 2025-01-07 16:31:39 +01:00
binlog_mdev342.result MDEV-7635: Part 1 2017-02-10 06:30:42 -05:00
binlog_mdev717.result Merge branch '10.1' into 10.2 2019-05-04 17:04:55 +02:00
binlog_mixed.result BINLOG with LOCK TABLES and SAVEPOINT could cause a crash in debug bin 2020-06-14 19:39:43 +03:00
binlog_mixed_cache_stat.result Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
binlog_mixed_load_data.result MDEV-7635: Part 1 2017-02-10 06:30:42 -05:00
binlog_mysqlbinlog-cp932.result BUG#14659685 - main.mysqlbinlog_row_myisam and 2012-10-30 10:40:07 +05:30
binlog_mysqlbinlog2.result MDEV-29225 make explicit_defaults_for_timestamps SESSION variable 2022-08-02 18:08:38 +02:00
binlog_mysqlbinlog_base64.result BUG#14659685 - main.mysqlbinlog_row_myisam and 2012-10-30 10:40:07 +05:30
binlog_mysqlbinlog_raw_flush.result MDEV-29402: Test sequence binlog.binlog_mdev717 binlog.binlog_mysqlbinlog_raw_flush fails 2023-11-15 13:09:03 +01:00
binlog_mysqlbinlog_row.result MDEV-34318 mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server 2024-07-17 21:25:40 +02:00
binlog_mysqlbinlog_row_frag.result Merge 10.3 into 10.4 2020-05-19 21:18:15 +03:00
binlog_mysqlbinlog_row_innodb.result MDEV-34318 mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server 2024-07-17 21:25:40 +02:00
binlog_mysqlbinlog_row_myisam.result MDEV-34318 mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server 2024-07-17 21:25:40 +02:00
binlog_mysqlbinlog_row_trans.result MDEV-34318 mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server 2024-07-17 21:25:40 +02:00
binlog_mysqlbinlog_stop_never.result MDEV-11154: Write_on_release_cache(log_event.cc) function will not write "COMMIT", if use "mysqlbinlog ... | mysql ..." 2019-07-15 13:30:10 +05:30
binlog_mysqlbinlog_suppress_O_TMPFILE.result MDEV-23846: O_TMPFILE error in mysqlbinlog stream output breaks restore 2020-11-23 12:16:45 +05:30
binlog_mysqlbinlog_warn_stop_datetime.result MDEV-35528: mariadb-binlog cannot process more than 1 logfiles when --stop-datetime is specified 2025-01-12 11:03:10 -07:00
binlog_mysqlbinlog_warn_stop_position.result MDEV-35528: mariadb-binlog cannot process more than 1 logfiles when --stop-datetime is specified 2025-01-12 11:03:10 -07:00
binlog_no_uniqfile_crash.result enforce no trailing \n in Diagnostic_area messages 2025-01-07 16:31:39 +01:00
binlog_old_versions.result MDEV-34 delete storage/ndb and sql/*ndb* (and collateral changes) 2014-10-11 18:53:06 +02:00
binlog_parallel_replication_ddl.result MDEV-27365 CREATE-or-REPLACE SEQUENCE is binlogged without DDL flag 2022-01-03 17:39:23 +02:00
binlog_parallel_replication_marks_row.result MDEV-23108: Point in time recovery of binary log fails when sql_mode=ORACLE 2020-07-22 11:34:50 +05:30
binlog_parallel_replication_marks_stm_mix.result MDEV-23108: Point in time recovery of binary log fails when sql_mode=ORACLE 2020-07-22 11:34:50 +05:30
binlog_query_filter_rules.result BUG#49978: Replication tests don't clean up replication state at the end 2010-12-19 18:07:28 +01:00
binlog_recover_checksum_error.result Merge 10.3 into 10.4 2020-10-22 13:27:18 +03:00
binlog_rotate_perf.result MDEV-19117 Don't keep binary log index file locked during show binary logs 2019-04-01 19:47:24 +03:00
binlog_row_annotate.result MDEV-34318 mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server 2024-07-17 21:25:40 +02:00
binlog_row_binlog.result Merge branch '10.4' into 10.5 2021-07-31 23:19:51 +02:00
binlog_row_cache_stat.result Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
binlog_row_ctype_cp932.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
binlog_row_ctype_ucs.result MDEV-34318 mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server 2024-07-17 21:25:40 +02:00
binlog_row_drop_tbl.result MDEV-7635: Part 1 2017-02-10 06:30:42 -05:00
binlog_row_drop_tmp_tbl.result Merge 10.1 into 10.2 2019-08-28 15:23:21 +03:00
binlog_row_insert_select.result MDEV-7635: Part 1 2017-02-10 06:30:42 -05:00
binlog_row_mix_innodb_myisam.result Merge 10.1 into 10.2 2019-07-25 12:14:27 +03:00
binlog_row_mysqlbinlog_db_filter.result
binlog_row_mysqlbinlog_options.result MDEV-34318 mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server 2024-07-17 21:25:40 +02:00
binlog_row_mysqlbinlog_verbose.result BUG#14548159: NUMEROUS CASES OF INCORRECT IDENTIFIER 2012-09-22 17:50:51 +05:30
binlog_server_id.result Merge 10.0-base -> 10.0 (GTID). 2013-04-17 15:17:01 +02:00
binlog_sf.result BUG#49978: Replication tests don't clean up replication state at the end 2010-12-19 18:07:28 +01:00
binlog_show_binlog_event_random_pos.result enforce no trailing \n in Diagnostic_area messages 2025-01-07 16:31:39 +01:00
binlog_show_binlog_events_invalid_offset_silent.result MDEV-32628: Cryptic ERROR message & inconsistent behavior on incorrect SHOW BINLOG EVENTS FROM ... 2023-11-17 09:43:56 -08:00
binlog_spurious_ddl_errors.result MDEV-22008 rpl.rpl_semi_sync fails in bb, MDEV-24418 reenable binlog_truncate_innodb and binlog_spurious_ddl_errors, rpl_parallel_retry fails in bb 2020-12-18 19:31:51 +01:00
binlog_sql_mode.result MDEV-19265 Server should throw warning if event is created and event_scheduler = OFF 2019-04-28 12:49:59 +02:00
binlog_start_comment.result
binlog_statement_insert_delayed.result MDEV-25363 binlog_stm_datetime_ranges_mdev15289 failed in bb 2021-04-14 09:15:41 +02:00
binlog_stm_binlog.result Merge 10.4 into 10.5 2022-12-13 14:39:18 +02:00
binlog_stm_blackhole.result SQL: allow PERIOD as identifier [fixes #331] 2017-11-27 15:07:34 +03:00
binlog_stm_cache_stat.result Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
binlog_stm_ctype_cp932.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
binlog_stm_ctype_ucs.result MDEV-34318 mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server 2024-07-17 21:25:40 +02:00
binlog_stm_datetime_ranges_mdev15289.result MDEV 28970: Add RESET MASTER to clear possible remaining binlog from previous test 2022-11-09 16:34:55 +00:00
binlog_stm_do_db.result MDEV 28970: Add RESET MASTER to clear possible remaining binlog from previous test 2022-11-09 16:34:55 +00:00
binlog_stm_drop_tbl.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
binlog_stm_drop_tmp_tbl.result Merge 10.1 into 10.2 2019-08-28 15:23:21 +03:00
binlog_stm_insert_select.result Merge 10.0-base -> 10.0 (GTID). 2013-04-17 15:17:01 +02:00
binlog_stm_mix_innodb_myisam.result Remove end . from error messages to get them consistent 2016-10-05 01:11:08 +03:00
binlog_stm_ps.result MDEV-14467 Item_param: replace {INT|DECIMAL|REAL|STRING|TIME}_VALUE with Type_handler 2017-11-29 10:03:51 +04:00
binlog_stm_row.result MDEV-7635: Part 1 2017-02-10 06:30:42 -05:00
binlog_stm_sp.result MDEV-16020 SP variables inside GROUP BY..WITH ROLLUP break replication 2018-04-27 22:11:18 +04:00
binlog_stm_sp_type_row.result MDEV-12291 Allow ROW variables as SELECT INTO targets 2017-04-05 15:03:00 +04:00
binlog_stm_unsafe_warning.result MDEV-24617 OPTIMIZE on a sequence causes unexpected ER_BINLOG_UNSAFE_STATEMENT 2022-03-10 13:38:07 +02:00
binlog_stm_user_variables.result MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00
binlog_switch_inside_trans.result Bug #15868071 USING SET GLOBAL SQL_LOG_BIN SHOULD NOT BE ALLOWED 2014-09-24 09:44:48 +08:00
binlog_table_map_optional_metadata.result Merge remote-tracking branch 'origin/10.4' into 10.5 2022-09-14 16:24:51 +04:00
binlog_table_map_optional_metadata_binary.result MDEV-29866: Add RESET MASTER to clear possible remaining binlog from previous test 2022-11-09 17:36:42 +00:00
binlog_table_map_optional_metadata_ucs2.result MDEV-29866: Add RESET MASTER to clear possible remaining binlog from previous test 2022-11-09 17:36:42 +00:00
binlog_table_map_optional_metadata_utf32.result MDEV-29866: Add RESET MASTER to clear possible remaining binlog from previous test 2022-11-09 17:36:42 +00:00
binlog_tmp_table.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
binlog_tmp_table_row.result MDEV-9266 Creating index on temporaray table breaks replication 2018-07-18 17:13:24 +05:30
binlog_trigger.result MDEV-6112 multiple triggers per table 2016-10-05 01:11:07 +03:00
binlog_truncate_innodb.result MDEV-22008 rpl.rpl_semi_sync fails in bb, MDEV-24418 reenable binlog_truncate_innodb and binlog_spurious_ddl_errors, rpl_parallel_retry fails in bb 2020-12-18 19:31:51 +01:00
binlog_truncate_kill.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
binlog_truncate_myisam.result MDEV-7635: Part 1 2017-02-10 06:30:42 -05:00
binlog_unsafe.result Merge 10.2 to 10.3 2019-08-13 19:28:51 +03:00
binlog_variables_log_bin.result test suite for compressed binlog event 2016-10-19 20:20:47 +02:00
binlog_variables_log_bin_index.result test suite for compressed binlog event 2016-10-19 20:20:47 +02:00
binlog_variables_relay_log.result MDEV-7110 : Add missing MySQL variable log_bin_basename and log_bin_index 2015-06-09 13:38:29 -04:00
binlog_variables_relay_log_index.result MDEV-7110 : Add missing MySQL variable log_bin_basename and log_bin_index 2015-06-09 13:38:29 -04:00
binlog_verbose_compressed_fields.result MDEV-25277: mysqlbinlog --verbose cannot read row events with compressed columns: Don't know how to handle column type: 140 2023-01-11 10:37:49 -07:00
binlog_write_error.result Merge branch '10.3' into 10.4 2022-07-27 11:02:57 +02:00
binlog_xa_checkpoint.result MDEV-742 XA PREPAREd transaction survive disconnect/server restart 2020-03-14 22:45:48 +02:00
binlog_xa_handling.result MDEV-27536 incremental commit to correct regression test. 2022-01-27 13:44:39 +02:00
binlog_xa_prepared.result MDEV-742 XA PREPAREd transaction survive disconnect/server restart 2020-03-14 22:45:48 +02:00
binlog_xa_prepared_disconnect.result MDEV-742 XA PREPAREd transaction survive disconnect/server restart 2020-03-14 22:45:48 +02:00
binlog_xa_recover.result fix binlog_xa_recover test 2021-02-22 19:43:08 +01:00
flashback-largebinlog.result Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
flashback.result MDEV-34318 mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server 2024-07-17 21:25:40 +02:00
foreign_key.result Added support for replication for S3 2020-03-24 21:00:02 +02:00
innodb_autoinc_lock_mode_binlog.result MDEV 28970: Add RESET MASTER to clear possible remaining binlog from previous test 2022-11-09 16:34:55 +00:00
innodb_rc_insert_before_delete.result MariaDB 10.5.19 release 2023-02-06 17:55:01 +02:00
load_data_stm_view.result Cleanups 2017-12-08 11:38:22 +02:00
mysqladmin.result MDEV-12612 mysqladmin --local flush... to use FLUSH LOCAL 2017-05-24 11:59:04 +02:00
read_only.result Merge 10.3 into 10.4 2019-11-01 15:23:18 +02:00
read_only_statement.result Merge 10.3 into 10.4 2019-11-01 15:23:18 +02:00
show_concurrent_rotate.result MDEV-20215: binlog.show_concurrent_rotate failed in buildbot with wrong result 2021-08-13 10:53:19 -06:00
temptable_uservar_disconnect-7938.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00