Oninit cdi / Archive
Talk to an expert →

Re: Online Crash

Posted in 1997

David Williams — — source: Informix-list mailing list archive (1991-1998)

In article <61gkhp$9d8@cssun.mathcs.emory.edu>, sujata_soman_at_omm- la2-infotech-001@internet.omm.com writes > > Try debugging the shmem.* file to see what the user was doing. Use > onstat -i shmem.*, and use the onstat commands without the "onstat"> and the "-". I had a similar problem on 7.13 and narrowed it down to a > varchar value being accessed as an integer. funny but true. > > Sujata > > >______________________________ Reply Separator _________________________________ >Subject: Online Crash >Author: Miran Nikolic <miran.nikolic@telekom.si> at internet >Date: 10/7/97 12:24 PM > > > Hi > >I am running INFORMIX ONLINE 7.23 UC1 on SGI Challenge IRIX 6.2 > > >When server crashes I got messages > >------------------------------------------------ >af.dcd4aa5 > >09:17:57 >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 >09:17:57 Stack for thread: 3533 sqlexec> > base: 0x37266018 > len: 269312 > pc: 0x007f0c04 > tos: 0x372a67c0 > >0x007f0300 mt_affail >0x0069e5d4 rsam_affail >0x0048a1d8 hang_thread >0x00489fec afsig_segv > >----------------------------------------------- > >SYSLOG > >Oct 2 09:17:58 4A:fobos unix: WARNING: Process [oninit] pid 22212 >killed: process or stack limit exceeded > ************************************ This is the problem. UNIX killed the Online process because it reached a UNIX kernel limit check the following kernel parameters are set to unlimited. HDATLIM SDATLIM HSTKLIM SSTKLIM HVMMLIM SVMMLIM > >------------------------------------------------ > >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> > >So I thought there is a problem with stack size and I increased Online >variable STACKSIZE to 128, but server also crashed. >It is interesting that we had exactly the same problem with version >7.22. So we went to 7.23 and all was OK but just for about two months. > >Cheers! > >PS: Is version 7.23 UC6 better? > >Miran Nikolic > DBA and SGI administrator > > Telekom Slovenije > Ljubljana > Slovenia > > tel: +386 61 304 645 > fax: +386 61 132 93 98 > email: miran.nikolic@telekom.si > > > > > > > > > -- David Williams

Related threads