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

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