RE: Server down - Assert failed - Index bad...
Robin,
I remember experiencing a similar problem. The exact details have escaped
now. I believe we had Informix technical support dial in and fix the
page(s) in question. Not much to offer, HTH.
Scott
> -----Original Message-----
> From: Boscia [SMTP:rwboscia@worldnet.att.net]
> Sent: Thursday, August 03, 2000 2:24 AM
> To: informix-list@iiug.org
> Subject: Re: Server down - Assert failed - Index bad...
>
> P.S. I did run oncheck -cI then oncheck -cr, cc,ce and cD and came up with
> the same info. I was unable to drop the "bad index".
> Thanks again
> Robin
>
>
> > From: Boscia <rwboscia@worldnet.att.net>
> > Organization: AT&T Worldnet
> > Newsgroups: comp.databases.informix
> > Date: Thu, 03 Aug 2000 04:16:47 GMT
> > Subject: Server down - Assert failed - Index bad...
> >
> > Our instance is down!!
> >
> > Errors in the online.log
> > Assert Failed: Page Check Error in btsearch:bad btree node> >
> > Results: Possible inconsistencies in index
> > 'database:"informix".sysobjstate#objdesc
> >
> > When I run the oncheck -ci I get:
> >
> >
> >
> > Validating indexes for 'database':informix.sysobjstate...
> > Index objdesc
> > Unable to open input file 's'
> > Unable to open input file 'c'
> > Could not bfget pagenum 21, iserrno 105
> > ISAM error: bad isam file format.> > ERROR: Index objdesc for 'database':informix.sysobjstate is bad.
> > Index objtab
> > Unable to open input file 's'
> > Unable to open input file 'c'
> >
> >
> > Index objdesc is bad. OK to repair it? y
> > Unable to open input file 's'
> > Unable to open input file 'c'
> > Error recreating index.
> > ISAM error: duplicate value for a record with unique key.> >
> > Error reading from network
> > Abnormal end !!!
> >
> >
> > Then of course it "dies"....
> >
> > Also .... in the oncheck -pe it shows these .....
> >
> > PHYSICAL LOG Pages 63 100000
> > ERROR: Extents overlap
> > db:bx.accidcmp 119 8
> > ERROR: Extents overlap
> > db:bx.foreign_sw 127 8
> >
> > I can't seem to see a table named sysobjstate - should I?
> >
> >
> > So what do I do to fix this????
> >
> > All help will be appreciated....
> >
> > Thanks
> >
> > Robin
> >
> >
> >
> >
> >