Bug #31491 Mysqld-nt.exe crashing
Submitted: 9 Oct 2007 20:30 Modified: 25 Aug 2008 20:51
Reporter: Jonatas Cruz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.51b - community OS:Windows (Server 2003)
Assigned to: CPU Architecture:Any
Tags: 0x0028168c, crash, crashing, Mysqld-nt.exe, shutdown

[9 Oct 2007 20:30] Jonatas Cruz
Description:
Friends,
Sometimes the MySql service on my server shutdown with the following error (in the Eventviewer):
"
Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module mysqld-nt.exe, version 0.0.0.0, fault address 0x0028168c.
"
I couldn't perceive any special detail for the crash, as some SQL or other command.
Is there some patch for this?

Regards
Jonatas

How to repeat:
That's is almost impossible, because I don't know the specific reason.
[9 Oct 2007 23:46] MySQL Verification Team
Are there any (innodb) errors in the mysql .err log file ?

0001:00281280       _lock_sec_rec_some_has_impl_off_kernel 00682280 f   innobase:lock0lock.obj
 0001:002816b0       _lock_rec_lock_fast        006826b0 f i innobase:lock0lock.obj
[10 Oct 2007 0:02] Jonatas Cruz
Hello Shane 
No, there is nothing regarding the crach in the .err file.

Regards
[10 Oct 2007 0:07] MySQL Verification Team
Thank you for the feedback. It is possible for you to setup the general
query log with aim to track the query which cause the crash?. Thanks in
advance.
[10 Oct 2007 0:39] Jonatas Cruz
Hi Miguel 
At the moment I think logging general queries maybe cause drawbacks in my applications.
Actually the crash occurs once a week, every monday.
If the servers crash again or if the frequency increase, I will do it to discover if is a query throwing this issue.

Regards,
Jonatas
[10 Oct 2007 0:49] MySQL Verification Team
Thank you for the feedback. Do you have some backup tool which is
scheduled or anti-virus application which access the tables while
the server is running at the same time when the crash happens?.
Thanks in advance.
[10 Oct 2007 2:05] Jonatas Cruz
I have already setup my antivirus to skip the mysql directory and none scheduled task is running at the same time of the crash, but the server crashed again last monday.
[14 Oct 2007 3:45] MySQL Verification Team
Thank you for the feedback. I will left in the feedback status according your
prior comment:

"If the servers crash again or if the frequency increase, I will do it to discover if is a query throwing this issue."

Thanks in advance.
[15 Nov 2007 0:00] Bugs System
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".
[3 Jun 2008 20:47] Jonatas Cruz
Hello
I am still facing the same problem, now in version 5.0.51b.
In the general query log, there is no relevant query that could crash the server (I have tested all queries running in the time of the crash).
Any help?
[12 Jun 2008 13:11] Susanne Ebrecht
Many thanks for writing a bug report.

To analyse this problem we need to know exactly what you did and how we could reproduce this.
[12 Jun 2008 13:47] Jonatas Cruz
Hi
This problem is random. There is no way to reproduce this.
[26 Jun 2008 15:14] MySQL Verification Team
Hi Jonatas,

Could be this an issue with Data Execution Prevention (DEP)?. Thanks in advance.
[26 Jun 2008 16:34] Jonatas Cruz
Hello
I added the mysqld-not.exe to the DEP exception list.
Lets run the server and analyse if it crashes again.
[4 Jul 2008 18:42] Valeriy Kravchuk
Do you have any new results after changing DEP exceptions list?
[8 Jul 2008 20:01] Jonatas Cruz
Nothing. The server still crashes, even added to dep list
[9 Aug 2008 6:37] Valeriy Kravchuk
Please, try to repeat with a newer version, 5.0.67, and inform about the results.
[14 Aug 2008 14:53] Jonatas Cruz
Hi
I changed my architeture to 64 bits (Windows 2k3 x64 + MySql 5.0.67 x64).
I will analyse for a while if the crashes occurs again.

Thanks
[15 Aug 2008 5:00] Valeriy Kravchuk
Please, inform about any similar problems in your new environment.
[25 Aug 2008 20:50] Jonatas Cruz
Got new crashes on my new architeture.
Posting in new bug report.

Jonatas P Cruz
[25 Aug 2008 20:51] Jonatas Cruz
Closed.
[28 Nov 2008 3:20] yuanhl yuan
Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module mysqld-nt.exe, version 0.0.0.0, fault address 0x001c36d4.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.