Re: ISAM -172 (Unexpected Internal Error)

Mike Bradbeer wrote: > > We are currently running some cleanup sql scripts and keep having this > error. > > -240 and the ISAM -172 ISAM error occurs also. > > We perform all the oncheck's identified in the online.log and this fixes the > indexes it says are bad. > > Re-run the scripts and they fall over again after 20 deletes of a > > (DELETE FROM titles WHERE 1=1) > > This is extremely urgent and I have taken the database offline until I can > resolve this so if anyone can point me in a direction I would be > most gratefule I'd definitely suggest unloading the table and dropping it and recreating it. Do you have multiple instances so that it is possible that physical chunks are being used by both servers and trashing each other? Or maybe someone has created an FS that overlaps a RAW chunk? Art S. Kagel