--On Tuesday, January 29, 2002 2:08 AM -0600 Ed Carp <[EMAIL PROTECTED]> wrote:

>> What seems to be happening is that the "open" of the db hangs.  So, when
>> you attempt to connect with a client, mysql tries to look at the grant
>> tables and hangs waiting for access.  This is just a guess though.
>
> When you connect with a client, mysql_real_connect opens a socket to the
> server, does the handshaking, then authenticates and  passes the query info.
> When I connect, I don't get anything, and gdb says the client is hung in one
> of the net_read routines, which makes sense - the client is waiting for
> something from the server.

Yes, exactly.  To authenticate you it has to consult the grant tables, i.e. the 
tables in the mysql db.  It has to open those files.  I never see the file 
opens.

> Is this a MySQL issue or not?  I'm not sure - I just downloaded
> MySQL-3.23.47-1.i386.rpm and installed it (this is supposedly the static
> version of the server, no?) and it gave me exactly the same result, which if
> it was a Linux issue, it shouldn't react the same, since it was linked
> statically, so I'm leaning towards it being a MySQL issue of MySQL not
> handling an error condition properly.

Yes, I think it is a mysql issue in that the mysql server does not respond.  It 
is likely that in both of our situations something has changed in the 
environment to make the server go catatonic.  I just can't figure out what it 
is and mysql is not helping me figure it out at all.  No error message, no 
core, no nothing.

Bill

+-----------------------------------------------
| Bill MacAllister
| Senior Programmer, Pride Industries
| 10030 Foothills Blvd., Roseville CA  95747
| Phone: +1 916.788.2402    Fax: +1 916.788-2540


---------------------------------------------------------------------
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

Reply via email to