Informix - Problem description
Problem IT29584 | Status: Closed |
959/172 WITH ASSERT FAILURE WHEN CREATING A STORED PROCEDURE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
While creating stored procedure get below error. 959: The current transaction has been rolled back due to an internal error. 172: ISAM error: Unexpected internal error and online.log has below message with assert failure 10:29:44 Assert Failed: No Exception Handler 10:29:44 IBM Informix Dynamic Server Version 12.10.FC12W1XKWE 10:29:44 Who: Session(51, informix@minos, 23861, 0x451464e8) Thread(163, sqlexec, 45103818, 10) File: mtex.c Line: 508 10:29:44 Results: Exception Caught. Type: MT_EX_OS, Context: mem 10:29:44 Action: Please notify IBM Informix Technical Support. 10:29:44 See Also: /usr2/as_support/rashmir/galaxy/1210FC12W1XKWE/tmp/af.48b3267 10:29:47 Thread ID 163 will now be suspended. and below is the stack from the af file. 10:29:44 Stack for thread: 163 sqlexec base: 0x0000000047a30000 len: 102400 pc: 0x00000000014229e9 tos: 0x0000000047b8a310 state: running vp: 10 0x00000000014229e9 (oninit) afstack 0x00000000014264d1 (oninit) mt_ex_throw_sig 0x000000000142f643 (oninit) afsig_handler 0x0000003f8b20e4c0 (Linux) 0x0000003f8a678d80 (/lib64/libc-2.5.so) __GI_strlen 0x0000000000ccff4c (oninit) p_lcbyte 0x0000000000cf008d (oninit) p_lzstring 0x0000000000cf261c (oninit) p_lztlist 0x0000000000cf1cca (oninit) p_lzelist 0x00000000006d0b53 (oninit) qd_saveplan 0x00000000006b405b (oninit) ip_sqloptim 0x00000000006d0f8b (oninit) cmp_stmt 0x00000000006d158c (oninit) pr_compile 0x0000000000a06138 (oninit) creatproc 0x00000000006eddce (oninit) aud_creatproc 0x00000000005fe3da (oninit) excommand 0x0000000000a49eec (oninit) sq_execute 0x0000000000b0d1a1 (oninit) sqmain 0x000000000154fdcb (oninit) spawn_thread 0x0000000001414420 (oninit) th_init_initgls 0x0000000001459e77 (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to version 12.10.xC14. * **************************************************************** * PROBLEM DESCRIPTION: * * 959/172 with assert failure when creating a stored * * procedure. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.06.2019 20.09.2019 20.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14 | |
Problem solved according to the fixlist(s) of the following version(s) |