| Latest versions | fixlist |
| 14.10.xC11 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
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) | |