INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

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) 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

****************************************************************
* 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.          *
****************************************************************

****************************************************************
* 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.          *
****************************************************************

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

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

17.03.2021
02.05.2023
02.05.2023