According to perror:
Error code 9: Bad file number
This is an operating system error code:
Out of curiosity, have you tried running myisamchk or some CHECK TABLE
Frank Bax wrote:
> At 10:07 AM 4/5/05, Frank Bax wrote:
>> At 04:27 PM 4/4/05, Frank Bax wrote:
>>> Cannot execute query.
>>> <snip my SQL statement>
>>> Can't find file: './donor/list_lst.frm' (errno: 9)
>>> ----- -----
>>> I got the same error last week on a different table. Today I notice
>>> that there is a table in another database on same system producing
>>> the same error. I attempted to access mysql cli, but it just locked
>>> up after entering password. Start/stop mysql and mysql cli at least
>>> started but issued errors about some tables even before I entered a
>>> command. I decided to reboot and the problem goes away (for a while).
>>> MySQL 4.0.20 - OpenBSD 3.6
>> Forgot to mention a couple of things:
>> 1) The file that mysql complains about does exist.
>> # ls -ltr donor/list*.frm
>> -rw-rw---- 1 _mysql _mysql 8694 Jan 15 09:43 donor/list_lst.frm
>> 2) When problem recurs (as it did on both databases this morning), the
>> same file in each database is affected each time error appears.
>> 3) In both databases (on same system) it is frm files in the error
> Since OpenBSD 2.8, there is a default limit of 128 open files for daemon
> Add --open-files-limit=2048 to mysql startup.
> The suggested changes to /etc/login.conf were not necessary on my system.
> Does MySQL ever close the file(s) associated with table(s), or once open
> do they stay open until shutdown?