Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Cannot Reproduce
-
10.6.5
-
Operating system: openSUSE Tumbleweed
Mariadb version: 10.6.5
Kernel version: 5.10.80
Description
SLAVE replication breaks with mariadb master running on version 10.6.5
We recently updated our mariadb master from 10.5.10 to 10.6.5 and since then started experiencing some random replication failure on our slave nodes.
However Slave nodes running version 10.6.5 but replicating to older 10.5.10 mariadb master works just fine.
Replication breaks around 4 times now (exactly at a binlog offset position 4) since the last 5 days after upgrading master to version 10.6.5.
In case it helps: We have multiple clients connecting to the master node and experiencing similar problem.
Logs during two such incidents as below:
2021-12-09 19:16:23 3399833 [ERROR] Read invalid event from master: 'Found invalid event in binary log', master could be corrupt but a more likely cause of this is a bug
2021-12-09 19:16:23 3399833 [ERROR] Slave I/O: Relay log write failure: could not queue event from master, Internal MariaDB error code: 1595
2021-12-09 19:16:23 3399833 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000004', position 4, master xxxx:3306
2021-12-13 14:00:34 4 [ERROR] Read invalid event from master: 'Found invalid event in binary log', master could be corrupt but a more likely cause of this is a bug
2021-12-13 14:00:34 4 [ERROR] Slave I/O: Relay log write failure: could not queue event from master, Internal MariaDB error code: 1595
2021-12-13 14:00:34 4 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000121', position 4, master xxxx:3306
Affected Mariadb version on master : 10.6.5
——
- MASTER configuration
[mysqld]
log-bin=mysql-bin
log-slave-updates
binlog-format=STATEMENT
expire_logs_days=3
Kindly request your support here !! Thanks in advance!