General exception error has occurred in the optimizer 1

[pengzhang]

Hi there,

I just run a complicated SQL from SQL editor. And I got the following error message:
[Informix][Dynamic Server 2000][rrrpdb] SQL Error (-874): General exception error has occurred in the optimizer.

But the strange thing is that I ran the same query against other servers with the same Informix version and Informix configuration and no problem with that.

I checked the error guide and it says that:

-874 Floating point exception error has occurred.
This internal error affects the cost calculations that the query optimizer makes. If the error recurs, please note all circumstances and contact Informix Technical Support.

And here is the message I copied from Informix log:

14:30:12 Assert Failed: NT Exception!
14:30:13 See Also: D:\tmp\af.550efa5
14:30:14 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
14:30:14 Informix Dynamic Server 2000 Version 9.21.TC5
14:30:14 Who: Session(318, informix@CDE.ABC.com, 210, 0)
Thread(360, sqlexec, 0, 1)
File: mtex.c Line: 874
14:30:14 Action: Please notify Informix Technical Support.
14:30:14 stack trace for pid 1068 written to D:\tmp\af.550efa5
14:30:15 See Also: D:\tmp\af.550efa5
14:30:18 Releasing server from system block


And here is the message from dump file:

Exception happened at address=0x006d34bb
Exception is EXCEPTION_ACCESS_VIOLATION (code 0xc0000005)
Attempt to read location 0x1c
Register Contents:
EAX=0x00000000 ESI=0x001335a0 EFLAGS=0x00010246
EBX=0x155df920 EDI=0x00020000 EIP=0x006d34bb
ECX=0x00000000 ESP=0x1562bdc4
EDX=0x00000000 EBP=0x1562be08
Call Stack for thread #360 - sqlexec
0x006d34bb (oninit)_opclassifyfltr (0x0, 0x0, 0x20000, 0x1335a0) ebp=0x1562be08
0x006c104f (oninit)_sqoptim (0x155df920, 0x0, 0x7, 0x155e8768) ebp=0x1562bf34
0x004a07b3 (oninit)_bldstructs (0x155df920, 0x1562bf68, 0x0, 0x2) ebp=0x1562bf54
0x004a05ed (oninit)_sqcmd (0x0, 0x0, 0x0, 0x0) ebp=0x1562bf78
0x004a0014 (oninit)_sq_cmnd (0x2, 0x151c7448, 0x2, 0x0) ebp=0x1562bf98
0x0045f168 (oninit)_sqmain (0x0, 0x0, 0x0, 0x0) ebp=0x1562bfbc
0x0099d904 (oninit)_startup (0x0, 0x1562c670, 0x155d8fe0, 0x670) ebp=0x1562bff8
Frame Pointer is NULL!
Unable to continue stack trace back


Does anyone have ideas about this error?

Thanks

Pengzhang

 

[tm88gt]

Run update statistics - that will fix the problem