Board logo

标题: MySQL主从同步主键重复Duplicate entry手动解决 [打印本页]

作者: shillan    时间: 2016-4-27 01:50     标题: MySQL主从同步主键重复Duplicate entry手动解决

现象:从机状态:
Slave_IO_Running: Yes
Slave_SQL_Running: No

报类似如下错误:
Last_SQL_Error: Error 'Duplicate entry '144654' for key 'PRIMARY'' on query. Default database: 'x4j'. Query: 'INSERT INTO mac_user_visit (uv_uid,uv_ip,uv_ly,uv_time) VALUES('80','-1347584867','','1461546069')'

Last_SQL_Error: Error 'Duplicate entry '27575' for key 'PRIMARY'' on query. Default database: 'x4j'. Query: 'INSERT INTO mac_user (u_name,u_qid,u_password,u_qq,u_email,u_regtime,u_status,u_points,u_group,u_phone,u_question,u_answer) VALUES('丶4','67F89C8D94396EEAD8D3A6807A5D1147','a41d8cd98f00b204c9800998ecf8427b','','','1461561325','1','1','1','','','')'


解决:
  1. mysql>set global sql_slave_skip_counter=1;
  2. mysql>start slave;
复制代码
上面的语句是告诉从库slave_sql线程让它忽略掉这个错误继续执行。




欢迎光临 逐梦论坛 (http://temp2023.zhumeng.org/) Powered by Discuz! 7.2