IBM Support

IT29584: 959/172 WITH ASSERT FAILURE WHEN CREATING A STORED PROCEDURE

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

  • 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) <signal frame>
    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
    

Local fix

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

Problem conclusion

  • Fixed in IDS 12.10.xC14.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29584

  • 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

    2019-06-28

  • Closed date

    2019-09-20

  • Last modified date

    2019-09-20

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
20 September 2019