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 message.
Since OpenBSD 2.8, there is a default limit of 128 open files for daemon processes.
Add --open-files-limit=2048 to mysql startup.
http://dev.mysql.com/doc/mysql/en/openbsd-2-8.html
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?
Frank
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
