Re: aha! replication breaking due to duplicate queries

2006-05-23 Thread balaraju mandala
Hi, yes, it is happening when ever some duplicates are loading replication is not moving further. I mean in my experirnce, i stoped my slave from replication for a while, and i forget the exact location where i stoped it. I resetted my binarylog to appropriate file, and position to 0, and starte

Re: aha! replication breaking due to duplicate queries

2006-05-22 Thread sheeri kritzer
As an addendum to this -- this was solved. The master and slave were out of sync. -Sheeri On 5/19/06, Jeremy Cole <[EMAIL PROTECTED]> wrote: Hi Sheeri, > So I've seen replication break a few times due to duplicate queries. > A few times it was around a server crashing, but I thought perhaps i

Re: aha! replication breaking due to duplicate queries

2006-05-19 Thread Jeremy Cole
Hi Sheeri, So I've seen replication break a few times due to duplicate queries. A few times it was around a server crashing, but I thought perhaps it was because of the crash. (ie, master sends a query, crashes, and then tries to send the query again when it comes back up). But in the past 16

Re: aha! replication breaking due to duplicate queries

2006-05-19 Thread Kishore Jalleda
On 5/19/06, sheeri kritzer <[EMAIL PROTECTED]> wrote: So I've seen replication break a few times due to duplicate queries. A few times it was around a server crashing, but I thought perhaps it was because of the crash. (ie, master sends a query, crashes, and then tries to send the query again wh

aha! replication breaking due to duplicate queries

2006-05-19 Thread sheeri kritzer
So I've seen replication break a few times due to duplicate queries. A few times it was around a server crashing, but I thought perhaps it was because of the crash. (ie, master sends a query, crashes, and then tries to send the query again when it comes back up). But in the past 16 hours, it's h