Fail Consistency Check AIX & Informix Online 5.10

Fail Consistency Check AIX & Informix Online 5.10

Post by espinozah » Wed, 15 May 2002 21:56:51



This is a multi-part message in MIME format.

------=_NextPart_000_02F6_01C1FB25.49EF3620
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=3D9044 user=3D201 us=3D30001c00
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 !=3D bp->bf_pagenum 400004, =
userp =3D 30001c00, pid =3D 9044, uid =3D 201
18:46:55  buffer header:
18:46:55  30ce20e0: 00000000 00000000 00000000 30ce2060   ........ =
....0. `=20
18:46:55  30ce20f0: 30ba1f70 300002f4 30ce24a0 00020000   0..p0... =
0.$.....=20
18:46:55  30ce2100: 01060000 00400004 31041000 00000000   .....@.. =
1.......=20
18:46:55  30ce2110: 00000000 00010000 30f04e1c 01000000   ........ =
0.N.....=20
18:46:55  page header:
18:46:55  31041000: 00500004 0220bbb4 00270001 0f06005a   .P... .. =
.'.....Z=20
18:46:55  31041010: 00000000 00000000   ........=20
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   ........ =
........=20
18:46:55  309d8c28: 00010000 04000001 00400004 00000000   ........ =
.@......=20
18:46:55  309d8c38: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c48: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c58: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c68: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c78: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c88: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c98: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8ca8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8cb8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8cc8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8cd8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8ce8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8cf8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8d08: 00000000 30b5275c 4457b814 00000000   ....0.'\ =
DW......=20
18:46:55  309d8d18: 30b7a02c 00000000 00000000 00000000   0..,.... =
........=20
18:46:55  309d8d28: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8d38: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8d48: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8d58: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8d68: 00000000 00000000   ........=20
18:46:55  -- Fail Consistency Check -- pthdrpage:ptalloc:bad partn page =
-- pid=3D9044 user=3D201 us=3D30001c00
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 !=3D bp->bf_pagenum 400004, =
userp =3D 30001c00, pid =3D 9046, uid =3D 201
18:55:29  buffer header:
18:55:29  30ce20e0: 00000000 00000000 00000000 30ce2060   ........ =
....0. `=20
18:55:29  30ce20f0: 30ba1f70 300002f4 30ce24a0 00020000   0..p0... =
0.$.....=20
18:55:29  30ce2100: 01060000 00400004 31041000 00000000   .....@.. =
1.......=20
18:55:29  30ce2110: 00000000 00010000 30f04e1c 01000000   ........ =
0.N.....=20
18:55:29  page header:
18:55:29  31041000: 00500004 0220bbb4 00270001 0f06005a   .P... .. =
.'.....Z=20
18:55:29  31041010: 00000000 00000000   ........=20
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   ........ =
........=20
18:55:29  309d8c28: 00010000 04000001 00400004 00000000   ........ =
.@......=20
18:55:29  309d8c38: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c48: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c58: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c68: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c78: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c88: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c98: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8ca8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8cb8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8cc8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8cd8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8ce8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8cf8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8d08: 00000000 30b5275c 4457b835 00000000   ....0.'\ =
DW.5....=20
18:55:29  309d8d18: 30b7a02c 00000000 00000000 00000000   0..,.... =
........=20
18:55:29  309d8d28: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8d38: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8d48: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8d58: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8d68: 00000000 00000000   ........=20
18:55:29  -- Fail Consistency Check -- pthdrpage:ptalloc:bad partn page =
-- pid=3D9046 user=3D201 us=3D30001c00
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

------=_NextPart_000_02F6_01C1FB25.49EF3620
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4912.300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>We have Informix Online 5.10 on a AIX =
4.31 box, and=20
sometimes we have received the following errors in the online.log file, =
where=20
the most important I can notice is this:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>18:46:55&nbsp; -- Fail Consistency =
Check --=20
pthdrpage:ptalloc:bad partn page -- pid=3D9044 user=3D201=20
us=3D30001c00<BR>18:46:55&nbsp; Cannot Open Dbspace 4</FONT><BR></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>This is the segment of the online.log=20
file:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>18:46:55&nbsp; bfcheck: bad page: =
pg_addr 500004 !=3D=20
bp-&gt;bf_pagenum 400004, userp =3D 30001c00, pid =3D 9044, uid =3D=20
201<BR>18:46:55&nbsp; buffer header:<BR>18:46:55&nbsp; 30ce20e0: =
00000000=20
00000000 00000000 30ce2060&nbsp;&nbsp; ........ ....0. ` =
<BR>18:46:55&nbsp;=20
30ce20f0: 30ba1f70 300002f4 30ce24a0 00020000&nbsp;&nbsp; 0..p0... =
0.$.....=20
<BR>18:46:55&nbsp; 30ce2100: 01060000 00400004 31041000 =
00000000&nbsp;&nbsp;=20
.....@.. 1....... <BR>18:46:55&nbsp; 30ce2110: 00000000 00010000 =
30f04e1c=20
01000000&nbsp;&nbsp; ........ 0.N..... <BR>18:46:55&nbsp; page=20
header:<BR>18:46:55&nbsp; 31041000: 00500004 0220bbb4 00270001=20
0f06005a&nbsp;&nbsp; .P... .. .'.....Z <BR>18:46:55&nbsp; 31041010: =
00000000=20
00000000&nbsp;&nbsp; ........ <BR>18:46:55&nbsp; slot table and=20
stamp:<BR>18:46:55&nbsp; 31041ffc: 0220bbb4&nbsp;&nbsp; . =
..<BR>18:46:55&nbsp;=20
tblspace header error:<BR>18:46:55&nbsp; 309d8c18: 00000000 00000000 =
00000000=20
00000000&nbsp;&nbsp; ........ ........ <BR>18:46:55&nbsp; 309d8c28: =
00010000=20
04000001 00400004 00000000&nbsp;&nbsp; ........ .@...... =
<BR>18:46:55&nbsp;=20
309d8c38: 00000000 00000000 00000000 00000000&nbsp;&nbsp; ........ =
........=20
<BR>18:46:55&nbsp; 309d8c48: 00000000 00000000 00000000 =
00000000&nbsp;&nbsp;=20
........ ........ <BR>18:46:55&nbsp; 309d8c58: 00000000 00000000 =
00000000=20
00000000&nbsp;&nbsp; ........ ........ <BR>18:46:55&nbsp; 309d8c68: =
00000000=20
00000000 00000000 00000000&nbsp;&nbsp; ........ ........ =
<BR>18:46:55&nbsp;=20
309d8c78: 00000000 00000000 00000000 00000000&nbsp;&nbsp; ........ =
........=20
<BR>18:46:55&nbsp; 309d8c88: 00000000 00000000 00000000 =
00000000&nbsp;&nbsp;=20
........ ........ <BR>18:46:55&nbsp; 309d8c98: 00000000 00000000 =
00000000=20
00000000&nbsp;&nbsp; ........ ........ <BR>18:46:55&nbsp; 309d8ca8: =
00000000=20
00000000 00000000 00000000&nbsp;&nbsp; ........ ........ =
<BR>18:46:55&nbsp;=20
309d8cb8: 00000000 00000000 00000000 00000000&nbsp;&nbsp; ........ =
........=20
<BR>18:46:55&nbsp; 309d8cc8: 00000000 00000000 00000000 =
00000000&nbsp;&nbsp;=20
........ ........ ...

read more »

 
 
 

Fail Consistency Check AIX & Informix Online 5.10

Post by Nebojsa Sev » Wed, 15 May 2002 22:26:20



>This is a multi-part message in MIME format.

Please don't post MIME.

What does onstat -d say?

Nebojsa
------------------------------------
Remove spam block (DELETE) to reply

 
 
 

Fail Consistency Check AIX & Informix Online 5.10

Post by Simmons, Keit » Wed, 15 May 2002 23:26:19


Call Informix Tech Support.

Keith Simmons
Banner Business Supplies Limited
Informix Certified Professional

-----Original Message-----

Sent: Tuesday, May 14, 2002 1:57 PM

Subject: Fail Consistency Check AIX & Informix Online 5.10

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

**********************************************************************************
This message is sent in strict confidence for the addressee only.  It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
**********************************************************************************

 
 
 

Fail Consistency Check AIX & Informix Online 5.10

Post by espinozah » Thu, 16 May 2002 00:33:22


This is a multi-part message in MIME format.

------=_NextPart_000_0029_01C1FB3B.27716670
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=3D9044 user=3D201 us=3D30001c00
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 !=3D bp->bf_pagenum 400004, =
userp =3D 30001c00, pid =3D 9044, uid =3D 201
18:46:55  buffer header:
18:46:55  30ce20e0: 00000000 00000000 00000000 30ce2060   ........ =
....0. `=20
18:46:55  30ce20f0: 30ba1f70 300002f4 30ce24a0 00020000   0..p0... =
0.$.....=20
18:46:55  30ce2100: 01060000 00400004 31041000 00000000   .....@.. =
1.......=20
18:46:55  30ce2110: 00000000 00010000 30f04e1c 01000000   ........ =
0.N.....=20
18:46:55  page header:
18:46:55  31041000: 00500004 0220bbb4 00270001 0f06005a   .P... .. =
.'.....Z=20
18:46:55  31041010: 00000000 00000000   ........=20
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   ........ =
........=20
18:46:55  309d8c28: 00010000 04000001 00400004 00000000   ........ =
.@......=20
18:46:55  309d8c38: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c48: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c58: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c68: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c78: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c88: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8c98: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8ca8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8cb8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8cc8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8cd8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8ce8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8cf8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8d08: 00000000 30b5275c 4457b814 00000000   ....0.'\ =
DW......=20
18:46:55  309d8d18: 30b7a02c 00000000 00000000 00000000   0..,.... =
........=20
18:46:55  309d8d28: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8d38: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8d48: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8d58: 00000000 00000000 00000000 00000000   ........ =
........=20
18:46:55  309d8d68: 00000000 00000000   ........=20
18:46:55  -- Fail Consistency Check -- pthdrpage:ptalloc:bad partn page =
-- pid=3D9044 user=3D201 us=3D30001c00
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 !=3D bp->bf_pagenum 400004, =
userp =3D 30001c00, pid =3D 9046, uid =3D 201
18:55:29  buffer header:
18:55:29  30ce20e0: 00000000 00000000 00000000 30ce2060   ........ =
....0. `=20
18:55:29  30ce20f0: 30ba1f70 300002f4 30ce24a0 00020000   0..p0... =
0.$.....=20
18:55:29  30ce2100: 01060000 00400004 31041000 00000000   .....@.. =
1.......=20
18:55:29  30ce2110: 00000000 00010000 30f04e1c 01000000   ........ =
0.N.....=20
18:55:29  page header:
18:55:29  31041000: 00500004 0220bbb4 00270001 0f06005a   .P... .. =
.'.....Z=20
18:55:29  31041010: 00000000 00000000   ........=20
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   ........ =
........=20
18:55:29  309d8c28: 00010000 04000001 00400004 00000000   ........ =
.@......=20
18:55:29  309d8c38: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c48: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c58: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c68: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c78: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c88: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8c98: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8ca8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8cb8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8cc8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8cd8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8ce8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8cf8: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8d08: 00000000 30b5275c 4457b835 00000000   ....0.'\ =
DW.5....=20
18:55:29  309d8d18: 30b7a02c 00000000 00000000 00000000   0..,.... =
........=20
18:55:29  309d8d28: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8d38: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8d48: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8d58: 00000000 00000000 00000000 00000000   ........ =
........=20
18:55:29  309d8d68: 00000000 00000000   ........=20
18:55:29  -- Fail Consistency Check -- pthdrpage:ptalloc:bad partn page =
-- pid=3D9046 user=3D201 us=3D30001c00
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

------=_NextPart_000_0029_01C1FB3B.27716670
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4912.300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>We have Informix Online 5.10 on a AIX =
4.31 box, and=20
sometimes we have received the following errors in the online.log file, =
where=20
the most important I can notice is this:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>18:46:55&nbsp; -- Fail Consistency =
Check --=20
pthdrpage:ptalloc:bad partn page -- pid=3D9044 user=3D201=20
us=3D30001c00<BR>18:46:55&nbsp; Cannot Open Dbspace 4</FONT><BR></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>This is the segment of the online.log=20
file:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>18:46:55&nbsp; bfcheck: bad page: =
pg_addr 500004 !=3D=20
bp-&gt;bf_pagenum 400004, userp =3D 30001c00, pid =3D 9044, uid =3D=20
201<BR>18:46:55&nbsp; buffer header:<BR>18:46:55&nbsp; 30ce20e0: =
00000000=20
00000000 00000000 30ce2060&nbsp;&nbsp; ........ ....0. ` =
<BR>18:46:55&nbsp;=20
30ce20f0: 30ba1f70 300002f4 30ce24a0 00020000&nbsp;&nbsp; 0..p0... =
0.$.....=20
<BR>18:46:55&nbsp; 30ce2100: 01060000 00400004 31041000 =
00000000&nbsp;&nbsp;=20
.....@.. 1....... <BR>18:46:55&nbsp; 30ce2110: 00000000 00010000 =
30f04e1c=20
01000000&nbsp;&nbsp; ........ 0.N..... <BR>18:46:55&nbsp; page=20
header:<BR>18:46:55&nbsp; 31041000: 00500004 0220bbb4 00270001=20
0f06005a&nbsp;&nbsp; .P... .. .'.....Z <BR>18:46:55&nbsp; 31041010: =
00000000=20
00000000&nbsp;&nbsp; ........ <BR>18:46:55&nbsp; slot table and=20
stamp:<BR>18:46:55&nbsp; 31041ffc: 0220bbb4&nbsp;&nbsp; . =
..<BR>18:46:55&nbsp;=20
tblspace header error:<BR>18:46:55&nbsp; 309d8c18: 00000000 00000000 =
00000000=20
00000000&nbsp;&nbsp; ........ ........ <BR>18:46:55&nbsp; 309d8c28: =
00010000=20
04000001 00400004 00000000&nbsp;&nbsp; ........ .@...... =
<BR>18:46:55&nbsp;=20
309d8c38: 00000000 00000000 00000000 00000000&nbsp;&nbsp; ........ =
........=20
<BR>18:46:55&nbsp; 309d8c48: 00000000 00000000 00000000 =
00000000&nbsp;&nbsp;=20
........ ........ <BR>18:46:55&nbsp; 309d8c58: 00000000 00000000 =
00000000=20
00000000&nbsp;&nbsp; ........ ........ <BR>18:46:55&nbsp; 309d8c68: =
00000000=20
00000000 00000000 00000000&nbsp;&nbsp; ........ ........ =
<BR>18:46:55&nbsp;=20
309d8c78: 00000000 00000000 00000000 00000000&nbsp;&nbsp; ........ =
........=20
<BR>18:46:55&nbsp; 309d8c88: 00000000 00000000 00000000 =
00000000&nbsp;&nbsp;=20
........ ........ <BR>18:46:55&nbsp; 309d8c98: 00000000 00000000 =
00000000=20
00000000&nbsp;&nbsp; ........ ........ <BR>18:46:55&nbsp; 309d8ca8: =
00000000=20
00000000 00000000 00000000&nbsp;&nbsp; ........ ........ =
<BR>18:46:55&nbsp;=20
309d8cb8: 00000000 00000000 00000000 00000000&nbsp;&nbsp; ........ =
........=20
<BR>18:46:55&nbsp; 309d8cc8: 00000000 00000000 00000000 = ...

read more »

 
 
 

Fail Consistency Check AIX & Informix Online 5.10

Post by Rajib Sarka » Thu, 16 May 2002 02:31:06


Please contact tech support for this ...

From the AF it is very much evident that the engine was expecting page#:
400004 whereas on the disk the address was 500004. Check whether any other
instance is not pointing to the same chunk (probably chunk#5) as this
particular instance. I suspect it might be the case ...:-(

The page on the disk looks like a Data Page with 0x27 rows in it ...

Looks like corruption to me ... u better call Tech Support before further
corruption is introduced.

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: Fail Consistency Check  AIX & Informix Online 5.10                            
                      owner-informix-li                                                                                                
                      s...@iiug.org                                                                                                      

                      05/14/2002 08:33                                                                                                  
                      AM                                                                                                                

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