pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: 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>
2006-10-10 06:48 ` Re: ERROR: invalid page header in block Adam Radlowski <adamr@informatyka.gdansk.pl>
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-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>
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