suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    get the ultimate tool for Informix

    pfeil  
Latest versionsfixlist
14.10.xC10 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 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)
Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download