# Why is this possible? **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [April 29, 2012, 10:33am UTC](https://forums.percona.com/t/why-is-this-possible/1805 "2012-04-29T10:33:17Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![esudnik](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@esudnik](https://forums.percona.com/u/esudnik)\ **Post date:** [April 29, 2012, 10:33am UTC](https://forums.percona.com/t/why-is-this-possible/1805/1 "2012-04-29T10:33:17Z")
“show slave status” shows following erros state: \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* Slave\_IO\_State: Waiting for master to send event Master\_Host: (hidden) Master\_User: replication Master\_Port: 3306 Connect\_Retry: 60 Master\_Log\_File: mysql-bin.000048 Read\_Master\_Log\_Pos: 658353090 Relay\_Log\_File: Ubuntu-1004-lucid-64-minimal-relay-bin.000170 Relay\_Log\_Pos: 5838 Relay\_Master\_Log\_File: mysql-bin.000048 Slave\_IO\_Running: Yes Slave\_SQL\_Running: Yes 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: Error ‘Duplicate entry ‘441569504’ for key ‘PRIMARY’’ on query. Default database: ‘serverstate’. Query: ‘INSERT INTO sensor\_check (ID,SENSOR\_ID,STATE\_CHANGED\_FLAG,RESPONSE\_TIME,DATE\_CREATED, CHECKPOINT\_ID,SUCCESSFUL\_FLAG,FAILURE\_REASON) VALUES (441569504,950754863,0,607,1335713457,3,1,0)’ Skip\_Counter: 1 Exec\_Master\_Log\_Pos: 656507841 Relay\_Log\_Space: 2004418 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: 0 Master\_SSL\_Verify\_Server\_Cert: No Last\_IO\_Errno: 0 Last\_IO\_Error: Last\_SQL\_Errno: 1062 Last\_SQL\_Error: Error ‘Duplicate entry ‘441569504’ for key ‘PRIMARY’’ on query. Default database: ‘serverstate’. Query: ‘INSERT INTO sensor\_check (ID,SENSOR\_ID,STATE\_CHANGED\_FLAG,RESPONSE\_TIME,DATE\_CREATED, CHECKPOINT\_ID,SUCCESSFUL\_FLAG,FAILURE\_REASON) VALUES (441569504,950754863,0,607,1335713457,3,1,0)’ 1 row in set (0.00 sec) …after 10 minutes without any change the “show slave status” shows folloing state: \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* Slave\_IO\_State: Waiting for master to send event Master\_Host: (hidden) Master\_User: replication Master\_Port: 3306 Connect\_Retry: 60 Master\_Log\_File: mysql-bin.000048 Read\_Master\_Log\_Pos: 658894508 Relay\_Log\_File: Ubuntu-1004-lucid-64-minimal-relay-bin.000886 Relay\_Log\_Pos: 537737 Relay\_Master\_Log\_File: mysql-bin.000048 Slave\_IO\_Running: Yes Slave\_SQL\_Running: Yes Replicate\_Do\_DB: Replicate\_Ignore\_DB: Replicate\_Do\_Table: Replicate\_Ignore\_Table: Replicate\_Wild\_Do\_Table: Replicate\_Wild\_Ignore\_Table: Last\_Errno: 0 Last\_Error: Skip\_Counter: 0 Exec\_Master\_Log\_Pos: 658894508 Relay\_Log\_Space: 537915 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: 0 Master\_SSL\_Verify\_Server\_Cert: No Last\_IO\_Errno: 0 Last\_IO\_Error: Last\_SQL\_Errno: 0 Last\_SQL\_Error: 1 row in set (0.00 sec) who is it possible?