MySQL Bugs: #30802: mysql started crashing today

Bug #30802	mysql started crashing today
Submitted:	4 Sep 2007 17:06	Modified:	6 Oct 2007 8:06
Reporter:	Dimitris Georgakoulos	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.0.41	OS:	Windows (2003 Server SP1)
Assigned to:		CPU Architecture:	Any

Description:
We have been in production for 5 months now without any crashes and problems with 5.0.41 and suddently today we've gotten 5 crashes.  Any help will be greatly appreciated.  Thank you so much in advance.

Event Type:	Error
Event Source:	Application Error
Event Category:	(100)
Event ID:	1000
Date:		9/4/2007
Time:		12:42:37 PM
User:		N/A
Computer:	119702-APP1
Description:
Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module ntdll.dll, version 5.2.3790.1830, fault address 0x0002fc3e.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
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 32 66 63 33 65   0002fc3e

Event Type:	Information
Event Source:	DrWatson
Event Category:	None
Event ID:	4097
Date:		9/4/2007
Time:		12:42:37 PM
User:		N/A
Computer:	119702-APP1
Description:
The application, D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe, generated an application error The error occurred on 09/04/2007 @ 12:42:37.569 The exception generated was c0000005 at address 7C82FC3E (ntdll!RtlAllocateHeap)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
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 44 00 3a 00   :. .D.:.
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 32 00 31 00 32 00   =.2.1.2.
000e8: 38 00 29 00 0d 00 0a 00   8.).....
000f0: 20 00 20 00 20 00 20 00    . . . .
000f8: 20 00 20 00 20 00 20 00    . . . .
00100: 57 00 68 00 65 00 6e 00   W.h.e.n.
00108: 3a 00 20 00 39 00 2f 00   :. .9./.
00110: 34 00 2f 00 32 00 30 00   4./.2.0.
00118: 30 00 37 00 20 00 40 00   0.7. .@.
00120: 20 00 31 00 32 00 3a 00    .1.2.:.
00128: 34 00 32 00 3a 00 33 00   4.2.:.3.
00130: 37 00 2e 00 35 00 36 00   7...5.6.
00138: 39 00 0d 00 0a 00 20 00   9..... .
00140: 20 00 20 00 20 00 20 00    . . . .
00148: 20 00 20 00 20 00 45 00    . . .E.
00150: 78 00 63 00 65 00 70 00   x.c.e.p.
00158: 74 00 69 00 6f 00 6e 00   t.i.o.n.
00160: 20 00 6e 00 75 00 6d 00    .n.u.m.
00168: 62 00 65 00 72 00 3a 00   b.e.r.:.
00170: 20 00 63 00 30 00 30 00    .c.0.0.
00178: 30 00 30 00 30 00 30 00   0.0.0.0.
00180: 35 00 20 00 28 00 61 00   5. .(.a.
00188: 63 00 63 00 65 00 73 00   c.c.e.s.
00190: 73 00 20 00 76 00 69 00   s. .v.i.
00198: 6f 00 6c 00 61 00 74 00   o.l.a.t.
001a0: 69 00 6f 00 6e 00 29 00   i.o.n.).
001a8: 0d 00 0a 00 0d 00 0a 00   ........
001b0: 2a 00 2d 00 2d 00 2d 00   *.-.-.-.
001b8: 2d 00 3e 00 20 00 53 00   -.>. .S.
001c0: 79 00 73 00 74 00 65 00   y.s.t.e.
001c8: 6d 00 20 00 49 00 6e 00   m. .I.n.
001d0: 66 00 6f 00 72 00 6d 00   f.o.r.m.
001d8: 61 00 74 00 69 00 6f 00   a.t.i.o.
001e0: 6e 00 20 00 3c 00 2d 00   n. .<.-.
001e8: 2d 00 2d 00 2d 00 2a 00   -.-.-.*.
001f0: 0d 00 0a 00 20 00 20 00   .... . .
001f8: 20 00 20 00 20 00 20 00    . . . .
00200: 20 00 20 00 43 00 6f 00    . .C.o.
00208: 6d 00 70 00 75 00 74 00   m.p.u.t.
00210: 65 00 72 00 20 00 4e 00   e.r. .N.
00218: 61 00 6d 00 65 00 3a 00   a.m.e.:.
00220: 20 00 31 00 31 00 39 00    .1.1.9.
00228: 37 00 30 00 32 00 2d 00   7.0.2.-.
00230: 41 00 50 00 50 00 31 00   A.P.P.1.
00238: 0d 00 0a 00 20 00 20 00   .... . .
00240: 20 00 20 00 20 00 20 00    . . . .
00248: 20 00 20 00 55 00 73 00    . .U.s.
00250: 65 00 72 00 20 00 4e 00   e.r. .N.
00258: 61 00 6d 00 65 00 3a 00   a.m.e.:.
00260: 20 00 53 00 59 00 53 00    .S.Y.S.
00268: 54 00 45 00 4d 00 0d 00   T.E.M...
00270: 0a 00 20 00 20 00 20 00   .. . . .
00278: 20 00 20 00 20 00 20 00    . . . .
00280: 20 00 54 00 65 00 72 00    .T.e.r.
00288: 6d 00 69 00 6e 00 61 00   m.i.n.a.
00290: 6c 00 20 00 53 00 65 00   l. .S.e.
00298: 73 00 73 00 69 00 6f 00   s.s.i.o.
002a0: 6e 00 20 00 49 00 64 00   n. .I.d.
002a8: 3a 00 20 00 30 00 0d 00   :. .0...
002b0: 0a 00 20 00 20 00 20 00   .. . . .
002b8: 20 00 20 00 20 00 20 00    . . . .
002c0: 20 00 4e 00 75 00 6d 00    .N.u.m.
002c8: 62 00 65 00 72 00 20 00   b.e.r. .
002d0: 6f 00 66 00 20 00 50 00   o.f. .P.
002d8: 72 00 6f 00 63 00 65 00   r.o.c.e.
002e0: 73 00 73 00 6f 00 72 00   s.s.o.r.
002e8: 73 00 3a 00 20 00 32 00   s.:. .2.
002f0: 0d 00 0a 00 20 00 20 00   .... . .
002f8: 20 00 20 00 20 00 20 00    . . . .
00300: 20 00 20 00 50 00 72 00    . .P.r.
00308: 6f 00 63 00 65 00 73 00   o.c.e.s.
00310: 73 00 6f 00 72 00 20 00   s.o.r. .
00318: 54 00 79 00 70 00 65 00   T.y.p.e.
00320: 3a 00 20 00 78 00 38 00   :. .x.8.
00328: 36 00 20 00 46 00 61 00   6. .F.a.
00330: 6d 00 69 00 6c 00 79 00   m.i.l.y.
00338: 20 00 31 00 35 00 20 00    .1.5. .
00340: 4d 00 6f 00 64 00 65 00   M.o.d.e.
00348: 6c 00 20 00 36 00 37 00   l. .6.7.
00350: 20 00 53 00 74 00 65 00    .S.t.e.
00358: 70 00 70 00 69 00 6e 00   p.p.i.n.
00360: 67 00 20 00 33 00 0d 00   g. .3...
00368: 0a 00 20 00 20 00 20 00   .. . . .
00370: 20 00 20 00 20 00 20 00    . . . .
00378: 20 00 57 00 69 00 6e 00    .W.i.n.
00380: 64 00 6f 00 77 00 73 00   d.o.w.s.
00388: 20 00 56 00 65 00 72 00    .V.e.r.
00390: 73 00 69 00 6f 00 6e 00   s.i.o.n.
00398: 3a 00 20 00 35 00 2e 00   :. .5...
003a0: 32 00 0d 00 0a 00 20 00   2..... .
003a8: 20 00 20 00 20 00 20 00    . . . .
003b0: 20 00 20 00 20 00 43 00    . . .C.
003b8: 75 00 72 00 72 00 65 00   u.r.r.e.
003c0: 6e 00 74 00 20 00 42 00   n.t. .B.
003c8: 75 00 69 00 6c 00 64 00   u.i.l.d.
003d0: 3a 00 20 00 33 00 37 00   :. .3.7.
003d8: 39 00 30 00 0d 00 0a 00   9.0.....
003e0: 20 00 20 00 20 00 20 00    . . . .
003e8: 20 00 20 00 20 00 20 00    . . . .
003f0: 53 00 65 00 72 00 76 00   S.e.r.v.
003f8: 69 00 63 00 65 00 20 00   i.c.e. .
00400: 50 00 61 00 63 00 6b 00   P.a.c.k.
00408: 3a 00 20 00 31 00 0d 00   :. .1...
00410: 0a 00 20 00 20 00 20 00   .. . . .
00418: 20 00 20 00 20 00 20 00    . . . .
00420: 20 00 43 00 75 00 72 00    .C.u.r.
00428: 72 00 65 00 6e 00 74 00   r.e.n.t.
00430: 20 00 54 00 79 00 70 00    .T.y.p.
00438: 65 00 3a 00 20 00 4d 00   e.:. .M.
00440: 75 00 6c 00 74 00 69 00   u.l.t.i.
00448: 70 00 72 00 6f 00 63 00   p.r.o.c.
00450: 65 00 73 00 73 00 6f 00   e.s.s.o.
00458: 72 00 20 00 46 00 72 00   r. .F.r.
00460: 65 00 65 00 0d 00 0a 00   e.e.....
00468: 20 00 20 00 20 00 20 00    . . . .

How to repeat:
Not sure.

Thank you for the bug report. Unlucky just with the Dr. Watson data we can't
guess the reason why your server is crashing, could you please enable the
general query log server start option (--log=filename_log) and when the
crash will happen again look the log and try to repeat with the last queries
logged in this way we can have a test case with specific query. Thanks in
advance.

Miguel, thank you for the response.  We were able to reproduce the crash with query logging activated but after getting the log and processing the queries one at a time we are not able to reproduce the crash on another machine.  Any suggestions?

Dimitris,

thank you for the feedback. To reproduce the case on our side we need content of error log from you and part of general query log with queries which were issued in crash time. Please upload them.

Also version 5.0.41 is a bit old and probably problem has been fixed. Please upgrade to current version 5.0.45, try with it and examine if problem still exists.

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