Re: more PANIC's

In article <144BBEC0668BD111BE1E006097D0866A05D1FC@mndssr60.minimal.pt>, Carlos Costa e Silva <ccs@minimal.pt> writes > >Anyone seen this? > >03:44:57 Assert Failed: No Exception Handler >03:44:57 Informix Dynamic Server Version 7.30.UC2 >03:44:57 Who: Session(11, minimal@mndscs00.minimal.pt, -730619, 0) > Thread(39, sqlexec, 0, 1) > File: mtex.c Line: 314 >03:44:57 Results: Exception Caught. Type: MT_EX_OS, Context: fpe >03:44:57 Action: Please notify Informix Technical Support. >03:45:04 See Also: /tmp/af.279fb8, shmem.279fb8.0 What does the /tmp/af.279fb8 file say??? >03:45:25 mtex.c, line 314, thread 39, proc id 680, No Exception Handler. >03:45:26 PANIC: Attempting to bring system down> > >when doing: > >select * from a >where field1 = 'some_text' >and field2 not in ( > select field2 from database@server:a > where field1 = 'some_text' >)> >Note that this works: > >select * from a >where field1 = 'some_text' >and not exists ( > select 1 from database@server2:a > where field1 = 'some_text' > and field2 = a.field2 >)> > >Systems: > >Command is done in SCO_SV >Release = 3.2v5.0.4 >Informix 7.30.UC2 > >Other Server: >WinNT 4.0 >Informix 7.30?? > > >Just curious, while waiting to call technical support. > > >Carlos Costa e Silva > > >-- >---- >Carlos Costa e Silva <ccs@minimal.pt> >Minimal Lda >Lisboa, Portugal >Tel: 351 1 7575772 >Fax: 351 1 7576655 > > > -- 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' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care