MySQL 4.1.7 / OpenBSD 3.6-current AGAIN (errno 9) error! Help plz! :)

[Dennis Nasarov <pheonix@sysattack.com>]

Hello folks,

I have compiled mysql 4.1.7 on obsd 3.6-current box and installed
without no problems... but after some time server is up i have
following:

041122 16:40:02 /services/mysql/libexec/mysqld: Can't open file: 'kirbi_counter.MYI'. (errno: 9)
041122 16:40:02 /services/mysql/libexec/mysqld: Can't open file: 'kirbi_counter.MYI'. (errno: 9)
041122 16:40:17 /services/mysql/libexec/mysqld: Can't find file: './forum-welcome/user.frm' (errno: 9)
041122 16:40:21 /services/mysql/libexec/mysqld: Can't open file: 'catalogtxt.MYI'. (errno: 9)
041122 16:40:21 /services/mysql/libexec/mysqld: Can't open file: 'catalog2.MYI'. (errno: 9)
041122 16:40:23 /services/mysql/libexec/mysqld: Can't open file: 'threadrate.MYI'. (errno: 9)
041122 16:40:24 /services/mysql/libexec/mysqld: Can't open file: 'catalogtxt.MYI'. (errno: 9)
041122 16:40:24 /services/mysql/libexec/mysqld: Can't open file: 'catalog2.MYI'. (errno: 9)
041122 16:40:24 /services/mysql/libexec/mysqld: Can't open file: 'catalogtxt.MYI'. (errno: 9)
041122 16:40:24 /services/mysql/libexec/mysqld: Can't open file: 'catalog2.MYI'. (errno: 9)
041122 16:40:25 /services/mysql/libexec/mysqld: Can't open file: 'threadrate.MYI'. (errno: 9)

I have read many articles in mailing lists and checks all advices i
have found but my MySQL server AGAIN SAYS ME (errno: 9) :(

As i understood trouble with limiting openfiles-cur (ulimit etc...) i
have add to my /etc/login.conf

#
# MySQL daemon
#
mysql:\
        :datasize=infinity:\
        :maxproc=infinity:\
        :openfiles-cur=2048:\
        :openfiles-max=8192:\
        :stacksize-cur=8M:\
        :localcipher=blowfish,8:\
        :tc=default:

As described on MySQL homepage but it doesen't helps! :(


BTW, only then started, for 5-10 mins Mysql server works excellent!

P.S databases were moved from mysql 3.x with copying (not
mysqldump-ing) is this can be a problem? If yes how move databases
correctly? (i need move 10Gigs of data quickly... mysqldump will take
a lot of time for it)

Thanks for any ideas/solutions folks :)
-- 
Dennis Nasarov