|
Problem IT32674
|
Status: Closed |
MULTIPLE ASSERT FAILURES FROM EXECUTION OF STORED PROCEDURE ON ASECONDARY SERVER USING REMOTE TABLE LOCATED ON SAME SERVER
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
The execution of a stored procedure on a secondary server that
performs a query of a remote table where the server name given
for the table is the same secondary server will result in
multiple AFs. An example of the first AF:
Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
Who: Session(42, informix@sechost, 16926, 10ab2e748)
Thread(70, sqlexec, 10aaf86a8, 1)
File: mtex.c Line: 420
Stack for thread: 70 sqlexec
oninit :: remprepare + 0x144
oninit :: qd_prepare + 0x68
oninit :: qd_getqplan + 0x780
oninit :: ip_evalexpr + 0x96c
oninit :: runproc + 0xca4
oninit :: udrlm_spl_execute + 0xdbc
oninit :: udrlm_exec_routine + 0x71c
oninit :: udr_execute + 0x17a0
oninit :: udr_spl_curnext + 0x98
oninit :: ip_curnext + 0x1ac
oninit :: ip_fetch + 0x104
oninit :: getrow + 0xfc
oninit :: fetchrow + 0x308
oninit :: exfetch + 0x758
oninit :: sql_nfetch + 0x8e0
oninit :: sq_nfetch + 0x298
oninit :: sqmain + 0xd68
This is then followed by a further AF when the database is
closed:
oninit :: release_remnode + 0x37c
oninit :: walknode + 0x138
oninit :: remrelease + 0x50
oninit :: closecb + 0x658
oninit :: close_cb_subtree_r + 0xe8
oninit :: close_cb_subtree_r + 0x2a8
oninit :: close_cb_subtree + 0x9c
oninit :: closesdb + 0x4a8
oninit :: doreleasesdb + 0x1e0
oninit :: drpcurlist + 0x268
oninit :: dormstproc + 0x64
oninit :: rmstproc + 0x54
oninit :: freecache + 0x4
oninit :: sqdbclose + 0x115c
oninit :: aud_sqdbclose + 0x4bc
oninit :: excommand + 0x15e4
oninit :: sq_execute + 0x414
oninit :: sqmain + 0xd68
An example of the query used in the stored procedure:
select count(*) into nrow from testdb@hdr_svr:t1; |
| 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 :
| 28.04.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) |
