Assert Failed: Archive detects that page 0x4bf5e1b

We are getting the following error in the online.log for a 7.31uc6 engine on Solaris 2.6 during an onbar backup of the instance: 03:33:43 Assert Failed: Archive detects that page 0x4bf5e1b is corrupt. 03:33:43 Informix Dynamic Server Version 7.31.UC6 03:33:43 Who: Session(5654230, informix@servername, 15517, 384532584) Thread(5710559, arcbackup1, 16e993bc, 4) File: rsarcbu.c Line: 2482 03:33:44 See Also: /tmp/dump/af.26c7f2f7 03:44:52 Archive on dbspace_dbs Completed with 1 corrupted pages detected. My questions are: 1. How do I figure out what table this page belongs to? 2. What oncheck command can I run to find the bad table or index? Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " **************************************

Oncheck -pP = Dump page for the given chunk number and page number [chunk num and page number] {[# pgs] [-h]} If I remember right ... 0x4b hex = 75 decimal ... so look in chunk 75. f5e1b hex = 1007131 decimal ... so look on page 1007131. Then you have a lot of other conversions to do to find out table, etc ... The chunk number may at least reduce the amount of databases you need to check by via a look at what you have within chunk 75 via an "oncheck -pe" output. If, on the other hand, you want to use oncheck commands ... The command "oncheck -cIx databasename" will look through all of the indices without locking the index. Once it finds the bad index, it will alert you to the fact and ask you if you want to fix or repair it. It is normally faster for you to drop and recreate the index than for the oncheck command to rebuild it for you. If this does not find the issue, it is likely a data page ... which is a bit more difficult to recover from. Run the "oncheck -cD databasename -n" to find it then contact IBM Informix for assistance on how to recover from it. Take care. Clifton M. Bean Informix DBA / AIX System Admin Currency Technics & Metrics Phone: (972) 812-1411 x244 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Knox, Ernest Sent: Tuesday, January 29, 2008 9:43 AM To: ids@iiug.org Subject: Assert Failed: Archive detects that page 0x4bf.... [11097] We are getting the following error in the online.log for a 7.31uc6 engine on Solaris 2.6 during an onbar backup of the instance: 03:33:43 Assert Failed: Archive detects that page 0x4bf5e1b is corrupt. 03:33:43 Informix Dynamic Server Version 7.31.UC6 03:33:43 Who: Session(5654230, informix@servername, 15517, 384532584) Thread(5710559, arcbackup1, 16e993bc, 4) File: rsarcbu.c Line: 2482 03:33:44 See Also: /tmp/dump/af.26c7f2f7 03:44:52 Archive on dbspace_dbs Completed with 1 corrupted pages detected. My questions are: 1. How do I figure out what table this page belongs to? 2. What oncheck command can I run to find the bad table or index? Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

Hi Ernie, First you need to convert the page. From the old manuals, going back to 7.31, a page looks like the following 0xcccppppp where c=chunk and p=page Since we get rid of 0's read this right to left. That means that in your case the Page is 0xf5e1b and the Chunk is 0x4b Convert both the decimal, and then use onstat -d to find your chunk and what dbspace it is associated with. Then run oncheck -pe <dbspace> To get your pages. You should then be able to find what table, or if a detached index, what index you are looking at. From there it is a simple oncheck -cI to validate the Index. ----- Original Message ---- From: "Knox, Ernest" <eknox@searshc.com> To: ids@iiug.org Sent: Tuesday, January 29, 2008 9:43:26 AM Subject: Assert Failed: Archive detects that page 0x4bf.... [11097] We are getting the following error in the online.log for a 7.31uc6 engine on Solaris 2.6 during an onbarbackup of the instance: 03:33:43 Assert Failed: Archive detects that page 0x4bf5e1b is corrupt. 03:33:43 Informix Dynamic Server Version 7.31.UC6 03:33:43 Who: Session(5654230, informix@servername, 15517, 384532584) Thread(5710559, arcbackup1, 16e993bc, 4) File: rsarcbu.c Line: 2482 03:33:44 See Also: /tmp/dump/af.26c7f2f7 03:44:52 Archive on dbspace_dbs Completed with 1 corrupted pages detected. My questions are: 1. How do I figure out what table this page belongs to? 2. What oncheckcommand can I run to find the bad table or index? Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!