Using a table with an index in an SDS environment where the
table is frequently loaded/deleted/load
we can see the following af files in the logfile:
09:55:17 Assert Failed: Page Check Error in bfput
09:55:17 IBM Informix Dynamic Server Version 12.10.F
09:55:17 Who: Session(59, informix@server, 0, 0x4511da28)
Thread(77, xchg_1.6, 450e9d28, 1)
File: rsdebug.c Line: 1168
09:55:17 Results: Possible inconsistencies in
'stores_demo:"informix".bi_esiti_in'
09:55:17 Action: Run 'oncheck -cDI
stores_demo:"informix".bi_esiti_in'
09:55:17 stack trace for pid 20441 written to
/usr/informix/tmp/af.4354465
09:55:17 See Also: /usr/informix/tmp/af.4354465,
shmem.4354465.0
09:55:20 Page Check Error in bfput
09:55:20 Assert Failed: Code assertion at rsbtcs.c:308
09:55:20 IBM Informix Dynamic Server Version 12.10.F
09:55:20 Who: Session(59, informix@server, 0, 0x4511da28)
Thread(77, xchg_1.6, 450e9d28, 1)
File: rsdebug.c Line: 3882
09:55:20 Results: rowoff+BT_RIDL_FLAG_SIZE+sizeof(int4) bc_slotptr+cs->bc_slotlen
09:55:20 Action: Please notify IBM Informix Techical Support.
09:55:20 stack trace for pid 20441 written to
/usr/informix/tmp/af.4354465
09:55:21 See Also: /usr/informix/tmp/af.4354465
09:55:24 Code assertion at rsbtcs.c:308
09:55:25 Assert Failed: Code assertion at rsbtcs.c:308
09:55:25 IBM Informix Dynamic Server Version 12.10.F
09:55:25 Who: Session(59, informix@server, 0, 0x4511da28)
Thread(77, xchg_1.6, 450e9d28, 1)
File: rsdebug.c Line: 3882
09:55:25 Results: rowoff+BT_RIDL_FLAG_SIZE+sizeof(int4) bc_slotptr+cs->bc_slotlen
09:55:25 Action: Please notify IBM Informix Techical Support.
09:55:25 stack trace for pid 20441 written to
/usr/informix/tmp/af.4354465
09:55:25 See Also: /usr/informix/tmp/af.4354465
09:55:27 Code assertion at rsbtcs.c:308
09:55:27 Assert Failed: Code assertion at rsbtcs.c:308
09:55:27 IBM Informix Dynamic Server Version 12.10.F
The first file showed
09:55:17 bfcheck: bad page: pg_frptr 1606 < sizeof(ifx_page_t)
24 or > slotbeg 1592
buffer header
000000004b5e79d8: 00000000 00000000 00000000 00000000 ........
........
000000004b5e79e8: 00000000 00000000 2049cf4a 00000000 ........
I.J....
000000004b5e79f8: 2049cf4a 00000000 d04eba4a 00000000 I.J....
.N.J....
000000004b5e7a08: d04eba4a 00000000 07080000 31000000 .N.J....
....1...
000000004b5e7a18: 00000000 00000000 289d0e45 00000000 ........
(..E....
000000004b5e7a28: 00000000 00000000 00000000 00000000 ........
........
000000004b5e7a38: 80000000 62021000 c6010000 01000000 ....b...
........
000000004b5e7a48: 552f0000 01000000 0080af4b 00000000 U/......
...K....
000000004b5e7a58: 4f000000 00000000 783d1800 00000000 O.......
x=......
000000004b5e7a68: ffffffff 22000000 00000000 01000000 ...."...
........
page
000000004baf8000: 552f0000 0100356e 7100b080 4606f2ff U/....5n
q...F...
000000004baf8010: 00000000 00000000 30303030 30303030 ........
00000000
000000004baf8020: 31000001 01003030 30303030 30303200 1.....00
0000002.
000000004baf8030: 00010200 30303030 30303030 33000001 ....0000
00003...
09:55:17 Stack for thread: 77 xchg_1.6
base: 0x000000004945b000
len: 561152
pc: 0x00000000013ce177
tos: 0x00000000494e24d0
state: running
vp: 1
(oninit) afstack
(oninit) afhandler
(oninit) affail_interface
(oninit) bffail
(oninit) buffput
(oninit) plogredo
(oninit) rlogm_redo
(oninit) next_recvr
(oninit) producer_thread
(oninit) startup |
****************************************************************
* USERS AFFECTED: *
* Users with an updatable secondary, a table with page-level *
* locking, and an index on that table, and multiple inserts *
* and deletes occurring to that table. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC8 *
**************************************************************** |
