On Thu, 8 Jul 2004 [EMAIL PROTECTED] wrote: > I am happy even if mysqladmin reports that mysqladmin shutdown has > failed instead of hanging so that I can kill/stop the process using > cruder methods.
I am about 99.9% sure that all gentle methods of stopping mysqld will fail; it's had all the files it's dealing with pulled out from under it. With "mysqladmin shutdown" or a simple "kill `cat /var/run/mysqld.pid`", the process is going to patiently wait for the data to be available for writing again. Perhaps your OS might have some tunables that control how long a process sits waiting on blocked disk reads/writes. You could probably just send a "kill" to the server instead, as that may be more scriptable. As far as I know, this is basically the same as the shutdown command (and it's how all the system shutdown scripts for mysqld I've seen work). Your script can then wait a bit and see if mysql has stopped or not. If it hasn't, then you can get out the "kill -9" hammer. Thanks, Charles > Thanks again, > Ravi > > > -----Original Message----- > From: Charles Sprickman [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 07, 2004 10:07 PM > To: Ravi T Ramachandra (WT01 - EMBEDDED & PRODUCT ENGINEERING SOLUTIONS) > Cc: [EMAIL PROTECTED] > Subject: Re: mysqladmin shutdown command hangs > > > On Thu, 8 Jul 2004 [EMAIL PROTECTED] wrote: > > > When there is an accidental communication breakdown between disk array > > > and server on which mysql process is running (e.g, pulling out FC > > cable), this is being detected by our scripts and then we are trying > > to shutdown the mysql process by using mysqladmin shutdown option. > > However this command hangs and does not complete. > > I would imagine it would continue to hang until the array becomes > available. It's probably in "disk wait" state, since mysql wants to do > a clean shutdown, which I'm sure requires it touching a number of files > in your db directory. > > Shutting it down seems like a bad thing to do; I would imagine stopping > client access to the db would be a more useful action to take if you > lose the array. > > Charles > > > We tried the --force option also with the mysqladmin shutdown command, > > > but it still hung. > > > > Does anybody have any suggestion/solution. > > > > Thanks, > > Ravi > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]