MySQL ODBC Connector - error 28 from table handler

Author

error 28 from table handler

Jacques Brignon

2006-04-02, 8:26 pm

Hi,

I am getting the following error when executing a simple SELECT query
which used to work:

"1030 : Got error 28 from table handler"

I did not found that in the manual. When googleing it it seems it may be
related to disk space ...

The server hosting my application is running MySQL 4.0.23. My db uses
MyISAM tables

Any idea of what might cause that, and what should be done to correct
this situation?

--
Jacques

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sander Smeenk

2006-04-03, 7:32 am

Quoting Jacques Brignon (jacbrignon@online.fr):

> "1030 : Got error 28 from table handler"

% perror 28
OS error code 28: No space left on device

> Any idea of what might cause that, and what should be done to correct
> this situation?

Aparently the disk that stores your MySQL datadirectory is full.
Either you or your hoster should clean it up ;)

With regards,
Sander.

--
| Junk is something you've kept for years and throw away three weeks
| before you need it.
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Jacques Brignon

2006-04-03, 7:32 am

Thanks,

Table corruption is exactly what I fear as a result of this problem. As long as
things semm to work again now after the hister cleaned some temp files, how do
I check my db for possible table corruptions?

Selon prathima rao <prathimanrao@vsnl.net>:

> if u have shut down the system then the table would have been corrupted
> ----- Original Message -----
> From: "Jacques Brignon" <jacbrignon@online.fr>
> To: <mysql@lists.mysql.com>
> Sent: Monday, April 03, 2006 1:58 AM
> Subject: error 28 from table handler
>
>
> http://lists.mysql.com/mysql? unsub...v
snl.net
>
>

--
Jacques Brignon

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links