Re: Online Crash

Posted in 1997

Roland M�ller — Tue, 07 Oct 1997 16:48:25 +0100 — source: Informix-list mailing list archive (1991-1998)

Miran Nikolic wrote: > I am running INFORMIX ONLINE 7.23 UC1 on SGI Challenge IRIX 6.2 > > When server crashes I got messages > <SNIP> > online.log > > 09:17:57 Assert Failed: Internal Error - Segmentation Violation > 09:17:57 Who: Session(2308, metacube@fobos, 231, 904512680) > Thread(3533, sqlexec, 35e7d958, 4) > 09:17:57 Results: OnLine must abort > 09:17:57 Action: Reinitialize shared memory > 09:17:57 See Also: /tmp/af.dcd4aa5, shmem.dcd4aa5.0> > email: miran.nikolic@telekom.si I am just guessing, but try to set OPTCOMPIND to 0. Maybe ye olde Optimizer crashed on figuring out how to get the data. Updating statistics might help as well. Regards, Roland