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 |
