|
Problem IT32724
|
Status: Closed |
SPL USING EXECUTE IMMEDIATE AND SQLTRACE IS ON CAN CAUSE AF ON STMTMON_SAVE_ITERATOR
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
When a stored procedure is using execute immediate expressions
in order to drop/create tables and indexes on the tables and
SQLTRACE is on, an assertion failed may be seen:
0x00000000006d2db8 (oninit) stmtmon_save_iterator
0x00000000006dd933 (oninit) stmtmon_insert
0x00000000005fb56b (oninit) excommand
0x00000000006b9aa2 (oninit) ip_evalsql
0x00000000006ba35a (oninit) ip_execimmed
0x00000000006c18a5 (oninit) runproc
0x00000000006c2f01 (oninit) udrlm_spl_execute
0x0000000000a86c1e (oninit) udrlm_exec_routine
0x00000000006fe0f9 (oninit) udr_execute
0x0000000000704855 (oninit) exroutine
0x0000000000a4345d (oninit) sq_exproc
0x0000000000b0b6c1 (oninit) sqmain
0x000000000155d25b (oninit) spawn_thread
0x00000000014201b0 (oninit) th_init_initgls |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC5. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC5. *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.05.2020
29.12.2020
29.12.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
