The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Replication error : Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'

Hello I use mariadb 10.3.36-MariaDB-log MariaDB Server I have issue with replication : In slave : MariaDB [(none)]> show slave status\G; ***** 1. row ***** Slave_IO_State: Master_Host: 10.112.82.9 Master_User: replicator Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000014 Read_Master_Log_Pos: 1007959758 Relay_Log_File: sld1dblag02t-relay-bin.000049 Relay_Log_Pos: 4 Relay_Master_Log_File: mysql-bin.000014 Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'

MariaDB [(none)]> SHOW BINARY LOGS; +------------------+-----------+

Log_nameFile_size

+------------------+-----------+

mysql-bin.00000811126
mysql-bin.000009381
mysql-bin.000010381
mysql-bin.000011129134

+------------------+-----------+ in data_dir location on slave I didn't found file mysql-bin.000014, Can You help me how can I resolve it and restart replication pls

thank You Brano

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.