MySQL Bugs: #53919: mysql数据库服务频繁意外终止

Bug #53919	mysql数据库服务频繁意外终止
Submitted:	23 May 2010 2:18	Modified:	7 Dec 2016 16:01
Reporter:	haoyue qingfeng	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	5.0.18	OS:	Windows (错误应用程序 mysqld-nt.exe，版本 0.0.0.0，错误模块 mysqld-nt.exe，版本 0.0.0.0，错误地址 0x001fa173)
Assigned to:		CPU Architecture:	Any
Tags:	错误应用程序 mysqld-nt.exe，版本 0.0.0.0，错误模块 mysqld-nt.exe，版本 0.0.0.0，错误地址 0x001fa173

Description:
事件类型:	错误
事件来源:	Application Error
事件种类:	(100)
事件 ID:	1000
日期:		2010-5-15
事件:		14:06:03
用户:		计算机:	xxxx
描述:
错误应用程序 mysqld-nt.exe，版本 0.0.0.0，错误模块 mysqld-nt.exe，版本 0.0.0.0，错误地址 0x001fa173。

有关更多信息，请参阅在 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 6d 79   .0 in my
0030: 73 71 6c 64 2d 6e 74 2e   sqld-nt.
0038: 65 78 65 20 30 2e 30 2e   exe 0.0.
0040: 30 2e 30 20 61 74 20 6f   0.0 at o
0048: 66 66 73 65 74 20 30 30   ffset 00
0050: 31 66 61 31 37 33         1fa173 

事件类型:	信息
事件来源:	DrWatson
事件种类:	无
事件 ID:	4097
日期:		2010-5-15
事件:		14:06:04
用户:		x
计算机:	c
描述:
应用程序 E:\mysql\bin\mysqld-nt.exe 产生了一个应用程序错误 此错误发生在 05/15/2010 @ 14:06:04.020 所产生的意外情况为 c0000005，在地址 005FA173 (mysqld_nt)处

有关更多信息，请参阅在 http://go.microsoft.com/fwlink/events.asp 的帮助和支持中心
 

How to repeat:
事件类型:	错误
事件来源:	Application Error
事件种类:	(100)
事件 ID:	1000
日期:		2010-5-15
事件:		14:06:03
用户:		计算机:	xxxx
描述:
错误应用程序 mysqld-nt.exe，版本 0.0.0.0，错误模块 mysqld-nt.exe，版本 0.0.0.0，错误地址 0x001fa173。

有关更多信息，请参阅在 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 6d 79   .0 in my
0030: 73 71 6c 64 2d 6e 74 2e   sqld-nt.
0038: 65 78 65 20 30 2e 30 2e   exe 0.0.
0040: 30 2e 30 20 61 74 20 6f   0.0 at o
0048: 66 66 73 65 74 20 30 30   ffset 00
0050: 31 66 61 31 37 33         1fa173 

事件类型:	信息
事件来源:	DrWatson
事件种类:	无
事件 ID:	4097
日期:		2010-5-15
事件:		14:06:04
用户:		x
计算机:	c
描述:
应用程序 E:\mysql\bin\mysqld-nt.exe 产生了一个应用程序错误 此错误发生在 05/15/2010 @ 14:06:04.020 所产生的意外情况为 c0000005，在地址 005FA173 (mysqld_nt)处

有关更多信息，请参阅在 http://go.microsoft.com/fwlink/events.asp 的帮助和支持中心

Please, check with a recent version of MySQL server, 5.0.91. In case of the same problem, please, describe it in English.

Excuse me, what is the root cause of the problem, don't really mysql question version?
The web site will be written in some places code or data specification of the establishment of unreasonable?

Sorry, I would like to know about the error application error address 0x001fa173 mysqld_nt.exe is what does it mean, the most likely cause of this problem what are the basic reasons?

Thank you for the feedback.

But this ug system is supposed for handling bugs in MySQL code. Error message you post can be result of a bug in MySQL code, but version 5.0.18 is very old and most likely  such bug is fixed. Please upgrade to current verion 5.0.91, try with it and inform us if problem still not fixed.

Excuse me, very sorry, because the server has a web site before, running for a long time, mysql service does not appear automatically out of the phenomenon, but recently put the new site do run on the server appears to stop the phenomenon of its own mysql service To this, I have to suspect that a new design for the site somewhere unreasonable result mysql service terminated automatically! You as a mysql expert, with years of experience, you believe that some of the code php site can lead to the above errors happen? Or as you say will be replaced with mysql version 5.0.91 from the 5.0.18 really can avoid this problem? Mysql 5.0.18 problem is really a bug? Or mysql server processes undergone some conflicts? Thank you for your guidance!

Thank you for the feedback.

We can not say this is MySQL bug or not having information provided. But yes, PHP script can cause crash because one of reasons: bug in MySQL code or wrong setup on your side which allows MySQL to use more resources than you really have.  After 5.0.18 a lot of crashing bugs were fixed. So upgrade can fix the problem. So we need you to upgrade and if problem still repeatable we need information in English language which we can understand.

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

Posted by developer:
 
This relates to EOL (no longer supported) versions of MySQL Server. Thus closing.