Hi Ian, Have you checked the NIC? If your ethernet card or switch port is failing, this may be causing the issues that you have in the logs.
The other issues with the tables, have you run mysqlcheck or myisamcheck against these tables to ensure they are not corrupt? http://dev.mysql.com/doc/mysql/en/table-maintenance.html could be useful. It will explain how to use mysqlcheck and/or myisamcheck in detail. Sorry if I am teaching you how to suck eggs. 8-) Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Ian Collins [mailto:[EMAIL PROTECTED] Sent: Thursday, 6 October 2005 7:49 AM To: mysql@lists.mysql.com Subject: mysql_real_query failed: Can't find file: ... .frm (errno: 24) Hi, I am running an application using the C-API against mysql 4.0.20 on a redhat AS 3 server. The users using this application are getting numerous (and seemingly random) query errors. Has anyone seen these before? The frm files do exist. It's not from just this table. mysql_real_query failed: Can't find file: './sqllive/XHEAD.frm' (errno: 24) The query for this particular error was: select max(id) from XHEAD Regards, Ian. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
