MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Udo Beckmann Date:January 7 2000 12:51pm
Subject:Re: minor y2k bug
View as plain text  
> > Try:
> >         /usr/local/bin/mysqladmin flush-logs
> > The first line of the outputfile (datadir/servername.NNN) shows:
> >         # /usr/local/libexec/mysqld, Version: 3.22.29-log at 1000107
> > 6:44:00
> 
> Time                 Id Command    Argument
> 000107  4:16:08     154 Quit
> 
> I think you read a '1' into that.  Under the time
> header, there are six digits, two for year (00 = 2000),
> two for month (01) and two for day (07).
> 
> ------------------------------------------------------
> hypnos              <mailto:hypnos@stripped>

The only problem is the errornous comment line generated by "mysqladmin
flush-logs". It should be something like "... at 00107 6:44:00" but its
written as "... at 100107 6:44:00". I assume the reason for the extra
'1' ist that MySQL handles dates similar to perl (i.e. you have to add
1900 to the value retrieved by the localtime() system call).

The reason why I detected this fault is, that I'm testing for empty log
files, i.e. files including only a comment line. These files had a size
of 69 bytes. Since Jan 1 2000 they have a size of 70 bytes.

Udo
Thread
minor y2k bugUdo Beckmann7 Jan
  • Re: minor y2k bughypnos7 Jan
Re: minor y2k bugUdo Beckmann7 Jan
  • Re: minor y2k bugPaul DuBois7 Jan
  • Re: minor y2k bugMichael Widenius9 Jan