APAR status
Closed as program error.
Error description
Repetitive queries against system catalog tables where session details are retrieved can result in assert failures and system hangs Example of assert failure and associated stack trace: 15:13:30 IBM Informix Dynamic Server Version 11.50.FC4 15:13:30 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 15:13:30 Who: Session(3599282, 4968, c625453a8) Thread(5725944, sqlexec, c795441f8, 32) File: mtex.c Line: 412 15:13:30 Action: Please notify IBM Informix Technical Support. base: 0x0000000d10417000 len: 528384 pc: 0x0000000100cb6ff0 tos: 0x0000000d10492961 state: running vp: 32 0x100cb6ff0 oninit :: afstack 0x100cb5e50 oninit :: afhandler 0x100cb5040 oninit :: affail_interface 0x100cbb630 oninit :: mt_ex_throw_sig 0x100c77618 oninit :: afsig_handler 0xffffffff7dbd610c /lib/sparcv9/libc.so.1 :: _thr_slot_offset 0xffffffff7dbc9ca8 /lib/sparcv9/libc.so.1 :: sema_post 0xffffffff7dbc9ea0 /lib/sparcv9/libc.so.1 :: sema_post 0x100caddf0 oninit :: mt_prscblst 0x100814ed4 oninit :: pstread 0x1006d4e3c oninit :: pst_rsread 0x1006d5818 oninit :: rsread 0x100d0ec9c oninit :: fmread 0x10031fa04 oninit :: readseq 0x10031ed68 oninit :: gettupl 0x10031a390 oninit :: scan_next 0x1005ce968 oninit :: next_row 0x1005cedd4 oninit :: get_first_row_from_producer 0x1005ceccc oninit :: process_non_groupby 0x1005cc710 oninit :: group_open 0x10032d8e4 oninit :: prepselect 0x100360eb8 oninit :: subqprep 0x1003600d8 oninit :: exsubq 0x100e777a0 oninit :: ev_cb 0x100e6cfe8 oninit :: new_eval 0x1001f5ecc oninit :: ip_evalexpr 0x1001f3df8 oninit :: runproc 0x100203934 oninit :: udrlm_spl_execute 0x1004e01dc oninit :: udrlm_exec_routine 0x1002361e8 oninit :: udr_execute 0x10023d190 oninit :: exroutine 0x1005b6944 oninit :: execproc No one can connect and Informix commands do not respond.
Local fix
Restart the database server.
Problem summary
**************************************************************** * USERS AFFECTED: * * Those using UDRs. * **************************************************************** * PROBLEM DESCRIPTION: * * Occasional crash of UDR routines which leads to error -9791. * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.50.FC7W1 or later. * ****************************************************************
Problem conclusion
Protect a structure from being modified while in use. Fix is in11.50.FC7W1.
Temporary fix
Comments
For download information, go to: http://www-933.ibm.com/support/fixcentral/ For documentation information, go to http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp
APAR Information
APAR number
IC70188
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-07-26
Closed date
2011-01-18
Last modified date
2011-01-21
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
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
21 January 2011