APAR status
Closed as program error.
Error 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;
Local fix
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. * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
Temporary fix
Comments
APAR Information
APAR number
IT32674
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-04-28
Closed date
2020-12-29
Last modified date
2020-12-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Line of Business":{"code":null,"label":null},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
Document Information
Modified date:
30 December 2020