APAR status
Closed as program error.
Error description
There was assert failed error when using force_ddl_exec 14:31:25 14:31:25 IBM Informix Dynamic Server Version 11.50.FC6TL Software Serial Number AAA#B000000 14:31:25 Assert Warning: (PARTP->pt_ocount == 1) 14:31:25 Who: Session(580, jfdba@koko, 1448, 7000001d2929108) Thread(1298, sqlexec, 7000001d28e02c8, 5) File: rspartn.c Line: 12570 14:31:25 Results: Consistency check failed 14:31:25 Action: Please notify IBM Informix Technical Support. 14:31:25 Raw hex dump of stack located in /informix_cq/tmp/af.8fad03d.rawstk 14:31:25 Stack for thread: 1298 sqlexec base: 0x07000001d3ea0000 len: 528384 pc: 0x00000001000dbf74 tos: 0x07000001d3f1dc00 state: running vp: 5 0x00000001000dc1a8 (oninit)afstack 0x00000001000de2bc (oninit)afhandler 0x000000010030e4d8 (oninit)rspnforce_excl_access 0x00000001002d3e7c (oninit)ispnopen_with_forceddl 0x0000000100374f74 (oninit)fm_openfragx 0x00000001002e12d4 (oninit)fmftopen_with_child 0x000000010058d0e4 (oninit)sqftopen_tab_hierarchy 0x000000010058cdb4 (oninit)openrel 0x00000001005fcdd0 (oninit)ddaltfrag 0x00000001006237e8 (oninit)aud_ddaltfrag 0x00000001004a9ea8 (oninit)excommand 0x00000001004ceb80 (oninit)sq_execute 0x00000001002574bc (oninit)sqmain 0x0000000100451f98 (oninit)listen_verify 0x0000000100450468 (oninit)spawn_thread 0x0000000100d462c4 (oninit)startup .... 14:31:26 14:31:26 IBM Informix Dynamic Server Version 11.50.FC6TL Software Serial Number AAA#B000000 14:31:26 Assert Failed: Condition Failed (Memory pointer (0x7000001dbf97798) freed twice), In (mt_shm_free) 14:31:26 Who: Session(580, jfdba@koko, 1448, 7000001d2929108) Thread(1298, sqlexec, 7000001d28e02c8, 5) File: mtshpool.c Line: 4161 14:31:26 Action: Please notify IBM Informix Technical Support. 14:31:26 Raw hex dump of stack located in /informix_cq/tmp/af.8fad03d.rawstk 14:31:26 Stack for thread: 1298 sqlexec base: 0x07000001d3ea0000 len: 528384 pc: 0x00000001000dbf74 tos: 0x07000001d3f1d630 state: running vp: 5 0x00000001000dc1a8 (oninit)afstack 0x00000001000de2bc (oninit)afhandler 0x000000010007122c (oninit)mem_asfail 0x0000000100074c24 (oninit)mt_free 0x000000010030e5f8 (oninit)rspnforce_excl_access 0x00000001002d3e7c (oninit)ispnopen_with_forceddl 0x0000000100374f74 (oninit)fm_openfragx 0x00000001002e12d4 (oninit)fmftopen_with_child 0x000000010058d0e4 (oninit)sqftopen_tab_hierarchy 0x000000010058cdb4 (oninit)openrel 0x00000001005fcdd0 (oninit)ddaltfrag 0x00000001006237e8 (oninit)aud_ddaltfrag 0x00000001004a9ea8 (oninit)excommand 0x00000001004ceb80 (oninit)sq_execute 0x00000001002574bc (oninit)sqmain 0x0000000100451f98 (oninit)listen_verify 0x0000000100450468 (oninit)spawn_thread 0x0000000100d462c4 (oninit)startup There are two reproduce environment. 1. The error happens when the engine terminates a remote sql Example: server a and server b a). execute the sql from server b unload to /dev/null select * from bsn_acctdb@a:acct_item_23; b). When the first sql is running ,execute the sql in server a set environment force_ddl_exec "60"; set lock mode to wait 10; begin; alter fragment on table acct_item_23 DETACH dbs1 acct_item_23_old; c). The assert failed happens every time. 2 The same error also happens in the following stress test. a) There are 100 sql to do select action continuously dbaccess cq <<! select * from acct_item_23 where acct_id = 100; ! b) There are 20 sql to do update action continuously dbaccess cq <<! update acct_item_23 set serv_id = serv_id+1 where acct_id = 200; ! c) A large transaction to do update continuously dbaccess cq <<! begin work; update acct_item_23 set amount = amount +5 where 1=1; rollback; ! d) another session to do alter fragment action continuously dbaccess cq <<! set environment force_ddl_exec "60"; set lock mode to wait 10; begin; alter fragment on table acct_item_23 DETACH dbs1 acct_item_23_old; set environment force_ddl_exec "off"; rollback; ! The assert failed happen in half a day.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Those using new feature FORCE_DDL_EXEC * **************************************************************** * PROBLEM DESCRIPTION: * * AF is seen when using the feature FORCE_DDL_EXEC. * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.50.xC7 and above. * ****************************************************************
Problem conclusion
Problem first fixed in 11.50.xC7.
Temporary fix
Comments
APAR Information
APAR number
IC65617
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-01-18
Closed date
2010-10-01
Last modified date
2010-10-01
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:
01 October 2010