MySQL Bugs: #2575: Mysql 4.0.17 crashes frequently on windows

Bug #2575	Mysql 4.0.17 crashes frequently on windows
Submitted:	30 Jan 2004 0:19	Modified:	29 Feb 2004 7:34
Reporter:	Brendan Fernandes	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.0.17	OS:	Windows (Windows Server 2003 Standard)
Assigned to:		CPU Architecture:	Any

Description:
I run a website with fairly moderate load; a total of 1gb of data, 2000-7000 hits per day.

Around 5 times a day, the server crashes. If using mysqld-max-nt, I see the following entry in the Windows event log:

Faulting application mysqld-max-nt.exe, version 0.0.0.0, faulting module mysqld-max-nt.exe, version 0.0.0.0, fault address 0x000c876e.

The address is consistent. If using mysqld-nt, I see the following entry in the event log. Again, the address is consistent:

Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module mysqld-nt.exe, version 0.0.0.0, fault address 0x000c47fe.

The site is running under Apache Tomcat (have used versions 4.1 and 5.0), connecting via mysql/connectorJ (have tried versions 2 and 3).

All tables are MyIsam.

How to repeat:
There is nothing specific that causes this to happen. Generally, there is no particular query that seems to crash the server, though it seems to crash under heavy load.

It sometimes happens during a mysqldump of the database.

I have tried various settings for query_cache_size (including 0).

Other notable settings in my.ini:
set-variable=key_buffer=64M
set-variable=table_cache=130
set-variable=sort_buffer=4M
set-variable=read_buffer_size=1M

If you need any help with trying to repeat this, please do not hesitate to contact me.

More useful information:

I was running the site, with the same database fine under Red Hat Linux with mysql version 3.23.41.
I had to change to a Windows server for various reasons, and retrieved the latest production version of mysql to run it on.

I started with 4.0.14, which was the latest release at the time. Mysql was crashing with the following entry in the Event log:

Faulting application mysqld-max-nt.exe, version 0.0.0.0, faulting module mysqld-max-nt.exe, version 0.0.0.0, fault address 0x000c749e.

Hope this helps,
bsf

Thank you for writting this report.

This bug report forum is only for repeatable bug reports. For bug
reports like this one you should use the MySQL mailing list or buy
commercial support from MySQL AB.  

What we need is fully repeatable test case.

This test case should consist of the series of SQL commands or actaions that will always lead to the problem, in your case to the crash.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I am still facing that exactly problem.