Very Computer

by **Rajib Sarka** » Sat, 18 May 2002 01:41:13

I think the problem is that the engine is expecting a page from chunk#4
..but when it is reading the disk it is finding a page from chunk #5,
that's why this AF. I would suggest:
a) Call Tech Support to open a case
b) Check to see if any other instance is pointing to the same chunk or not
(specifically, check for chunk#5)

To me, it looks like there's no other way other than to restore.

Thanx much,

Rajib Sarkar
Advisory Support Engineer(Wells Fargo Bank)
IBM Software Group -- Data Management
Ph: 602-2172100, Fax: 602-2172100

www.ibm.com/software

"espinozahj"
<espinozahj@mipun To: <informix-l...@iiug.org>
to.com> cc:
Sent by: Subject: Please help me !!!!! ------ Fail Consistency Check AIX & Informix Online
owner-informix-li 5.10
s...@iiug.org

05/16/2002 09:03
AM

Please is there anybody who can give me at least any idea of what is going
on with this?????

I am in a hurry due to this error ...

We have informix Online 5.10 on a AIX 4.31 box, and sometimes we have
received the following errors in the online.log file, where the most
important I can notice is this:

18:46:55 -- Fail Consistency Check -- pthdrpage:ptalloc:bad partn page --
pid=9044 user=201 us=30001c00
18:46:55 Cannot Open Dbspace 4

This is the segment of the online.log file:

18:46:55 bfcheck: bad page: pg_addr 500004 != bp->bf_pagenum 400004, userp
= 30001c00, pid = 9044, uid = 201
18:46:55 buffer header:
18:46:55 30ce20e0: 00000000 00000000 00000000 30ce2060 ........ ....0. `
18:46:55 30ce20f0: 30ba1f70 300002f4 30ce24a0 00020000 0..p0... 0.$.....
18:46:55 30ce2100: 01060000 00400004 31041000 00000000 .....@.. 1.......
18:46:55 30ce2110: 00000000 00010000 30f04e1c 01000000 ........ 0.N.....
18:46:55 page header:
18:46:55 31041000: 00500004 0220bbb4 00270001 0f06005a .P... .. .'.....Z
18:46:55 31041010: 00000000 00000000 ........
18:46:55 slot table and stamp:
18:46:55 31041ffc: 0220bbb4 . ..
18:46:55 tblspace header error:
18:46:55 309d8c18: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8c28: 00010000 04000001 00400004 00000000 ........ .@......
18:46:55 309d8c38: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8c48: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8c58: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8c68: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8c78: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8c88: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8c98: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8ca8: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8cb8: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8cc8: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8cd8: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8ce8: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8cf8: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8d08: 00000000 30b5275c 4457b814 00000000 ....0.'\ DW......
18:46:55 309d8d18: 30b7a02c 00000000 00000000 00000000 0..,.... ........
18:46:55 309d8d28: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8d38: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8d48: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8d58: 00000000 00000000 00000000 00000000 ........ ........
18:46:55 309d8d68: 00000000 00000000 ........
18:46:55 -- Fail Consistency Check -- pthdrpage:ptalloc:bad partn page --
pid=9044 user=201 us=30001c00
18:46:55 Cannot Open Dbspace 4
18:46:55 INFORMIX-OnLine Initialized -- Shared Memory Initialized
18:46:55 Physical Recovery Started
18:46:56 Checkpoint Completed
18:46:56 Physical Recovery Complete: 0 Pages Restored
18:46:56 Checkpoint Completed
18:46:56 Logical Recovery Complete
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

18:50:51 Logical Log 362 Backed Up
18:50:51 Logical Log 363 Backed Up
18:50:56 Logical Log 364 Backed Up
18:55:17 Checkpoint Completed
18:55:18 Tbconfig parameter PHYSDBS modified from dataroot to datalogp

Thu May 2 18:55:29 2002

18:55:29 bfcheck: bad page: pg_addr 500004 != bp->bf_pagenum 400004, userp
= 30001c00, pid = 9046, uid = 201
18:55:29 buffer header:
18:55:29 30ce20e0: 00000000 00000000 00000000 30ce2060 ........ ....0. `
18:55:29 30ce20f0: 30ba1f70 300002f4 30ce24a0 00020000 0..p0... 0.$.....
18:55:29 30ce2100: 01060000 00400004 31041000 00000000 .....@.. 1.......
18:55:29 30ce2110: 00000000 00010000 30f04e1c 01000000 ........ 0.N.....
18:55:29 page header:
18:55:29 31041000: 00500004 0220bbb4 00270001 0f06005a .P... .. .'.....Z
18:55:29 31041010: 00000000 00000000 ........
18:55:29 slot table and stamp:
18:55:29 31041ffc: 0220bbb4 . ..
18:55:29 tblspace header error:
18:55:29 309d8c18: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8c28: 00010000 04000001 00400004 00000000 ........ .@......
18:55:29 309d8c38: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8c48: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8c58: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8c68: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8c78: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8c88: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8c98: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8ca8: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8cb8: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8cc8: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8cd8: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8ce8: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8cf8: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8d08: 00000000 30b5275c 4457b835 00000000 ....0.'\ DW.5....
18:55:29 309d8d18: 30b7a02c 00000000 00000000 00000000 0..,.... ........
18:55:29 309d8d28: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8d38: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8d48: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8d58: 00000000 00000000 00000000 00000000 ........ ........
18:55:29 309d8d68: 00000000 00000000 ........
18:55:29 -- Fail Consistency Check -- pthdrpage:ptalloc:bad partn page --
pid=9046 user=201 us=30001c00
18:55:29 Cannot Open Dbspace 4
18:55:29 INFORMIX-OnLine Initialized -- Shared Memory Initialized
18:55:29 Physical Recovery Started
18:55:29 Checkpoint Completed
18:55:29 Physical Recovery Complete: 0 Pages Restored
18:55:30 Checkpoint Completed
18:55:30 Logical Recovery Complete
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

by **Mark D. Stoc** » Sat, 18 May 2002 16:26:39

> Please is there anybody who can give me at least any idea of what is going
> on with this?????

> I am in a hurry due to this error ...

Call IBM Informix technical support.

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+

| http://www.informix.com http://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |This email will self-destruct in |/// / ////|
| |10 sec. If you received this email |// / /////|
| |in error, sorry about the mess. |/ ////////|
+----------------------+-----------------------------------+-----------+

by **Neil Trub** » Sat, 18 May 2002 16:51:01

> > Please is there anybody who can give me at least any idea of what is
going
> > on with this?????

> > I am in a hurry due to this error ...

> Call IBM Informix technical support.

Everyone tells me I'm being unhelpful when I offer this eminently sensible
and appropriate advice :-(

by **Obnoxio The Clo** » Sat, 18 May 2002 21:35:40

On Fri, 17 May 2002 08:51:01 +0100, "Neil Truby"

>> > Please is there anybody who can give me at least any idea of what is
>going
>> > on with this?????

>> > I am in a hurry due to this error ...

>> Call IBM Informix technical support.

>Everyone tells me I'm being unhelpful when I offer this eminently sensible
>and appropriate advice :-(

You're both being unhelpful.

I reckon the original poster should call Informix Technical Support.

by **Mark D. Stoc** » Sat, 18 May 2002 23:39:34

> > > Please is there anybody who can give me at least any idea of what is
> going
> > > on with this?????

> > > I am in a hurry due to this error ...

> > Call IBM Informix technical support.

> Everyone tells me I'm being unhelpful when I offer this eminently sensible
> and appropriate advice :-(

Argh Neil! You off the same advice and I'll return your compliment. :-)

It's a bit different to RTFM.

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+

| http://www.informix.com http://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |This email will self-destruct in |/// / ////|
| |10 sec. If you received this email |// / /////|
| |in error, sorry about the mess. |/ ////////|
+----------------------+-----------------------------------+-----------+

by **Mark D. Stoc** » Sat, 18 May 2002 23:44:30

> On Fri, 17 May 2002 08:51:01 +0100, "Neil Truby"

> >> > Please is there anybody who can give me at least any idea of what is
> >going
> >> > on with this?????

> >> > I am in a hurry due to this error ...

> >> Call IBM Informix technical support.

> >Everyone tells me I'm being unhelpful when I offer this eminently sensible
> >and appropriate advice :-(

> You're both being unhelpful.

You don't mean that.

Quote:> I reckon the original poster should call Informix Technical Support.

Didn't you hear about the take-over? It's all owned by HP or someone
now.

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+

| http://www.informix.com http://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |This email will self-destruct in |/// / ////|
| |10 sec. If you received this email |// / /////|
| |in error, sorry about the mess. |/ ////////|
+----------------------+-----------------------------------+-----------+

by **Obnoxio The Clo** » Sun, 19 May 2002 00:33:05

On Fri, 17 May 2002 15:44:30 +0100, "Mark D. Stock"

>> On Fri, 17 May 2002 08:51:01 +0100, "Neil Truby"

>> >> > Please is there anybody who can give me at least any idea of what is
>> >going
>> >> > on with this?????

>> >> > I am in a hurry due to this error ...

>> >> Call IBM Informix technical support.

>> >Everyone tells me I'm being unhelpful when I offer this eminently sensible
>> >and appropriate advice :-(

>> You're both being unhelpful.

>You don't mean that.

Yes.

by **Mark D. Stoc** » Sun, 19 May 2002 00:29:36

> > > > Please is there anybody who can give me at least any idea of what is
> > going
> > > > on with this?????

> > > > I am in a hurry due to this error ...

> > > Call IBM Informix technical support.

> > Everyone tells me I'm being unhelpful when I offer this eminently sensible
> > and appropriate advice :-(

> Argh Neil! You off the same advice and I'll return your compliment. :-)

Off?! I meant Offer!

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+

| http://www.informix.com http://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |This email will self-destruct in |/// / ////|
| |10 sec. If you received this email |// / /////|
| |in error, sorry about the mess. |/ ////////|
+----------------------+-----------------------------------+-----------+