IT10790: INDEX REPACK WRITES ASSERT FAILURE EVEN IF IT SUCCEEDS

APAR status

• Closed as program error.

Error description

• The index repack on a fragmented table succeeds but writes
  assert failure files:
  
  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
  blocked 1, Plog used 18432, Llog used 42859
  
  Assert Warning: Repack has attempted 1000 times to repack index
  ak_46989:"informix".miscari#ix_cont_fisa
  IBM Informix Dynamic Server Version 12.10.FC5W1
  Who: Session(36, informix@, 0, 0x44c3f0e0)
                  Thread(150, repack.2, 44bfb1e8, 1)
                  File: rsidxreorg.c Line: 1578
   Results: Unable to complete repack of index because its too
  volatile.
  Action: Try running the repack operation when index is being
  updated less frequently.
  stack trace for pid 23044 written to
  /opt/informix/12.10.FC5W1/tmp/af.47e5ee2
  See Also: /opt/informix/12.10.FC5W1/tmp/af.47e5ee2
  Repack has attempted 1000 times to repack index
  ak_46989:"informix".miscari#ix_cont_fisa
  SCHAPI Repack succeeded for index
  'ak_46989:informix.ix_cont_fisa' partnum 400003.
  SCHAPI Shrink for ak_46989:informix.ix_cont_fisa started
  SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum
  200003 succeeded.
  SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum
  300003 succeeded.
  SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum
  400003 succeeded.
  SCHAPI index repack shrink  ak_46989:informix.ix_cont_fisa
  succeeded
  
   (oninit) afstack
   (oninit) afhandler
   (oninit) afwarn_interface
   (oninit) rsidxrepack
   (oninit) fmrepack_idxfrag
   (oninit) startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * users of IDS 12.10                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC6                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC6
  

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