IBM Support

IT39529: 959/172 OCCURS WHEN DELETE DATA FROM TABLES THROUGH SYNONYMS

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

  • Deleting record from table through synonym raises Error: 959/172
    and instance crashes.
    
    -959    The current transaction has been rolled back due to an
    internal error.
    -172    ISAM error: Unexpected internal error.
    
    12:06:42  Assert Failed: No Exception Handler
    12:06:42   Who: Session(94, informix@hostname, 23838,
    0x44d59618)
                    Thread(151, sqlexec, 44d19528, 1)
                    File: mtex.c Line: 567
    12:06:42   Results: Exception Caught. Type: MT_EX_OS, Context:
    mem
    12:06:42   Action: Please notify IBM Informix Technical Support.
    12:06:42   See Also:
    /home/informix/af.47f4141, shmem.47f4141.0
    
    0x000000000141b3c9 (oninit) afstack
    0x000000000141ee31 (oninit) mt_ex_throw_sig
    0x0000000001428293 (oninit) afsig_handler
    0x00007f9820bcfb10 (Linux) <signal frame>
    0x0000000000706de0 (oninit) hashfullname
    0x0000000000728d74 (oninit) setddmodify
    0x000000000088f386 (oninit) chkdefcon
    0x00000000008908e0 (oninit) chkdeflist
    0x0000000000758de8 (oninit) sqcommit
    0x00000000006c8976 (oninit) aud_sqcommit
    0x00000000005d60ca (oninit) excommand
    0x0000000000a31b13 (oninit) sq_execute_workhorse
    0x0000000000a3212e (oninit) sq_execute
    0x0000000000aeeaac (oninit) sqmain
    0x000000000154e6e9 (oninit) spawn_thread
    0x000000000140cae0 (oninit) th_init_initgls
    0x0000000001453c88 (oninit) startup
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 14.10.xC9.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Informix Server 14.10.xC9.                        *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 14.10.xC9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT39529

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-01-03

  • Closed date

    2022-10-04

  • Last modified date

    2022-10-04

  • 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":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Line of Business":[{"code":"LOB10","label":"Data and AI"}]}]

Document Information

Modified date:
04 October 2022