mysqld process hanging -- can't restart
Hi, I'm having a problem every so often with the following error message: 040718 15:21:59 InnoDB: Started /usr/sbin/mysqld: ready for connections. Version: '4.0.16-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 Number of processes running now: 1 mysqld process hanging, pid 12141 - killed 040719 17:35:54 mysqld restarted 040719 17:35:54 Can't start server: Bind on TCP/IP port: Address already in use 040719 17:35:54 Do you already have another mysqld server running on port: 3306 ? 040719 17:35:54 Aborting 040719 17:35:54 /usr/sbin/mysqld: Shutdown Complete 040719 17:35:54 mysqld ended 040719 23:09:12 mysqld started As you can see, I didn't notice the server was down until a couple hours later. A lot of people have said I should check to see what process it running on port 3306 but I'm never there when this happens. In any case, it seems pretty clear to me that MySQL isn't all the way shutdown when it tries to start back up again. When I manually have to restart the server it usually takes 10-20 seconds depending on it's current load; the above error message only seems to give a fraction of a second for the server to shutdown. What I can I do to fix this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld process hanging
I saw in my log file and I get an error as below Number of processes running now: 1 mysqld process hanging, pid 9444 - killed 030528 20:21:21 mysqld restarted /usr/libexec/mysqld: ready for connections and there is a lot of error message like that. what happen and how to solve that.? thanks in advance _ Using a handphone prepaid card? Reload your credit online! http://www.msn.com.my/reloadredir/default.asp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld process hanging
Hi, I am having a problem wiht MySQL 3.23.53 The logs tell all: 021211 18:40:42 mysqld started /usr/libexec/mysqld: ready for connections Number of processes running now: 1 mysqld process hanging, pid 6066 - killed 021211 19:14:43 mysqld restarted /usr/libexec/mysqld: ready for connections Number of processes running now: 1 mysqld process hanging, pid 18762 - killed 021211 19:28:55 mysqld restarted /usr/libexec/mysqld: ready for connections [repeated many times...] This I do not like but I can live with. What worries me is this: /usr/local/libexec/mysqld: ready for connections Number of processes running now: 2 mysqld process hanging, pid 22134 - killed mysqld process hanging, pid 22134 - killed 021211 19:23:59 mysqld restarted 021211 19:23:59 Can't start server: Bind on TCP/IP port: Address already in use 021211 19:23:59 Do you already have another mysqld server running on port: 3307 ? 021211 19:23:59 Aborting So sometimes my mysqld process hangs, and it is not (cannot be?) killed. If I du a fuser, I can see one mysqld process which I can kill -9 manually and then start the server. Could you point me to the right direction? - Why are my processes getting into a hanging state? - Why aren't they killed and the server restarted then? I am using RedHat 8 on a P3 without InnoDB. (I can give more info on the config if needed.) - Csongor ps: Yes, I know the port is 3307 and not 3306, but that is OK. - 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