【求助】求救啊-Mysql Master/Slave自动复制故障!
我有两台服务都安装了相同版本的Mysql 4.0.17,一本做成Master,另一做成slave,好让Slave可以自动的Replication 数据库,我经常在slave上用show slave status 时,显示如下。
| ma-db1.wx.beltongrp.com | repl | 3306 | 30 | ma-db1-bin.051 | 106834794 | ma-db2-relay-bin.002 | 1058337 | ma-db1-bin.002 | Yes | No | | | 1062 | Error 'Duplicate entry '2014' for key 1' on query 'INSERT INTO `spc_solder_Paste_C1` (`pn`, `line`, `date`, `time`, `en`, `fixture`, `solder_ht1`, `solder_ht2`, `solder_ht3`, `solder_ht4`, `avg`, `range`, `action`) VALUES ('C1', 'LINE1-1', {d '2005-07-01'}, {t '23:10:13'}, 'L01346', 'C1 NO.2', .0042, .0035, .0038, .004, .00388, .0007, 'N02001')'. Default database: 'spc' | 0 | 1058180 | 11461514133 |
就算把这条记录从表中删除,又会有N多这样的数据重复的提示。让数据库自动复制停下来。请教各位大侠,我应该如何解决这个问题啊?