home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT39202 Status: Closed

874 GENERAL EXCEPTION ERROR HAS OCCURRED IN THE OPTIMIZER

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
12:36:20  Assert Failed: Exception Caught. Type: MT_EX_OS,
Context: mem
12:36:20  IBM Informix Dynamic Server Version 12.10.FC15AEE
12:36:20   Who: Session(238, informix@xxxxxxx, 20799,
0x44d5aab8)
                Thread(1358, sqlexec, 44d19e08, 1)
                File: mtex.c Line: 479
12:36:20   Action: Please notify IBM Informix Technical Support.
12:36:20  stack trace for pid 2027 written to
/standalone/12.10.FC15/af.93623b4
12:36:20   See Also:
/standalone/12.10.FC15/af.93623b4, shmem.93623b4.0
12:36:25  Exception Caught. Type: MT_EX_OS, Context: mem

0x000000000141b3c9 (oninit) afstack
0x000000000141e35c (oninit) afhandler
0x000000000141eaa2 (oninit) affail_interface
0x000000000141f091 (oninit) mt_ex_throw_sig
0x0000000001428293 (oninit) afsig_handler
0x00007f8932d3ab10 (Linux) 
0x000000000080d05d (oninit) updprojexpr
0x000000000080d32a (oninit) updprojexpr
0x000000000080d147 (oninit) updprojexpr
0x000000000080d32a (oninit) updprojexpr
0x000000000080d147 (oninit) updprojexpr
0x0000000000819ef6 (oninit) itbldqnode
0x000000000081c068 (oninit) itcallbldquery
0x000000000081d4ca (oninit) itbldroot
0x00000000007d1851 (oninit) sqoptim
0x0000000000a1411a (oninit) bldstructs
0x0000000000a1743e (oninit) sqcmd
0x0000000000a19eda (oninit) sq_cmnd
0x0000000000a1a034 (oninit) sq_prepare
0x0000000000aeeaac (oninit) sqmain
0x000000000154e6e9 (oninit) spawn_thread
0x000000000140cae0 (oninit) th_init_initgls
0x0000000001453c88 (oninit) startup
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC16 and 14.10.xC8.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC16 or 14.10.xC8.          *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC16 and 14.10.xC8.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC16 or 14.10.xC8.          *
****************************************************************
Comment
Fixed in Informix Server 12.10.xC16 and 14.10.xC8.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
24.11.2021
02.05.2023
02.05.2023
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)