Egor Egorov ([EMAIL PROTECTED]) writes: > Ed, > > Monday, January 28, 2002, 11:26:44 PM, you wrote: > > EC> Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on > EC> a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the > EC> box, mysql will start, but connections to the database just hang. > EC> mysqldmin, etc. all hang also. /tmp/mysqld.sock is being created, but when > EC> we do a "telnet localhost 3306", it connects, but we don't get the > EC> characteristic "3.23.36<garbage>" string that we would normally see. Any > EC> hints? > > Yes, take the right-compiled MySQL binary distribution from > http://www.mysql.com.
I rebuild MySQL 3.23.36 with debug on, then ran "mysqld --debug". Here's the output of the trace, if it will help. Looks like MySQL gets to the listen(), but hangs up in threads before it does an accept(): T@1024 : >init_signals T@1026 : >signal_hand T@1026 : | >init_thr_alarm T@1026 : | | >init_queue T@1026 : | | | >my_malloc T@1026 : | | | | my: Size: 488 MyFlags: 16 T@1026 : | | | | exit: ptr: 820b070 T@1026 : | | | <my_malloc T@1026 : | | <init_queue T@1026 : | <init_thr_alarm T@1026 : | >my_create T@1026 : | | my: Name: '/usr/local/var/adsl-61-76-31.pid' CreateFlags: 436 AccessFl ags: 1 MyFlags: 16 T@1026 : | <my_create T@1026 : | >my_malloc T@1026 : | | my: Size: 33 MyFlags: 16 T@1026 : | | exit: ptr: 820b260 T@1026 : | <my_malloc T@1026 : | exit: fd: 8 T@1026 : | >my_write T@1026 : | | my: Fd: 8 Buffer: bf7ffcf0 Count: 5 MyFlags: 16 T@1026 : | <my_write T@1026 : | >my_close T@1026 : | | my: fd: 8 MyFlags: 0 T@1026 : | | >my_free T@1026 : | | | my: ptr: 820b260 T@1026 : | | <my_free T@1026 : | <my_close -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London --------------------------------------------------------------------- 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
