Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9838

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.24
    • N/A
    • Replication
    • None
    • CentOS release 6.4 (Final)
      2.6.32-358.11.1.el6.x86_64

    Description

      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 101070557
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            sitnikov@gmail.com Andrei Sitnikov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.