Hi Brad, You are running out of file descriptors, type this: kes# sysctl -a | grep files kern.maxfiles: 20000 kern.maxfilesperproc: 18000 kern.openfiles: 5230 kes# limit -h cputime unlimited filesize unlimited datasize 1048576 kbytes stacksize 262144 kbytes coredumpsize unlimited memoryuse unlimited descriptors 18000 memorylocked unlimited maxproc 4115
You probably increased the number of tables in my.cnf and did not allocate enough descriptors for the process. use sysctl to increase the number of available descriptors. Ken ----- Original Message ----- From: "Brad Phinney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 19, 2002 3:47 PM Subject: MySQL, FreeBSD problem > Hello all. > > I have an application that does a lot of table creation and writing for > a FreeBSD 4.4 SMP machine. Over time, I begin to see the following > errors. > > DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Errcode: 2) at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2552, <FILE> chunk 138. > DBD::mysql::db do failed: Table 'p3_samt_trans.p3_int_sender_2_12_0' doesn't exist at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2301, <FILE> chunk 138. > > > These errors seem to happen for no reason. If I issue a select, do or > anything else 2 seconds later, I get no errors. The table in question > above does in fact exist, although MySQL claims that it does not. > > The machine (or mysql for that matter) is not under particularly heavy > load. It simply occassionally just cant read a database directory for > some reason or another. A fraction of a second later, the same command > will work fine. > > Now, I am using the 3.23.47 Free BSD binary from the MySQL site on this > machine. > > I notice that the problem continues to get worse as time goes on. If I > restart mysqld however, the problem seems to go away for a bit. But > after 2-3 days, the problem comes back. > > Any ideas? thoughts? > > Any assistance with this problem would be welcomed. > > Thanks. > > > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php