Hi,
This is because direct inserts are being pointed to one of the slave (or)
you have taken the dump from the master in which when you try to restore
it and start replication you will have to start from the master position
what u have noted. In such case you might get this error to ignore this
you can start your mysql with skip-slave-error=1062 in such case these
duplicates will not repeat.
Thanks & Regards
Dilipkumar
----- Original Message -----
From: "David Hillman" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, July 26, 2006 12:34 AM
Subject: Re: Slave Replication issues
On Jul 25, 2006, at 12:47 PM, David Nance wrote:
Hi, we have been losing slaves due to errors in replication. See error
message below. Would appreciate if anyone could share if they have
seen same
issues. It seems something may be getting corrupted in the binary log.
Thanks.
The error reads:
Last_error: Error 'Duplicate entry '12312942' for key 1' on query
'INSERT
INTO permissions (user_id, journal_id, date_granted, start_date,
end_date,
type) VALUES ('1503443', '94', NOW(), '0000-00-00 00:00:00',
'0000-00-00
00:00:00', 'author')'. Default database: 'manuscript_central_1_1'
One of the indexes on your 'permissions' table in defined to be
'unique', and your application is trying to insert a row with a
duplicate value. This doesn't seem like a replication error, unless
there really isn't a unique index on permissions... but I bet there is.
--
David Hillman
LiveText, Inc
1.866.LiveText x235
********** DISCLAIMER **********
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or entity to
which it is addressed, and may contain information that is privileged,
confidential or exempt from disclosure under applicable law. If this is a
forwarded message, the content of this E-MAIL may not have been sent with
the authority of the Company. If you are not the intended recipient, an
agent of the intended recipient or a person responsible for delivering the
information to the named recipient, you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail & notify us
immediately at [EMAIL PROTECTED]
Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in
Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
