MySQL Bugs: #15864: Random stopping of service

Bug #15864	Random stopping of service
Submitted:	19 Dec 2005 18:05	Modified:	26 Jan 2006 21:35
Reporter:	Paul McLean	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.0.18	OS:	Windows (Windows 2003 Ent Server)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
Below from Event Viewer:

Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module ntdll.dll, version 5.2.3790.1830, fault address 0x000396d0.

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

0000: 41 70 70 6c 69 63 61 74   Applicat
0008: 69 6f 6e 20 46 61 69 6c   ion Fail
0010: 75 72 65 20 20 6d 79 73   ure  mys
0018: 71 6c 64 2d 6e 74 2e 65   qld-nt.e
0020: 78 65 20 30 2e 30 2e 30   xe 0.0.0
0028: 2e 30 20 69 6e 20 6e 74   .0 in nt
0030: 64 6c 6c 2e 64 6c 6c 20   dll.dll 
0038: 35 2e 32 2e 33 37 39 30   5.2.3790
0040: 2e 31 38 33 30 20 61 74   .1830 at
0048: 20 6f 66 66 73 65 74 20    offset 
0050: 30 30 30 33 39 36 64 30   000396d0

Below from Dr. Watson:

The application, C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe, generated an application error The error occurred on 12/19/2005 @ 12:50:45.626 The exception generated was c0000005 at address 7C8396D0 (ntdll!RtlAddressInSectionTable)

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

00000: 0d 00 0a 00 0d 00 0a 00   ........
00008: 41 00 70 00 70 00 6c 00   A.p.p.l.
00010: 69 00 63 00 61 00 74 00   i.c.a.t.
00018: 69 00 6f 00 6e 00 20 00   i.o.n. .
00020: 65 00 78 00 63 00 65 00   e.x.c.e.
00028: 70 00 74 00 69 00 6f 00   p.t.i.o.
00030: 6e 00 20 00 6f 00 63 00   n. .o.c.
00038: 63 00 75 00 72 00 72 00   c.u.r.r.
00040: 65 00 64 00 3a 00 0d 00   e.d.:...
00048: 0a 00 20 00 20 00 20 00   .. . . .
00050: 20 00 20 00 20 00 20 00    . . . .
00058: 20 00 41 00 70 00 70 00    .A.p.p.
00060: 3a 00 20 00 43 00 3a 00   :. .C.:.
00068: 5c 00 50 00 72 00 6f 00   \.P.r.o.
00070: 67 00 72 00 61 00 6d 00   g.r.a.m.
00078: 20 00 46 00 69 00 6c 00    .F.i.l.
00080: 65 00 73 00 5c 00 4d 00   e.s.\.M.
00088: 79 00 53 00 51 00 4c 00   y.S.Q.L.
00090: 5c 00 4d 00 79 00 53 00   \.M.y.S.
00098: 51 00 4c 00 20 00 53 00   Q.L. .S.
000a0: 65 00 72 00 76 00 65 00   e.r.v.e.
000a8: 72 00 20 00 35 00 2e 00   r. .5...
000b0: 30 00 5c 00 62 00 69 00   0.\.b.i.
000b8: 6e 00 5c 00 6d 00 79 00   n.\.m.y.
000c0: 73 00 71 00 6c 00 64 00   s.q.l.d.
000c8: 2d 00 6e 00 74 00 2e 00   -.n.t...
000d0: 65 00 78 00 65 00 20 00   e.x.e. .
000d8: 28 00 70 00 69 00 64 00   (.p.i.d.
000e0: 3d 00 36 00 30 00 30 00   =.6.0.0.
000e8: 29 00 0d 00 0a 00 20 00   )..... .
000f0: 20 00 20 00 20 00 20 00    . . . .
000f8: 20 00 20 00 20 00 57 00    . . .W.
00100: 68 00 65 00 6e 00 3a 00   h.e.n.:.
00108: 20 00 31 00 32 00 2f 00    .1.2./.
00110: 31 00 39 00 2f 00 32 00   1.9./.2.
00118: 30 00 30 00 35 00 20 00   0.0.5. .
00120: 40 00 20 00 31 00 32 00   @. .1.2.
00128: 3a 00 35 00 30 00 3a 00   :.5.0.:.
00130: 34 00 35 00 2e 00 36 00   4.5...6.
00138: 32 00 36 00 0d 00 0a 00   2.6.....
00140: 20 00 20 00 20 00 20 00    . . . .
00148: 20 00 20 00 20 00 20 00    . . . .
00150: 45 00 78 00 63 00 65 00   E.x.c.e.
00158: 70 00 74 00 69 00 6f 00   p.t.i.o.
...

How to repeat:
Unknown could be a day before it happens again

Which exactly server version are you using?. Also did you created/edited
stored procedures using the MySQL Administrator GUI tool?

Thanks in advance.

Happened Again today

No stored procedures

MySQL server 5.0.15

Does have your Windows 2003 the SP1 installed and please read
the bug #12071 for the possibility of related issues.]

Thanks in advance.

SP1 is installed

Seems this is an exact match to my bug report
Bug #14791.
But I do not see an exact solution just a lot of attempts.
Do you have any additional info?

Then I assume that your 5.0.15 is an upgrade from early version?
If yes did you just copied or installed the new server using the older
databases without to do a dump from the older version?

Hi,

I had the exact same problem has this one with version 5.0.15 (random crashes every 2-3 days...

I updated to version 5.0.17 hoping it would fix the problem...

Server just crashed today (nothing in file error.log)
Here is what I have in the even log:
~~
Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module ntdll.dll, version 5.2.3790.1830, fault address 0x0002f5dd.

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

The MySQL service terminated unexpectedly.  It has done this 1 time(s).

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

by the way, I have windows 2003 ent edition
Server has less then 20 dbs

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".

My apologies to MySQL team, you folks are very explicit about do dump first before upgrading. And indeed it was a corupted DB causing my issues. Probably because I did NOT dump first. I did solve/find the problem sometime ago, just didn't get back here to update my comments till now.

Thanks,
Hope this helps others to. Everyone else they are the experts, so listen up!