Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW

Qlik Replicate: Task fails with error: bogus data in log event; the first event 'mysql-bin.000xxx

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Gerald_U
Support
Support

Qlik Replicate: Task fails with error: bogus data in log event; the first event 'mysql-bin.000xxx

Last Update:

Dec 12, 2023 1:24:33 AM

Updated By:

Sonja_Bauernfeind

Created date:

Dec 12, 2023 1:24:33 AM

Tasks are failing with the irrecoverable error below:

[SOURCE_CAPTURE ]E: Read next binary log event failed; mariadb_rpl_fetch error 1236 (bogus data in log event; the first event 'mysql-bin.000890' at 563945841, the last event read from 'mysql-bin.000890' at 865072956, the last byte read from 'mysql-bin.000890' at 865072975.) [1020403] (mysql_endpoint_capture.c:1088)


[SOURCE_CAPTURE ]E: Error reading binary log. [1020414] (mysql_endpoint_capture.c:4093)

 

Resolution

Restart the Maria source database system and turn on CRC32 for the binlog checksum. If the issue persists, review and implement the changes in bogus data in log event | Percona.com.

Cause

This error occurs when the secondary server's required binary log for replication no longer exists on the primary database server.

 

Environment

Labels (1)
Version history
Last update:
‎2023-12-12 01:24 AM
Updated by: