Bug #92635 HA_ERR_CORRUPT_EVENT on different slave schema
Submitted: 2 Oct 2018 13:10 Modified: 30 Nov 2021 9:28
Reporter: wooseok lee Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Row Based Replication ( RBR ) Severity:S3 (Non-critical)
Version:5.7.17, 5.7.36 OS:Any
Assigned to: CPU Architecture:Any
Tags: HA_ERR_CORRUPT_EVENET

[2 Oct 2018 13:10] wooseok lee
Description:
hi

this case does not happen on mariaDB 5.5v(Master) -> mysql 5.7v(Slave)
but this happens on mysql 5.7v(Master) -> mysql 5.7v(Slave)

Today, i experienced an error. so, i want to check whether this case is original or bug.

How to repeat:
set global binlog_format=ROW

on master : 
create table t1 (d1 datetime);

----------

on slave :
alter table t1 modify column d1 datetime(3)

----------

on master : 
insert into t1(d1) values ('2018-01-01 00:00:00');

then, replication is breaked with the following message.
----------
Could not execute Write_rows event on table d2.t1; Unknown error, Error_code: 1105; handler error HA_ERR_CORRUPT_EVENT; the event's master log mysql-bin.000009, end_log_pos 709
----------
[30 Nov 2021 9:28] MySQL Verification Team
Hello!

Thank you for the report.

regards,
Umesh