Bug #38698 Problems with "Incorrect information in file" on .frm files since 5.1.24-rc

• Submitted: 10 Aug 2008 13:06
• Modified: 11 Aug 2008 10:15
• Reporter: Paul Smedley
• Status: Not a Bug
• Category: MySQL Server: General
• Severity: S2 (Serious)
• Version: 5.1.24 & above
• OS: Other (OS/2)
• CPU Architecture: Any

[10 Aug 2008 13:06] Paul Smedley

Description:
Hi,

I've been compiling Mysql on OS/2 for a while - and am currently running 5.1.23-rc successfully.

With 5.1.24-rc and above (including 5.1.26-rc), on starting mysqld I get the following:
080810 22:27:41 [ERROR] mysqld: Incorrect information in file: '.\mysql\time_zone_name.frm'
080810 22:27:41 [Warning] Can't open and lock time zone table: Incorrect information in file: '.\mysql\time_zone_name.frm' trying to live without them

Attempts to open other tables also give the '080810 22:27:41 [ERROR] mysqld: Incorrect information in file:' message but with a different .frm name

Should tables created with earlier versions be able to be used with the latest build?

Any clues on what could have changed since 5.1.23-rc?

How to repeat:
See above

[10 Aug 2008 17:11] Valeriy Kravchuk

Thank you for a problem report. Had you tried to execute mysql_upgrade after upgrading to 5.1.24+?

[10 Aug 2008 20:40] Paul Smedley

Yes I tried mysql_upgrade - in the window I run it from I get a bunch of errors like:
Error    : Incorrect information in file: '.\joomla_database\jos_messages.frm'
error    : Corrupt
mysql.help_relation                                OK
mysql.slow_log
Error    : Incorrect information in file: '.\mysql\slow_log.frm'
error    : Corrupt
mysql.time_zone
Error    : Incorrect information in file: '.\mysql\time_zone.frm'
error    : Corrupt
mysql.time_zone_leap_second                        OK
mysql.time_zone_name
Error    : Incorrect information in file: '.\mysql\time_zone_name.frm'
error    : Corrupt
mysql.time_zone_transition
Error    : Incorrect information in file: '.\mysql\time_zone_transition.frm'
error    : Corrupt
mysql.time_zone_transition_type
Error    : Incorrect information in file: '.\mysql\time_zone_transition_type.frm
'
error    : Corrupt
Running 'mysql_fix_privilege_tables'...
OK

[11 Aug 2008 9:43] Paul Smedley

Please close the ticket - for some reason the .frm files were being opening in ascii mode not binary - ensuring the flags are set correctly for binary mode in my_open resolves the issue.

Why it wasn't an issue in the older builds is beyond me.

[11 Aug 2008 10:15] Sveta Smirnova

Thank you for the feedback.

Closed as "Not a Bug", because last comment.