The problem with this error is
(1). It seems OS dependent (cannot recreate it on Linux, Solaris). (2). It happens randomly, no rhyme nor reason. I am simply making a DBI call to do ALTER TABLE or tables-> command. One second it could fail to open the DB directory (hence the error). Three seconds later, the command succeds. No reason. Just does. It seems as if occassionally, a mysqld thread "forgets" its working directory for data, and thus complains that it cannot open the database. On Wed, 13 Feb 2002, Jonathan Hilgeman wrote: > I would first check your /var/log/messages file, or whatever file is > receiving your system warnings/errors. This could be a filesystem problem. > If you're not logged in as root, just keep trying your program until you get > that error, and quickly go to the shell and type: > > ls -lt /var/log > > That should give you a listing of that directory with the > most-recently-modified files first, and check some of the first listed logs > for errors related to your problem. > > - OR - > > This could also be your program attempting to open/read a directory as a > file instead of opening it as a directory. What's your code for opening it? > Are you using a variable that should contain the filename? If so, have you > done debugging to see if that filename is ever blank for any reason? (Print > out the variable just before you run the file-open) > > - Jonathan > > -----Original Message----- > From: phinney [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 12, 2002 9:38 AM > To: [EMAIL PROTECTED] > Subject: BSD and MySQL : Major Problems > > > I am having some problems with MySQL and FreeBSD SMP 4.4 (STABLE) and > (FAST) on an Intel platform. > > First, some vitals : > --------------------- > > I am using the MySQL 3.23.48 FreeBSD 4.4 ELF binary, along with the > latest versions of DBI/DBD::MySQL. > > I installed the binary, setup was no problem. I compiled the DBI and > DBD sourced from CPAN. Again, no problem. Also using perl 5.6.0 that > came with BSD. > > > The Problem > ----------------- > > I have a problem that rears its ugly head semi-occassionally. > Basically, I get the following error. > > 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. > > If I repeat the code snippet that caused that error not two seconds > later, it will work fine. > > There seems to be no pattern to the occurrence of the error. No > trigger. It just happens out of the blue. It also happens to any of > the Databases, not just the one listed above. > > Any ideas - any help would be much appreciated. > > Brad, > > > --------------------------------------------------------------------- > 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