MySQL Bugs: #56994: ERROR 1030 (HY000): Got error 28 from storage engine

Bug #56994	ERROR 1030 (HY000): Got error 28 from storage engine
Submitted:	24 Sep 2010 4:29	Modified:	24 Sep 2010 4:48
Reporter:	HARIKRUSHNA VANPARIYA	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S1 (Critical)
Version:	5.0.27-standard	OS:	Solaris
Assigned to:		CPU Architecture:	Any
Tags:	1030 (HY000), error, solaris, Sun

Description:

When I am trying to execute the commnad to show the structure of the table it throws the error : "ERROR 1030 (HY000): Got error 28 from storage engine
". 

Other Commands like "select * from tableName;" shows the table content but I am not able to fetch the structure of the table. I am also able to create a new table and add content to the table. The error just thrown when I try to execute the command to see the structure of the table.

It also shows same error when I try the command : "SHOW COLUMNS FROM TableName;"
 What can be the possible solution for this? How can I resolve this error?
Please provide me urgent guidelines as my application get stuck due to this. 
Please also suggest some workaround if available.

How to repeat:
$ desc TableName;

It gives the following error on the next line:
ERROR 1030 (HY000): Got error 28 from storage engine

$SHOW COLUMNS FROM TableName;
ERROR 1030 (HY000): Got error 28 from storage engine

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Hint: OS error code  28:  No space left on device. Check free space in the /tmp filesystem or filesystem TMPDIR environment variable points to.