home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT05035 Status: Closed

IWA MEMORY ERROR WHEN CALLING IFX_TRICKLEFEED_INSTRIGPROC() VIA A TRIGGER

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
An Informix Warehouse Accelerator feed set run against a 
compressed table in IDS 12.10.FC3 on HP-UX 11.31 will experience 
a memory error with the following stack: 
 
The stack trace seen is as follows: 
 
15:29:53  IBM Informix Dynamic Server Version 12.10.FC3 Software 
Serial Number AAA#B000000 
 
15:29:53  Assert Failed: Memory block header corruption detected 
in mt_shm_malloc_segid 6 
15:29:53   Who: Session(3227, db@server, 7216, c00000080fafb790) 
  Thread(7913, sqlexec, c00000080fad0970, 8) 
  File: mtshpool.c Line: 1937 
15:29:53   Results: Pool not repaired 
15:29:53   Action: Please notify IBM Informix Technical Support. 
15:29:53  Raw hex dump of stack located in 
/ifxwork1/dba/temp/af.22d18060.rawstk 
15:29:53  Stack for thread: 7913 sqlexec 
 
 base: 0xc0000008372af000 
  len:   102400 
   pc: 0x0000000000000000 
  tos: 0xc0000008372c58c0 
state: running 
   vp: 8 
 
afstack 
afhandler 
affail_interface 
mt_shm_malloc_segid 
mt_malloc 
mi_dalloc_internal 
mi_dalloc 
ifx_TrickleFeed_insTrigProc 
ifx_TrickleFeed_insTrigProc 
udrlm_clang_execute_internal 
udrlm_clang_execute 
udrlm_exec_routine 
udr_execute 
exroutine 
execproc 
aud_execproc 
excommand 
dotrstmts 
dotrigs 
ferafttrig 
addone 
insert_next 
doinsert 
aud_doinsert 
excommand 
sq_execute 
sqmain 
listen_verify 
spawn_thread 
th_init_initgls 
startup 
coroutine_start 
 
If the trigger calling the 'ifx_tricklefeed_instrigproc()' is 
removed, then everything works fine.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* IWA users with tricklefeed on fact table having defined a    * 
* datetime column as last column in the data mart definition   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10                          * 
****************************************************************
Local Fix:
Solution
Problem Fixed In IBM Informix Server 12.10
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
20.10.2014
16.10.2015
16.10.2015
Problem solved at the following versions (IBM BugInfos)
12.10.0
Problem solved according to the fixlist(s) of the following version(s)
12.10.xC5 FixList
12.10.xC5.W1 FixList