silent crash

Hi,

Since a few months, we have a strange issue with mysql server ( last
release for win, on a xp SP2 box ).

Randomly, Mysql daemon stops responding.
( estimated frequency : about 1 time per week or per 2 week )

I mean :
* No way to connect ( by tcp/ip or by running the mysql command line tool ).
* Stop and then restart the Mysql service is unsuccessful.

The only "workaround" is to ... reboot the computer !
And then, all's ok for a random duration.

When I read the Mysql log, no error is written.
I never saw this kind of issue, and so :
- I updated Mysql server version.
- I replaced the computer which run Mysql for a new one with more memory
and cpu ( 512Mo / 1,8Ghz ).

So, I'm tired of this issue ... does any one have an idea, something to
check ??

Thanks you everybody for any help.

Luc.

Luc wrote:
>
> Hi,
>
> Since a few months, we have a strange issue with mysql server ( last
> release for win, on a xp SP2 box ).
>
> Randomly, Mysql daemon stops responding.
> ( estimated frequency : about 1 time per week or per 2 week )
>
> I mean :
> * No way to connect ( by tcp/ip or by running the mysql command line
> tool ).
> * Stop and then restart the Mysql service is unsuccessful.
>
> The only "workaround" is to ... reboot the computer !
> And then, all's ok for a random duration.

What about anti-virus programs and such, tried to turn them off?

> When I read the Mysql log, no error is written.
> I never saw this kind of issue, and so :
> - I updated Mysql server version.
> - I replaced the computer which run Mysql for a new one with more memory
> and cpu ( 512Mo / 1,8Ghz ).

Do you dare to update to the Unix world?
It's considered more stable.


--

//Aho

I would look at windows application log files as well. plus i believe you can
turn on performance monitoring so that you know when and/or how it starts to overload.

are you sure it's independant of a long running query or loop?

--

Jack Vamvas
___________________________________
The latest IT jobs - www.ITjobfeed.com
<a href="http://www.itjobfeed.com">UK IT Jobs</a>


"Luc" <lucky@mon-mail.com> wrote in message
news:et96ro$fgk$1@news.tiscali.fr...
>
> Hi,
>
> Since a few months, we have a strange issue with mysql server ( last
> release for win, on a xp SP2 box ).
>
> Randomly, Mysql daemon stops responding.
> ( estimated frequency : about 1 time per week or per 2 week )
>
> I mean :
> * No way to connect ( by tcp/ip or by running the mysql command line
> tool ).
> * Stop and then restart the Mysql service is unsuccessful.
>
> The only "workaround" is to ... reboot the computer !
> And then, all's ok for a random duration.
>
> When I read the Mysql log, no error is written.
> I never saw this kind of issue, and so :
> - I updated Mysql server version.
> - I replaced the computer which run Mysql for a new one with more memory
> and cpu ( 512Mo / 1,8Ghz ).
>
> So, I'm tired of this issue ... does any one have an idea, something to
> check ??
>
> Thanks you everybody for any help.
>
> Luc.
>
>
>
>
>
>
>
>
>
>

Jack Vamvas a écrit :
> are you sure it's independant of a long running query or loop?
>
I think so ... but I have no way to be 100% sure.

As all scripts started on this computer are Perl scripts, and so I tried
to kill all perl processes when issue appears. But it didn't solved the
issue.

All these scripts asking the mysql server were written by myself ...
it's not an insurance of "good work" but I know that no one else run
queries to this mysql server.

J.O. Aho a écrit :
> What about anti-virus programs and such, tried to turn them off?

I have desactivated it ( Mc Afee viruscan ).
But, to do a test, I uninstalled it fully since a few days.

I'll tell you if it seems to solves the issue ...

>
> Do you dare to update to the Unix world?
> It's considered more stable.

I come from the unix world ... but my company is running on the
Microsoft world and always with many MsSQL servers ! :o(
So It was hard to have the agreement of my boss to use MySQL ( because
dba's knows only MsSQL, here ), and to use Perl instead of vb/asp.
My company think about migrating to the unix world, but I can't choose
now to install a box with another OS. It's another problem :o(

Anyway, in my previous company, I ran successfully a MySQL 4.1 server
for years with no crash problems ...
And the queries/load average were bigger.

Luc wrote:
> J.O. Aho a écrit :
>> What about anti-virus programs and such, tried to turn them off?
>
> I have desactivated it ( Mc Afee viruscan ).
> But, to do a test, I uninstalled it fully since a few days.
>
> I'll tell you if it seems to solves the issue ...

If it turns out that the virus scanner is the problem, maybe that could be an
argument to try another environment. I wish you the best of luck.

--

//Aho

Luc a écrit :
> J.O. Aho a écrit :
>> What about anti-virus programs and such, tried to turn them off?
>
> I have desactivated it ( Mc Afee viruscan ).
> But, to do a test, I uninstalled it fully since a few days.
>
> I'll tell you if it seems to solves the issue ...

Unfortunately, I had a new "crash" of MySQL today.

I'm despaired :'(

Luc wrote:
> Luc a écrit :
>> J.O. Aho a écrit :
>>> What about anti-virus programs and such, tried to turn them off?
>>
>> I have desactivated it ( Mc Afee viruscan ).
>> But, to do a test, I uninstalled it fully since a few days.
>>
>> I'll tell you if it seems to solves the issue ...
>
> Unfortunately, I had a new "crash" of MySQL today.
>
> I'm despaired :'(

If you would call some support place they would most likely recommend
reinstall microsoft, but before that, is it possible for your to add logging
in your scripts, time and task? This way you could see if the crash happens at
the same place each time or if it's all random.

Running the mysql with strace would most likely be the best, but I doubt there
are such tool for microsoft.

--

//Aho

J.O. Aho a écrit :

> is it possible for your to add logging
> in your scripts, time and task? This way you could see if the crash happens at
> the same place each time or if it's all random.

I already have some logging functions in my scripts.
But currently, the only logged errors are about a connect failure.
And before that connect failure, all scripts seems to return normally
data ( all queries are successful ).

Sometimes, issue appears when I run a script which do a basic select (
where clause is on a specific id only ) on a single table and with only
five hundred rows at all ... I think it's not to much, don't you ?

And Apache logs aren't very interesting too.

The strangest thing is that stopping/restarting the mysql service don't
solve issue ... I don't understand why MySQL is able to restart with no
errors, and why it continue to "deny/refuse" connections after. And so,
why a "reboot" solve the issue.

> Running the mysql with strace would most likely be the best, but I doubt there
> are such tool for microsoft.
>

I don't know if I can use strace, but I'll try to do so.

Anyway, thanks you very much for your answers ( I'll continue to tell
you the results of the tests/logs if I find something interesting ).