Please help me !!!!! ------ Fail Consistency Check AIX & Informix Online 5.10

Please help me !!!!! ------ Fail Consistency Check AIX & Informix Online 5.10

Post by espinozah » Sat, 18 May 2002 01:03:19



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

 
 
 

Please help me !!!!! ------ Fail Consistency Check AIX & Informix Online 5.10

Post by David William » Sat, 18 May 2002 06:02:47


You have either

a) corruption
b) a bug in Online

Raise a call with Technical Support


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

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

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