Charles, Sometimes, the connection to disk array will not be available to this server for long time and in such a case, we want another server to connect to the disk array and run mysql processes. Unfortunately, from our design, this cannot happen until the existing server shuts down.
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. 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]
