主:
110417 18:05:46 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:10:47 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:15:48 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:20:49 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:25:49 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:30:50 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:35:51 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:40:51 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:50:28 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197529)
110417 18:55:28 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197529)
从:
110417 18:05:46 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:05:46 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:10:47 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:10:47 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:15:48 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:15:48 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:20:49 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:20:49 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:25:49 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:25:49 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:30:50 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:30:50 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:35:51 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:35:51 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:40:51 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:40:51 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:50:28 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:50:28 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197529
110417 18:55:28 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:55:28 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197529
能看出是网络问题么?或者MySQL的配置不对?
110417 18:05:46 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:10:47 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:15:48 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:20:49 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:25:49 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:30:50 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:35:51 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:40:51 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197237)
110417 18:50:28 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197529)
110417 18:55:28 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197529)
从:
110417 18:05:46 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:05:46 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:10:47 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:10:47 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:15:48 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:15:48 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:20:49 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:20:49 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:25:49 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:25:49 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:30:50 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:30:50 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:35:51 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:35:51 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:40:51 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:40:51 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197237
110417 18:50:28 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:50:28 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197529
110417 18:55:28 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110417 18:55:28 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at postion 23197529
能看出是网络问题么?或者MySQL的配置不对?
解决方案 »
- 在iframe 框,怎么能够让iframe 中的提示框在整个页面查看,而不是只是在那个框中
- PostgreSQL 时间的问题 100分
- [求助]一个关于考试成绩的SQL语句
- mysql数据库,查看和修改concurrent_insert的问题
- jsp連結資料庫更新問題
- 关于postgresql中的dblink.sql
- select 语句
- update 无法更新?请教,我是新手
- 如何更改数据库的端口~!~!?
- 导入sql文件时,提示[Err] 1146 - Table 'jieyuenew.cmjobcode' doesn't exist
- WEB系统操作一段时间就连接不上,数据库mysql
- 执行SHOW BINLOG EVENTS后报错,请教
包或任何生成的/中间字符串的最大大小。
包消息缓冲区初始化为net_buffer_length字节,但需要时可以增长到max_allowed_packet字节。该值默认很小,以捕获大的(可能是错误的)数据包。
如果你使用大的BLOB 列或长字符串,你必须增加该值。应同你想要使用的最大的BLOB一样大。max_allowed_packet的协议限制为1GB。
http://space.itpub.net/7607759/viewspace-683607
110417 18:50:28 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000001, 23197529)
110417 18:55:28 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
只需要关注ERR的信息。NOTE的不是错误,是提示信息而已。
110424 21:17:08 [Note] Start binlog_dump to slave_server(121281), pos(mysql-bin.000027, 723776392)
110424 21:17:08 [Note] Stop asynchronous binlog_dump to slave (server_id: 121281)
110424 21:17:08 [Note] Start asynchronous binlog_dump to slave (server_id: 121281), pos(mysql-bin.000027, 723776392)
110424 21:17:08 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110424 21:17:08 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000027' at postion 544212893
110424 21:23:07 [Note] Start binlog_dump to slave_server(121281), pos(mysql-bin.000027, 723776844)
110424 21:23:07 [Note] Start asynchronous binlog_dump to slave (server_id: 121281), pos(mysql-bin.000027, 723776844)
110424 21:23:07 [Note] Stop asynchronous binlog_dump to slave (server_id: 121281)
110424 21:45:11 [Note] Start binlog_dump to slave_server(121281), pos(mysql-bin.000027, 728535286)
110424 21:45:11 [Note] Stop asynchronous binlog_dump to slave (server_id: 121281)
110424 21:45:11 [Note] Start asynchronous binlog_dump to slave (server_id: 121281), pos(mysql-bin.000027, 728535286)
110424 21:47:06 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110424 21:47:06 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000027' at postion 549293649
[Server2]
110424 21:17:07 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110424 21:17:07 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000027' at postion 723776392
110424 21:17:08 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000027, 544212893)
110424 21:17:08 [Note] Stop asynchronous binlog_dump to slave (server_id: 121291)
110424 21:17:08 [Note] Start asynchronous binlog_dump to slave (server_id: 121291), pos(mysql-bin.000027, 544212893)
110424 21:23:07 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110424 21:23:07 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000027' at postion 723776844
110424 21:45:11 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
110424 21:45:11 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000027' at postion 728535286
110424 21:47:06 [Note] Start binlog_dump to slave_server(121291), pos(mysql-bin.000027, 549293649)
110424 21:47:06 [Note] Stop asynchronous binlog_dump to slave (server_id: 121291)
110424 21:47:06 [Note] Start asynchronous binlog_dump to slave (server_id: 121291), pos(mysql-bin.000027, 549293649)
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#110423 22:27:19 server id 1 end_log_pos 107 Start: binlog v 4, server v 5.5.11-log created 110423 22:27:19
# Warning: this binlog is either in use or was not closed properly.
BINLOG '
l5izTQ/L2QEAZwAAAGsAAAABAAQANS41LjExLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==
'/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;