APAR status
Closed as program error.
Error 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.
Local fix
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 or 14.10.xC9. * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC16 and 14.10.xC9.
Temporary fix
Comments
APAR Information
APAR number
IT37866
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-08-03
Closed date
2022-09-26
Last modified date
2023-05-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
08 May 2023