With out knowing your system configuration it sounds to me like you've got some problems with locking.
I suggest looking into that. Brad Phinney wrote: > > 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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. --------------------------------------------------------------------- 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
