Oninit cdi / Archive
Talk to an expert →

HELP: Informix doesn't come up anymore

Posted in 2003

Topics: Error Codes & Troubleshooting, Server Administration, Logging & Checkpoints

Tim — — source: , line -1, thread 7, proc id 185, No Exception Handler.@@NL@@@@NL@@12:16:49 PANIC: Attempting to bring system down@@NL@@@@NL@@Sat May 03 12:26:26 2003@@NL@@@@NL@@12:26:26 DR: DRAUTO is 0 (Off)@@NL@@@@NL@@12:26:32 Informix Dynamic Server Version 7.31.TC2 Software Serial Number@@NL@@AAC#J726137@@NL@@@@NL@@12:26:32 Assert Failed: No Exception Handler@@NL@@@@NL@@12:26:32 Informix Dynamic Server Version 7.31.TC2@@NL@@@@NL@@12:26:32 Who: Session(2, informix@, 0, 0)@@NL@@@@NL@@Thread(7, soctcppoll, 0, 7)@@NL@@@@NL@@Exception at Addr: 0x77f64ab3, TOS: 0x25561ca8, FP:0x25561d60, Exc: c0000005@@NL@@@@NL@@12:26:32 Results: Exception Caught. Type: MT_EX_OS, Context: mem@@NL@@@@NL@@12:26:32 Action: Please notify Informix Technical Support.@@NL@@@@NL@@12:26:33 Informix Dynamic Server Initialized -- Shared Memory Initialized.@@NL@@@@NL@@12:26:33 Physical Recovery Started.@@NL@@@@NL@@12:26:33 Physical Recovery Complete: 0 Pages Restored.@@NL@@@@NL@@12:26:33 Logical Recovery Started.@@NL@@@@NL@@===========------------- - - - - - -@@NL@@@@NL@@E:\\INFORMIX\\bin\\onstat -g ath: 7@@NL@@@@NL@@Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:17 --@@NL@@347584 Kbytes@@NL@@@@NL@@Threads:@@NL@@@@NL@@tid tcb rstcb prty status vp-class name@@NL@@@@NL@@2 2549ebe8 0 2 sleeping forever 3lio lio vp 0@@NL@@@@NL@@3 2549ee58 0 2 sleeping forever 4pio pio vp 0@@NL@@@@NL@@4 2549f0c8 0 2 sleeping forever 5aio aio vp 0@@NL@@@@NL@@5 2549f338 0 2 sleeping forever 6msc msc vp 0@@NL@@@@NL@@6 254f2230 253ba018 4 sleeping secs: 1 1cpu main_loop()@@NL@@@@NL@@7 254f2d00 0 2 running 7soc soctcppoll@@NL@@@@NL@@8 254f3548 0 2 running 8soc soctcpio@@NL@@@@NL@@9 254f3d40 0 3 sleeping forever 1cpu soctcplst@@NL@@@@NL@@10 2552a458 253ba500 2 sleeping forever 1cpu flush_sub(0)@@NL@@@@NL@@11 2552a678 253ba9e8 2 sleeping forever 1cpu flush_sub(1)@@NL@@@@NL@@12 2552a8c0 253baed0 2 sleeping forever 1cpu flush_sub(2)@@NL@@@@NL@@13 2552ab08 253bb3b8 2 sleeping forever 1cpu flush_sub(3)@@NL@@@@NL@@14 2552ad50 0 4 sleeping forever 5aio kaio@@NL@@@@NL@@15 2552b300 0 4 sleeping forever 1cpu kaio@@NL@@@@NL@@16 2552e278 253bb8a0 3 sleeping forever 1cpu aslogflush@@NL@@@@NL@@17 2552e588 253bbd88 2 sleeping secs: 59 1cpu btclean@@NL@@@@NL@@18 2552e910 253bc270 2 ready 1cpu fast_rec@@NL@@@@NL@@18 2552e910 253bc270 2 running 1cpu fast_rec@@NL@@@@NL@@19 2552ee88 253bc758 2 sleeping secs: 1 1cpu bld_logrecs@@NL@@@@NL@@20 2552f0d0 253bcc40 2 cond wait packet_con 1cpu logredo@@NL@@@@NL@@21 2552f870 253bd128 2 cond wait packet_con 1cpu xchg_1.0@@NL@@@@NL@@22 2552fab8 253bd610 2 cond wait packet_con 1cpu xchg_1.1@@NL@@@@NL@@23 2552fd00 253bdaf8 2 cond wait packet_con 1cpu xchg_1.2@@NL@@@@NL@@24 2549f5a8 253bdfe0 2 cond wait packet_con 1cpu xchg_1.3@@NL@@@@NL@@25 2549f750 253be4c8 2 cond wait packet_con 1cpu xchg_1.4@@NL@@@@NL@@26 2549f970 253be9b0 2 cond wait packet_con 1cpu xchg_1.5@@NL@@@@NL@@27 2549fbb8 253bee98 2 cond wait packet_con 1cpu xchg_1.6@@NL@@@@NL@@28 2549fe00 253bf380 2 cond wait packet_con 1cpu xchg_1.7@@NL@@@@NL@@29 254ba2a0 253bf868 2 cond wait packet_con 1cpu xchg_1.8@@NL@@@@NL@@30 254ba4c0 253bfd50 2 cond wait packet_con 1cpu xchg_1.9@@NL@@@@NL@@31 254bae98 253c0238 2 sleeping secs: 1 1cpu xchg_2.0@@NL@@@@NL@@===========------------- - - - - - -@@NL@@@@NL@@E:\\INFORMIX\\bin\\onstat -g stk 7 light:@@NL@@@@NL@@Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:17 --@@NL@@347584 Kbytes@@NL@@@@NL@@Stack for thread: 7 soctcppoll@@NL@@@@NL@@base: 0x2555e018@@NL@@@@NL@@len: 16896@@NL@@@@NL@@pc: 0x00697f60@@NL@@@@NL@@tos: 0x2556200c@@NL@@@@NL@@state: running@@NL@@@@NL@@vp: 7@@NL@@@@NL@@0xfffffff0 (***nosymtab***)0xfffffff0@@NL@@@@NL@@===========------------- - - - - - -@@NL@@@@NL@@E:\\INFORMIX\\bin\\onstat -u: 2@@NL@@@@NL@@Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:18 --@@NL@@347584 Kbytes@@NL@@@@NL@@Userthreads@@NL@@@@NL@@address flags sessid user tty wait tout locks nreads nwrites@@NL@@@@NL@@253ba018 ---P-RD 1 informix - 0 0 0 23 0@@NL@@@@NL@@253ba500 ---P--F 0 informix - 0 0 0 0 0@@NL@@@@NL@@253ba9e8 ---P--F 0 informix - 0 0 0 0 0@@NL@@@@NL@@253baed0 ---P--F 0 informix - 0 0 0 0 0@@NL@@@@NL@@253bb3b8 ---P--F 0 informix - 0 0 0 0 0@@NL@@@@NL@@253bb8a0 ---P--- 6 informix - 0 0 0 0 0@@NL@@@@NL@@253bbd88 ---P--B 7 informix - 0 0 0 0 0@@NL@@@@NL@@253bc270 ---P-RD 8 informix - 0 0 0 19 0@@NL@@@@NL@@253bcc40 Y----RD 8 informix - 2552f400 0 0 0 0@@NL@@@@NL@@253bd128 Y----RD 8 informix - 254baa28 0 0 0 0@@NL@@@@NL@@253bd610 Y----RD 8 informix - 254ba9e0 0 0 0 0@@NL@@@@NL@@253bdaf8 Y----RD 8 informix - 254ba998 0 0 0 0@@NL@@@@NL@@253bdfe0 Y----RD 8 informix - 254ba950 0 0 0 0@@NL@@@@NL@@253be4c8 Y----RD 8 informix - 254ba908 0 0 0 0@@NL@@@@NL@@253be9b0 Y----RD 8 informix - 254ba8c0 0 0 0 0@@NL@@@@NL@@253bee98 Y----RD 8 informix - 254ba878 0 0 0 0@@NL@@@@NL@@253bf380 Y----RD 8 informix - 254ba830 0 0 0 0@@NL@@@@NL@@253bf868 Y----RD 8 informix - 254ba7e8 0 0 0 0@@NL@@@@NL@@253bfd50 Y----RD 8 informix - 254ba7a0 0 0 0 0@@NL@@@@NL@@253c0238 -----RD 8 informix - 0 0 0 0 0@@NL@@@@NL@@20 active, 128 total, 0 maximum concurrent@@NL@@@@NL@@===========------------- - - - - - -@@NL@@@@NL@@E:\\INFORMIX\\bin\\onstat -g ses 2:@@NL@@@@NL@@Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:18 --@@NL@@347584 Kbytes@@NL@@@@NL@@session #RSAM total used@@NL@

Hi, your help is greatly appreciated on this matter !! Yesterady somebody rebooted the NT server in the middle of an import. When starting oninit, we get following error: the af.xxxx file 12:26:32 12:26:32 Informix Dynamic Server Version 7.31.TC2 Software Serial Number AAC#J726137 12:26:32 Assert Failed: No Exception Handler 12:26:32 Who: Session(2, informix@, 0, 0) Thread(7, soctcppoll, 0, 7) Exception at Addr: 0x77f64ab3, TOS: 0x25561ca8, FP:0x25561d60, Exc: c0000005 12:26:32 Results: Exception Caught. Type: MT_EX_OS, Context: mem 12:26:32 Action: Please notify Informix Technical Support. --------------------------------- Begin System Alarm Program Output --------------------------------- +-+-+-+-+-+-+-+-+-+-+-+-+-+ SYSALARMPROG Debug Info ON +-+-+-+-+-+-+-+-+-+-+-+-+-+ Arguments: AF_CLASS = 3 AF_ID = AF_FILE = \\tmp\\af.3ef9958 SES_ID = 2 RSTCB = 0x0 THREAD_ID = 7 TCB = 0x254f2d00 BITMASK = 513 AF_DIR = \\tmp Bits on: Global settings: BLOCK_SYSTEM = off DIAG_AFWARN = off WRITE_TO_CONSOLE = off DBA = informix SEND_DBA_MAIL = off RAS = rasnotice@informix.com SEND_RAS_MAIL = off COMPRESS = "None" COMPRESS_SUFFIX = DO_ONSTAT_G_ALL = off DO_ONSTAT_A = off PRINT_POOL = off SHORT_BLOCK_TIME = 600 LONG_BLOCK_TIME = 3600 CONSOLE = DUMPDIR = \\tmp IBIN = E:\\INFORMIX\\bin ONSTAT = E:\\INFORMIX\\bin\\onstat ONCHECK = E:\\INFORMIX\\bin\\oncheck ONMODE = E:\\INFORMIX\\bin\\onmode Host Name: BAAN Database Server Name: ol_baan Date and Time of failure: The current date is: Sat 05/03/2003 The current time is: 12:26:33.50 Shared memory file: "None" ===========------------- - - - - - - onstat -m: Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:16 -- 347584 Kbytes Message Log File: E:\\informix\\online.log 12:14:35 Checkpoint Completed: duration was 0 seconds. 12:14:44 See Also: af.3ef9683, shmem.3ef9683.0 12:16:49 \

↪ replying to Tim
Obnoxio The Clown — — source: Usenet: comp.databases.informix

Tim wrote: > Hi, > > your help is greatly appreciated on this matter !! > 12:26:32 Action: Please notify Informix Technical Support. The other 3528 lines of this post were just a waste of bandwidth.

Related threads

Glossary