Re: Help with hanging MySQL server
Ed Carp ([EMAIL PROTECTED]) writes: > Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on > a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the > box, mysql will start, but connections to the database just hang. > mysqldmin, etc. all hang also. /tmp/mysqld.sock is being created, but when > we do a "telnet localhost 3306", it connects, but we don't get the > characteristic "3.23.36" string that we would normally see. Any > hints? An update: I upgraded to RedHat Linux 7.2 (the server was running 6.2), only to find the system unusable - common programs would core dump, leading me to believe the shared libraries had gotten trashed. So, I pulled a 20GB drive off the shelf, formatted it, loaded RedHat 7.2 on it, restored the databases, and everything works fine. I still don't know what the problem was. I hope it doesn't come back :( -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc "I tell you, freedom and human rights in America are doomed. The U.S. government will lead the American people in and the West in general into an unbearable hell and a choking life." --Osama bin Laden Look around - he's right... :( - 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
Re: Help with hanging MySQL server
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" 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_create T@1026 : | | my: Name: '/usr/local/var/adsl-61-76-31.pid' CreateFlags: 436 AccessFl ags: 1 MyFlags: 16 T@1026 : | my_malloc T@1026 : | | my: Size: 33 MyFlags: 16 T@1026 : | | exit: ptr: 820b260 T@1026 : | my_write T@1026 : | | my: Fd: 8 Buffer: bf7ffcf0 Count: 5 MyFlags: 16 T@1026 : | my_close T@1026 : | | my: fd: 8 MyFlags: 0 T@1026 : | | >my_free T@1026 : | | | my: ptr: 820b260 T@1026 : | | 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
Re: Help with hanging MySQL server
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" string that we would normally see. Any > EC> hints? > > Yes, take the right-compiled MySQL binary distribution from > http://www.mysql.com. I've got the same problem, and it doesn't fix the problem. -- 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