IDS Forum

RE: Assert Failed: Archive detects that page 0x4bf

Posted By: Clifton Bean
Date: Tuesday, 29 January 2008, at 11:19 a.m.

In Response To: Assert Failed: Archive detects that page 0x4bf5e1b (Knox, Ernest)

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!!

Messages In This Thread

• Assert Failed: Archive detects that page 0x4bf5e1b
  Knox, Ernest -- Tuesday, 29 January 2008, at 10:43 a.m.
  • RE: Assert Failed: Archive detects that page 0x4bf
    Clifton Bean -- Tuesday, 29 January 2008, at 11:19 a.m.
  • Re: Assert Failed: Archive detects that page 0x4bf
    Mark Jamison -- Tuesday, 29 January 2008, at 12:01 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.