[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
MySQL 4.1.7 / OpenBSD 3.6-current AGAIN (errno 9) error! Help plz! :)
- To: misc_(_at_)_openbsd_(_dot_)_org
- Subject: MySQL 4.1.7 / OpenBSD 3.6-current AGAIN (errno 9) error! Help plz! :)
- From: Dennis Nasarov <pheonix_(_at_)_sysattack_(_dot_)_com>
- Date: Mon, 22 Nov 2004 16:57:12 +0500
- Reply-to: Dennis Nasarov <pheonix_(_at_)_sysattack_(_dot_)_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
Visit your host, monkey.org