Mysql复制出现Lost connection to MySQL server during query

Question

外网服务器是复制的主服务器为:freebsd 8.0+mysql5.4
freebsd之间的复制很正常
但是在本地架设了个虚拟机想将公网的数据备份下来。 就出问题了。
问题出现的很奇怪。恢复到默认数据。启动复制是非常正常。
只要使用stop SLAVE然后再start slave就不行了。
日志里面总是出现：
100527 10:50:16 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
100527 10:50:26 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000002' at postion 105010796
100527 10:50:36 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
100527 10:50:46 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000002' at postion 105010796
100527 10:50:59 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
100527 10:51:09 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000002' at postion 105010796
100527 10:51:22 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
100527 10:51:32 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000002' at postion 105010796

Answer 1

mysql> show slave status\G;                                                                                                                                                                              
*************************** 1. row ***************************
               Slave_IO_State: Waiting to reconnect after a failed master event read
                  Master_Host: ***
                  Master_User: ***
                  Master_Port: 3306
                Connect_Retry: 10
              Master_Log_File: mysql-bin.000002
          Read_Master_Log_Pos: 105010796
               Relay_Log_File: www-relay-bin.000002
                Relay_Log_Pos: 4
        Relay_Master_Log_File: mysql-bin.000002
             Slave_IO_Running: Connecting
            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: 105010796
              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: 0
                Last_IO_Error: 
               Last_SQL_Errno: 0
               Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 1
1 row in set (0.00 sec)

Answer 2

虚拟机是：安装在XP下的 freebsd系统

Answer 3

master 还有mysql-bin.000002
这个日志文件么？没有了吧？

Answer 4

可能是网络问题,也可能是packet包主服务器和从服务器不一致!建议从服务器配置文件中添加以下配置(添加压缩+设置来和主服务器一致的packet大小)slave_compressed_protocol=true
max_allowed_packet = 64M

Answer 5

loveflea  
按照你的方式设置了.可是还是不管用.郁闷啊..

Answer 6

1. 真的是网络问题。
2. BUG.