title: Mysql error 1236 from master when reading data from binary log
body: <p>I have 2 MySql with a master/slave configuration and the replication is failing. The MySql Master crashed and a new register in the <strong>mysql-bin.index</strong> was created. I deleted this new register because this file was not existed in the file system. Then the MySql Master restarted successfully.</p>
  
  <p>Now, I have the next error in the slave:</p>
  
  <pre><code>mysql&gt; show slave status \G
  *************************** 1. row ***************************
             Slave_IO_State: 
                Master_Host: 10.64.253.99
                Master_User: replication
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: mysql-bin.001050
        Read_Master_Log_Pos: 54868051
             Relay_Log_File: mysqld-relay-bin.000001
              Relay_Log_Pos: 4
      Relay_Master_Log_File: mysql-bin.001050
           Slave_IO_Running: No
          Slave_SQL_Running: Yes
            Replicate_Do_DB: 
        Replicate_Ignore_DB: 
         Replicate_Do_Table: 
     Replicate_Ignore_Table: 
    Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                 Last_Errno: 0
                 Last_Error: 
               Skip_Counter: 0
        Exec_Master_Log_Pos: 54868051
            Relay_Log_Space: 107
            Until_Condition: None
             Until_Log_File: 
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File: 
         Master_SSL_CA_Path: 
            Master_SSL_Cert: 
          Master_SSL_Cipher: 
             Master_SSL_Key: 
      Seconds_Behind_Master: NULL
  Master_SSL_Verify_Server_Cert: No
              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'
             Last_SQL_Errno: 0
             Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
           Master_Server_Id: 1
  </code></pre>
  
  <p>If I execute the "show master status" for view the mysql bin log file and the position:</p>
  
  <pre><code>mysql&gt; show master status \G
  *************************** 1. row ***************************
              File: mysql-bin.001050
          Position: 55586895
      Binlog_Do_DB: aaa
   Binlog_Ignore_DB: xxx,yyy,zzz,mysql
  </code></pre>
  
  <p>Then I set new config to the slave:</p>
  
  <pre><code>STOP SLAVE;
  CHANGE MASTER TO 
      MASTER_HOST='10.64.253.99',
      MASTER_USER='slaveUser',
      MASTER_PASSWORD='12345',
      MASTER_LOG_FILE='mysql-bin.001050', 
      MASTER_LOG_POS=55586895;
  START SLAVE;
  </code></pre>
  
  <p>And if I check slave status again I have the same error:</p>
  
  <pre><code>mysql&gt; show slave status \G
  *************************** 1. row ***************************
             Slave_IO_State: 
                Master_Host: 10.64.253.99
                Master_User: replication
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: mysql-bin.001050
        Read_Master_Log_Pos: 55586895
             Relay_Log_File: mysqld-relay-bin.000001
              Relay_Log_Pos: 4
      Relay_Master_Log_File: mysql-bin.001050
           Slave_IO_Running: No
          Slave_SQL_Running: Yes
            Replicate_Do_DB: 
        Replicate_Ignore_DB: 
         Replicate_Do_Table: 
     Replicate_Ignore_Table: 
    Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                 Last_Errno: 0
                 Last_Error: 
               Skip_Counter: 0
        Exec_Master_Log_Pos: 55586895
            Relay_Log_Space: 107
            Until_Condition: None
             Until_Log_File: 
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File: 
         Master_SSL_CA_Path: 
            Master_SSL_Cert: 
          Master_SSL_Cipher: 
             Master_SSL_Key: 
      Seconds_Behind_Master: NULL
  Master_SSL_Verify_Server_Cert: No
              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'
             Last_SQL_Errno: 0
             Last_SQL_Error: 
   Replicate_Ignore_Server_Ids: 
           Master_Server_Id: 1
  </code></pre>
  
  <p>I have checked in the MySql Master that the mysql-bin.001050 exist and is not empty.</p>
  
  <p>This is a production environment then new data are inserted every minute. The position value can to change in minutes or seconds. I don't know if this is a problem.</p>
  
  <p>The max_allowed_packet variable has the same value in the two MySql (16M).</p>
  
  <p>Why can not the slave find the binary log file?</p>