最新国产好看的视频,伊人天堂AV在线,国产Aaaaaa视频,蜜臀视频在线观看一区,人妻av色图,密臀久久久精品影片,青青视频免费观看毛片,久草在线观看视,国产三级精品色情在线

MySQL5.1主從同步出現Relay log read failure錯誤解決方法

 更新時間:2014年07月22日 11:16:27   投稿:junjie  
這篇文章主要介紹了MySQL5.1主從同步出現Relay log read failure錯誤解決方法,需要的朋友可以參考下

眾所周知MySQL5.1的Replication是比較爛的。MySQL的每一個版本更新關于同步方面每次都是可以看到一大堆。但MySQL 5.1性能是比較突出的。所以經不住誘惑使用MySQL 5.1。所以也要經常遇到一些Bug。如:

復制代碼 代碼如下:

mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.10.118
                  Master_User: repl_wu
                  Master_Port: 3306
                Connect_Retry: 30
              Master_Log_File: mysql-bin.005121
          Read_Master_Log_Pos: 64337286
               Relay_Log_File: relay-bin.003995
                Relay_Log_Pos: 18446697137031827760
        Relay_Master_Log_File: mysql-bin.005121
             Slave_IO_Running: Yes
            Slave_SQL_Running: No
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 1594
                   Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 4
              Relay_Log_Space: 64337901
              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: 0
                Last_IO_Error:
               Last_SQL_Errno: 1594
               Last_SQL_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
1 row in set (0.00 sec)

從上面可以看到是中繼日值或是Master上的日值出問題了。

首先如果是中繼日值壞掉,那只需要找到同步的時間點,然后重新同步,這樣就可以有新的中繼日值了。如果Master上的日值壞了就麻煩了。

從經驗來看,這是中繼日值出問題了。處理方法:

需要找到同步的點。

日值為:Master_Log_File: mysql-bin.005121,Relay_Master_Log_File: mysql-bin.005121以Relay_Master_Log_File為準,Master_Log_File為參考。

日值執(zhí)行時間點:

復制代碼 代碼如下:
Exec_Master_Log_Pos: 4

那么現在就可以:

復制代碼 代碼如下:

mysql>stop slave;
 
mysql>change master to Master_Log_File='mysql-bin.005121', Master_Log_Pos=4;
  
mysql>start slave;
 
mysql>show slave status\G;

進行確認。

建議:

在使用MySQL-5.1.36以下的版本的同學,請盡快升級到MySQL-5.1.40 & MySQL-5.1.37sp1

相關文章

最新評論

安岳县| 宁都县| 康保县| 南昌县| 黑水县| 万年县| 安康市| 泰兴市| 庆元县| 金坛市| 雷州市| 黄石市| 井陉县| 凤山县| 庆城县| 得荣县| 巴彦县| 仙游县| 江川县| 新巴尔虎右旗| 邵阳市| 灵台县| 台州市| 昭通市| 什邡市| 普宁市| 茂名市| 海林市| 金川县| 宜兴市| 涞水县| 故城县| 台江县| 南充市| 晋州市| 海宁市| 遵义县| 土默特右旗| 崇礼县| 宁都县| 鄢陵县|