Re: Corrupt index

On Tue, Mar 18, 2003 at 10:03:54AM -0500, Amir Becher wrote:
> I am experiencing frequent index corruptions (approximately once a
> week). I solve the problem by using the REINDEX TABLE command and
> rerunning my programs. Does anyone know why I might be experiencing
> these problems? Also, is there a way to determine whether an index is
> corrupt (other than seeing inconsistencies in the data)?

I would ask some questions about your hardware.  Memtest86 and
badblocks may be useful to you on x86 Linux.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110