Informix - Problem description
Problem IT26745 | Status: Closed |
TRIGGER/PROCEDURE FAILS WITH AF/MEM AND ERROR -9791 AFTER UPGRADE TO 12.10.FC12 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
IDS12.10.FC11 to IDS12.10.FC12, a simple trigger that updates another record upon insert began failing with an assertion failure MT_EX_OS: mem, and the online.log shows error -9791. 13:10:54 Context ptr = 0x000000005ebe7b00 13:10:54 Siginfo ptr = 0x000000005ebe7c30 13:10:54 Reg 0(R8) 0x0000000061b4be98 Reg 1(R9) 0x0000000000000000 13:10:54 Reg 2(R10) 0x0000000066034ec0 Reg 3(R11) 0x0000005c14000001 13:10:54 Reg 4(R12) 0x0000000063a4e038 Reg 5(R13) 0x0000000000000000 13:10:54 Reg 6(R14) 0x0000000061b4bed8 Reg 7(R15) 0x0000000000000000 13:10:54 Reg 8(RDI) 0x0000000063a4e038 Reg 9(RSI) 0x0000000000000000 13:10:54 Reg 10(RBP) 0x0000000061b4bc68 Reg 11(RBX) 0x0000000000000000 13:10:54 Reg 12(RDX) 0x0000000000000000 Reg 13(RAX) 0x0000000061b4ba50 13:10:54 Reg 14(RCX) 0x0000000000000000 Reg 15(RSP) 0x00000000660347d0 13:10:54 Reg 16(RIP) 0x00000000006acab4 Reg 17(EFL) 0x0000000000010246 13:10:54 Reg 18(CSGSFS) 0x0000000000000033 Reg 19(ERR) 0x0000000000000004 13:10:54 Reg 20(TRAPNO) 0x000000000000000e Reg 21(OLDMASK) 0x0000000000000000 13:10:54 Reg 22(CR2) 0x0000000000000010 13:10:54 13:10:54 IBM Informix Dynamic Server Version 12.10.FC12 Software Serial Number AAA#B000000 13:10:54 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 13:10:54 Who: Session(685323, resqual@10.222.7.176, 1, 0x60062418) Thread(687715, sqlexec, 60021008, 9) File: mtex.c Line: 420 13:10:54 Action: Please notify IBM Informix Technical Support. 13:10:54 SHM Globals and Master Pool/Master Block Adresses: 13:10:54 shmcb = 0x00000000440d2648 13:10:54 rhead = 0x000000004413f800 13:10:54 pool list = 0x00000000440d2720 13:10:54 block pool list = 0x0000000044139328 13:10:54 TRANSP = 0x0000000060062418 13:10:54 PARTP = 0x0000000000000000 13:10:54 PARTNP = 0x0000000000000000 13:10:54 OPENP = 0x0000000063b45568 13:10:54 FILEP = 0x000000006437eee8 13:10:54 Raw hex dump of stack located in /informix/tmp/ids_resqual/af.824b8f9d.rawstk 13:10:54 Stack for thread: 687715 sqlexec base: 0x0000000066020000 len: 102400 pc: 0x000000000141f989 tos: 0x000000005ebe66c0 state: running vp: 9 0x000000000141f989 (oninit) afstack 0x0000000001422961 (oninit) afhandler 0x0000000001423142 (oninit) affail_interface 0x00000000014236d1 (oninit) mt_ex_throw_sig 0x000000000142e343 (oninit) afsig_handler 0x00007fab2685e6d0 (Linux) 0x00000000006acab4 (oninit) get_trigvardata 0x00000000006af407 (oninit) getvardata 0x00000000008983a1 (oninit) geval 0x00000000008ba56e (oninit) eval_projection_list 0x00000000008bb3c1 (oninit) dodmlrow 0x00000000008bcfc0 (oninit) dodelupd 0x00000000005fdd73 (oninit) excommand 0x00000000006b6ba4 (oninit) ip_evalsql 0x00000000006c20a7 (oninit) runproc 0x00000000006c3210 (oninit) udrlm_spl_execute 0x0000000000a8179e (oninit) udrlm_exec_routine 0x00000000006fdfdc (oninit) udr_execute 0x0000000000704725 (oninit) exroutine 0x00000000005f5a10 (oninit) execproc 0x00000000006ed30e (oninit) aud_execproc 0x00000000005fd124 (oninit) excommand 0x00000000008c4b48 (oninit) dotrstmts 0x00000000008c5bd2 (oninit) dotrigs 0x00000000008c61a0 (oninit) ferafttrig 0x00000000008526fd (oninit) addone 0x0000000000856917 (oninit) insone_next 0x00000000008be8ad (oninit) doinsert 0x00000000005fbf68 (oninit) excommand 0x0000000000a47d8c (oninit) sq_execute 0x0000000000b0b011 (oninit) sqmain 0x000000000154ca1b (oninit) spawn_thread 0x0000000001411450 (oninit) th_init_initgls 0x0000000001456d88 (oninit) startup ucontext: 0x000000005ebe7b00 siginfo: 0x000000005ebe7c30 si_signo: 11 si_code: 1 si_errno: 0 si_pid: 16 si_uid: 0 si_addr: 0x0000000000000010 si_value: 0x000000005ebe7c48 si_fd: 0 13:10:54 See Also: /informix/tmp/ids_resqual/af.824b8f9d, shmem.824b8f9d.0 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Optimization of trigger procedure not thread safe : * * Trigger/Procedure fails with AF/MEM and error -9791 after * * upgrade to 12.10.FC12 * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.10.2018 26.09.2019 26.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |