User table is DELETED !!

[Male_LadyBug]

at post table


warning >> Table is marked as crashed and last repair failed
warning >> 2 clients is using or hasn't closed the table properly
warning >> Size of indexfile is: 31593472 Should be: 23549952

error >> Found 574302 keys of 574301
error >> Corrupt
error >>28 when writing to datafile

[Male_LadyBug]

.post
error : 28 when writing to datafile
error : 28 when writing to datafile

[Steve Machol]

Error code 28: No space left on device

The partition it's trying to write to doesn't have enough space for the temp file it's trying to create. You'll need to free up some space on that partitition.

[Male_LadyBug]

You'll need to free up some space on that partitition

BUT

I used 73% from DB space !!

ok in the LAST the DB space was FULL but now i have more space.

what i do now to repair this problem ??

[Steve Machol]

As I said there is not enough space to crweate the temp files necessary to complete this operation. If you're still getting the '28' error, then the only thing you can do is free up more space.

Note you need to check all partitions - not just the one containing the database. It's possible the problem is on whichever partition is being used for temp files.

[Male_LadyBug]

>>> warning !!

repair status is OK but there warning !!
Number of rows changed from 541257 to 765934

what dos it mean ??

[Steve Machol]

What do you mean 'but there warning'?

[Male_LadyBug]

Warning msg ( at repair post table ):
Number of rows changed from 541257 to 765934

[Steve Machol]

I think that's more informative than a warning. Is everything working okay now?