IT36267: IT IS POSSIBLE FOR AN RSS OR HDR SECONDARY TO ASSERT WITH BAD PAGE WHEN UPDATING INDEX PAGE

APAR status

• Closed as program error.

Error description

• An index page that is "just right" with very little free
  space can lead to an assertion failure
  like below when an update modifies a row that causes a DELITEM
  and an ADDITEM to this
  same index page.
  
  Examples of failures follow:⠨⠨03/17/21 10:53:11  Assert
  Failed: Page Check Error in bfput
  03/17/21 10:53:11  IBM Informix Dynamic Server Version
  12.10.FC12W1
  03/17/21 10:53:11   Who: Session(34, informix@hostname, 0,
  0x452823f8)
                  Thread(76, xchg_1.3, 4524b438, 1)
                  File: rsdebug.c Line: 1167
  03/17/21 10:53:11   Results: Possible inconsistencies in
  'jury2:"informix".jurors'
  03/17/21 10:53:11   Action: Run 'oncheck -cDI
  jury2:"informix".jurors'
  03/17/21 10:53:11  stack trace for pid 7707 written to
  /tmp/af.43425e7
  03/17/21 10:53:11   See Also:
  /tmp/af.43425e7
  03/17/21 10:53:12  Blocking whole system for max 3600 secs
  03/17/21 10:53:12  Server will be shutdown when block is
  released
  
  10:53:11  Stack for thread: 76 xchg_1.3
  
   base: 0x000000004693d000
    len:   69632
     pc: 0x0000000001422ae9
    tos: 0x000000004694c1b0
  state: running
     vp: 1
  
  0x0000000001422ae9 (/work2/prod/12.10.FC12W1/bin/oninit) afstack
  0x0000000001425ac1 (/work2/prod/12.10.FC12W1/bin/oninit)
  afhandler
  0x00000000014262a2 (/work2/prod/12.10.FC12W1/bin/oninit)
  affail_interface
  0x0000000000e2f80a (/work2/prod/12.10.FC12W1/bin/oninit) bffail
  0x0000000000dc3544 (/work2/prod/12.10.FC12W1/bin/oninit) buffput
  0x0000000000ed4d52 (/work2/prod/12.10.FC12W1/bin/oninit)
  plogredo
  0x0000000000f274a3 (/work2/prod/12.10.FC12W1/bin/oninit)
  rlogm_redo
  0x0000000000ed792c (/work2/prod/12.10.FC12W1/bin/oninit)
  next_recvr
  0x000000000147fc7e (/work2/prod/12.10.FC12W1/bin/oninit)
  producer_thread
  0x0000000001459f77 (/work2/prod/12.10.FC12W1/bin/oninit) startup
  
  03/17/21 11:06:45  IBM Informix Dynamic Server Version
  12.10.FC14
  03/17/21 11:06:45   Who: Session(31, informix@hostname, 0,
  0x4518da08)
                  Thread(74, xchg_1.4, 4514cf88, 1)
                  File: rsdebug.c Line: 3656
  03/17/21 11:06:45   Results:
  rowoff+BT_RIDL_FLAG_SIZE+sizeof(int4) <=
  cs->bc_slotptr+cs->bc_slotlen
  03/17/21 11:06:45   Action: Please notify IBM Informix Technical
  Support.
  03/17/21 11:06:45  stack trace for pid 13427 written to
  /tmp/af.4322912
  03/17/21 11:06:45   See Also:
  /tmp/af.4322912
  03/17/21 11:06:46  Code assertion at rsbtcs.c:308
  
  11:06:45  Stack for thread: 74 xchg_1.4
  
   base: 0x0000000046ae9000
    len:   69632
     pc: 0x0000000001410459
    tos: 0x0000000046af8090
  state: running
     vp: 1
  
  0x0000000001410459 (/work2/prod/12.10.FC14/bin/oninit) afstack
  0x0000000001413431 (/work2/prod/12.10.FC14/bin/oninit) afhandler
  0x0000000001413c12 (/work2/prod/12.10.FC14/bin/oninit)
  affail_interface
  0x0000000000e10a05 (/work2/prod/12.10.FC14/bin/oninit)
  rsam_assert
  0x0000000000f4c615 (/work2/prod/12.10.FC14/bin/oninit)
  ridl_ld_elem
  0x0000000000e12267 (/work2/prod/12.10.FC14/bin/oninit) rsprnode
  0x0000000000e124b9 (/work2/prod/12.10.FC14/bin/oninit) rsprtnode
  0x0000000000ebccbd (/work2/prod/12.10.FC14/bin/oninit) plogredo
  0x0000000000f125c2 (/work2/prod/12.10.FC14/bin/oninit)
  rlogm_redo
  0x0000000000ec250c (/work2/prod/12.10.FC14/bin/oninit)
  next_recvr
  0x000000000146edbe (/work2/prod/12.10.FC14/bin/oninit)
  producer_thread
  0x0000000001448997 (/work2/prod/12.10.FC14/bin/oninit) startup
  
  11:13:31  IBM Informix Dynamic Server Version 12.10.FC14
  Software Serial Number AAA#B000000
  
  11:13:31  Assert Failed: Page Check Error in btdelfgrmv: bad
  slot
  11:13:31   Who: Session(38, informix@hostname, 0,
  0x45185e48)
                  Thread(87, proxyBTClean_3, 451542e8, 8)
                  File: rsdebug.c Line: 1200
  11:13:31   Results: Possible inconsistencies in
  'jury2:"informix".jurors'
  11:13:31   Action: Run 'oncheck -cDI jury2:"informix".jurors'
  11:13:31  SHM Globals and Master Pool/Master Block Adresses:
  
  11:13:31  Stack for thread: 87 proxyBTClean_3
  
   base: 0x0000000047ba2000
    len:   69632
     pc: 0x0000000001410459
    tos: 0x0000000047bb1c20
  state: running
     vp: 8
  
  0x0000000001410459 (/work2/prod/12.10.FC14/bin/oninit) afstack
  0x0000000001413431 (/work2/prod/12.10.FC14/bin/oninit) afhandler
  0x0000000001413c12 (/work2/prod/12.10.FC14/bin/oninit)
  affail_interface
  0x0000000000e1789e (/work2/prod/12.10.FC14/bin/oninit) slotfail
  0x0000000000d6d99e (/work2/prod/12.10.FC14/bin/oninit)
  btdelfgrmv
  0x000000000127640c (/work2/prod/12.10.FC14/bin/oninit)
  proxyCleanBTThread
  0x0000000001401c70 (/work2/prod/12.10.FC14/bin/oninit)
  th_init_initgls
  0x0000000001448997 (/work2/prod/12.10.FC14/bin/oninit) startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC16 and 14.10.xC7.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC16 or 14.10.xC7.          *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC16 and 14.10.xC7.
  

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