IT29116: RUNNING A QUERY WITH MERGE FAILS WITH ERRORS -959/-172 AND CREATES AN ASSERTION

APAR status

• Closed as program error.

Error description

• A query executed with MERGE fails with errors -959/-172 and
  creates an assertion.
  
  $  dbaccess mydb query
  
  Database selected.
  
  Explain set.
  
    959: The current transaction has been rolled back due to an
  internal error.
  
    172: ISAM error:  Unexpected internal error
  Error in line 44
  Near character position 50
  $
  
  02/25/19 17:24:57  Maximum server connections 1
  02/25/19 17:24:57  Checkpoint Statistics - Avg. Txn Block Time
  0.000, # Txns blocked 0, Plog used 155, Llog used 473
  
  02/25/19 17:26:04  Explain file for session 38 :
  /media/informix/usr2/work/cases/TS001904483_merge/Repro/sqexplai
  n.out
  02/25/19 17:26:30  Assert Failed: No Exception Handler
  02/25/19 17:26:30  IBM Informix Dynamic Server Version
  12.10.FC12W1AEE
  02/25/19 17:26:30   Who: Session(38, informix@nnnnnn, 5836,
  0x450afcd8)
                  Thread(142, sqlexec, 4506c458, 1)
                  File: mtex.c Line: 508
  02/25/19 17:26:30   Results: Exception Caught. Type: MT_EX_OS,
  Context: mem
  02/25/19 17:26:30   Action: Please notify IBM Informix Technical
  Support.
  02/25/19 17:26:30   See Also:
  /media/informix/usr2/prods/12.10/FC12W1/tmp/af.4766b96
  02/25/19 17:26:32  Thread ID 142 will now be suspended.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IDS prior to 12.10.xC13.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Running a query with MERGE fails with errors -959/-172 and   *
  * creates an assertion failure.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Fixed in IDS 12.10.xC13.
  

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