Bug #40520 "ERROR 1030 (HY000) :Got error 1 from storage engine"

• Submitted: 5 Nov 2008 7:12
• Modified: 5 Dec 2008 18:48
• Reporter: manimekalai mahadevan
• Status: No Feedback
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 4.1.9-standard
• OS: Linux
• CPU Architecture: Any
• Tags: ERROR 1030 (HY000): Got error 1 from storage engine

[5 Nov 2008 7:12] manimekalai mahadevan

Description:
select distinct pr.name,sp.name,sp.sid from s1 sp,P1 pr,s2 asp where asp.pid=pr.pid and pr.pid='4' and sp.sid=asp.sid;
ERROR 1030 (HY000): Got error 1 from storage engine

select pr.name,sp.name,sp.sid from s1 sp,P1 pr,s2 asp where asp.pid=pr.pid and pr.pid='4' and sp.sid=asp.sid;
i am not getting any error. query is executed successfully. but repeated records are displaying. 

how to solve this. is there any alternate solution.

How to repeat:
mysql website

[5 Nov 2008 18:48] Valeriy Kravchuk

Please, try ot repeat with a newer version, 4.1.22 at least. In case of the same problem, please, send the results of:

EXPLAIN select distinct pr.name,sp.name,sp.sid from s1 sp,P1 pr,s2 asp where asp.pid=pr.pid and pr.pid='4' and sp.sid=asp.sid\G

EXPLAIN select pr.name,sp.name,sp.sid from s1 sp,P1 pr,s2 asp where asp.pid=pr.pid and pr.pid='4' and sp.sid=asp.sid\G

[6 Dec 2008 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".