Last_IO_Errno: 1062

落日映苍穹つ 2022-01-09 04:45 218阅读 0赞

主键冲突的错误 1062

模拟错误：

在主库上操作：

create table test100(id int not null,name varchar(20),primary key(id));

insert into test100 (id,name) values(100,'lianggj');

在从库上操作：

insert into test100 (id,name) values(200,'guo');

在主库上操作：

insert into test100 (id,name) values(200,'guo');

mysql> show slave status \\G;

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

Slave\_IO\_State: Waiting for master to send event

Master\_Host: 192.168.56.56

Master\_User: repl

Master\_Port: 3306

Connect\_Retry: 60

Master\_Log\_File: mysql-bin.000002

Read\_Master\_Log\_Pos: 955

Relay\_Log\_File: relay-bin.000006

Relay\_Log\_Pos: 897

Relay\_Master\_Log\_File: mysql-bin.000002

Slave\_IO\_Running: Yes

Slave\_SQL\_Running: No

Replicate\_Do\_DB:

Replicate\_Ignore\_DB:

Replicate\_Do\_Table:

Replicate\_Ignore\_Table:

Replicate\_Wild\_Do\_Table:

Replicate\_Wild\_Ignore\_Table:

Last\_Errno: 1062

Last\_Error: Could not execute Write\_rows event on table lgj3306.test100; Duplicate entry '200' for key 'PRIMARY', Error\_code: 1062; handler error HA\_ERR\_FOUND\_DUPP\_KEY; the event's master log mysql-bin.000002, end\_log\_pos 924

Skip\_Counter: 0

Exec\_Master\_Log\_Pos: 684

Relay\_Log\_Space: 1456

Until\_Condition: None

Until\_Log\_File:

Until\_Log\_Pos: 0

Master\_SSL\_Allowed: No

Master\_SSL\_CA\_File:

Master\_SSL\_CA\_Path:

Master\_SSL\_Cert:

Master\_SSL\_Cipher:

Master\_SSL\_Key:

Seconds\_Behind\_Master: NULL

Master\_SSL\_Verify\_Server\_Cert: No

Last\_IO\_Errno: 0

Last\_IO\_Error:

Last\_SQL\_Errno: 1062

Last\_SQL\_Error: Could not execute Write\_rows event on table lgj3306.test100; Duplicate entry '200' for key 'PRIMARY', Error\_code: 1062; handler error HA\_ERR\_FOUND\_DUPP\_KEY; the event's master log mysql-bin.000002, end\_log\_pos 924

Replicate\_Ignore\_Server\_Ids:

Master\_Server\_Id: 563306

Master\_UUID: 3c1ec304-e17d-11e6-9f17-080027746853

Master\_Info\_File: /data/mysql/3306/data/master.info

SQL\_Delay: 0

SQL\_Remaining\_Delay: NULL

Slave\_SQL\_Running\_State:

Master\_Retry\_Count: 86400

Master\_Bind:

Last\_IO\_Error\_Timestamp:

Last\_SQL\_Error\_Timestamp: 170124 12:26:56

Master\_SSL\_Crl: