Shulou(Shulou.com)06/01 Report--

Last_SQL_Errno: 1062

Last_SQL_Error: Error 'Duplicate entry '54755' for key 'PRIMARY'' on query. Default database: 'zabbix'. Query: 'INSERT INTO auditlog (userid,clock,ip,action,resourcetype,resourceid,resourcename,auditid) VALUES ('28','1510843124','60.27.136.153','3','0','28','','54755')'

After I set up the slave library, the slave library alarms 1062, as shown above:

Solution 1:

>stop slave sql_thread;

>set global sql_slave_skip_counter=1;

>start slave sql_thread;

But skipping an error will continue to report the next error.

Solution 2:

>stop slave;

#service mysqld stop

#vim /etc/my.cnf

[mysqld]

slave_skip_errors=1062 //Add this line to mysqld. 1062 is skipped.

Solution 3 Change the binlog_format of the slave library to match the master library:

The binlog format of the master library is mixed

#vim /etc/my.cnf

binlog_format=MIXED

Comment out slave_skip_errors=1062 in Solution 2.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.