Bug #25974 Server

• Submitted: 31 Jan 2007 13:19
• Modified: 1 Mar 2007 8:50
• Reporter: Anthony Glen
• Status: Can't repeat
• Category: MySQL Server: General
• Severity: S1 (Critical)
• Version: 4.1.14 / 5.0.27a
• OS: Linux (Linux Slackware 10)
• CPU Architecture: Any

[31 Jan 2007 13:19] Anthony Glen

Description:
Certain SQL queries will fail to complete execution under MySQL V4.1.14 and consistently cause the Linux server itself to grind to a halt; displaying multiple "httpd" processes having been spawned from tghe time the .  Rebooting the server is the only way to clear the problem.

This behaviour is not displayed under MySQL V3.23.56 (available in Slackware 9) where the same SQL queries execute properly and within a reasonable amnount of time.

How to repeat:
The following SQL query will cause this behaviour:

SELECT TMRS_0.CustomerFaultReference, TMRS_0.TMRSNumber, SLAs_0.SLADescription, Events_0.EventTime, Events_1.EventTime,  Events_2.EventTime, Events_0.EventComment
FROM TMRSDB.Events Events_0, TMRSDB.Events Events_1, TMRSDB.Events Events_2, TMRSDB.SLAs SLAs_0, TMRSDB.TMRS TMRS_0 
WHERE TMRS_0.SLANum = SLAs_0.SLANum AND Events_0.TMRSNum = TMRS_0.TMRSNum AND Events_1.TMRSNum = TMRS_0.TMRSNum AND Events_2.TMRSNum = TMRS_0.TMRSNum AND Events_0.EventDeleted = 'N' AND Events_1.EventDeleted = 'N' AND Events_2.EventDeleted = 'N' AND ((SLAs_0.SLADescription Like 'HIE%') AND (Events_0.EventNameNum=1) AND (Events_1.EventNameNum=6) AND (Events_2.EventNameNum=16))

[31 Jan 2007 13:35] Sveta Smirnova

Thank you for the report.

But version 4.1.14 is quite old. Please try with current full supported 5.0.27 version or current only has extended support 4.1.22 version and say us result.

[1 Mar 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".

[1 Mar 2007 8:30] Anthony Glen

Hi,
Repeating this large SELECT query under MySQL version 5.0.27a does appear to correct this problem and also others whereby the linux server was grinding to a halt  (i.e. running various other reports).

This does look like it has been corrected in this later version of the MySQL software.

[1 Mar 2007 8:44] Sveta Smirnova

Thank you for the comment.

> Repeating this large SELECT query under MySQL version 5.0.27a does
> appear to correct this problem

So I'll close this report as "Can't repeat". If you not agree fill free to describe why and reopen again.

[1 Mar 2007 8:50] Anthony Glen

Yes, please close this bug report.
Thank You