List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 7 2000 3:57pm
Subject:Re: minor y2k bug
View as plain text  
At 1:51 PM +0100 2000-01-07, Udo Beckmann wrote:
>  > > 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.


It occurs for me, too (the 100 rather than 10) under 3.22.25, but not
under 3.23.8, so I assume it's been fixed in more recent versions.

-- 
Paul DuBois, paul@stripped
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