RE: Onmode -F . . . oops!

Here's the start: 13:21:54 13:21:54 Informix Dynamic Server Version 7.30.UC7 Software Serial Number AAC#J587572 13:21:54 Assert Failed: No Exception Handler 13:21:54 Who: Session(3010, vrd_07@victory, 4799, 0) Thread(3319, sqlexec, 0, 1) File: mtex.c Line: 314 13:21:54 Results: Exception Caught. Type: MT_EX_OS, Context: mem 13:21:54 Action: Please notify Informix Technical Support. 13:21:54 Stack for thread: 3319 sqlexec Here's the stack trace for the thread: /usr/informix/bin/onstat -g stk 3319 light: Informix Dynamic Server Version 7.30.UC7 -- On-Line -- Up 1 days 18:49:16 -- 1 086432 Kbytes Stack for thread: 3319 sqlexec base: 0xc6c89018 len: 36864 pc: 0x00000000 tos: 0xc6c8a3e0 state: running vp: 1 ( 0 ) 0x365650 resume ( 1 ) 0x349f2b mt_system+0x64 + 0x4f (0x32333833 , 0x70696420, 0x666f7220, 0x0) ( 2 ) 0x363d03 afhandler + 0x6bb (0xc6c89c88 , 0x578688, 0xc4197564, 0x3) ( 3 ) 0x3635ff afcrash_interface + 0xa7 (0x0 , 0x0, 0x500, 0x3e0100) ( 4 ) 0x365357 mt_ex_throw_sig + 0x257 (0xc6c89a88 , 0x578a70, 0x5789a8, 0x5335 e0) ( 5 ) 0x35367 afsig_bus + 0x2f (0x0 , 0x10000, 0x0, 0x0) -----Original Message----- From: David Williams [mailto:djw@smooth1.demon.co.uk] Sent: Monday, February 05, 2001 7:40 PM To: informix-list@iiug.org Subject: Re: Onmode -F . . . oops! In article <95mlal$qkb$1@news.xmission.com>, John Carlson <John_Carlson@whsmithusa.com> writes > >Actually, three AF files were created. The assert fail happened on a very >innocent SELECT statement. The Assert failure message should mention a /tmp/af.file What does it say? -- David Williams

In article <95p65u$nct$1@news.xmission.com>, John Carlson <John_Carlson@whsmithusa.com> writes > >Here's the start: > >13:21:54 > >13:21:54 Informix Dynamic Server Version 7.30.UC7 Software Serial Number >AAC#>J587572 > > > >13:21:54 Assert Failed: No Exception Handler > >13:21:54 Who: Session(3010, vrd_07@victory, 4799, 0)> > Thread(3319, sqlexec, 0, 1) > > File: mtex.c Line: 314 > >13:21:54 Results: Exception Caught. Type: MT_EX_OS, Context: mem > >13:21:54 Action: Please notify Informix Technical Support. > >13:21:54 Stack for thread: 3319 sqlexec> > >Here's the stack trace for the thread: > >/usr/informix/bin/onstat -g stk 3319 light: > > > >Informix Dynamic Server Version 7.30.UC7 -- On-Line -- Up 1 days 18:49:16 >-- 1 >086432 Kbytes > > > >Stack for thread: 3319 sqlexec> > base: 0xc6c89018 > > len: 36864 > > pc: 0x00000000 > > tos: 0xc6c8a3e0 > >state: running > > vp: 1 > > > >( 0 ) 0x365650 resume > >( 1 ) 0x349f2b mt_system+0x64 + 0x4f (0x32333833 , 0x70696420, 0x666f7220, >0x0) >( 2 ) 0x363d03 afhandler + 0x6bb (0xc6c89c88 , 0x578688, 0xc4197564, 0x3) > >( 3 ) 0x3635ff afcrash_interface + 0xa7 (0x0 , 0x0, 0x500, 0x3e0100) > >( 4 ) 0x365357 mt_ex_throw_sig + 0x257 (0xc6c89a88 , 0x578a70, 0x5789a8, >0x5335 >e0) > >( 5 ) 0x35367 afsig_bus + 0x2f (0x0 , 0x10000, 0x0, 0x0) > Where the rest of the stack trace?? > > > >-----Original Message----- >From: David Williams [mailto:djw@smooth1.demon.co.uk] >Sent: Monday, February 05, 2001 7:40 PM >To: informix-list@iiug.org >Subject: Re: Onmode -F . . . oops! > > >In article <95mlal$qkb$1@news.xmission.com>, John Carlson ><John_Carlson@whsmithusa.com> writes >> >>Actually, three AF files were created. The assert fail happened on a very >>innocent SELECT statement. > > > > The Assert failure message should mention a /tmp/af.file > > What does it say? > -- David Williams

What did "Informix Technical Support" say when you notified them as per the messages content ??? Yours -- Earle A Long (Senior DBA) SinglePoint Limited "John Carlson" <John_Carlson@whsmithusa.com> wrote in message news:95p65u$nct$1@news.xmission.com... > > Here's the start: > > 13:21:54 > > 13:21:54 Informix Dynamic Server Version 7.30.UC7 Software SerialNumber > AAC# > J587572 > > > > 13:21:54 Assert Failed: No Exception Handler > > 13:21:54 Who: Session(3010, vrd_07@victory, 4799, 0)> > Thread(3319, sqlexec, 0, 1) > > File: mtex.c Line: 314 > > 13:21:54 Results: Exception Caught. Type: MT_EX_OS, Context: mem > > 13:21:54 Action: Please notify Informix Technical Support. > > 13:21:54 Stack for thread: 3319 sqlexec> > > Here's the stack trace for the thread: > > /usr/informix/bin/onstat -g stk 3319 light: > > > > Informix Dynamic Server Version 7.30.UC7 -- On-Line -- Up 1 days 18:49:16 > -- 1 > 086432 Kbytes > > > > Stack for thread: 3319 sqlexec> > base: 0xc6c89018 > > len: 36864 > > pc: 0x00000000 > > tos: 0xc6c8a3e0 > > state: running > > vp: 1 > > > > ( 0 ) 0x365650 resume > > ( 1 ) 0x349f2b mt_system+0x64 + 0x4f (0x32333833 , 0x70696420, 0x666f7220, > 0x0) > ( 2 ) 0x363d03 afhandler + 0x6bb (0xc6c89c88 , 0x578688, 0xc4197564, 0x3) > > ( 3 ) 0x3635ff afcrash_interface + 0xa7 (0x0 , 0x0, 0x500, 0x3e0100) > > ( 4 ) 0x365357 mt_ex_throw_sig + 0x257 (0xc6c89a88 , 0x578a70, 0x5789a8, > 0x5335 > e0) > > ( 5 ) 0x35367 afsig_bus + 0x2f (0x0 , 0x10000, 0x0, 0x0) > > > > > -----Original Message----- > From: David Williams [mailto:djw@smooth1.demon.co.uk] > Sent: Monday, February 05, 2001 7:40 PM > To: informix-list@iiug.org > Subject: Re: Onmode -F . . . oops! > > > In article <95mlal$qkb$1@news.xmission.com>, John Carlson > <John_Carlson@whsmithusa.com> writes > > > >Actually, three AF files were created. The assert fail happened on a very > >innocent SELECT statement. > > > > The Assert failure message should mention a /tmp/af.file > > What does it say? > > -- > David Williams >