IT03029: BAD INDEX ON HDR SECONDARY IN A COMBINED ER PRIMARY TARGET SYSTEM WITH ATTACHED HDR

APAR status

• Closed as program error.

Error description

• In a combined ER primary target with an attached HDR secondary
  on the ER target occasionally
  assert fails with "Error during recovery left index
  inconsistent" messages. Afterward the indicated
  index is bad on the HDR secondary. On the HDR primary and the ER
  primary no errors occur.
  
  Message looks like this :
  
  03:17:30  Assert Warning: Error during recovery left index
  inconsistent.
  03:17:30  IBM Informix Dynamic Server Version 12.10.FC1
  03:17:30   Who: Session(19, informix@server, 0, 0x4b90e268)
                  Thread(37, xchg_1.1, 4b8d1da8, 12)
                  File: rskey.c Line: 1647
  03:17:30   Results: Index
  'test:"informix".ta_kmo_zu_ne#ux_kmozune_une' is now unusable
  03:17:30   Action: Run 'oncheck -cI
  test:"informix".ta_kmo_zu_ne#ux_kmozune_une'
  03:17:30  stack trace for pid 25333 written to
  /work/1210/tmp/af.40d46aa
  03:17:30   See Also: /work/1210/tmp/af.40d46aa
  03:17:31  Error during recovery left index inconsistent.
  03:17:31  Rollforward of log record failed. iserrno = 100
  03:17:31  Log Record: log = 18, pos = 0x9d9684, type =
  OLDRSAM:ADDITEM(28), trans = 3691395284195082276
  03:17:31  Rollforward of log record failed. iserrno = 100
  03:17:31  Log Record: log = 18, pos = 0x9d9684, type =
  OLDRSAM:ADDITEM(28), trans = 36
  
  
  03:17:30  doadditem: Node 0x1, match 3
  03:17:30  Could not add item, rowid 0x104, key:
  KEY:4961:"NE5":
  03:17:30  Node
  Node 1 Root+Leaf Prev 0 Next 0
  page 1:69227 sz 2048 flags b0 nslots 3 frcnt 1969 frptr 401 next
  0 prev 0
  Slot 1 sl_ptr 388 sl_len 13 sl_flags 0
  :4961:"NE3":
          10028d   103
  Slot 2 sl_ptr 375 sl_len 13 sl_flags 0
  :4961:"NE4":
          10028d   102
  Slot 3 sl_ptr 362 sl_len 13 sl_flags 0
  :4961:"NE5":
          10028d   101
  ----------------------------------------------------------------
  ------
  03:17:30
  03:17:30  IBM Informix Dynamic Server Version 12.10.FC1 Software
  Serial Number AAA#B000000
  
  03:17:30  Assert Warning: Error during recovery left index
  inconsistent.
  03:17:30   Who: Session(19, informix@coelho, 0, 0x4b90e268)
                  Thread(37, xchg_1.1, 4b8d1da8, 12)
                  File: rskey.c Line: 1647
  03:17:30   Results: Index
  'test:"informix".ta_kmo_zu_ne#ux_kmozune_une' is now unusable
  03:17:30   Action: Run 'oncheck -cI
  test:"informix".ta_kmo_zu_ne#ux_kmozune_une'
  03:17:30  Raw hex dump of stack located in
  /work/1210/tmp/af.40d46aa.rawstk
  03:17:30  Stack for thread: 37 xchg_1.1
  
  (oninit) afstack
  (oninit) afhandler
  (oninit) afwarn_interface
  (oninit) kybad
  (oninit) plogredo
  (oninit) rlogm_redo
  (oninit) next_recvr
  (oninit) producer_thread
  (oninit) startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-12.10.xC5                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-12.10.xC5
  

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

  IFMX ULT WHSE E

• Fixed component ID

  IM0019BOS

Applicable component levels

• RB70 PSN

     UP

• RB70 PSY

     UP

• RC10 PSN

     UP

• RC10 PSY

     UP