>> Has there been an issue on the
>> box (like an OS panic or power failure) that could have caused updates
>> to the index file to partially written?
>
> We had a power failure some days ago and it could have some influence.
>
> ....
> ....
> This solved the problem !!! Thank you very much for your help. You
> made my day :-)))
OK, cool. Glad it worked out. Having a box drop it's power or having
the underlying OS bail out on you is a little hard to deal with. Well,
you can deal with it easily if you don't want any performance (sync
writes to the disk for each update etc). Just a rule of thumb for the
future : if the OS didn't get a chance to flush it's kernel buffers
then there's a good chance any active indicies will be corrupted.
But, as you can see, it's easy enough to recreate them. I'm glad to be
able to make your day ;-)
Bambi
..
-----------------------------------------------------------------
This is the Mini SQL Mailing List operated by Hughes Technologies
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Thu Sep 01 2005 - 00:20:01 PDT