APAR status
Closed as program error.
Error description
When you have a single sqlexec thread executing DML, it is possible that it can hang for unexpectedly long durations sleeping forever trying to commit in a stack like: 0x0000000001c14ed2 (oninit) yield_processor_mvp 0x0000000001be7b09 (oninit) mt_yield 0x000000000150d54f (oninit) cdrLSNQ_Wait 0x0000000001780143 (oninit) hdrSyncTxnMode 0x00000000018af936 (oninit) proxyWaitForAllNodesFromPrimary 0x0000000000ff21a3 (oninit) rscommit 0x0000000001276298 (oninit) iscommit 0x00000000008a27c0 (oninit) sqiscommit 0x000000000083c6a0 (oninit) sqcommit 0x000000000077e667 (oninit) aud_sqcommit 0x0000000000c1e745 (oninit) sql_commit 0x0000000000c1e43b (oninit) sq_commit 0x0000000000d4c0e7 (oninit) sqmain 0x0000000001dbeecd (oninit) listen_verify 0x0000000001dbdf08 (oninit) spawn_thread 0x0000000001ba9c27 (oninit) th_init_initgls 0x0000000001c336ad (oninit) startup The hang can be remedied simply enough through a log buffer flush by some other session's DML activity, but when this is the only thread executing DML it may continue to hang until either a checkpoint or possibly dbscheduler activity.
Local fix
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. * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC16 and 14.10.xC8.
Temporary fix
Comments
APAR Information
APAR number
IT39943
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
2022-02-11
Closed date
2023-05-08
Last modified date
2023-05-08
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
08 May 2023