Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file n...

最新推荐文章于 2024-05-17 15:28:22 发布

转载最新推荐文章于 2024-05-17 15:28:22 发布 · 1k 阅读

本文记录了一次从备份恢复MySQL从服务器过程中遇到的错误1236，详细展示了错误发生时的二进制日志位置及从服务器配置。通过展示master与slave的日志状态对比，帮助读者理解此错误的背景与可能原因。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

setup slave from backup i got 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'

MASTER

MariaDB [(none)]> SHOW BINLOG EVENTS IN 'mysqld-bin.140180' FROM 101070557 LIMIT 4;

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

| Log_name          | Pos       | Event_type     | Server_id | End_log_pos | Info                                  |

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

| mysqld-bin.140180 | 101070557 | Gtid           |         7 |   101070595 | BEGIN GTID 0-7-8640143404             |

| mysqld-bin.140180 | 101070595 | Table_map      |         7 |   101070647 | table_id: 4446293 (dating.users_hits) |

| mysqld-bin.140180 | 101070647 | Update_rows_v1 |         7 |   101070695 | table_id: 4446293 flags: STMT_END_F   |

| mysqld-bin.140180 | 101070695 | Query          |         7 |   101070778 | COMMIT                                |

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

4 rows in set (0.00 sec)

MariaDB [(none)]> show binary logs ;

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

| Log_name          | File_size  |

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

| mysqld-bin.140100 |  134219175 |

...

| mysqld-bin.140180 |  134217853 |

| mysqld-bin.140181 |  134232575 |

| mysqld-bin.140182 |  134229889 |

...

| mysqld-bin.140570 |   46141034 |

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

547 rows in set (0.00 sec)

#>for f in $(cat mysqld-bin.index); do test -f $f || echo "Not found $f" ; done;

<no output>

#>head mysqld-bin.index

./mysqld-bin.140100

./mysqld-bin.140101

./mysqld-bin.140102

./mysqld-bin.140103

./mysqld-bin.140104

./mysqld-bin.140105

./mysqld-bin.140106

./mysqld-bin.140107

./mysqld-bin.140108

./mysqld-bin.140109

SLAVE

MariaDB [(none)]> change master to master_host='10.8.2.31', master_user='replica', master_password='', master_log_file='mysqld-bin.140180 ', master_log_pos=101070557;

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> start slave IO_THREAD;

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show slave status\G

*************************** 1. row ***************************

               Slave_IO_State:

                  Master_Host: 10.8.2.31

                  Master_User: replica

                  Master_Port: 3306

                Connect_Retry: 60

              Master_Log_File: mysqld-bin.140180

          Read_Master_Log_Pos: 101070557

               Relay_Log_File: relay-bin.000001

                Relay_Log_Pos: 4

        Relay_Master_Log_File: mysqld-bin.140180

             Slave_IO_Running: No

            Slave_SQL_Running: No

...

          Exec_Master_Log_Pos: 101070557

...

                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'

160330 15:18:42 [Note] Slave SQL thread initialized, starting replication in log 'mysqld-bin.140180 ' at position 101070557, relay log './relay-bin.000001' position: 4

160330 15:18:42 [Note] Slave I/O thread: connected to master 'replica@10.8.2.31:3306',replication started in log 'mysqld-bin.140180 ' at position 101070557

160330 15:18:42 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)

160330 15:18:42 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file', Internal MariaDB error code: 1236

160330 15:18:42 [Note] Slave I/O thread exiting, read up to log 'mysqld-bin.140180 ', position 10