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