mysql> select fid,tid,subject,dateline from A where dateline='133
3127754';
+-----+---------+-----------------------------+------------+
| fid | tid | subject | dateline |
+-----+---------+-----------------------------+------------+
| 16 | 2304652 | 概述专门 | 1333127755 |
+-----+---------+-----------------------------+------------+
1 row in set (0.00 sec)mysql> select fid,tid,subject,dateline from A where dateline='133
3127755';
+-----+---------+-----------------------------+------------+
| fid | tid | subject | dateline |
+-----+---------+-----------------------------+------------+
| 16 | 2304652 | 概述专门 | 1333127755 |
+-----+---------+-----------------------------+------------+
1 row in set (0.00 sec)
为什么出现这样的情况,现在从的同步不了,怎么解决?
3127754';
+-----+---------+-----------------------------+------------+
| fid | tid | subject | dateline |
+-----+---------+-----------------------------+------------+
| 16 | 2304652 | 概述专门 | 1333127755 |
+-----+---------+-----------------------------+------------+
1 row in set (0.00 sec)mysql> select fid,tid,subject,dateline from A where dateline='133
3127755';
+-----+---------+-----------------------------+------------+
| fid | tid | subject | dateline |
+-----+---------+-----------------------------+------------+
| 16 | 2304652 | 概述专门 | 1333127755 |
+-----+---------+-----------------------------+------------+
1 row in set (0.00 sec)
为什么出现这样的情况,现在从的同步不了,怎么解决?
同步不了的错误是如下:
Last_SQL_Error: Error 'Duplicate entry '1333127754' for key 'dateline'我以为是有重复,于是就做了下dateline的更新'1333127754' 更新为 '1333127755'
那为什么查询'1333127754' 可以查到数据呢?
主要是两个问题:第一个是为什么出现这种奇怪的查询问题;另外一个就是怎么解决同步错误的问题
3127754';
+-----+---------+-----------------------------+------------+
| fid | tid | subject | dateline |
+-----+---------+-----------------------------+------------+
| 16 | 2304652 | 概述专门 | 1333127755 |
+-----+---------+-----------------------------+------------+
1 row in set (0.00 sec)mysql> select fid,tid,subject,dateline from A where dateline='133
3127755';
+-----+---------+-----------------------------+------------+
| fid | tid | subject | dateline |
+-----+---------+-----------------------------+------------+
| 16 | 2304652 | 概述专门| 1333127755 |
+-----+---------+-----------------------------+------------+
1 row in set (0.00 sec)mysql> select fid,tid,subject,dateline from A where tid=2304652;
+-----+---------+-----------------------------+------------+
| fid | tid | subject | dateline |
+-----+---------+-----------------------------+------------+
| 16 | 2304652 | 概述专门 | 1333127755 |
+-----+---------+-----------------------------+------------+
1 row in set (0.00 sec)这是神马情况,我疯了,拷贝数据库太大了,现在寻求同步的解决方法
别加单引号 用手打下那个数字1333127754另外一个就是怎么解决同步错误的问题
跳过错误 stop slave;set global sql_slave_skip_count=1;start slave;