- 论坛徽章:
- 6
|
| 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 |
就楼主来将就是1062错误
请楼主不要将程序往slave的DB中有写操作.表类型如果是innodb的话,在mysql服务重起时,会偶尔出现这样的现象,在my.cnf加入跳过1062就OK了. |
|