MySQL复制环境Slave报错"Got fatal error 1236 from master when reading data"

╰半夏微凉° 2024-04-18 01:28 120阅读 0赞

MySQL复制环境Slave节点报错  
mysql> show slave status\\G  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
               Slave\_IO\_State:   
                  Master\_Host: 10.20.30.10  
                  Master\_User: repl  
                  Master\_Port: 3306  
                Connect\_Retry: 60  
               Master\_Log\_File: mysql-bin.000008  
          Read\_Master\_Log\_Pos: 920  
               Relay\_Log\_File: mysqld-relay-bin.000018  
                Relay\_Log\_Pos: 4  
        Relay\_Master\_Log\_File: mysql-bin.000008  
             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: 920  
              Relay\_Log\_Space: 154  
              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  
                  Master\_UUID: 203fe772-177e-11e7-b15c-000c296b3b20  
             Master\_Info\_File: /mysql\_data\_57/master.info  
                    SQL\_Delay: 0  
          SQL\_Remaining\_Delay: NULL  
      Slave\_SQL\_Running\_State: Slave has read all relay log; waiting for more updates  
           Master\_Retry\_Count: 86400  
                  Master\_Bind:   
      Last\_IO\_Error\_Timestamp: 170624 17:03:05  
     Last\_SQL\_Error\_Timestamp:   
               Master\_SSL\_Crl:   
           Master\_SSL\_Crlpath:   
           Retrieved\_Gtid\_Set:   
            Executed\_Gtid\_Set:   
                Auto\_Position: 0  
         Replicate\_Rewrite\_DB:   
                 Channel\_Name:   
           Master\_TLS\_Version:   
1 row in set (0.00 sec)

在Master节点上查看二进制日志的位置  
 mysql> show master status;  
\+------------------+----------+--------------+------------------+-------------------+  
| File             | Position | Binlog\_Do\_DB | Binlog\_Ignore\_DB | Executed\_Gtid\_Set |  
\+------------------+----------+--------------+------------------+-------------------+  
| mysql-bin.000011 |     1734 |              |                  |                   |  
\+------------------+----------+--------------+------------------+-------------------+  
1 row in set (0.00 sec)

解决方法：   
除非主库有二进制日志备份，否则需要重建Slave节点

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2141222/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2141222/