Bug #15009 Bug

• Submitted: 17 Nov 2005 9:55
• Modified: 17 Dec 2005 17:55
• Reporter: Waleed Tanvir
• Status: No Feedback
• Category: MySQL Server
• Severity: S2 (Serious)
• OS: Windows (Windows XP)
• CPU Architecture: Any

[17 Nov 2005 9:55] Waleed Tanvir

Description:
mySQL query error: SELECT DISTINCT(p.forum_id), f.name, COUNT(p.author_id) as f_posts FROM inv_posts p, inv_forums f WHERE p.forum_id IN (0,4,2,3,5,6) AND p.author_id='5814' AND p.forum_id=f.id GROUP BY p.forum_id ORDER BY f_posts DESC

mySQL error: Can't open file: 'inv_posts.MYI' (errno: 145)
mySQL error code: 
Date: Thursday 17th of November 2005 04:41:09 AM

How to repeat:
mySQL query error: SELECT DISTINCT(p.forum_id), f.name, COUNT(p.author_id) as f_posts FROM inv_posts p, inv_forums f WHERE p.forum_id IN (0,4,2,3,5,6) AND p.author_id='5814' AND p.forum_id=f.id GROUP BY p.forum_id ORDER BY f_posts DESC

mySQL error: Can't open file: 'inv_posts.MYI' (errno: 145)
mySQL error code: 
Date: Thursday 17th of November 2005 04:41:09 AM

[17 Nov 2005 17:55] Valeriy Kravchuk

Thank you for a problem report. Look:

C:\Documents and Settings\openxs>perror 145
MySQL error code 145: Table was marked as crashed and should be repaired

So, you have to execute the

REPAIR TABLE inv_posts EXTENDED;

statement and send the results it gives you. Then try to repeat the problematic query and inform about the results too.

See also http://dev.mysql.com/doc/refman/5.0/en/repair.html.

[18 Dec 2005 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".