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 | |
12.10.xC5.W1 |