Re: 4.0.2 Replication Bug...

2002-03-11 Thread Michael Widenius
Hi! > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes: Sasha> On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote: >> My 4.0.2 slave has run through about 14 million queries and it's going >> well. Sasha> Good news >> >> Do you have any feel for how much slower a debugging versio

Re: 4.0.2 Replication Bug...

2002-03-07 Thread Jeremy Zawodny
On Thu, Mar 07, 2002 at 09:57:54AM -0700, Sasha Pachev wrote: > On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote: > > > > Do you have any feel for how much slower a debugging version of > > MySQL is compared to a normal version? ?I ask because my > > replication heartbeat monitor has noti

Re: 4.0.2 Replication Bug...

2002-03-07 Thread Sasha Pachev
On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote: > My 4.0.2 slave has run through about 14 million queries and it's going > well. Good news > > Do you have any feel for how much slower a debugging version of MySQL > is compared to a normal version? ?I ask because my replication > heart

Re: 4.0.2 Replication Bug...

2002-03-06 Thread Jeremy Zawodny
On Tue, Mar 05, 2002 at 12:13:25PM -0800, Jeremy Zawodny wrote: > On Tue, Mar 05, 2002 at 09:19:35AM -0700, Sasha Pachev wrote: > > On Tuesday 05 March 2002 01:17 am, Jeremy Zawodny wrote: > > > When the machine is pounding away on updates (over 300/sec), it can > > > take a long time to get a res

Re: 4.0.2 Replication Bug...

2002-03-05 Thread Jeremy Zawodny
On Tue, Mar 05, 2002 at 09:19:35AM -0700, Sasha Pachev wrote: > On Tuesday 05 March 2002 01:17 am, Jeremy Zawodny wrote: > > When the machine is pounding away on updates (over 300/sec), it can > > take a long time to get a response to SHOW SLAVE STATUS. ?I get one, > > but it can take between 5 an

Re: 4.0.2 Replication Bug...

2002-03-05 Thread Sasha Pachev
On Tuesday 05 March 2002 01:17 am, Jeremy Zawodny wrote: > When the machine is pounding away on updates (over 300/sec), it can > take a long time to get a response to SHOW SLAVE STATUS. ?I get one, > but it can take between 5 and 30 seconds: My first inclination was to blame FreeBSD threads, but

Re: 4.0.2 Replication Bug...

2002-03-05 Thread Jeremy Zawodny
On Sat, Mar 02, 2002 at 09:57:58PM -0800, Jeremy Zawodny wrote: > > Murphy's law strikes! Just a few hours ago I blasted the relay logs > on my 4.0.2 slave. It ran out of disk space! > > I'll rsync the slave and build a fresh MySQL from the bitkeeper tree > and let you know. Sasha, I re-sync

Re: 4.0.2 Replication Bug...

2002-03-02 Thread Jeremy Zawodny
On Sat, Mar 02, 2002 at 10:32:39PM -0700, Sasha Pachev wrote: > On Monday 11 February 2002 01:01 pm, Jeremy Zawodny wrote: > > Okay, I've hit a bug. ?It happened after the slave had replicated > > about 5,397,000 queries. > > Jeremy: > > I have finally gotten around to this and I think I've foun

Re: 4.0.2 Replication Bug...

2002-03-02 Thread Sasha Pachev
On Monday 11 February 2002 01:01 pm, Jeremy Zawodny wrote: > Okay, I've hit a bug. ?It happened after the slave had replicated > about 5,397,000 queries. Jeremy: I have finally gotten around to this and I think I've found the bug. At least, on a different system where I could repeat it before m

Re: 4.0.2 Replication Bug...

2002-02-13 Thread Jeremy Zawodny
On Mon, Feb 11, 2002 at 07:29:19PM -0700, Sasha Pachev wrote: > On Monday 11 February 2002 12:55 pm, Jeremy Zawodny wrote: > > The slave hit a duplicate key error and died. ?The IO thread appears > > to still be running, but the SQL thread is not. ?When I try to do a > > "SLAVE START" on the slave

Re: 4.0.2 Replication Bug...

2002-02-11 Thread Sasha Pachev
On Monday 11 February 2002 12:55 pm, Jeremy Zawodny wrote: > The slave hit a duplicate key error and died. ?The IO thread appears > to still be running, but the SQL thread is not. ?When I try to do a > "SLAVE START" on the slave, the command never returns to the "mysql> " > prompt. Jeremy: First