I've a strange problem. A Mariadb replication start failing since this morning. Until today everything works fine from month.
This is my scenario: I've a server in a DC which is the master, and a server in another DC (slave) Mysql port on master is open only for the slave network. Since this morning i've the error:
2023-04-27 11:34:06 484086 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.003150' at position 48850240
2023-04-27 11:34:08 484086 [ERROR] Slave IO thread did not receive an expected Rows-log end-of-statement for event starting at log 'mysql-bin.003150' position 9686234 whose last block was seen at log 'mysql-bin.003150' position 48833684. The end-of-statement should have been delivered before the current one at log 'mysql-bin.003150' position 48850240
2023-04-27 11:34:08 484086 [ERROR] Slave I/O: Relay log write failure: could not queue event from master, Internal MariaDB error code: 1595
2023-04-27 11:34:08 484086 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.003150', position 48850240
Stopped the Mysql slave, start slave and everything works fine for another X time (half an hour, one hour it's quite random)
When I checked with mysqlbinlog I've this output:
/!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1/;
/!40019 SET @@session.max_insert_delayed_threads=0/;
/!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0/;
DELIMITER /!/;
mysqlbinlog: File 'mysqld-relay-bin.001306' not found (Errcode: 2 "No such file or directory")
or when I get a real error:
mysqlbinlog: unknown variable 'default-character-set=utf8mb4'
Now the second one I've fixed (I hope!) by adding: [client] loose-default-character-set=utf8mb4
Mariadb version is the same on both master and slave: Ver 15.1 Distrib 10.5.18-MariaDB
I don't know what else i can try. Does anyone have a hint?
