ERROR 1030: Got error 127 from table handler

[gj165]

I have a mysql database that was working perfectly
until I upgraded from Solaris 2.5 to 2.7.

I have many tables, all other tables work except one
that got such an error:

mysql> select * from users;
ERROR 1030: Got error 127 from table handler


If I say
select * from users where key=1234;

then it will be OK, but not selecting all?

Can anybody help?

 

[cathl]

I got this error message once, I can't remember how I got it but it wasn't anything to do with Solaris. Anyway I fixed it using the REPAIR TABLE command, its worth a try!