Informix - Problem description
Problem IT15229 | Status: Closed |
VARIOUS ASSERT FAIL AND WARNINGS WHEN LONG TRANSACTION ROLLBACKSOCCUR THAT INVOLVE REMOTE CONNECTIONS | |
product: | |
INFORMIX SERVER / 5725A3900 / B50 - IDS 11.50 | |
Problem description: | |
When long transaction rollbacks occur on transactions that involve local and remote servers, it's possible that many various assertion failures or warnings could occur. On AIX, a common failure is: (oninit)afstack (oninit)mt_ex_throw_sig@AF11_4 (oninit)afsig_handler (oninit)remcomroll (oninit)remcomroll (oninit)sqrollback (oninit)aud_sqrollback (oninit)sql_rollback (oninit)sq_rollback (oninit)sqmain (oninit)listen_verify (oninit)spawn_thread (oninit)th_init_initgls (oninit)startup The same failure on linux x86_64 looks like: (oninit) afstack (oninit) mt_ex_throw_sig (oninit) afsig_handler (Linux) (oninit) remcomroll (oninit) sqrollback (oninit) _puterr (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup Some other examples: (oninit) afstack (oninit) afhandler (oninit) afwarn_interface (oninit) listen_af_alarm (oninit) lisnsocket (oninit) tlListen (oninit) slSQIlisten (oninit) pfListen (oninit) cmListen (oninit) alListen (oninit) ASF_Call (oninit) sql_listener (oninit) startup (oninit) afstack (oninit) afhandler (oninit) affail_interface (oninit) mt_ex_throw_sig (oninit) afsig_handler (Linux) (oninit) recover_pool_bad_free (oninit) mt_shm_malloc_segid (oninit) mt_calloc (oninit) meAlloc (oninit) asf_opfbuf (oninit) ASF_OpenHosts (oninit) ASF_GetSvrInfo (oninit) dd_remconnect (oninit) remcatalog (oninit) readtab (oninit) ddgettable_hierarchy (oninit) ddgettable_nofixup (oninit) dp_tabchk (oninit) qd_check (oninit) qd_initenv (oninit) ip_evalsql (oninit) runproc (oninit) udrlm_spl_execute (oninit) udrlm_exec_routine (oninit) udr_execute (oninit) exroutine (oninit) execproc (oninit) aud_execproc (oninit) excommand (oninit) dotrstmts (oninit) dotrigs (oninit) ferafttrig (oninit) dodmlrow (oninit) dodelupd (oninit) excommand (oninit) sq_execute (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup (oninit) afstack (oninit) afhandler (oninit) afwarn_interface (oninit) mt_shm_malloc_segid (oninit) mt_calloc (oninit) meAlloc (oninit) net_buffer_setup (oninit) connsocket (oninit) tlConnect (oninit) slSQIreq (oninit) pfConReq (oninit) cmReqSync (oninit) cmConReq (oninit) ASF_Call (oninit) dd_newconnect (oninit) dd_remconnect (oninit) remcatalog (oninit) readtab (oninit) ddgettable_hierarchy (oninit) aud_ddgettable (oninit) gettab (oninit) tlgetddtab (oninit) tlp2tnode (oninit) tbl2tab (oninit) ins2cb (oninit) stmt2cb (oninit) p_sp2cb (oninit) ip_sqlparse (oninit) ip_evalsql (oninit) runproc (oninit) udrlm_spl_execute (oninit) udrlm_exec_routine (oninit) udr_execute (oninit) exroutine (oninit) execproc (oninit) aud_execproc (oninit) excommand (oninit) dotrstmts (oninit) dotrigs (oninit) ferafttrig (oninit) dodmlrow (oninit) dodelupd (oninit) excommand (oninit) sq_execute (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup (oninit) afstack (oninit) afhandler (oninit) afwarn_interface (oninit) mt_shm_malloc_segid (oninit) mt_calloc (oninit) meAlloc (oninit) asf_opfbuf (oninit) ASF_OpenHosts (oninit) ASF_GetSvrInfo (oninit) dd_remconnect (oninit) remcatalog (oninit) readtab (oninit) ddgettable_hierarchy (oninit) aud_ddgettable (oninit) gettab (oninit) tlgetddtab (oninit) tlp2tnode (oninit) tbl2tab (oninit) ins2cb (oninit) stmt2cb (oninit) p_sp2cb (oninit) ip_sqlparse (oninit) ip_evalsql (oninit) runproc (oninit) udrlm_spl_execute (oninit) udrlm_exec_routine (oninit) udr_execute (oninit) exroutine (oninit) execproc (oninit) aud_execproc (oninit) excommand (oninit) dotrstmts (oninit) dotrigs (oninit) ferafttrig (oninit) dodmlrow (oninit) dodelupd (oninit) excommand (oninit) sq_execute (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * production enviroinment * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.05.2016 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |