RE: mysqld refuse to die

2002-11-09 Thread Jan Steinman
[HUNDREDS of lines clipped...]

PLEASE, folks, try to trim up your quotes a bit?

Adding one line while mindlessly quoting a thread that has itself been mindlessly 
quoted at least a half-dozen levels deep may not bother those who get separate 
messages, but those who get the digest version suffer quite a bit because of it.

Just try to be a bit more thoughtful about what others see. Thanks in advance!

-- 
 SQL SQL SQL SQL SQL SQL SQL SQL  
: Jan Steinman -- nature Transography(TM): 
: Bytesmiths -- artists' services: 
: Buy My Step Van! 

-
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




Re: mysqld refuse to die

2002-11-09 Thread Gelu Gogancea
Hi,

What error you get when try to stop mysql daemon ?..or tell us what is in
mysqld.log?
Maybe we can help you.

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: "Jack Chen" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, November 09, 2002 5:45 PM
Subject: Re: mysqld refuse to die


> Thanks you all for your nice suggestions. The thing is, for some reason, I
> could not stop the mysqld using 'mysqld stop'. Any insight about why this
> would fail?
>
> Another question, which might not be a *pure* mysql one, is: I ran a
> script to load my mysql database, but it has not finished the job for
> almost 10 hours and now it is in *wait 4* state. Anything I can do about
> this? Should I wait till it is done or there is no hope and I just need to
> stop it and ran again?
>
> Thanks,
>
> Jack
>
> 
> Jack Chen, Stein Lab, Cold Spring Harbor Labs
> 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> 
>
> On Sat, 9 Nov 2002, Gelu Gogancea wrote:
>
> > Hi,
> > If you really wish to kill the mysql daemon in this way :
> > You should try :
> > ps -ef |grep "mysql"
> > ...show all the mysqld processes and after this must enumarate all pid
of
> > processes in a single kill command.
> > E.g.
> > kill -9 1024 1056 ...(processes which are open).
> > But it's more "health" if you can stop the server using :
> > /etc/rc.d/mysqld stop
> >
> > Regards,
> >
> > Gelu
> > _
> > G.NET SOFTWARE COMPANY
> >
> > Permanent e-mail address : [EMAIL PROTECTED]
> >   [EMAIL PROTECTED]
> > - Original Message -
> > From: "Jack Chen" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, November 09, 2002 7:57 AM
> > Subject: Re: mysqld refuse to die
> >
> >
> > > I have just figured out:
> > >
> > > kill -9 xxx (process number)
> > >
> > > Thanks,
> > >
> > > Jack
> > >
> > > 
> > > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > > 
> > >
> > > On Sat, 9 Nov 2002, Jack Chen wrote:
> > >
> > > > Hi All,
> > > >
> > > > Please help me with this problem:
> > > >
> > > > For some reason, I could not bring down my mysqld by running
> > > >
> > > > mysqld stop
> > > >
> > > > An error message indicate: fail
> > > >
> > > > What's going on?
> > > >
> > > > Thanks,
> > > >
> > > > Jack
> > > >
> > > > 
> > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > > > 
> > > >
> > > >
> > >
> -
> > > > 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? Tr

Re: mysqld refuse to die

2002-11-09 Thread Jack Chen
Thanks you all for your nice suggestions. The thing is, for some reason, I
could not stop the mysqld using 'mysqld stop'. Any insight about why this
would fail?

Another question, which might not be a *pure* mysql one, is: I ran a
script to load my mysql database, but it has not finished the job for
almost 10 hours and now it is in *wait 4* state. Anything I can do about
this? Should I wait till it is done or there is no hope and I just need to
stop it and ran again?

Thanks,

Jack


Jack Chen, Stein Lab, Cold Spring Harbor Labs
1 Bungtown Road, Cold Spring Harbor, NY, 11724 
Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]


On Sat, 9 Nov 2002, Gelu Gogancea wrote:

> Hi,
> If you really wish to kill the mysql daemon in this way :
> You should try :
> ps -ef |grep "mysql"
> ...show all the mysqld processes and after this must enumarate all pid of
> processes in a single kill command.
> E.g.
> kill -9 1024 1056 ...(processes which are open).
> But it's more "health" if you can stop the server using :
> /etc/rc.d/mysqld stop
> 
> Regards,
> 
> Gelu
> _
> G.NET SOFTWARE COMPANY
> 
> Permanent e-mail address : [EMAIL PROTECTED]
>   [EMAIL PROTECTED]
> - Original Message -
> From: "Jack Chen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, November 09, 2002 7:57 AM
> Subject: Re: mysqld refuse to die
> 
> 
> > I have just figured out:
> >
> > kill -9 xxx (process number)
> >
> > Thanks,
> >
> > Jack
> >
> > 
> > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > 
> >
> > On Sat, 9 Nov 2002, Jack Chen wrote:
> >
> > > Hi All,
> > >
> > > Please help me with this problem:
> > >
> > > For some reason, I could not bring down my mysqld by running
> > >
> > > mysqld stop
> > >
> > > An error message indicate: fail
> > >
> > > What's going on?
> > >
> > > Thanks,
> > >
> > > Jack
> > >
> > > 
> > > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > > 
> > >
> > >
> > > -
> > > 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
> >
> >
> > ---
> > Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV
> AntiVirus.
> > Xnet automatically scans all messages for viruses using RAV AntiVirus.
> >
> > Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate
> variantele lor. Va rugam sa luati in considerare ca exista un risc de
> fiecare data cand deschideti fisiere atasate si ca MobiFon nu este
> responsabila pentru nici un prejudiciu cauzat de virusi.
> > Disclaimer: RAV AntiVirus may not be able to detect all new viruses and
> variants. Please be aware that there is a risk involved whenever opening
> e-mail attachments to your computer and that MobiFon is not responsible for
> any damages caused by viruses.
> >
> >
> 
> 


-
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




RE: mysqld refuse to die

2002-11-09 Thread Alan McDonald
Also
In My Humble Opinion (IMHO)
For What It's Worth (FWIW)

> -Original Message-
> From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
> Sent: Saturday, 9 November 2002 23:37
> To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
> Subject: Re: mysqld refuse to die
>
>
> Yes.All processes are named "mysqld"...less one "mysqld_safe"
> which is "main
> guilty" for keeping mysql daemon in "life".
>
> P.S.
> Please tell me (if you wish)...what means AFAIK?
> Regards,
>
> Gelu
> _
> G.NET SOFTWARE COMPANY
>
> Permanent e-mail address : [EMAIL PROTECTED]
>   [EMAIL PROTECTED]
> - Original Message -
> From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
> To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Saturday, November 09, 2002 2:27 PM
> Subject: Re: mysqld refuse to die
>
>
> > just kill mysqld_safe and then the mysqld process :)
> > (but AFAIK all the mysql thread are names mysqld ??)
> > - Original Message -
> > From: "Gelu Gogancea" <[EMAIL PROTECTED]>
> > To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Jack Chen"
> <[EMAIL PROTECTED]>;
> > <[EMAIL PROTECTED]>
> > Sent: Saturday, November 09, 2002 12:20 PM
> > Subject: Re: mysqld refuse to die
> >
> >
> > > ...because not all mysql processes are named "mysql" and is
> one (and you
> > > know about this) which is for safe running(mysqld_safe or safe_mysqld)
> > which
> > > create new threads when another is "killed".
> > > Regards,
> > >
> > > Gelu
> > > _
> > > G.NET SOFTWARE COMPANY
> > >
> > > Permanent e-mail address : [EMAIL PROTECTED]
> > >   [EMAIL PROTECTED]
> > > - Original Message -
> > > From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
> > > To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>;
> > > <[EMAIL PROTECTED]>
> > > Sent: Saturday, November 09, 2002 2:12 PM
> > > Subject: Re: mysqld refuse to die
> > >
> > >
> > > > Hi,
> > > >
> > > > Why not trying killall -9 mysqld ?
> > > >
> > > > Regards,
> > > >   Jocelyn
> > > > - Original Message -
> > > > From: "Gelu Gogancea" <[EMAIL PROTECTED]>
> > > > To: "Jack Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > > > Sent: Saturday, November 09, 2002 12:08 PM
> > > > Subject: Re: mysqld refuse to die
> > > >
> > > >
> > > > > Hi,
> > > > > If you really wish to kill the mysql daemon in this way :
> > > > > You should try :
> > > > > ps -ef |grep "mysql"
> > > > > ...show all the mysqld processes and after this must enumarate all
> pid
> > > of
> > > > > processes in a single kill command.
> > > > > E.g.
> > > > > kill -9 1024 1056 ...(processes which are open).
> > > > > But it's more "health" if you can stop the server using :
> > > > > /etc/rc.d/mysqld stop
> > > > >
> > > > > Regards,
> > > > >
> > > > > Gelu
> > > > > _
> > > > > G.NET SOFTWARE COMPANY
> > > > >
> > > > > Permanent e-mail address : [EMAIL PROTECTED]
> > > > >   [EMAIL PROTECTED]
> > > > > - Original Message -
> > > > > From: "Jack Chen" <[EMAIL PROTECTED]>
> > > > > To: <[EMAIL PROTECTED]>
> > > > > Sent: Saturday, November 09, 2002 7:57 AM
> > > > > Subject: Re: mysqld refuse to die
> > > > >
> > > > >
> > > > > > I have just figured out:
> > > > > >
> > > > > > kill -9 xxx (process number)
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Jack
> > > > > >
> > > > > > 

RE: mysqld refuse to die

2002-11-09 Thread Alan McDonald
As Far As I Know

> -Original Message-
> From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
> Sent: Saturday, 9 November 2002 23:37
> To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
> Subject: Re: mysqld refuse to die
>
>
> Yes.All processes are named "mysqld"...less one "mysqld_safe"
> which is "main
> guilty" for keeping mysql daemon in "life".
>
> P.S.
> Please tell me (if you wish)...what means AFAIK?
> Regards,
>
> Gelu
> _
> G.NET SOFTWARE COMPANY
>
> Permanent e-mail address : [EMAIL PROTECTED]
>   [EMAIL PROTECTED]
> - Original Message -
> From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
> To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Saturday, November 09, 2002 2:27 PM
> Subject: Re: mysqld refuse to die
>
>
> > just kill mysqld_safe and then the mysqld process :)
> > (but AFAIK all the mysql thread are names mysqld ??)
> > - Original Message -
> > From: "Gelu Gogancea" <[EMAIL PROTECTED]>
> > To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Jack Chen"
> <[EMAIL PROTECTED]>;
> > <[EMAIL PROTECTED]>
> > Sent: Saturday, November 09, 2002 12:20 PM
> > Subject: Re: mysqld refuse to die
> >
> >
> > > ...because not all mysql processes are named "mysql" and is
> one (and you
> > > know about this) which is for safe running(mysqld_safe or safe_mysqld)
> > which
> > > create new threads when another is "killed".
> > > Regards,
> > >
> > > Gelu
> > > _
> > > G.NET SOFTWARE COMPANY
> > >
> > > Permanent e-mail address : [EMAIL PROTECTED]
> > >   [EMAIL PROTECTED]
> > > - Original Message -
> > > From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
> > > To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>;
> > > <[EMAIL PROTECTED]>
> > > Sent: Saturday, November 09, 2002 2:12 PM
> > > Subject: Re: mysqld refuse to die
> > >
> > >
> > > > Hi,
> > > >
> > > > Why not trying killall -9 mysqld ?
> > > >
> > > > Regards,
> > > >   Jocelyn
> > > > - Original Message -
> > > > From: "Gelu Gogancea" <[EMAIL PROTECTED]>
> > > > To: "Jack Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > > > Sent: Saturday, November 09, 2002 12:08 PM
> > > > Subject: Re: mysqld refuse to die
> > > >
> > > >
> > > > > Hi,
> > > > > If you really wish to kill the mysql daemon in this way :
> > > > > You should try :
> > > > > ps -ef |grep "mysql"
> > > > > ...show all the mysqld processes and after this must enumarate all
> pid
> > > of
> > > > > processes in a single kill command.
> > > > > E.g.
> > > > > kill -9 1024 1056 ...(processes which are open).
> > > > > But it's more "health" if you can stop the server using :
> > > > > /etc/rc.d/mysqld stop
> > > > >
> > > > > Regards,
> > > > >
> > > > > Gelu
> > > > > _
> > > > > G.NET SOFTWARE COMPANY
> > > > >
> > > > > Permanent e-mail address : [EMAIL PROTECTED]
> > > > >   [EMAIL PROTECTED]
> > > > > - Original Message -
> > > > > From: "Jack Chen" <[EMAIL PROTECTED]>
> > > > > To: <[EMAIL PROTECTED]>
> > > > > Sent: Saturday, November 09, 2002 7:57 AM
> > > > > Subject: Re: mysqld refuse to die
> > > > >
> > > > >
> > > > > > I have just figured out:
> > > > > >
> > > > > > kill -9 xxx (process number)
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Jack
> > > > > >
> > > > > > 
> > > > > > Jack Che

Re: mysqld refuse to die

2002-11-09 Thread Gelu Gogancea
Yes.All processes are named "mysqld"...less one "mysqld_safe" which is "main
guilty" for keeping mysql daemon in "life".

P.S.
Please tell me (if you wish)...what means AFAIK?
Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, November 09, 2002 2:27 PM
Subject: Re: mysqld refuse to die


> just kill mysqld_safe and then the mysqld process :)
> (but AFAIK all the mysql thread are names mysqld ??)
> - Original Message -
> From: "Gelu Gogancea" <[EMAIL PROTECTED]>
> To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Jack Chen"
<[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Saturday, November 09, 2002 12:20 PM
> Subject: Re: mysqld refuse to die
>
>
> > ...because not all mysql processes are named "mysql" and is one (and you
> > know about this) which is for safe running(mysqld_safe or safe_mysqld)
> which
> > create new threads when another is "killed".
> > Regards,
> >
> > Gelu
> > _
> > G.NET SOFTWARE COMPANY
> >
> > Permanent e-mail address : [EMAIL PROTECTED]
> >   [EMAIL PROTECTED]
> > - Original Message -
> > From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
> > To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>;
> > <[EMAIL PROTECTED]>
> > Sent: Saturday, November 09, 2002 2:12 PM
> > Subject: Re: mysqld refuse to die
> >
> >
> > > Hi,
> > >
> > > Why not trying killall -9 mysqld ?
> > >
> > > Regards,
> > >   Jocelyn
> > > - Original Message -
> > > From: "Gelu Gogancea" <[EMAIL PROTECTED]>
> > > To: "Jack Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > > Sent: Saturday, November 09, 2002 12:08 PM
> > > Subject: Re: mysqld refuse to die
> > >
> > >
> > > > Hi,
> > > > If you really wish to kill the mysql daemon in this way :
> > > > You should try :
> > > > ps -ef |grep "mysql"
> > > > ...show all the mysqld processes and after this must enumarate all
pid
> > of
> > > > processes in a single kill command.
> > > > E.g.
> > > > kill -9 1024 1056 ...(processes which are open).
> > > > But it's more "health" if you can stop the server using :
> > > > /etc/rc.d/mysqld stop
> > > >
> > > > Regards,
> > > >
> > > > Gelu
> > > > _
> > > > G.NET SOFTWARE COMPANY
> > > >
> > > > Permanent e-mail address : [EMAIL PROTECTED]
> > > >   [EMAIL PROTECTED]
> > > > - Original Message -
> > > > From: "Jack Chen" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Saturday, November 09, 2002 7:57 AM
> > > > Subject: Re: mysqld refuse to die
> > > >
> > > >
> > > > > I have just figured out:
> > > > >
> > > > > kill -9 xxx (process number)
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Jack
> > > > >
> > > > > 
> > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > > > > 
> > > > >
> > > > > On Sat, 9 Nov 2002, Jack Chen wrote:
> > > > >
> > > > > > Hi All,
> > > > > >
> > > > > > Please help me with this problem:
> > > > > >
> > > > > > For some reason, I could not bring down my mysqld by running
> > > > > >
> > > > > > mysqld stop
> > > > > >
> > > > > > An error me

Re: mysqld refuse to die

2002-11-09 Thread Jocelyn Fournier
just kill mysqld_safe and then the mysqld process :)
(but AFAIK all the mysql thread are names mysqld ??)
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, November 09, 2002 12:20 PM
Subject: Re: mysqld refuse to die


> ...because not all mysql processes are named "mysql" and is one (and you
> know about this) which is for safe running(mysqld_safe or safe_mysqld)
which
> create new threads when another is "killed".
> Regards,
>
> Gelu
> _
> G.NET SOFTWARE COMPANY
>
> Permanent e-mail address : [EMAIL PROTECTED]
>   [EMAIL PROTECTED]
> - Original Message -
> From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
> To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Saturday, November 09, 2002 2:12 PM
> Subject: Re: mysqld refuse to die
>
>
> > Hi,
> >
> > Why not trying killall -9 mysqld ?
> >
> > Regards,
> >   Jocelyn
> > - Original Message -
> > From: "Gelu Gogancea" <[EMAIL PROTECTED]>
> > To: "Jack Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Saturday, November 09, 2002 12:08 PM
> > Subject: Re: mysqld refuse to die
> >
> >
> > > Hi,
> > > If you really wish to kill the mysql daemon in this way :
> > > You should try :
> > > ps -ef |grep "mysql"
> > > ...show all the mysqld processes and after this must enumarate all pid
> of
> > > processes in a single kill command.
> > > E.g.
> > > kill -9 1024 1056 ...(processes which are open).
> > > But it's more "health" if you can stop the server using :
> > > /etc/rc.d/mysqld stop
> > >
> > > Regards,
> > >
> > > Gelu
> > > _
> > > G.NET SOFTWARE COMPANY
> > >
> > > Permanent e-mail address : [EMAIL PROTECTED]
> > >   [EMAIL PROTECTED]
> > > - Original Message -
> > > From: "Jack Chen" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Saturday, November 09, 2002 7:57 AM
> > > Subject: Re: mysqld refuse to die
> > >
> > >
> > > > I have just figured out:
> > > >
> > > > kill -9 xxx (process number)
> > > >
> > > > Thanks,
> > > >
> > > > Jack
> > > >
> > > > 
> > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > > > 
> > > >
> > > > On Sat, 9 Nov 2002, Jack Chen wrote:
> > > >
> > > > > Hi All,
> > > > >
> > > > > Please help me with this problem:
> > > > >
> > > > > For some reason, I could not bring down my mysqld by running
> > > > >
> > > > > mysqld stop
> > > > >
> > > > > An error message indicate: fail
> > > > >
> > > > > What's going on?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Jack
> > > > >
> > > > > 
> > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > > > > 
> > > > >
> > > > >
> > > >
> > -
> > > > > 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 unsubscr

Re: mysqld refuse to die

2002-11-09 Thread Gelu Gogancea
...because not all mysql processes are named "mysql" and is one (and you
know about this) which is for safe running(mysqld_safe or safe_mysqld) which
create new threads when another is "killed".
Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, November 09, 2002 2:12 PM
Subject: Re: mysqld refuse to die


> Hi,
>
> Why not trying killall -9 mysqld ?
>
> Regards,
>   Jocelyn
> - Original Message -
> From: "Gelu Gogancea" <[EMAIL PROTECTED]>
> To: "Jack Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Saturday, November 09, 2002 12:08 PM
> Subject: Re: mysqld refuse to die
>
>
> > Hi,
> > If you really wish to kill the mysql daemon in this way :
> > You should try :
> > ps -ef |grep "mysql"
> > ...show all the mysqld processes and after this must enumarate all pid
of
> > processes in a single kill command.
> > E.g.
> > kill -9 1024 1056 ...(processes which are open).
> > But it's more "health" if you can stop the server using :
> > /etc/rc.d/mysqld stop
> >
> > Regards,
> >
> > Gelu
> > _
> > G.NET SOFTWARE COMPANY
> >
> > Permanent e-mail address : [EMAIL PROTECTED]
> >   [EMAIL PROTECTED]
> > - Original Message -
> > From: "Jack Chen" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, November 09, 2002 7:57 AM
> > Subject: Re: mysqld refuse to die
> >
> >
> > > I have just figured out:
> > >
> > > kill -9 xxx (process number)
> > >
> > > Thanks,
> > >
> > > Jack
> > >
> > > 
> > > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > > 
> > >
> > > On Sat, 9 Nov 2002, Jack Chen wrote:
> > >
> > > > Hi All,
> > > >
> > > > Please help me with this problem:
> > > >
> > > > For some reason, I could not bring down my mysqld by running
> > > >
> > > > mysqld stop
> > > >
> > > > An error message indicate: fail
> > > >
> > > > What's going on?
> > > >
> > > > Thanks,
> > > >
> > > > Jack
> > > >
> > > > 
> > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > > > 
> > > >
> > > >
> > >
> -
> > > > 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
> > >
> > >
> > > ---
> > > Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV
> > AntiVirus.
> > > Xnet automatically scans all messages for viruses using RAV AntiVirus.
> > >
&g

Re: mysqld refuse to die

2002-11-09 Thread Jocelyn Fournier
Hi,

Why not trying killall -9 mysqld ?

Regards,
  Jocelyn
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: "Jack Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, November 09, 2002 12:08 PM
Subject: Re: mysqld refuse to die


> Hi,
> If you really wish to kill the mysql daemon in this way :
> You should try :
> ps -ef |grep "mysql"
> ...show all the mysqld processes and after this must enumarate all pid of
> processes in a single kill command.
> E.g.
> kill -9 1024 1056 ...(processes which are open).
> But it's more "health" if you can stop the server using :
> /etc/rc.d/mysqld stop
>
> Regards,
>
> Gelu
> _
> G.NET SOFTWARE COMPANY
>
> Permanent e-mail address : [EMAIL PROTECTED]
>   [EMAIL PROTECTED]
> - Original Message -
> From: "Jack Chen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, November 09, 2002 7:57 AM
> Subject: Re: mysqld refuse to die
>
>
> > I have just figured out:
> >
> > kill -9 xxx (process number)
> >
> > Thanks,
> >
> > Jack
> >
> > 
> > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > 
> >
> > On Sat, 9 Nov 2002, Jack Chen wrote:
> >
> > > Hi All,
> > >
> > > Please help me with this problem:
> > >
> > > For some reason, I could not bring down my mysqld by running
> > >
> > > mysqld stop
> > >
> > > An error message indicate: fail
> > >
> > > What's going on?
> > >
> > > Thanks,
> > >
> > > Jack
> > >
> > > 
> > > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > > 
> > >
> > >
> > > -
> > > 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
> >
> >
> > ---
> > Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV
> AntiVirus.
> > Xnet automatically scans all messages for viruses using RAV AntiVirus.
> >
> > Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate
> variantele lor. Va rugam sa luati in considerare ca exista un risc de
> fiecare data cand deschideti fisiere atasate si ca MobiFon nu este
> responsabila pentru nici un prejudiciu cauzat de virusi.
> > Disclaimer: RAV AntiVirus may not be able to detect all new viruses and
> variants. Please be aware that there is a risk involved whenever opening
> e-mail attachments to your computer and that MobiFon is not responsible
for
> any damages caused by viruses.
> >
> >
>
>
> -
> 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




Re: mysqld refuse to die

2002-11-09 Thread Gelu Gogancea
Hi,
If you really wish to kill the mysql daemon in this way :
You should try :
ps -ef |grep "mysql"
...show all the mysqld processes and after this must enumarate all pid of
processes in a single kill command.
E.g.
kill -9 1024 1056 ...(processes which are open).
But it's more "health" if you can stop the server using :
/etc/rc.d/mysqld stop

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: "Jack Chen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, November 09, 2002 7:57 AM
Subject: Re: mysqld refuse to die


> I have just figured out:
>
> kill -9 xxx (process number)
>
> Thanks,
>
> Jack
>
> 
> Jack Chen, Stein Lab, Cold Spring Harbor Labs
> 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> 
>
> On Sat, 9 Nov 2002, Jack Chen wrote:
>
> > Hi All,
> >
> > Please help me with this problem:
> >
> > For some reason, I could not bring down my mysqld by running
> >
> > mysqld stop
> >
> > An error message indicate: fail
> >
> > What's going on?
> >
> > Thanks,
> >
> > Jack
> >
> > 
> > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > 
> >
> >
> > -
> > 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
>
>
> ---
> Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV
AntiVirus.
> Xnet automatically scans all messages for viruses using RAV AntiVirus.
>
> Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate
variantele lor. Va rugam sa luati in considerare ca exista un risc de
fiecare data cand deschideti fisiere atasate si ca MobiFon nu este
responsabila pentru nici un prejudiciu cauzat de virusi.
> Disclaimer: RAV AntiVirus may not be able to detect all new viruses and
variants. Please be aware that there is a risk involved whenever opening
e-mail attachments to your computer and that MobiFon is not responsible for
any damages caused by viruses.
>
>


-
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




Re: mysqld refuse to die

2002-11-09 Thread Iikka Meriläinen
On Sat, 9 Nov 2002, Jack Chen wrote:

> I have just figured out:
>
> kill -9 xxx (process number)
>

Hi!

Did you try just 'kill xxx'? How about 'mysqladmin shutdown'? 'kill -9' is
an extremely cruel way to bring a server down. You may get corrupted
databases that way, although sometimes it's the only option.

Regards,
Iikka

> On Sat, 9 Nov 2002, Jack Chen wrote:
>
> > Hi All,
> >
> > Please help me with this problem:
> >
> > For some reason, I could not bring down my mysqld by running
> >
> > mysqld stop
> >
> > An error message indicate: fail
> >
> > What's going on?
> >
> > Thanks,
> >
> > Jack
> >
> > 
> > Jack Chen, Stein Lab, Cold Spring Harbor Labs
> > 1 Bungtown Road, Cold Spring Harbor, NY, 11724
> > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> > 

**
* Iikka Meriläinen   *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**



-
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




Re: mysqld refuse to die

2002-11-08 Thread Jack Chen
I have just figured out:

kill -9 xxx (process number)

Thanks,

Jack


Jack Chen, Stein Lab, Cold Spring Harbor Labs
1 Bungtown Road, Cold Spring Harbor, NY, 11724 
Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]


On Sat, 9 Nov 2002, Jack Chen wrote:

> Hi All,
> 
> Please help me with this problem:
> 
> For some reason, I could not bring down my mysqld by running 
> 
> mysqld stop
> 
> An error message indicate: fail
> 
> What's going on? 
> 
> Thanks,
> 
> Jack
> 
> 
> Jack Chen, Stein Lab, Cold Spring Harbor Labs
> 1 Bungtown Road, Cold Spring Harbor, NY, 11724 
> Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
> 
> 
> 
> -
> 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




mysqld refuse to die

2002-11-08 Thread Jack Chen
Hi All,

Please help me with this problem:

For some reason, I could not bring down my mysqld by running 

mysqld stop

An error message indicate: fail

What's going on? 

Thanks,

Jack


Jack Chen, Stein Lab, Cold Spring Harbor Labs
1 Bungtown Road, Cold Spring Harbor, NY, 11724 
Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]



-
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