RE: Problem installing IDS 9.40 on Linux
Posted in 2003
Strange.
Your server has crashed during SQL parsing...
Just routine server operation.
I've successfully run 9.40uc1 on RH7.2 without any problem..
Is this crash reproducible?
If Yes, You should test Your entire environment carefully.
(onconfig, lacale setting, IFMX-specific variables, etc)
------------------------------------------
Alexey Sonkin
Senior Database Administrator
> -----Original Message-----
> From: Ph. Chantry [mailto:nospam@nomail.com]
> Sent: Tuesday, August 26, 2003 9:45 AM
> To: informix-list@iiug.org
> Subject: Re: Problem installing IDS 9.40 on Linux
>
> > whats printed in the /tmp/af.3fce8fc file?
>
> 19688 lines... I send below the 120 first one. If you need more, let me
> know.
> Thanks,
> Philippe
>
> 12:46:21
> 12:46:21 Informix Dynamic Server Version 9.40.UC1 Software Serial> Number AAA#B000000
>
> 12:46:21 Assert Failed: No Exception Handler
> 12:46:21 Who: Session(9, informix@dat3ix.seditel.fr, 7545, 0x10d87af8)
> Thread(20, sqlexec, 10d58478, 1)
> File: mtex.c Line: 431
> 12:46:21 Results: Exception Caught. Type: MT_EX_OS, Context: mem
> 12:46:21 Action: Please notify Informix Technical Support.
> 12:46:21 Stack for thread: 20 sqlexec>
> base: 0x1141a000
> len: 36864
> pc: 0x085cfa2b
> tos: 0x11421794
> state: running
> vp: 1
>
> 0x085cfa2b (oninit)afstack (0x112928c8, 0x3f49e8fd, 0x11421d9c, 0x85cefd2,
> 0x88746c0, 0x1d67)
> 0x085cefe0 (oninit)afhandler(0x3, 0x8874e8f, 0x11421e3c, 0x10b7dc30,
> 0x601,
> 0x1)
> 0x085cea65 (oninit)afcrash_interface(0x8874e8f, 0x11421e3c, 0x10b7dc30,
> 0x8874e88, 0x1af, 0x886ed4d)
> 0x085d262e (oninit)mt_ex_throw_sig(0x1, 0x886ed4d, 0x0, 0x11424bdc,
> 0x4002ec20, 0x63)
> 0x085aa6e9 (oninit)afsig_handler(0xb, 0x11421fa0, 0x11422020, 0x10193018,
> 0x1143c538, 0x1143c538)
> 0x4002a7e6 </lib/i686/libpthread.so.0>(null)(0xb, 0x11421fa0, 0x11422020,
> 0xb, 0x0, 0x80)
> 0x42028550 </lib/i686/libc.so.6>(null)(0x0, 0xd, 0x0, 0x1143c538,
> 0x1143c538, 0x11440ef0)
> 0x08389ded (oninit)p_smview(0x11440ec8, 0x1143c538, 0x114223a8, 0x8384fc4,
> 0x1143c538, 0x8927fcc)
> 0x083852ad (oninit)p_smstmt(0x11440ef0, 0x1143c538, 0x114223d8, 0x83824ec,
> 0x2, 0x8927fcc)
> 0x08384fa2 (oninit)p_smentry(0x11440ef0, 0x4, 0x11422878, 0x835c579,
> 0x11426548, 0x11427018)
> 0x0835c6f6 (oninit)spparse (0x11428928, 0x114228ec, 0x114228f0, 0x0, 0x0,
> 0x0)
> 0x082c5b91 (oninit)exstmt (0x11426548, 0x0, 0x114228f4, 0x0, 0x0,
> 0x8820910)
> 0x082c5db7 (oninit)scread (0x8820910, 0x0, 0x0, 0x0, 0x0, 0x100003)
> 0x082c76fa (oninit)cdbscript(0x8820910, 0x0, 0x11422e58, 0x82bfd09,
> 0x114282f8, 0x114282f8)
> 0x082bfd20 (oninit)dbcreate(0x114282f8, 0x2, 0x11422e88, 0x81d4978,
> 0x114282f8, 0x114282f8)
> 0x08191434 (oninit)aud_dbcreate(0x114282f8, 0x11335e6c, 0x11422ed8,
> 0x85818c5, 0x11422f0c, 0x11428498)
> 0x081e81d8 (oninit)sqcreatedb(0x114282f8, 0x11422f08, 0x11422f0c,
> 0x11422f10, 0x11422f70, 0x114282f8)
> 0x08369c90 (oninit)excommand(0x114282f8, 0xc, 0x2, 0x835bc56, 0x7, 0x4)
> 0x082fa0ea (oninit)sq_execute(0xa, 0x7, 0x0, 0x0, 0x0, 0x0)
> 0x08355a49 (oninit)sqmain (0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
> 0x085b4980 (oninit)startup (0x0, 0x11423670, 0x11423058, 0x670,
> 0x22846d39,
> 0x0)
> 0x00000000 (*nosymtab*)0x0
>
>
> 12:46:21 See Also: /tmp/af.3fce8fc>
> ---------------------------------
> Begin System Alarm Program Output
> ---------------------------------
>
> Assertion Failure Type: CRASH
> Host Name: dat3ix.seditel.fr
> Database Server Name: itest940
> Time of failure: Mon Aug 25 12:46:21 CEST 2003
> AF file: /tmp/af.3fce8fc
> Shared memory file: None
> System Blocking: OFF
>
>
> ===========------------- - - - - - -
> tail -100 /usr1/informix940/itest.log:
>
> 12:46:11 Informix Dynamic Server Started.>
> Mon Aug 25 12:46:11 2003
>
> 12:46:11 Event alarms enabled. ALARMPROG =
> '/usr1/informix940/etc/log_full.sh'
> 12:46:11 Booting Language <c> from module <>
> 12:46:11 Loading Module <CNULL>
> 12:46:11 Booting Language <builtin> from module <>
> 12:46:11 Loading Module <BUILTINNULL>
> 12:46:16 Informix Dynamic Server Version 9.40.UC1 Software Serial> Number AAA#B000000
> 12:46:16 Dynamically allocated new virtual shared memory segment (size
> 8192KB)
> 12:46:20 Informix Dynamic Server Initialized -- Complete Disk> Initialized.
> 12:46:20 Checkpoint Completed: duration was 0 seconds.
> 12:46:20 Checkpoint loguniq 1, logpos 0xcc, timestamp: 82
>
> 12:46:20 Maximum server connections 0
> 12:46:20 Dataskip is now OFF for all dbspaces
> 12:46:20 On-Line Mode
> 12:46:20 Building 'sysmaster' database ...
> 12:46:21 Assert Failed: No Exception Handler
> 12:46:21 Informix Dynamic Server Version 9.40.UC1
> 12:46:21 Who: Session(9, informix@dat3ix.seditel.fr, 7545, 0x10d87af8)
> Thread(20, sqlexec, 10d58478, 1)
> File: mtex.c Line: 431
> 12:46:21 Results: Exception Caught. Type: MT_EX_OS, Context: mem
> 12:46:21 Action: Please notify Informix Technical Support.
> 12:46:21 stack trace for pid 7527 written to /tmp/af.3fce8fc
> 12:46:21 See Also: /tmp/af.3fce8fc>
>
> ===========------------- - - - - - -
> /usr1/informix940/bin/onstat -g ath:
>
> Informix Dynamic Server Version 9.40.UC1 -- On-Line -- Up 00:00:09 --
> 27920 Kbytes
>
> Threads:
> tid tcb rstcb prty status vp-class name
> 2 11268478 0 2 sleeping forever 3lio lio vp
> 0
> 3 1127d140 0 2 sleeping forever 4pio pio vp
> 0
> 4 11292140 0 2 sleeping forever 5aio aio vp
> 0
> 5 112a7140 0 2 sleeping forever 6msc msc vp
> 0
> 6 112d4140 0 2 sleeping forever 7aio aio vp
> 1
> 7 112e92a0 10d56018 4 sleeping secs: 1 1cpu
> main_loop()
> 8 112e9e98 0 2 sleeping forever 1cpu
> soctcppoll
> 9 11268d78 0 3 sleeping forever 1cpu
> soctcplst
> 10 1127d488 10d56628 2 sleeping forever 1cpu
> flush_sub(0)
> 11 112922d0 0 2 sleeping forever 8aio aio vp
> 2
> 12 11360140 0 2 sleeping forever 9aio aio vp
> 3
> 13 11375140 0 2 sleeping forever 10aio aio vp
> 4
> 14 1138a140 0 2 sleeping forever 11aio aio vp
> 5
> 15 1139f3f0 10d56c38 3 sleeping forever 1cpu
> aslogflush
> 16 1139f9f8 10d57248 1 sleeping secs: 5 1cpu
> btscanner 0
> 17 1139fd88 10d57858 4 sleeping secs: 1 1cpu
> onmode_mon
> 18 11292418 10d57e68 4 sleeping forever 1cpu
> build_smi
> *20 112928c8 10d58478 3 running 1cpu
> sqlexec
>
>
>
> ===========------------- - - - - - -
>
sending to informix-list