Bug #12583 MySQL Server seems to corrupt .frm files in normal use

• Submitted: 15 Aug 2005 13:25
• Modified: 15 Aug 2005 21:57
• Reporter: Tom Cully
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: MySQL 4.1
• OS: Windows (Win32 / Linux)
• CPU Architecture: Any

[15 Aug 2005 13:25] Tom Cully

Description:
We are running a local MySQL server on WinXP, and make use of a remote 4.1 server hosted by the UK firm 'heartinternet.com' for our website (PHP/MySQL). Both on our local server, and since yesterday our webhost, MySQL 4.1 seems to fail after a period of normal use, with the error:

'Can't find file: './GAMETHEWORLD/###TABLENAME###.frm' (errno: 13)'

- where ###TABLENAME### is a name of a table in our database.

How to repeat:
Problem appears to happen spontaneously after a certian time. Our local (Win32) server is under continuous use with a Game Stats generation app, and fails roughly once a fortnight. 

Suggested fix:
The only way i can fix this is to drop the table, and reload it from a backup. This is seriously inconvenient, and happens about once a fortnight. The tables that seem to do this most often seem to be the largest and most commonly used ones (`news` is accessed by every page, `gamestats` contains 640,000 rows etc.)

[15 Aug 2005 21:57] MySQL Verification Team

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.