[MDEV-32179] Slave I/O: Replication event checksum verification failed while reading from network, Internal MariaDB error code: 1743 Created: 2023-09-15  Updated: 2023-10-16  Resolved: 2023-10-16

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.7
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: mansi dadheech Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

Master-Slave Replication between 3 nodes. Have 2 Masters and 1 Slave in MMM cluster.

[root@DB2~]# cat /etc/os-release
NAME="Red Hat Enterprise Linux"
VERSION="8.6 (Ootpa)"
ID="rhel"
ID_LIKE="fedora"
VERSION_ID="8.6"
PLATFORM_ID="platform:el8"
PRETTY_NAME="Red Hat Enterprise Linux 8.6 (Ootpa)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:redhat:enterprise_linux:8::baseos"
HOME_URL="https://www.redhat.com/"
DOCUMENTATION_URL="https://access.redhat.com/documentation/red_hat_enterprise_linux/8/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"

REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 8"
REDHAT_BUGZILLA_PRODUCT_VERSION=8.6
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="8.6"

[root@DB2~]# free -mh
total used free shared buff/cache available
Mem: 503Gi 82Gi 409Gi 2.0Mi 11Gi 417Gi
Swap: 31Gi 0B 31Gi

Disk:
/dev/mapper/rhel-var ext4 5.7T 1.2T 4.2T 22% /var

Attachments: Text File DB1my.cnf.txt    

 Description   

Our environment has three DB replication cluster including 2 master nodes and 1 slave. [When writer points to 1st database 2nd one will behave like a slave].

Replication was up and running, and suddenly slave IO got stopped with the following logs:

2023-09-15  0:25:33 0 [Note] InnoDB: Buffer pool(s) load completed at 230915  0:25:33
 
2023-09-15  3:17:09 9 [ERROR] Slave I/O: Replication event checksum verification failed while reading from network, Internal MariaDB error code: 1743
 
2023-09-15  3:17:09 9 [ERROR] Slave I/O: Relay log write failure: could not queue event from master, Internal MariaDB error code: 1595
 
2023-09-15  3:17:09 9 [Note] Slave I/O thread exiting, read up to log 'db1-binary.003668', position 68457187, master 10.76.24.71:3306



 Comments   
Comment by Sergei Golubchik [ 2023-09-17 ]

Is it possible for you to try a more recent MariaDb version - (10.7 is EOL) ?

Generated at Thu Feb 08 10:29:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.