1744
MariaDBERRORCommonReplicationHIGH confidence

Binlog file read event checksum failure

Production Risk

Critical — relay log data corrupt; replication stopped.

What this means

A binlog event read from a local file on the replica had a checksum mismatch, indicating disk-level data corruption.

Why it happens
  1. 1Disk I/O errors corrupting the relay log file.
  2. 2Relay log written with one checksum algorithm and read with another.
How to reproduce
trigger — this will error
trigger — this will error
-- Occurs automatically; not directly triggerable via SQL

expected output

ERROR 1744 (HY000): Replication event checksum verification failed while reading from a log file.

Fix

Flush relay logs and restart replication from a clean position

Flush relay logs and restart replication from a clean position
STOP SLAVE;
RESET SLAVE;
START SLAVE;

Why this works

Discards the corrupted relay log and re-fetches events from the master.

What not to do

Sources
Official documentation ↗

MySQL 8.0 — 1744 ER_BINLOG_READ_EVENT_CHECKSUM_FAILURE

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors