Clay,
I have only been running MySQL on Mac OS 10.1.3 on a PowerBook
G4 for development purposes, but a couple of things occurred to me:
1.) When the log says "Got error 9 from select" and that error
shows as "Bad file descriptor", I am reminded of the quirkiness that
sometimes happens when applications interface with HFS/HFS+ volumes.
Does your Mac OS X Server have HFS+ volumes, or do you use AIX
filesystem volumes?
2.) Do any of your queries to the mysql filename reference a
filename, and if so, is the filename part of your $PATH variable, or
does it require a path prefix prepended to the filename?
I know these are obscure questions, but you have quite an
obscure issue on your hands. They're mostly a hacker's stab in the
dark. Best wishes, and we all (particularly those of us dealing with
Mac OS X :^) ) are interested in hearing how you finally figure this
out. If you have not already visited his site, you might go to Mark
Liyanage's site (http://www.entropy.ch/) and email him to see if he has
anything to offer.
Sincerely,
--
Barry C. Hawkins
Systems Consultant
All Things Computed
[EMAIL PROTECTED]
-----Original Message-----
From: Clay Loveless [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 8:20 PM
To: Mark Matthews; [EMAIL PROTECTED]
Subject: Re: more on 1049 errors
Okay, this just happened again, and this time I did get an error in the
logs.
020425 18:01:00 Error in accept: Resource temporarily unavailable
020425 18:01:00 mysqld: Got error 9 from select
'perror' says:
Error code 9: Bad file descriptor
... Which still leaves me a bit in the dark. Has anyone else experienced
"error 9"?
As Paul DuBois mentioned in another response, MySQL and Mac OS X are
pretty recent companions, so it's entirely possible this could be
related to the OS and its file system routines.
I'm using a pretty speedy disk on a dual processor G4 ... And noted
today while perusing the support option price list that the use of a
dual processor puts me in the "advanced" support category (as does the
use of Mac OS X).
Any possibility of the dual processing playing a role here?
Our MySQL server is also a "dual disk" system, where the OS the MySQL
application reside on one Ultra160 SCSI drive, and the MySQL data files
reside on a second Ultra160 SCSI drive.
I can also pass along my "my.cnf" parameters if they may be of use in
diagnosing the problem ... I've based them off of the "large" example
"my.cnf" settings.
Thanks in advance for any additional assistance -- I really do
appreciate the dialog on the problem.
-Clay
___________________________
Clay Loveless
Webmaster, Crawlspace
http://www.crawlspace.com/
> From: "Mark Matthews" <[EMAIL PROTECTED]>
> Date: Thu, 25 Apr 2002 16:39:56 -0500
> To: "Clay Loveless" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> Subject: Re: how to get support help?
>
> What does your MySQL error log say when this happens? (it should be in
> the same directory with your databases and be your hostname plus a
> ".err" extension). This information should shed some light on what's
> going on under the hood.
>
> -Mark
>
> Original message:
> ------------------------------------------------------------
> Subject: Re: how to get support help?
> From: Clay Loveless <[EMAIL PROTECTED]>
> Date: 2002-04-25 17:50:48
> [Download message RAW]
>
> Erik, et. al.--
>
> Thanks for all the helpful advice.
>
> I'll make a note that the MySQL mailing list welcomes messages from
> people shrieking "HELP!!!" even though they clearly haven't bothered
> to read the manual, but offers little to those who've actually tried
> to resolve a problem on their own BEFORE wasting everyone else's time
> and bandwidth.
>
> This approach is contrary to other lists I'm a part of, so I'm glad
> you've helped me get my mind right on how *this* list (clearly an
> anomaly) works.
>
> Anyone else offering the "buy a contract" response can save their
> keystrokes, I'm now crystal clear on that solution.
>
> -Clay
>
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
