Thanks for the information.
Do you run mysql as service ??Bcoz I do not have the binary files that you had mentioned.
I use binary files "safe_mysqld" and "mysqladmin" to start and stop the mysql in my Application.
Any inputs for my below mentioned problem is appreciated.
Thanks
Regards
Sunil Gavaskar
Sunil Gavaskar wrote:
Anybody can help this??? thanks regards sunilHi,
I am facing mysql shutdown process hanging problem on Solaris 5.8, mysql 3.23.40
I am running our product Web NMS which uses MySQL DB, on solaris machine.
While shutting down the application, except MySQL process, all other process are killed
and the application hangs.
On analysis I found that, "mysqladmin -h localhost shutdown" is hanging.
*But when I tried to take the dump, the process (mysqladmin -h localhost shutdown) gets killed.
*Kindly provide us the cause of the problem.
Herewith I have attached the files,
ps_before_shutdown.txt- Processes list before shutting down the Web NMS
bash-2.03$ ps -aef|grep -i telesyn
root 1541 1524 0 Feb 11 pts/5 7:25 /opt/TelesynNMSBeta/jre1.4/bin/rmiregistry 1099
root 1524 1516 0 Feb 11 pts/5 93:12 /opt/TelesynNMSBeta/jre1.4/bin/java -cp /opt/TelesynNMSBeta/classes::/opt/Teles
hmgaya 450 410 0 Feb 10 pts/2 0:00 /usr/dt/bin/sdt_shell -c unset DT; DISPLAY=atn65.telesyn.corp:0; hmgaya 452 450 0 Feb 10 pts/2 0:00 -bash -c unset DT; DISPLAY=atn65.telesyn.corp:0; /usr/dt/bin/
nobody 1548 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1544 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1549 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
root 1539 1526 0 Feb 11 pts/5 223:56 /opt/TelesynNMSBeta/mysql/bin/mysqld -Sg --basedir=/opt/TelesynNMSBeta/mysql --
nobody 1546 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1545 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
root 1543 1 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1551 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1568 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1569 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1570 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1571 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
bash-2.03$
ps_during_hang.txt- Processes list while application is hanging
bash-2.03$ ps -aef|grep -i telesyn
root 1524 1516 2 Feb 11 pts/5 93:14 /opt/TelesynNMSBeta/jre1.4/bin/java -cp /opt/TelesynNMSBeta/classes::/opt/Teles
hmgaya 450 410 0 Feb 10 pts/2 0:00 /usr/dt/bin/sdt_shell -c unset DT; DISPLAY=atn65.telesyn.corp:0; hmgaya 452 450 0 Feb 10 pts/2 0:00 -bash -c unset DT; DISPLAY=atn65.telesyn.corp:0; /usr/dt/bin/
nobody 1548 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1544 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1549 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1546 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1545 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
root 1543 1 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1551 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1568 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1569 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1570 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
nobody 1571 1543 0 Feb 11 ? 0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http
root 3769 1524 0 15:47:13 pts/5 0:00 /opt/TelesynNMSBeta/mysql/bin/mysqladmin -u root -h localhost shutdown
root 3768 3766 2 15:46:56 pts/4 0:04 /opt/TelesynNMSBeta/jre1.4/bin/java com.adventnet.launcher.nms.ShutdownServer -
bash-2.03$
ps_after_ctrl_backslash.txt- Processes list after taking the dump(dump).
bash-2.03$ ps -aef|grep -i telesyn
hmgaya 450 410 0 Feb 10 pts/2 0:00 /usr/dt/bin/sdt_shell -c unset DT; DISPLAY=atn65.telesyn.corp:0; hmgaya 452 450 0 Feb 10 pts/2 0:00 -bash -c unset DT; DISPLAY=atn65.telesyn.corp:0; /usr/dt/bin/
bash-2.03$
core- dump
Currently the machine does not have anything else running and I am connecting to it through Exceed (I tried both CDE and Xapplication displaying somewhere else) because I do not have a Sun monitor yet.
Also the problem is not consistencly reproducible. Thanks a lot in advance. Regards Sunil Gavaskar
--------------------------------------------------------------------- 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