Sample Header Ad - 728x90

SOLVED - Mariadb replication Master Slave fail with error code 1595

2 votes
0 answers
1626 views
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?
Asked by Paolo Daniele (21 rep)
Apr 27, 2023, 02:34 PM
Last activity: Sep 8, 2023, 04:37 PM