pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
ERROR:  invalid page header in block
2+ messages / 2 participants
[nested] [flat]

* ERROR:  invalid page header in block
@ 2006-10-09 07:21  MG <pgsql-admin@carladata.de>
  0 siblings, 1 reply; 2+ messages in thread

From: MG @ 2006-10-09 07:21 UTC (permalink / raw)
  To: pgsql-admin

Hello,

I have the following error and I'm a bit worried:

SELECT COUNT(*) AS total FROM (SELECT "oid", * FROM "public"."lock") AS sub
-> ERROR:  invalid page header in block 0 of relation "lock"delete from lock where bildschirmnr=16-> ERROR:  invalid page header in block 0 of relation "lock"Any ideas whats going on?Thanks for any helpMichaela

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: ERROR:  invalid page header in block
@ 2006-10-10 06:48  Adam Radlowski <adamr@informatyka.gdansk.pl>
  parent: MG <pgsql-admin@carladata.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Adam Radlowski @ 2006-10-10 06:48 UTC (permalink / raw)
  To: MG <pgsql-admin@carladata.de>; +Cc: pgsql-admin

I've tried to do this same thing i "psql" client. It was worked properly.
I'm not sure, but maybe Your table on disk is corrupted.
Does it work simply:
select oid from public.lock
and
select * from public.lock
and
SELECT "oid", * FROM "public"."lock"
?
Your query will be faster makinkg it that way:
SELECT COUNT(*) AS total FROM "public"."lock"
"lock" is not very fine name for table (for ex. You can do inside 
transaction: LOCK table public.lock IN SHARE MODE).
Greetings
Adam


MG wrote:

> Hello,
>  
> I have the following error and I'm a bit worried:
>  
> SELECT COUNT(*) AS total FROM (SELECT "oid", * FROM "public"."lock") 
> AS sub
>
>-> ERROR:  invalid page header in block 0 of relation "lock"
>
>delete from lock where bildschirmnr=16
>
>-> ERROR:  invalid page header in block 0 of relation "lock"
>
>Any ideas whats going on?
>
>Thanks for any help
>
>Michaela
>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-10-10 06:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-09 07:21 ERROR:  invalid page header in block MG <pgsql-admin@carladata.de>
2006-10-10 06:48 ` Adam Radlowski <adamr@informatyka.gdansk.pl>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox