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]

Reply via email to