Re: Error: 1062 Duplicate Entry '252' for key 1
From: Mike Mapsnac [EMAIL PROTECTED] The slave server stop working today and I looked to the error log and the the error message is Error: 1062 Duplicate Entry '252' for key 1 And than it shows the query and time when it happens. My question is why no error messages on master server just on slave server? Obviously the query the master did not cause an error. As I understand , all queries run on master server and than on slave server. Both servers mysql 4.1 (Red Hat). Why the problem exist on slave server only? The replication mechanism is currently only one way: from master to slave. So if someone has performed an insert on the slave instead of the master then this could explain why the insert on the master succeeded and the insert on the slave failed. Give the users on the slave databases the appropriate rights (no insert, delete, create, etc.) to prevent this. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error: 1062 Duplicate Entry '252' for key 1
Thanks for explanation. But I don't insert anything at all to the SLAVE. It is 100%. Can the problem be problem be relative to Mysql 4.0.13 ? Thanks From: Jigal van Hemert [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Error: 1062 Duplicate Entry '252' for key 1 Date: Thu, 29 Jan 2004 14:32:51 +0100 From: Mike Mapsnac [EMAIL PROTECTED] The slave server stop working today and I looked to the error log and the the error message is Error: 1062 Duplicate Entry '252' for key 1 And than it shows the query and time when it happens. My question is why no error messages on master server just on slave server? Obviously the query the master did not cause an error. As I understand , all queries run on master server and than on slave server. Both servers mysql 4.1 (Red Hat). Why the problem exist on slave server only? The replication mechanism is currently only one way: from master to slave. So if someone has performed an insert on the slave instead of the master then this could explain why the insert on the master succeeded and the insert on the slave failed. Give the users on the slave databases the appropriate rights (no insert, delete, create, etc.) to prevent this. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Check out the new MSN 9 Dial-up fast reliable Internet access with prime features! http://join.msn.com/?pgmarket=en-uspage=dialup/homeST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error: 1062 Duplicate Entry '252' for key 1
From: Mike Mapsnac [mailto:[EMAIL PROTECTED] Thanks for explanation. But I don't insert anything at all to the SLAVE. It is 100%. Can the problem be problem be relative to Mysql 4.0.13 ? Thanks Out of curiosity, what's the data type of this column? -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error: 1062 Duplicate Entry '252' for key 1
Can this problem be relative to the problem with auto_increment value? Sometimes auto_increment value skips next value in insert. | 261149 | 2004-01-29 16:19:53 | | 261151 | 2004-01-29 16:20:47 | | 261152 | 2004-01-29 16:21:36 | | 261154 | 2004-01-29 16:22:47 | | 261157 | 2004-01-29 16:23:43 | Thanks From: Jigal van Hemert [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Error: 1062 Duplicate Entry '252' for key 1 Date: Thu, 29 Jan 2004 14:32:51 +0100 From: Mike Mapsnac [EMAIL PROTECTED] The slave server stop working today and I looked to the error log and the the error message is Error: 1062 Duplicate Entry '252' for key 1 And than it shows the query and time when it happens. My question is why no error messages on master server just on slave server? Obviously the query the master did not cause an error. As I understand , all queries run on master server and than on slave server. Both servers mysql 4.1 (Red Hat). Why the problem exist on slave server only? The replication mechanism is currently only one way: from master to slave. So if someone has performed an insert on the slave instead of the master then this could explain why the insert on the master succeeded and the insert on the slave failed. Give the users on the slave databases the appropriate rights (no insert, delete, create, etc.) to prevent this. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Get a FREE online virus check for your PC here, from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
