|
Problem IT17533
|
Status: Closed |
BFCHECK ERROR AFTER PGCOMPRESS / PAGE_REORG TO MAKE ROOM FOR AN INSERT OR A LARGER UPDATED SLOT
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
The error occurs when updating rows to a larger size that causes
a page compress to make the slots on the
page contiguous because we know the row will fit thereafter.
The problem has been seen on updates, but also after a page
compress to accommodate a new insert.
What seems to be happening is that we call page compress, but
upon completion the page frcnt and frptr are set to
the original values before the compress. This causes us to
write through the end of the page over the slot table, trailing
stamp and beyond yielding bfcheck errors.
You might see bfchecks like :
09:33:38 bfcheck: bad page: pg_frptr 2151 < sizeof(ifx_page_t)
24 or > slotbeg 2028
08:46:21 bfcheck: bad page: pg_frptr 2224 < sizeof(ifx_page_t)
24 or > slotbeg 2008
and stacks for failed inserts like:
oninit :: mt_system
oninit :: afhandler
oninit :: affail_interface
oninit :: bffail
oninit :: buffput
oninit :: wrt_home
oninit :: wrtrecord
oninit :: rswrite
oninit :: fmwrite
oninit :: aud_sqiswrite
oninit :: chkrowcons
oninit :: addone
oninit :: ins1row
oninit :: insone_next
oninit :: doinsert
oninit :: excommand
oninit :: sq_execute
oninit :: sqmain
oninit :: listen_verify
oninit :: spawn_thread
oninit :: th_init_initgls
oninit :: startup
and stacks for failed updates like:
oninit :: mt_system
oninit :: afhandler
oninit :: affail_interface
oninit :: bffail
oninit :: buffput
oninit :: wrt_home
oninit :: wrtrecord
oninit :: rswrite
oninit :: fmwrite
oninit :: aud_sqiswrite
oninit :: chkrowcons
oninit :: addone
oninit :: ins1row
oninit :: insone_next
oninit :: doinsert
oninit :: excommand
oninit :: sq_execute
oninit :: sqmain
oninit :: listen_verify
oninit :: spawn_thread
oninit :: th_init_initgls
oninit :: startup |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users running IDS under high stress on Solaris (sparc). *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC9 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.10.2016
10.07.2017
10.07.2017 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC9
|
| Problem solved according to the fixlist(s) of the following version(s) |
