Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
None
Description
In unlike case of a crash when @@global.binlog_checksum is changing from none to
crc32 and that only the first of two Binlog_checkpoint_log_event gets written to
the crc32 rotated binlog file, the following recovery faces a checksum verification error.
How to repeat:
set @@global.binlog_checksum=none; |
set @@global.debug_dbug='d,crash_before_write_second_checkpoint_event'; |
set @@global.binlog_checksum=crc32; # => CRASH |
Now at the server restart having --master-verify-checksum=1 the error log
receives the following
[ERROR] Replication event checksum verification failed while reading from a log file
|
[ERROR] Error in Log_event::read_log_event(): 'Replication event checksum verification failed while reading from a log file', data_len: 25, event_type: 163
|
nevertheless the server proceeds to ignore them and finishes initialization.
The simulation label is defined as
--- a/sql/log.cc
|
+++ b/sql/log.cc
|
@@ -6784,6 +6784,11 @@ void MYSQL_BIN_LOG::purge() |
|
void MYSQL_BIN_LOG::checkpoint_and_purge(ulong binlog_id) |
{
|
+ DBUG_EXECUTE_IF("crash_before_write_second_checkpoint_event", |
+ flush_io_cache(&log_file);
|
+ mysql_file_sync(log_file.file, MYF(MY_WME));
|
+ DBUG_SUICIDE(););
|
+
|
do_checkpoint_request(binlog_id);
|
purge();
|
}
|
|
Attachments
Issue Links
- relates to
-
MDEV-21117 refine the server binlog-based recovery for semisync
-
- Closed
-