Slave I/O Replication event checksum verification failed while reading from network internal mariadb error 1743
Slave I/O Relay log write failure:could not queue event from master, internal mariadb error :1595
Please help
Hello @Engineer,
Have you tried restarting replication? ‘Checksum failed’ could have been the result of a network packet loss or similar issue. You can also stop replication, and purge out the current relay logs by using ‘RESET SLAVE’ then start replication again. This will fetch fresh data from the upstream source and create new replica logs.
1 Like
i issued reset slave and start slave I got this error
An attempt was made to binlog GTID 0-210001-4463101598 which would create an out of order sequence number with existing
GTID 0-210001-4506648507 , and gtid strict mode is enables
@matthewb please help
1 Like
Your GTIDs got messed up somehow with that failed checksum. You’ll need to reset the replica and reset the gtid_purged before starting replication again.
1 Like
How do I achieve that ?
1 Like
How did you originally set up replication? You need to repeat that process.
1 Like