Bug #8241 "Got error 28 from table handler" when making a distinct on a text type column

• Submitted: 1 Feb 2005 16:26
• Modified: 3 Feb 2005 16:38
• Reporter: [ name withheld ]
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.0.23
• OS: Solaris (solaris 8)
• CPU Architecture: Any

[1 Feb 2005 16:26] [ name withheld ]

Description:
We're using a Solaris 8 (Sparc 32) binary distribution.
We have a table with a text type column called "remarques" (this table has only 173 records, and uses 106Ko on hard disc).
When we are making a query "SELECT distinct(remarques) FROM table", we got this message : "Got error 28 from table handler".
There's no problem of storage, our disk is not full at all (/tmp have 1% used and /db, where are the datas, have 6% used).
Any Ideas ?

How to repeat:
1) Installing a Solaris 8 (Sparc 32) binary distribution.
2) Create a table with a text type column.
3) Making a query "SELECT distinct([text type column]) FROM table"

[3 Feb 2005 16:32] [ name withheld ]

Sorry,

Our /var partition was full, that's the reason of all of this !
No more problem to report.