• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.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
Question in the chat LiveZilla Live Help

Informix - Problem description

Problem IT32674 Status: Closed

MULTIPLE ASSERT FAILURES FROM EXECUTION OF STORED PROCEDURE ON ASECONDARY
SERVER USING REMOTE TABLE LOCATED ON SAME SERVER

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
The execution of a stored procedure on a secondary server that
performs a query of a remote table where the server name given
for the table is the same secondary server will result in
multiple AFs. An example of the first AF:

  Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
   Who: Session(42, informix@sechost, 16926, 10ab2e748)
        Thread(70, sqlexec, 10aaf86a8, 1)
        File: mtex.c Line: 420

  Stack for thread: 70 sqlexec

oninit :: remprepare + 0x144
oninit :: qd_prepare + 0x68
oninit :: qd_getqplan + 0x780
oninit :: ip_evalexpr + 0x96c
oninit :: runproc + 0xca4
oninit :: udrlm_spl_execute + 0xdbc
oninit :: udrlm_exec_routine + 0x71c
oninit :: udr_execute + 0x17a0
oninit :: udr_spl_curnext + 0x98
oninit :: ip_curnext + 0x1ac
oninit :: ip_fetch + 0x104
oninit :: getrow + 0xfc
oninit :: fetchrow + 0x308
oninit :: exfetch + 0x758
oninit :: sql_nfetch + 0x8e0
oninit :: sq_nfetch + 0x298
oninit :: sqmain + 0xd68

This is then followed by a further AF when the database is
closed:

oninit :: release_remnode + 0x37c
oninit :: walknode + 0x138
oninit :: remrelease + 0x50
oninit :: closecb + 0x658
oninit :: close_cb_subtree_r + 0xe8
oninit :: close_cb_subtree_r + 0x2a8
oninit :: close_cb_subtree + 0x9c
oninit :: closesdb + 0x4a8
oninit :: doreleasesdb + 0x1e0
oninit :: drpcurlist + 0x268
oninit :: dormstproc + 0x64
oninit :: rmstproc + 0x54
oninit :: freecache + 0x4
oninit :: sqdbclose + 0x115c
oninit :: aud_sqdbclose + 0x4bc
oninit :: excommand + 0x15e4
oninit :: sq_execute + 0x414
oninit :: sqmain + 0xd68

An example of the query used in the stored procedure:

select count(*) into nrow from testdb@hdr_svr:t1;
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC5.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC15 (when available) or    *
* 14.10.xC5.                                                   *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
28.04.2020
29.12.2020
29.12.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

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

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.