mysql数据库同步问题

netfoxs

有两个服务器，一个在电信机房，作为master，一个在网通机房，作为slave
之前都是好好的，近日发现数据突然无法同步了，进入服务器查看：

slave端看到如下：
mysql> SHOW PROCESSLIST\G
*************************** 1. row ***************************
     Id: 11
   User: system user
   Host:
     db: NULL
Command: Connect
   Time: 1185
  State: Waiting for master to send event
   Info: NULL
*************************** 2. row ***************************
     Id: 12
   User: system user
   Host:
     db: NULL
Command: Connect
   Time: 73228
  State: Has read all relay log; waiting for the slave I/O thread to update it
   Info: NULL

master端看到的：

mysql> SHOW PROCESSLIST\G
*************************** 1. row ***************************
     Id: 633
   User: rep
   Host: 61.162.230.16:32946
     db: NULL
Command: Binlog Dump
   Time: 219
  State: Writing to net
   Info: NULL

从这两个信息来看，问题应该是出在于master端，
但不知道是什么问题，该如何解决？

谢谢了！

lvscluster

你连  show slave status的信息都没拿出来.,  同步甚么鸟鬼啊. 还在那里凭空猜测.

netfoxs

mysql> show slave status;
+----------------------------------+---------------+-------------+-------------+---------------+------------------+---------------------+-----------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+
| Slave_IO_State                   | Master_Host   | Master_User | Master_Port | Connect_Retry | Master_Log_File  | Read_Master_Log_Pos | Relay_Log_File        | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Table | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno | Last_Error                                                                                                                                                                                               | Skip_Counter | Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | Until_Log_File | Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | Master_SSL_CA_Path | Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key | Seconds_Behind_Master |
+----------------------------------+---------------+-------------+-------------+---------------+------------------+---------------------+-----------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+
| Waiting for master to send event | 61.152.245.15 | rep         |        3306 |            60 | mysql-bin.000002 |              517410 | host-relay-bin.000002 |      17071610 | mysql-bin.000001      | Yes              | No                |                 |                     |                    |                        |                         |                             |       1062 | Error 'Duplicate entry '3278' for key 1' on query. Default database: 'hks3s'. Query: 'INSERT INTO `user_online` ( `uid` , `all_online` , `cur_online` , `online_jifen` ) VALUES ('3278', '0', '0', '0')' |            0 |            17426973 |        29535735 | None            |                |             0 | No                 |                    |                    |                 |                   |                |                  NULL |
+----------------------------------+---------------+-------------+-------------+---------------+------------------+---------------------+-----------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+
1 row in set (0.00 sec)


把hks3s这个数据库跳过就可以同步了

yejr

lz显然不看手册