Hi

I've got a huge table which crashed to day - it just say it's locked.
After both a "repair" and a reboot it's still locked. I tried a
"check" and it gave me the following info:

Table Op Msg_type Msg_text
tableXX check warning Table is marked as crashed and last repair
failed
tableXX check warning Size of indexfile is: 1575015424 Should
be: 1...
tableXX check error Found 117350832 keys of 117350831
tableXX check error Corrupt

When I try a "select" I get the following message:

SQL desc `tableXX` failed : Can't open file: 'tableXX.MYI'. (errno:
144)
= "Table is crashed and last repair failed"

I really hope you have any good ideas?

tanx

On 26 Nov., 14:16, ask <ask...@gmail.com> wrote:
> Hi
>
> I've got a huge table which crashed to day - it just say it's locked.
> After both a "repair" and a reboot it's still locked. I tried a
> "check" and it gave me the following info:
>
> Table Op Msg_type Msg_text
> tableXX check warning Table is marked as crashed and last repair
> failed
> tableXX check warning Size of indexfile is: 1575015424 Should
> be: 1...
> tableXX check error Found 117350832 keys of 117350831
> tableXX check error Corrupt
>
> When I try a "select" I get the following message:
>
> SQL desc `tableXX` failed : Can't open file: 'tableXX.MYI'. (errno:
> 144)
> = "Table is crashed and last repair failed"
>
> I really hope you have any good ideas?
>
> tanx

gee ... freeing up som HDD space does help indeed