Bug #74081 MySQL crashes, self recovery every few days

• Submitted: 25 Sep 2014 17:33
• Modified: 25 Oct 2014 20:13
• Reporter: Bob Jones
• Status: No Feedback
• Category: MySQL Server: Query Cache
• Severity: S2 (Serious)
• Version: 5.5.17
• OS: Windows (repeated crash,self recovers)
• CPU Architecture: Any
• Tags: crash, recovery, rollback, windows

[25 Sep 2014 17:33] Bob Jones

Description:
I am reporting on behalf of a large enterprise organization. We have 1 client machine whose mysql install repeatedly crashes. The log reports numerous transaction rollbacks, and it generally recovers itself and moves on. Sometimes it cannot recover, and at the end of the error log will be "invalid pointer" and a query. We have mysql analysis process though level 6(? out IT did this, I'm trying to recall). We've run disk health checks. We have PRTG monitor setup and it is reporting nothing out of the ordinary, though we are not sure what we are looking for. I have error log file to send but don't see how to attach.

How to repeat:
Not reproducible on demand, but happens frequently for 1 client machine out of hundreds in our network on mysql 5.5.17

Suggested fix:
?

[25 Sep 2014 17:37] Bob Jones

MySQL Crash with self recovery

Attachment: mysql crash.txt (text/plain), 28.91 KiB.

[25 Sep 2014 20:13] MySQL Verification Team

Thank you for the bug report. Your server version is quite older 5.5.17! please try current release 5.5.40. Thanks.

[26 Oct 2014 1: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".