home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IT37866 Status: Closed

VARIOUS ASSERTIONS SEEN IN RESTOREROW() ON A NON-LOGGED COMPRESSED
INTERVAL ROLLING WINDOW TABLE DURING A ROLL BACK OF WORK

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
The database is none logging.

When there is some sort of error experienced (in this case
during an update) then it is possible to see various assertion
failures and crashes.

11:58:06  bfcheck: bad page: pg_addr 0:0 != bp->bf_pagenum
7:48537
0x00000001000b0f6c (oninit)afstack
0x00000001000b00fc (oninit)afhandler
0x00000001000b05d8 (oninit)affail_interface
0x00000001001bcfc4 (oninit)bffail
0x00000001001cf774 (oninit)restorerow
0x00000001005509e0 (oninit)fm_nolog
0x000000010061888c (oninit)fmrewrec
0x00000001007374a0 (oninit)aud_sqisrewrec
0x0000000100ebdcb0 (oninit)doupdate
0x0000000100ebc9e0 (oninit)chkrowcons
0x0000000100ec5844 (oninit)dodmlrow
0x0000000100ec7cec (oninit)dodelupd
0x000000010073e110 (oninit)aud_dodelupd
0x0000000100a8f0e4 (oninit)excommand
0x00000001007c8230 (oninit)sq_execute_workhorse
0x00000001007c8ab4 (oninit)sq_execute
0x000000010070f42c (oninit)sqmain

13:28:35  ptmap: bad pagenum = 12848 -- only 3072 pages
0x00000001000b0f6c (oninit)afstack
0x00000001000b00fc (oninit)afhandler
0x00000001000b05d8 (oninit)affail_interface
0x00000001005a16cc (oninit)ptmapx
0x000000010023ad70 (oninit)buffget
0x00000001001ce5dc (oninit)restorerow
0x00000001005509e0 (oninit)fm_nolog
0x000000010061888c (oninit)fmrewrec
0x00000001007374a0 (oninit)aud_sqisrewrec
0x0000000100ebdcb0 (oninit)doupdate
0x0000000100ebc9e0 (oninit)chkrowcons
0x0000000100ec5844 (oninit)dodmlrow
0x0000000100ec7cec (oninit)dodelupd
0x000000010073e110 (oninit)aud_dodelupd
0x0000000100a8f0e4 (oninit)excommand
0x00000001007c8230 (oninit)sq_execute_workhorse
0x00000001007c8ab4 (oninit)sq_execute
0x000000010070f42c (oninit)sqmain

13:49:40  bfcheck: bad page: pg_frcnt 4102 > slotbeg 4004 -
sizeof(ifx_page_t) 24
0x00000001000b0f6c (oninit)afstack
0x00000001000b00fc (oninit)afhandler
0x00000001000b05d8 (oninit)affail_interface
0x00000001001bb93c (oninit)buffcheck
0x0000000100238bc0 (oninit)buffput
0x00000001001ce878 (oninit)restorerow
0x00000001005509e0 (oninit)fm_nolog
0x000000010061888c (oninit)fmrewrec
0x00000001007374a0 (oninit)aud_sqisrewrec
0x0000000100ebdcb0 (oninit)doupdate
0x0000000100ebc9e0 (oninit)chkrowcons
0x0000000100ec5844 (oninit)dodmlrow
0x0000000100ec7cec (oninit)dodelupd
0x000000010073e110 (oninit)aud_dodelupd
0x0000000100a8f0e4 (oninit)excommand
0x00000001007c8230 (oninit)sq_execute_workhorse
0x00000001007c8ab4 (oninit)sq_execute
0x000000010070f42c (oninit)sqmain

11:59:20  ptmap: bad pagenum = 2312 -- only 2304 pages
0x00000001000b0f6c (oninit)afstack
0x00000001000b00fc (oninit)afhandler
0x00000001000b05d8 (oninit)affail_interface
0x00000001005a16cc (oninit)ptmapx
0x000000010023ad70 (oninit)buffget
0x00000001001ce5dc (oninit)restorerow
0x00000001005509e0 (oninit)fm_nolog
0x000000010061888c (oninit)fmrewrec
0x00000001007374a0 (oninit)aud_sqisrewrec
0x0000000100ebdcb0 (oninit)doupdate
0x0000000100ebc9e0 (oninit)chkrowcons
0x0000000100ec5844 (oninit)dodmlrow
0x0000000100ec7cec (oninit)dodelupd
0x000000010073e110 (oninit)aud_dodelupd
0x0000000100a8f0e4 (oninit)excommand
0x00000001007c8230 (oninit)sq_execute_workhorse
0x00000001007c8ab4 (oninit)sq_execute
0x000000010070f42c (oninit)sqmain

This usually leads to index issues which either need to be
repaired or rebuilt.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC16 and 14.10.xC9.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC16 (if available) or      *
* 14.10.xC9.                                                   *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC16 and 14.10.xC9.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC16 (if available) or      *
* 14.10.xC9.                                                   *
****************************************************************
Comment
Fixed in Informix Server 12.10.xC16 and 14.10.xC9.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.08.2021
26.09.2022
26.09.2022
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)