Fail Consistency Check (AIX 4.31 & Informix Online 5.10)

Fail Consistency Check (AIX 4.31 & Informix Online 5.10)

Post by espinozah » Wed, 15 May 2002 00:28:59



This is a multi-part message in MIME format.

------=_NextPart_000_03DE_01C1FA71.60690BB0
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_03DE_01C1FA71.60690BB0
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>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
........ ........ <BR>18:46:55&nbsp; 309d8cd8: 00000000 ...

read more »

 
 
 

Fail Consistency Check (AIX 4.31 & Informix Online 5.10)

Post by Nebojsa Sev » Wed, 15 May 2002 19:18:45



>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