IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error 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;
    

Local fix

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.                                                   *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32674

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-04-28

  • Closed date

    2020-12-29

  • Last modified date

    2020-12-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Line of Business":{"code":null,"label":null},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
30 December 2020