Bug #10741 [Stress] Linux mysql server hangs after nearly one hour of processing
Submitted: 19 May 2005 12:35 Modified: 16 Oct 2005 18:12
Reporter: Disha Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.5-beta OS:Linux (Fedora Core release 3 (Heidelber)
Assigned to: CPU Architecture:Any

[19 May 2005 12:35] Disha
Description:
Linux mysql server hangs after nearly one hour of processing. No queries execute on the server. The one hour period is a rough estimate. It may take more or even less time for the server to hang.

How to repeat:
1. Start 10 sessions on each of the 10 clients to connect to Linux mysql server.
2. In each session start execution of testfiles.

Expected Results: All the test files should be executed properly for as long as the stress run is executed.
    

Actual Results:  The test files execute properly for nearly an hour, after which the server seems to hang, without doing any processing.
    

Attachments:  	Master-Status_log-20050518.log
		Master-Status_log-20050519.log
		mysql_err_log.zip
		Mysql500_query_log1.zip
		Mysql500_query_log2.zip
		Mysql500_query_log3.zip
		Mysql500_query_log4.zip
		Mysql500_query_log5.zip
		Mysql500_query_log6.zip
[19 May 2005 12:36] Disha
Server Monitor Log file1

Attachment: Master-Status_log-20050518.log (application/octet-stream, text), 66.19 KiB.

[19 May 2005 12:37] Disha
MySQL server monitor log file2

Attachment: Master-Status_log-20050519.log (application/octet-stream, text), 89.14 KiB.

[19 May 2005 12:37] Disha
MySQL server error-log file

Attachment: mysql_err_log.zip (application/x-zip-compressed, text), 107.71 KiB.

[19 May 2005 12:37] Disha
MySQL server query-log file #1

Attachment: Mysql500_query_log1.zip (application/x-zip-compressed, text), 159.53 KiB.

[19 May 2005 12:38] Disha
MySQL server query-log file #2

Attachment: Mysql500_query_log2.zip (application/x-zip-compressed, text), 190.44 KiB.

[19 May 2005 12:38] Disha
MySQL server query-log file #3

Attachment: Mysql500_query_log3.zip (application/x-zip-compressed, text), 176.04 KiB.

[19 May 2005 12:39] Disha
MySQL server query-log file #4

Attachment: Mysql500_query_log4.zip (application/x-zip-compressed, text), 152.88 KiB.

[19 May 2005 12:39] Disha
MySQL server query-log file #5

Attachment: Mysql500_query_log5.zip (application/x-zip-compressed, text), 151.55 KiB.

[19 May 2005 12:39] Disha
MySQL server query-log file #6

Attachment: Mysql500_query_log6.zip (application/x-zip-compressed, text), 152.43 KiB.

[7 Jun 2005 11:57] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/25698
[16 Sep 2005 18:12] Valeriy Kravchuk
Have you tried to repeat this hang it on newer versions of MySQL? I'd recommend to try on 5.0.12 or latest snapshots of 5.0.14-rc?
[16 Oct 2005 23: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".