Re: Solved (Re: 4.0.2 Replication still buggy...)

2002-05-16 Thread Michael Widenius
Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Wednesday 01 May 2002 11:34 pm, Jeremy Zawodny wrote: After even more tracking stuff down, I managed to isolate it to a change made in MySQL 4.0.1. ?The query in question was doing: ? INSERT INTO ... SELECT ... rather than

Re: Solved (Re: 4.0.2 Replication still buggy...)

2002-05-03 Thread Sasha Pachev
On Wednesday 01 May 2002 11:34 pm, Jeremy Zawodny wrote: After even more tracking stuff down, I managed to isolate it to a change made in MySQL 4.0.1. ?The query in question was doing: ? INSERT INTO ... SELECT ... rather than ? INSERT IGNORE INTO ... SELECT ... MySQL 3.23.xx lets

Re: Solved (Re: 4.0.2 Replication still buggy...)

2002-05-03 Thread Jeremy Zawodny
On Fri, May 03, 2002 at 11:46:42AM -0600, Sasha Pachev wrote: On Wednesday 01 May 2002 11:34 pm, Jeremy Zawodny wrote: After even more tracking stuff down, I managed to isolate it to a change made in MySQL 4.0.1. ?The query in question was doing: ? INSERT INTO ... SELECT ... rather

Solved (Re: 4.0.2 Replication still buggy...)

2002-05-02 Thread Jeremy Zawodny
1On Fri, Apr 26, 2002 at 09:11:52AM -0700, Jeremy Zawodny wrote: I started it up and it ran for about a day before it ran into a duplicate key error. The 3.23.47 slave hasn't hit the duplicate key error, nor have any of our other slaves. So it is a 4.0.2 bug of some sort. This has been

Re: 4.0.2 Replication still buggy...

2002-04-30 Thread Jeremy Zawodny
On Fri, Apr 26, 2002 at 01:28:59PM -0600, Sasha Pachev wrote: [snip] Sasha, here's an update with some context preserved for your sanity. :-) I recently wiped my 4.0.2 slave clean and installed the latest 4.0.2, built from the BK tree. Then I synced it up with a nearby slave running

4.0.2 Replication still buggy...

2002-04-26 Thread Jeremy Zawodny
Hey Sasha, I recently wiped my 4.0.2 slave clean and installed the latest 4.0.2, built from the BK tree. Then I synced it up with a nearby slave running 3.23.47 (using rsync after I had flushed the tables on the other slave and run a SLAVE STOP). I started it up and it ran for about a day

Re: 4.0.2 Replication still buggy...

2002-04-26 Thread Sasha Pachev
On Friday 26 April 2002 10:11 am, Jeremy Zawodny wrote: Hey Sasha, I recently wiped my 4.0.2 slave clean and installed the latest 4.0.2, built from the BK tree. Then I synced it up with a nearby slave running 3.23.47 (using rsync after I had flushed the tables on the other slave and run a

Re: 4.0.2 Replication still buggy...

2002-04-26 Thread Jeremy Zawodny
On Fri, Apr 26, 2002 at 01:28:59PM -0600, Sasha Pachev wrote: On Friday 26 April 2002 10:11 am, Jeremy Zawodny wrote: I recently wiped my 4.0.2 slave clean and installed the latest 4.0.2, built from the BK tree. Then I synced it up with a nearby slave running 3.23.47 (using rsync after