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

[Gerald_U]

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

• Qlik Replicate 
• MariaDB as a source database