APAR status
Closed as program error.
Error description
It is possible for a thread running on a SDS secondary to assert fail comparable to: 11:34:00 Assert Failed: Thread exited with 43 buffers held. 11:34:00 IBM Informix Dynamic Server Version 12.10.FC4W1XB 11:34:00 Who: Session(48447, informix@\ufffd.bE, 4870, 0x44ce6bd8) Thread(48477, sqlexec, 44cb64a8, 8) File: rsshmem.c Line: 2082 11:34:00 Results: Dynamic Server must abort 11:34:00 stack trace for pid 12689 written to /opt/informix/tmp/af.c1452c77 11:34:00 See Also: /work2/laube/pmrs/43731_082_000/tmp/af.c1452c77 11:34:01 Thread ID 48477 will NOT be suspended because it is holding a buffer. Stack for thread: 48477 sqlexec base: 0x0000000050e55000 len: 69632 pc: 0x0000000001a9a4b1 tos: 0x0000000050e64610 state: running vp: 8 (oninit) mt_system (oninit) afhandler (oninit) afcrash_interface (oninit) rstcb_cleanup (oninit) destroy_session (oninit) sq_exit (oninit) sqmain (oninit) listen_verify (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup The problem seems to be related to running update statistics high on the primary of a PRI/SDS pair while accessing pages in the buffer pool for the sysdistrib table on the SDS secondary.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * informix users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * ****************************************************************
Problem conclusion
Problem Fixed In IBM Informix Server 12.10.xC6
Temporary fix
Comments
APAR Information
APAR number
IT09280
Reported component name
IFMX ULT WHSE E
Reported component ID
IM0019BOS
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-06-04
Closed date
2015-12-30
Last modified date
2015-12-30
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
IFMX ULT WHSE E
Fixed component ID
IM0019BOS
Applicable component levels
RC10 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBJS3","label":"Informix Ultimate Warehouse Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
30 December 2015