more PANIC's
Posted in 1998
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
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