suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    get the ultimate tool for Informix

    pfeil  
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT27997 Status: Closed

BFCHECK BAD PAGE PG_FRPTR < SIZEOF(IFX_PAGE_T) 24 OR > SLOTBEG WHEN
UPDATING PAGE WITH OUTSTANDING IN PLACE ALTERS

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
Table is created in a 4K page dbspace.  It has a 1 single data
page in use with 59 rows on it.  It is then altered by 7 alter
table statements that add 4 columns (1 int, and 3 varchars, and
then reduces the size of the 3 varchars that were just added).

At that point an update statement is run that modifies just 1
row on the page.  The server appears to think it can leave all
the rows on the same page, and ends up writing into the slot
table (because there isn't enough free space on the page to
accommodate the increased row size for all 59 rows).

The server assert fails trying to write the page out (so it's
caught in the bfcheck that bfput is doing) but the changes get
logged, so when the server crashes, it attempts to do the same
thing in recovery and fails again, so the server can't be
brought online.

The stack trace in the failure:

afstack
afhandler
affail_interface
bffail
buffput
ckpgversion  (may not see this frame, was present on solaris,
not present on linux)
rewrecord
rsrewrec
fmrewrec
aud_sqisrewrec
doupdate
chkrowcons
dodmlrow
dodelupd
excommand
sq_execute
sqmain
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS prior to 12.10.xC13.                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Bfcheck bad page pg_frptr  < sizeof(ifx_page_t) 24 or  *
* > slotbeg  when updating page with outstanding in      *
* place alters.                                                *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.02.2019
24.09.2019
24.09.2019
Problem solved at the following versions (IBM BugInfos)
12.10.xC13
Problem solved according to the fixlist(s) of the following version(s)
Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download