|
Problem IT42252
|
Status: Closed |
EXECUTING A PREPARED STATEMENT OF MANY INDIVIDUAL INSERTS HAVINGINSERT TRIGGERS CAN ASSERT IN UDRLM_EXEC_ROUTINE
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
If you execute a prepared statement that contains at least 101
individual insert statement then you can assert with the stack
below:
base: 0x0000000047d52000
len: 167936
pc: 0x000000000141b3c9
tos: 0x0000000044ae6310
state: running
vp: 1
0x000000000141b3c9 (oninit) afstack
0x000000000141ee31 (oninit) mt_ex_throw_sig
0x0000000001428293 (oninit) afsig_handler
0x0000003e0840e4c0 (Linux)
0x0000000000a69f20 (oninit) udrlm_exec_routine
0x00000000006d9048 (oninit) udr_execute
0x00000000006df865 (oninit) exroutine
0x00000000005cd7b0 (oninit) execproc
0x00000000006c815e (oninit) aud_execproc
0x00000000005d5534 (oninit) excommand
0x00000000008a4eed (oninit) dotrstmts
0x00000000008a6530 (oninit) dotrigs
0x00000000008a6b00 (oninit) ferafttrig
0x0000000000831ac4 (oninit) addone
0x000000000083624a (oninit) insone_next
0x000000000089f101 (oninit) doinsert
0x00000000006c5a9d (oninit) aud_doinsert
0x00000000005d43d5 (oninit) excommand
0x0000000000a31b13 (oninit) sq_execute_workhorse
0x0000000000a31f51 (oninit) sq_execute
0x0000000000aeeaac (oninit) sqmain
0x000000000154e6e9 (oninit) spawn_thread
0x000000000140cae0 (oninit) th_init_initgls
0x0000000001453c88 (oninit) startup
If, the number of insert statements in the prepared statement to
100 or less then the problem no longer reproduces. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC16 and 14.10.xC10. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC16 or 14.10.xC10. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC16 and 14.10.xC10. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC16 or 14.10.xC10. *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC16 and 14.10.xC10. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.10.2022
13.06.2023
13.06.2023 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
