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