Oninit cdi / Archive
Talk to an expert →

Re: assert fail on ids9.21.uc1

Posted in 2000

Topics: Error Codes & Troubleshooting

m.l.wilson — — source: Informix-list mailing list archive (1991-1998)

okay - so I'd better watch my language! here's the af error...... 13:48:04 Informix Dynamic Server 2000 Version 9.21.UC1 Software SerialNumber A AC#A897698 13:48:04 Assert Failed: No Exception Handler 13:48:04 Who: Session(414, wttdmas@dbdevweb.larc.nasa.gov, 2833, 180606280) Thread(467, sqlexec, ac10d48, 1) File: mtex.c Line: 405 13:48:04 Results: Exception Caught. Type: MT_EX_OS, Context: mem 13:48:04 Action: Please notify Informix Technical Support. 13:48:04 Stack for thread: 467 sqlexec base: 0x0bbc3018 len: 33280 pc: 0x006da000 tos: 0x0bbca050 state: running vp: 1 0x006d9478 (oninit)afhandler(0x5bb5153, 0x0, 0x1, 0xac3d548, 0x3, 0xac10d48) 0x006d8f00 (oninit)afcrash_interface(0x9cb728, 0xbbca798, 0xb46dda0, 0x9cb740, 0x195 , 0x0) 0x006dd204 (oninit)mt_ex_throw_sig(0x1, 0x9c8b58, 0x0, 0x0, 0x1, 0x92278c) 0x006ae0d0 (oninit)afsig_handler(0x15, 0xffffffff, 0x0, 0x0, 0x0, 0xbbcac50) 0x0012f99c (oninit)sel2cb (0xb5312c8, 0xb439060, 0x0, 0x0, 0x81010100, 0xff00) 0x0012ed74 (oninit)qblk2cb (0xb5313a0, 0xb439060, 0x0, 0x3d7b28, 0x8c3cf4, 0x0) 0x00125ac8 (oninit)p_sp2cb (0x0, 0xb439060, 0x0, 0x992, 0x4e5, 0x4e5) 0x0034f00c (oninit)parsecmd(0x0, 0x0, 0x0, 0xbbcb058, 0x2, 0xbbcb0c6) 0x0034e4c0 (oninit)sqcmd (0x0, 0x0, 0x0, 0xa08218, 0xff35c524, 0xff10fe50) 0x0034e148 (oninit)sq_cmnd (0x2, 0x0, 0x134a, 0x0, 0xb41bf90, 0xbbcb12c) 0x003d0620 (oninit)sqmain (0xa13a38, 0x9f42f4, 0xa08218, 0xc, 0xa, 0x0) 0x006baee0 (oninit)startup (0xa13a14, 0x0, 0x0, 0x0, 0x0, 0x0) 0x0070024c (oninit)net_wait_for_io(0x0, 0x0, 0x0, 0x0, 0x0, 0x0) 0x00000000 (*nosymtab*)0x0 here's the sql.... Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 414 SELECT wttdmas_prism CR Not Wait -9628 0 7.20 Current SQL statement : select run_file.run_file_id, test.test_id, test.facility, test.test_number, run.alpha_all_nom, run.alpha_all_act, run.beta_all_nom, run.beta_all_act, run.mach_all_nom, run.mach_all_act, run.reyn_no_avg_nom, run.reyn_no_avg_act from run_file, outer (test, run, run_file_j) where test.test_id = run.test_id and run.run_id = run_file_j.run_id and run_file_j.run_file_id = run_file.run_file_id order by run_file.run_file_id ASC Last parsed SQL statement : select run_file.run_file_id, test.test_id, test.facility, test.test_number, run.alpha_all_nom, run.alpha_all_act, run.beta_all_nom, run.beta_all_act, run.mach_all_nom, run.mach_all_act, run.reyn_no_avg_nom, run.reyn_no_avg_act from run_file, outer (test, run, run_file_j) where test.test_id = run.test_id and run.run_id = run_file_j.run_id and run_file_j.run_file_id = run_file.run_file_id order by run_file.run_file_id ASC Obnoxio The Clown wrote: > From: "m.l.wilson" <m.l.wilson@larc.nasa.gov> > > > >Paul and all, > > Is there any particular part in the af file that is the most helpful? > >These > > We're looking for the bit that tells us what the problem is... > > >things are sooo large.... > > That's funny.... (I only wish!!) > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- ---------------------------------------------------------------- Maria L. Wilson 757.766.8265 757.766.2571(fax) Computer Sciences Corporation NASA Langley Research Center m.l.wilson@larc.nasa.gov Hampton, VA 23666 http://www.larc.nasa.gov ----------------------------------------------------------------

↪ replying to m.l.wilson
David Williams — — source: Informix-list mailing list archive (1991-1998)

In article <8itool$c89$1@news.xmission.com>, m.l.wilson <m.l.wilson@larc.nasa.gov> writes > >okay - so I'd better watch my language! > >here's the af error...... > >13:48:04 Informix Dynamic Server 2000 Version 9.21.UC1 Software Serial>Number A >AC#A897698 > >13:48:04 Assert Failed: No Exception Handler >13:48:04 Who: Session(414, wttdmas@dbdevweb.larc.nasa.gov, 2833, 180606280) > Thread(467, sqlexec, ac10d48, 1) > File: mtex.c Line: 405 >13:48:04 Results: Exception Caught. Type: MT_EX_OS, Context: mem >13:48:04 Action: Please notify Informix Technical Support. >13:48:04 Stack for thread: 467 sqlexec> > base: 0x0bbc3018 > len: 33280 > pc: 0x006da000 > tos: 0x0bbca050 >state: running > vp: 1 > >0x006d9478 (oninit)afhandler(0x5bb5153, 0x0, 0x1, 0xac3d548, 0x3, 0xac10d48) >0x006d8f00 (oninit)afcrash_interface(0x9cb728, 0xbbca798, 0xb46dda0, 0x9cb740, >0x195 >, 0x0) >0x006dd204 (oninit)mt_ex_throw_sig(0x1, 0x9c8b58, 0x0, 0x0, 0x1, 0x92278c) >0x006ae0d0 (oninit)afsig_handler(0x15, 0xffffffff, 0x0, 0x0, 0x0, 0xbbcac50) >0x0012f99c (oninit)sel2cb (0xb5312c8, 0xb439060, 0x0, 0x0, 0x81010100, 0xff00) > >0x0012ed74 (oninit)qblk2cb (0xb5313a0, 0xb439060, 0x0, 0x3d7b28, 0x8c3cf4, 0x0) > >0x00125ac8 (oninit)p_sp2cb (0x0, 0xb439060, 0x0, 0x992, 0x4e5, 0x4e5) >0x0034f00c (oninit)parsecmd(0x0, 0x0, 0x0, 0xbbcb058, 0x2, 0xbbcb0c6) >0x0034e4c0 (oninit)sqcmd (0x0, 0x0, 0x0, 0xa08218, 0xff35c524, 0xff10fe50) >0x0034e148 (oninit)sq_cmnd (0x2, 0x0, 0x134a, 0x0, 0xb41bf90, 0xbbcb12c) >0x003d0620 (oninit)sqmain (0xa13a38, 0x9f42f4, 0xa08218, 0xc, 0xa, 0x0) >0x006baee0 (oninit)startup (0xa13a14, 0x0, 0x0, 0x0, 0x0, 0x0) >0x0070024c (oninit)net_wait_for_io(0x0, 0x0, 0x0, 0x0, 0x0, 0x0) >0x00000000 (*nosymtab*)0x0 > >here's the sql.... > >Sess SQL Current Iso Lock SQL ISAM F.E. >Id Stmt type Database Lvl Mode ERR ERR Vers >414 SELECT wttdmas_prism CR Not Wait -9628 0 7.20 > >Current SQL statement : > select run_file.run_file_id, test.test_id, test.facility, > test.test_number, run.alpha_all_nom, run.alpha_all_act, run.beta_all_nom, > run.beta_all_act, run.mach_all_nom, run.mach_all_act, > run.reyn_no_avg_nom, run.reyn_no_avg_act from run_file, outer (test, > run, run_file_j) where test.test_id = run.test_id and run.run_id = > run_file_j.run_id and run_file_j.run_file_id = run_file.run_file_id > order by run_file.run_file_id ASC> >Last parsed SQL statement : > select run_file.run_file_id, test.test_id, test.facility, > test.test_number, run.alpha_all_nom, run.alpha_all_act, run.beta_all_nom, > run.beta_all_act, run.mach_all_nom, run.mach_all_act, > run.reyn_no_avg_nom, run.reyn_no_avg_act from run_file, outer (test, > run, run_file_j) where test.test_id = run.test_id and run.run_id = > run_file_j.run_id and run_file_j.run_file_id = run_file.run_file_id > order by run_file.run_file_id ASC> > > The most probably bug is 127889 SELECT NON-EXISTED OR WRONG COLUMN FROM A TEMP TABLE CAUSE ENGINE TO CRASH. Are any of these table temporary?? > >Obnoxio The Clown wrote: > >> From: "m.l.wilson" <m.l.wilson@larc.nasa.gov> >> > >> >Paul and all, >> > Is there any particular part in the af file that is the most helpful? >> >These >> >> We're looking for the bit that tells us what the problem is... >> >> >things are sooo large.... >> >> That's funny.... > >(I only wish!!) > >> >> ________________________________________________________________________ >> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > >-- >---------------------------------------------------------------- >Maria L. Wilson 757.766.8265 757.766.2571(fax) >Computer Sciences Corporation >NASA Langley Research Center m.l.wilson@larc.nasa.gov >Hampton, VA 23666 http://www.larc.nasa.gov >---------------------------------------------------------------- > > -- David Williams

Related threads