Online Crash
Posted in 1997
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
------------------------------------------------
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