IT07039: INDEX CORRUPTION IN TEMP OVERFLOW PARTITION FOR DEFERRED CONSTRAINT CHECKING

APAR status

• Closed as program error.

Error description

• 'SET CONSTRAINTS ... IMMEDIATE' (or COMMIT WORK) at the end of a
  large transaction using 'SET CONSTRAINTS ... DEFERRED' can fail
  with
  
    680: Cannot write constraint violation data for constraint
  (andreasl.n106_45).
  
    105: ISAM error:  bad isam file format.
  
  
  An assertion failure would be created stating, in the af file:
  
  Rowid 0x213 not found for delete in partnum
  <partnum_in_tempdbs>, key 1
  
  
  Assertion and stack would look like this:
  
  10:51:49  Assert Failed: ... some garbage ...
  10:51:49   Who: Session(37612, user@host, 40108060,
  7000000204a3768)
                  Thread(37641, sqlexec, 700000020468568, 1)
                  File: rsnode.c Line: 2849
  10:51:49   Results: Delete failed
  10:51:49   Action: Run 'oncheck -cI db:"owner"._temptable#'
  10:51:49  Raw hex dump of stack located in
  /opt/informix/tmp/af.96f18eb5.rawstk
  10:51:49  Stack for thread: 37641 sqlexec
  
   base: 0x07000000f063d000
    len:   69632
     pc: 0x00000001000ad4d4
    tos: 0x07000000f0649920
  state: running
     vp: 1
  
    afstack
    afhandler
    affail_interface
    btdelitem
    delrecord
    rsdelrec
    isdelrec
    fmdelrec
    sqisdelrec
    recheckcon
    chkdefcon
    chkdeflist
    setcons
    aud_setcons
    excommand
    sq_execute
    sqmain
    listen_verify
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL DB Users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10                          *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10
  

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

• RC10 PSY

     UP