Re: mysql_real_query failed: Can't find file: ... .frm (errno: 24)

Hello. See: http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html Ian Collins wrote: > 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

RE: mysql_real_query failed: Can't find file: ... .frm (errno: 24)

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