Re: Segmentation Violation bug

David Williams <djw@smooth1.demon.co.uk> p''e v''l'nku <VPWAPMALolz0Ewib@smooth1.demon.co.uk>? > In article <01bd2b31$7350a9e0$e12a6cc2@jdufek.brno.iss.cz>, Josef Dufek > <jdufek@iss.cz-NOSPAM> writes > >Hallo! > > > >I have rewrited some of my 4gl reports (originaly generated by FourGen) > >into SP. But this SP breaks our server. This happen from time to time > >and I am unable to find a solution (except upgrading). > > > >From the online.log: > >Assert Failed: Internal Error - Segmentation Violation > >Who:Session(2205, stcbuc02@gemini2.gr.spt.cz, 16951, 109249008) > > Thread(2634, sqlexec, 67f8dd8, 1)> >Results: OnLine must abort > >Action: Reinitialize shared memory > >/usr/var/adm/crash/af.a4a9941, shmem.a4a9941.0 > > What does /usr/var/adm/crash/af.a4a9941 say? 09:22:26 09:22:26 Assert Failed: Internal Error - Segmentation Violation 09:22:26 Who:Session(2205, stcbuc02@gemini2.gr.spt.cz, 16951, 109249008) Thread(2634, sqlexec, 67f8dd8, 1) 09:22:26 Results: OnLine must abort 09:22:26 Action: Reinitialize shared memory 09:22:26 See Also: /usr/var/adm/crash/af.a4a9941, shmem.a4a9941.0 09:22:26 Stack for thread: 2634 sqlexec base: 0x000000000a8fc020 len: 66560 pc: 0x00000001203934d0 tos: 0x000000000a90aa50 0x0000000000000000 ***unknown*** 09:23:01 ------------------ End of assertion failure 0 ----------------- > Or > > onstat -g ses 2205 shmem.a4a9941.0 *** WARNING: INFORMIX-OnLine server is no longer running. *** INFORMIX-OnLine Version 7.13.UC2X1 -- On-Line (LONGTX) -- Up 10 days 02:37:10 -- 229112 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 2205 stcbuc02 ttyp8 16951 gemini2. 1 1466368 1410856 tid name rstcb flags curstk status 2634 sqlexec 67f8dd8 ---P--- 6608 running Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 2205 V a1d8020 1417216 39840 1161 74 2205_SORT_0 V 96a8020 49152 15672 7 2 name free used name free used overhead 15672 336 scb 0 160 opentable 0 55336 filetable 0 6008 ru 0 360 misc 160 0 log 0 2192 temprec 0 5496 ralloc 15064 1182056 gentcb 0 248 ostcb 0 2976 net 0 9808 sort 536 33640 sqscb 0 25736 sql 72 0 srtmembuf 0 128 rdahead 0 1544 hashfiletab 0 552 osenv 0 1408 buft_buffer 4352 64712 sqtcb 15944 12064 fragman 3232 5864 shmblklist 480 232 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 2205 EXEC PROCEDURE eko DR Wait 10 0 0 6.05 Last parsed SQL statement : execute procedure s_rit2i2(?,null,?,?,null,null,null,?) User-created Temp tables : partnum tabname rowsize 1000db tmpradek 43 1000da tmpsesta 1580 1000d9 tmpdotaz 1580 1000d8 tmppredl 43 1000d7 tmpvykaz 65 1000c1 tmpoblst 156 1000c0 tmpparam 101 *** WARNING: INFORMIX-OnLine server is no longer running. *** > and > onstat -g ath shmem.a4a9941.0 *** WARNING: INFORMIX-OnLine server is no longer running. *** INFORMIX-OnLine Version 7.13.UC2X1 -- On-Line (LONGTX) -- Up 10 days 02:40:00 -- 229112 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 6966778 0 2 sleeping(Forever) 3lio lio vp 0 3 6966c98 0 2 sleeping(Forever) 4pio pio vp 0 4 69671b8 0 2 sleeping(Forever) 5aio aio vp 0 5 69676d8 0 2 sleeping(Forever) 6msc msc vp 0 6 6967df8 67f6020 4 ready 1cpu main_loop() 7 6982f88 0 2 sleeping(Forever) 1cpu soctcppoll 8 6983df0 0 2 running 7shm sm_poll 9 6a21958 0 3 sleeping(Forever) 1cpu soctcplst 10 6a42a70 0 2 sleeping(Forever) 1cpu sm_listen 11 6a58b08 0 2 ready 1cpu sm_discon 12 6a58ef8 67f66a8 2 sleeping(Forever) 1cpu flush_sub(0) 13 6a59320 67f6d30 2 sleeping(Forever) 1cpu flush_sub(1) 14 6a59748 67f73b8 2 sleeping(Forever) 1cpu flush_sub(2) 15 6a59b70 67f7a40 2 sleeping(Forever) 1cpu flush_sub(3) 16 6a430e0 0 4 sleeping(Forever) 1cpu kaio 17 6a43df0 67f80c8 2 ready 1cpu btclean 33 7394bc8 67f9460 4 ready 1cpu onmode_mon 52 6ba0df8 67fcf28 3 cond wait(netnorm) 1cpu ontape 1879 8076610 67fc8a0 2 cond wait(netnorm) 1cpu sqlexec 2334 77f6b08 6805ed8 2 cond wait(netnorm) 1cpu sqlexec 2372 802e0b8 67fe948 2 cond wait(netnorm) 1cpu sqlexec 2403 7af0628 67fefd0 2 cond wait(netnorm) 1cpu sqlexec 2422 84ae578 68037a8 2 cond wait(sm_read) 1cpu sqlexec 2424 75aa098 6807270 2 cond wait(sm_read) 1cpu sqlexec 2478 8f8cf78 67ffce0 2 cond wait(netnorm) 1cpu sqlexec 2484 7452a28 68044b8 2 ready 1cpu sqlexec 2572 9acc350 6805850 2 ready 1cpu sqlexec 2583 7da3928 67fc218 2 ready 1cpu sqlexec 2591 72e3858 67fb508 2 cond wait(netnorm) 1cpu sqlexec 2617 8f8d2d0 6803e30 2 cond wait(netnorm) 1cpu sqlexec 2621 77ac1a8 6801700 2 cond wait(netnorm) 1cpu sqlexec 2634 72e4118 67f8dd8 2 running 1cpu sqlexec 2636 85c48e8 68078f8 2 cond wait(netnorm) 1cpu sqlexec 2637 6cb5e20 680a6b0 3 sleeping(Forever) 1cpu logbackup *** WARNING: INFORMIX-OnLine server is no longer running. *** > > >rsinit.c, line 9217, thread 2634, proc id 26089, Segmentation Violation. > >PANIC: Attempting to bring system down > > > >OSF1 V3.2 62 alpha > >INFORMIX-OnLine Dynamic Server 7.13.UC2X1 > > > >Did you see such a bug? > > > >Thanx. > >Pepa. > > > > -- > David Williams > > Maintainer of the Informix FAQ > Primary site (Beta Version) http://www.smooth1.demon.co.uk > Official site http://www.iiug.org/techinfo/faq/faq_top.html > > I see you standin', Standin'