home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT05035 Status: Geschlossen

IWA MEMORY ERROR WHEN CALLING IFX_TRICKLEFEED_INSTRIGPROC() VIA A TRIGGER

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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:
Lösung
Problem Fixed In IBM Informix Server 12.10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.10.2014
16.10.2015
16.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.0
Problem behoben lt. FixList in der Version
12.10.xC5 FixList
12.10.xC5.W1 FixList