327426 - Template_Error caused when MySQL has a 'Got error 127 from storage engine' error

Status: RESOLVED INVALID

(Bugzilla :: Bugzilla-General, defect)

Description

[Gavin Cattell]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1

While trying to access a specific bug, the message "Template_Error" kept appearing , Sanity check and checksetup.pl both showed no errors. 
Turning on the data/errorlog didn't show any errors relating to this bug.

After a few days fishing around I realised when running the command:
SELECT * FROM attachments WHERE bug_id=8358;
I was getting:
ERROR 1030 (HY000): Got error 127 from storage engine

A quick google later shows that a:
REPAIR TABLE attachments;
will fix the problem.

This bug isn't being raised about the MySQL error I understand that's an issue with MySQL, this bug is about the "Template_error" message I got, and the lack of any output into the error log. It's pretty tricky to tell why the bug is broken.

Can anything be done to help furture debugging/error logging?

System Details:
Redhat AS 3 
MySQL 4.1x
Bugzilla 2.20

Regards
Gavin Cattell

Reproducible: Sometimes

Steps to Reproduce:
1. A TABLE in the MySQL database must be showing a 'Got error 127 from storage engine' error.
2. Go to the bug to which the error is associated.
3. Check the logs to show that no output for this error was received.

Actual Results:  
No output in logs :(

Expected Results:  
Output in logs showing me what the problem was :)

Comment 1

[Frédéric Buclin]

Looks like a problem with MySQL rather than Bugzilla to me.