On Sat, Mar 09, 2002 at 12:31:20PM -0700, Sasha Pachev wrote:
> 
> Jeremy:
> 
> I think I now understand what happened, or at least I have a
> pausilble theory that explains what I see in the logs.
> 
> When I had you kill the broken mysqld last time it went down in the
> middle of updating db3-relay-bin.005 - that is the only explanation
> I can think of for it being truncated in the middle of event and
> especially at such a strange position that is not anywhere near your
> max_binlog_size value.

That does make sense, yes.

That reminds me of an easy feature request.  Would it be possible to
have a slave-auto-start=no option (or something like that) in my.cnf?
There have been cases when I want to start a server but do not want
replication to start on its own?

> To prove this, check modification time on db3-relay-bin.005 - should
> be around the time mysqld was killed and should be almost identical
> to the creation time on the first core, if you still have it around.

Actually, I blew away the core file just a few hours ago.  And the
relay-bin file has been processed and is gone now. :-(

> Nevertheless, it was a blessing in disguise to have the stale broken
> log laying around - it helped me find a different bug.

Excellent.

> However, we need to fix the stale log problem before we can go
> on. One way to do is to re-start the whole replication from
> scratch. A more creative way would be to use dd to trim
> db3-relay-bin.005 down to 214929332 bytes and re-start the server.

The server is well past that point already with the new code, so I
guess that won't be necessary.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.47-max: up 30 days, processed 1,024,823,330 queries (392/sec. avg)

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to