Re: mysql shutdown hangs-solaris

Mon, 17 Feb 2003 04:25:24 -0800 

Anybody can help this???

thanks
regards
sunil
Hi,
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

Reply via email to