1) It may seem OS dependent, but unless you've tried the other 2 OSes on the same box with the exact same setup (unlikely), I wouldn't blame the OS right away. (Can you tell I'm biased towards FreeBSD?)
2) This seems to still point to the file system, so again, check your errors/error logs/message logs for issues related to this. 3) You still didn't provide your code. 4) What's your MySQL data directory? 5) Are there any other programs that access MySQL on this server or any filesystem utilities that are running (indexing, searches, etc...)? - Jonathan -----Original Message----- From: Brad Phinney [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 8:39 AM To: Jonathan Hilgeman Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: BSD and MySQL : Major Problems 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
