On Solaris I always use : /etc/rc3.d/S99mysqld stop /etc/rc3.d/S99mysqld start
Jerry ----- Original Message ----- From: "Sunil Gavaskar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Sinisa Milivojevic" <[EMAIL PROTECTED]> Sent: Monday, February 17, 2003 2:50 PM Subject: Re: mysql shutdown hangs-solaris > 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 > --------------------------------------------------------------------- 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