Very Computer

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> </DIV>
<DIV><FONT face=3DArial size=3D2>18:46:55  -- Fail Consistency =
Check --=20
pthdrpage:ptalloc:bad partn page -- pid=3D9044 user=3D201=20
us=3D30001c00<BR>18:46:55  Cannot Open Dbspace 4</FONT><BR></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </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> </DIV>
<DIV><FONT face=3DArial size=3D2>18:46:55  bfcheck: bad page: =
pg_addr 500004 !=3D=20
bp->bf_pagenum 400004, userp =3D 30001c00, pid =3D 9044, uid =3D=20
201<BR>18:46:55  buffer header:<BR>18:46:55  30ce20e0: =
00000000=20
00000000 00000000 30ce2060   ........ ....0. ` =
<BR>18:46:55 =20
30ce20f0: 30ba1f70 300002f4 30ce24a0 00020000   0..p0... =
0.$.....=20
<BR>18:46:55  30ce2100: 01060000 00400004 31041000 =
00000000  =20
.....@.. 1....... <BR>18:46:55  30ce2110: 00000000 00010000 =
30f04e1c=20
01000000   ........ 0.N..... <BR>18:46:55  page=20
header:<BR>18:46:55  31041000: 00500004 0220bbb4 00270001=20
0f06005a   .P... .. .'.....Z <BR>18:46:55  31041010: =
00000000=20
00000000   ........ <BR>18:46:55  slot table and=20
stamp:<BR>18:46:55  31041ffc: 0220bbb4   . =
..<BR>18:46:55 =20
tblspace header error:<BR>18:46:55  309d8c18: 00000000 00000000 =
00000000=20
00000000   ........ ........ <BR>18:46:55  309d8c28: =
00010000=20
04000001 00400004 00000000   ........ .@...... =
<BR>18:46:55 =20
309d8c38: 00000000 00000000 00000000 00000000   ........ =
........=20
<BR>18:46:55  309d8c48: 00000000 00000000 00000000 =
00000000  =20
........ ........ <BR>18:46:55  309d8c58: 00000000 00000000 =
00000000=20
00000000   ........ ........ <BR>18:46:55  309d8c68: =
00000000=20
00000000 00000000 00000000   ........ ........ =
<BR>18:46:55 =20
309d8c78: 00000000 00000000 00000000 00000000   ........ =
........=20
<BR>18:46:55  309d8c88: 00000000 00000000 00000000 =
00000000  =20
........ ........ <BR>18:46:55  309d8c98: 00000000 00000000 =
00000000=20
00000000   ........ ........ <BR>18:46:55  309d8ca8: =
00000000=20
00000000 00000000 00000000   ........ ........ =
<BR>18:46:55 =20
309d8cb8: 00000000 00000000 00000000 00000000   ........ =
........=20
<BR>18:46:55  309d8cc8: 00000000 00000000 00000000 =
00000000  =20
........ ........ <BR>18:46:55  309d8cd8: 00000000 ...

read more »

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

Very Computer

Fail Consistency Check (AIX 4.31 & Informix Online 5.10)

Fail Consistency Check (AIX 4.31 & Informix Online 5.10)

Fail Consistency Check (AIX 4.31 & Informix Online 5.10)