APAR status
Closed as program error.
Error description
IDS 11.50.xC5 crashes running a large query that includes LEFT OUTER JOINS, INNER JOINS and CASEs statements. AF file from IDS 11.50.FC5 shows the following stack trace : 14:11:39 Found during mt_shm_free 1 14:11:39 Pool '26091' (0x7000000db54d040) 14:11:39 Bad block header 0x7000000e5536690 blk-64 07000000e5536650: 00000000 00000000 00000000 00000000 ........ ........ 07000000e5536660: 00000000 00000000 00000000 00000000 ........ ........ 07000000e5536670: 00000000 00000000 00000000 00000000 ........ ........ 07000000e5536680: 00000000 00000000 00000000 00000000 ........ ........ blk+64 07000000e5536690: 001502d3 00000000 07000000 dbefb788 ........ ........ 07000000e55366a0: 07000000 dbefb038 07000000 dc99bdb0 .......8 ........ 07000000e55366b0: 07000000 eac9ba90 07000000 eac9b178 ........ .......x 07000000e55366c0: 00000000 00000000 07000000 e8da1038 ........ .......8 14:11:39 Multiple block errors found 14:11:39 14:11:39 IBM Informix Dynamic Server Version 11.50.FC5 Software Serial Number AAA#B000000 14:11:39 Assert Failed: Memory block header corruption detected in mt_shm_free 1 14:11:39 Who: Session(26091, db@host, 3192, 7000000dd148790) Thread(27378, sqlexec, 7000000dcd96c18, 3) File: mtshpool.c Line: 4099 14:11:39 Results: Unable to repair pool 14:11:39 Action: Please notify IBM Informix Technical Support. 14:11:39 Raw hex dump of stack located in /tmp/af.6edac17b.rawstk 14:11:39 Stack for thread: 27378 sqlexec base: 0x07000000eabf2000 len: 135168 pc: 0x00000001000c2944 tos: 0x07000000eac10c70 state: running vp: 3 (oninit)afstack (oninit)afhandler (oninit)recover_pool_bad_block (oninit)mt_free (oninit)old_do_rhpfree_39_30 (oninit)tbl2tab (oninit)sel2cb (oninit)qblk2cb (oninit)p_sp2cb (oninit)parsecmd (oninit)sqcmd (oninit)sq_cmnd (oninit)sq_prepare (oninit)sqmain (oninit)listen_verify (oninit)spawn_thread (oninit)startup Problem reproduces on IDS 11.50.xC5W4 and IDS 11.50.xC6 with the following stack trace : afstack afhandler affail_interface mt_free old_do_rhpfree tbl2tab sel2cb qblk2cb p_sp2cb parsecmd sqcmd sq_cmnd sq_prepare sqmain listen_verify spawn_thread startup
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * User having ANSI joins and regular joins in same query * **************************************************************** * PROBLEM DESCRIPTION: * * When regular joins are used in middle order along with ANSI * * joins, the server crashes releasing memory at end of the * * statement. * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.50.xC7 and above. * ****************************************************************
Problem conclusion
Problem first fixed in 11.50.xC7.
Temporary fix
Comments
APAR Information
APAR number
IC66675
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-02-25
Closed date
2010-11-15
Last modified date
2010-11-15
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 PSN
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:
15 November 2010