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


    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 statusG
    *************************** 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
  • 相关阅读:
    学习zabbix(一)
    学习openstack(七)
    并不对劲的bzoj3677:p3647:[APIO2014]连珠线
    并不对劲的bzoj5415:loj2718:uoj393:p4768:[NOI2018]归程
    并不对劲的bzoj5475:loj2983:p5206:[wc2019]数树
    并不对劲的多项式求ln,exp
    并不对劲的bzoj1758:p4292:[WC2010]重建计划
    (中等) UESTC 94 Bracket Sequence,线段树+括号。
    (简单) HDU 5154 Harry and Magical Computer,图论。
    (中等) UESTC 360 Another LCIS ,线段树+区间更新。
  • 原文地址:https://www.cnblogs.com/weifeng1463/p/9673806.html
Copyright © 2020-2023  润新知