:> -----Original Message----- :> From: imer...@pato.vaala.fi [mailto:imer...@pato.vaala.fi]On Behalf Of :> Iikka Meriläinen :> Sent: Monday, August 26, 2002 2:14 PM :> To: James Friesen :> Cc: win...@lists.mysql.com :> Subject: RE: MYSQL service shuts down. :> :> :> Hi, :> :> This problem was due to the lack of disk space. When the partition that :> MySQL lives in is full, it can't append its errors to the log :> file, and it :> forces an immediate shutdown, terminating all threads that :> might be active :> at that moment, and rolling back any transactions as well. :> :> Please try starting your mysqld with the --log command line :> parameter (as :> well as --standalone and --console) and see the log file at :> mysql\data\[hostname].log for more detailed information. :> :> Regards, :> Iikka :> :> ps. Your version might be 3.23.x... :-) as 3.32.x doesn't exist.. :> :> On Mon, 26 Aug 2002, James Friesen wrote: :> :> > I too am having the same trouble. Database is down. That's :> all it says... :> > :> > No other problems, I can connect to the database, and it's :> running on a TCP :> > port. :> > :> > I just can't get it to respond. :> > :> > Ver 3.32.something.. :> > :> > ??? :> > :> > >:> -----Original Message----- :> > >:> From: imer...@pato.vaala.fi :> [mailto:imer...@pato.vaala.fi]On Behalf Of :> > >:> Iikka Meriläinen :> > >:> Sent: Monday, August 26, 2002 10:46 AM :> > >:> To: James Frankman :> > >:> Cc: win...@lists.mysql.com :> > >:> Subject: Re: MYSQL service shuts down. :> > >:> :> > >:> :> > >:> On Mon, 26 Aug 2002, James Frankman wrote: :> > >:> :> > >:> > We have MYSQL running as a service under win2000. It has been :> > >:> working fine the past few months, but all of the sudden we are :> > >:> noticing the service shutting down for no reason. I have :> > >:> checked the mysql.err and see no errors being reported. How can :> > >:> I troubleshoot this and find out what is casueing mysql :> to shutdown? :> > >:> > :> > >:> Hello, :> > >:> :> > >:> A couple of questions: :> > >:> 1) What version of MySQL (3.23.x or 4.0.x, and whether it's max :> > >:> and/or nt :> > >:> version) :> > >:> :> > >:> 2) Please double-check your mysql.err, as it's extremely :> unlikely for :> > >:> mysqld to just crash without any traces left behind :> > >:> :> > >:> 3) Is your server under heavy load (cpu, disk i/o, network) :> > >:> when the crash :> > >:> occurs? :> > >:> :> > >:> 4) Are any other services or Windows itself crashing? :> > >:> :> > >:> 5) Can you tell whether there are any special queries :> running while it :> > >:> crashes, or is there some specific query that causes problems? :> > >:> :> > >:> Please try to answer to these so that we have something :> to base our :> > >:> thoughts on. :> > >:> :> > >:> Regards, :> > >:> Iikka :> > >:> ****************************************** :> > >:> * Iikka Meriläinen * :> > >:> * E-mail: Iikk...@pato.vaala.fi * :> > >:> * Vaala, Finland * :> > >:> ****************************************** :> > >:> :> > >:> :> > >:> :> --------------------------------------------------------------------- :> > >:> Please check :> > "http://www.mysql.com/Manual_chapter/manual_toc.html" before :> > posting. To request this thread, e-mail :> win3...@lists.mysql.com :> > :> > To unsubscribe, send a message to the address shown in the :> > List-Unsubscribe header of this message. If you cannot see it, :> > e-mail win3...@lists.mysql.com instead. :> > :> > :> > --------------------------------------------------------------------- :> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win3...@lists.mysql.com