|
|
mm配置 ，配置如下
主1：
[root@BJ-ROLEDB-JY data]# uname -a
Linux BJ-ROLEDB-JY 2.6.18-194.32.1.el5 #1 SMP Wed Jan 5 17:52:25 EST 2011 x86_64 x86_64 x86_64 GNU/Linux
主2：
[root@BJ-ROLEDB-JY-SLAVE ~]# uname -a
Linux BJ-ROLEDB-JY-SLAVE 2.6.18-194.el5 #1 SMP Fri Apr 2 14:58:14 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
主1接应用，主2，做standby
Server version: 5.5.15-log Source distribution
主1的error log:
111029 0:44:23 [Note] Start binlog_dump to slave_server(7), pos(mysql-bin.000594, 44631974)
111029 12:30:40 [Note] Start binlog_dump to slave_server(7), pos(mysql-bin.000617, 11863737)
111029 12:40:44 [Note] Start binlog_dump to slave_server(7), pos(mysql-bin.000617, 11863828)
111029 12:46:45 [Note] Start binlog_dump to slave_server(7), pos(mysql-bin.000617, 11863828)
111029 12:52:46 [Note] Start binlog_dump to slave_server(7), pos(mysql-bin.000617, 11863828)
111029 12:58:50 [Note] Start binlog_dump to slave_server(7), pos(mysql-bin.000617, 11863828)
111029 13:04:53 [Note] Start binlog_dump to slave_server(7), pos(mysql-bin.000617, 11863828)
111029 13:10:57 [Note] Start binlog_dump to slave_server(7), pos(mysql-bin.000617, 11863828)
111029 13:20:43 [Note] Start binlog_dump to slave_server(7), pos(mysql-bin.000617, 11863828)
111030 16:06:59 [Note] Start binlog_dump to slave_server(7), pos(mysql-bin.000673, 98153952)
主2的error log:
111029 0:41:36 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
111029 0:41:36 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000594' at position 44631974
111029 12:27:52 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
111029 12:27:52 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000617' at position 11863737
111029 12:37:53 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
111029 12:37:53 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000617' at position 11863828
111029 12:42:57 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
111029 12:43:57 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000617' at position 11863828
111029 12:48:58 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
111029 12:49:58 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000617' at position 11863828
111029 12:54:59 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
111029 12:55:59 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000617' at position 11863828
111029 13:01:03 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
111029 13:02:03 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000617' at position 11863828
111029 13:07:06 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
111029 13:08:06 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000617' at position 11863828
111029 13:16:55 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
111029 13:17:55 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000617' at position 11863828
111029 14:13:38 [Note] Start binlog_dump to slave_server(1), pos(mysql-bin.000001, 5035927)
111030 16:04:10 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
111030 16:04:10 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000673' at position 98153952
我在两边show slave status都正常。
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 116.213.130.171
Master_User: rep
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000699
Read_Master_Log_Pos: 76440653
Relay_Log_File: mysqld-relay-bin.002097
Relay_Log_Pos: 76440799
Relay_Master_Log_File: mysql-bin.000699
Slave_IO_Running: Yes
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: 76440653
Relay_Log_Space: 181298831
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: 0
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)
然后mysqlbinlog有错误的位置：
[root@BJ-ROLEDB-JY data]# mysqlbinlog mysql-bin.000617 --start-position=11863737 --stop-position=11863828
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#111029 12:19:57 server id 1 end_log_pos 107 Start: binlog v 4, server v 5.5.15-log created 111029 12:19:57
BINLOG '
7X6rTg8BAAAAZwAAAGsAAAAAAAQANS41LjE1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==
'/*!*/;
# at 11863737
#111029 12:24:05 server id 1 end_log_pos 11863828 Query thread_id=543 exec_time=0 error_code=0
SET TIMESTAMP=1319862245/*!*/;
SET @@session.pseudo_thread_id=543/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=2097152/*!*/;
SET @@session.auto_increment_increment=2, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;
SET @@session.time_zone='SYSTEM'/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
BEGIN
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
在另外一台测试机子上应用：
mysql> source b
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Charset changed
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
没问题。
请问大大们，这个是bug吗？
三思老大的blog里面有一篇也是有关server_errno=2013的文章，但是他那个场景是断电发生的，我这个是在一切运行ok的情况下产生的，而且还没有一点副作用，请问这是神马情况？求解
|
|
IP卡
狗仔卡
发表于 2011-10-31 10:19
收藏
提升卡
置顶卡
变色卡
显身卡
楼主