pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCould not read block error question
4+ messages / 3 participants
[nested] [flat]
* Could not read block error question
@ 2010-09-28 07:48 Lukasz Brodziak <lukasz.brodziak@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Lukasz Brodziak @ 2010-09-28 07:48 UTC (permalink / raw)
To: pgsql-admin
Hello
One question about blocks in PG. I got an error "Could not read block
<no.> of relation...." it appeared to be in pg_trigger but the thing
is that the block number was 110 and the file has only 67 pages. So
the question is how is it possible?
--
Łukasz Brodziak
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Could not read block error question
@ 2010-09-28 14:03 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Lukasz Brodziak <lukasz.brodziak@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Kevin Grittner @ 2010-09-28 14:03 UTC (permalink / raw)
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>; pgsql-admin
Lukasz Brodziak <lukasz.brodziak@gmail.com> wrote:
> I got an error "Could not read block <no.> of relation...." it
> appeared to be in pg_trigger
If you'd pasted in the message as it appeared, we wouldn't need to
guess whether you're right.
> the block number was 110 and the file has only 67 pages. So the
> question is how is it possible?
That could be, if your reading of things is right, database
corruption. Before you do anything else, shutdown the database
server and make a copy of the data directory and all its
subdirectories. (Don't try to pick one database or otherwise pick
and choose files.) Save that backup until you've recovered from the
problem and things have been stable for at least a few weeks.
Next, read this page and repost with more information:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
So far you haven't given us much to work with.
-Kevin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Could not read block error question
@ 2010-09-28 14:38 Lukasz Brodziak <lukasz.brodziak@gmail.com>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 4+ messages in thread
From: Lukasz Brodziak @ 2010-09-28 14:38 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-admin
I would provide all the needed information if I only had them. The
thing is it happened on one of our client's machine and all he did was
reporting the problem without providing us the data folder. So I asked
the question just to know whether it is possible to read from a higher
block number than the highest physical number. Thank You for Your
attention.
2010/9/28 Kevin Grittner <Kevin.Grittner@wicourts.gov>:
> Lukasz Brodziak <lukasz.brodziak@gmail.com> wrote:
>
>> I got an error "Could not read block <no.> of relation...." it
>> appeared to be in pg_trigger
>
> If you'd pasted in the message as it appeared, we wouldn't need to
> guess whether you're right.
>
>> the block number was 110 and the file has only 67 pages. So the
>> question is how is it possible?
>
> That could be, if your reading of things is right, database
> corruption. Before you do anything else, shutdown the database
> server and make a copy of the data directory and all its
> subdirectories. (Don't try to pick one database or otherwise pick
> and choose files.) Save that backup until you've recovered from the
> problem and things have been stable for at least a few weeks.
>
> Next, read this page and repost with more information:
>
> http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
>
> So far you haven't given us much to work with.
>
> -Kevin
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Łukasz Brodziak
II MU Bioinformatyka
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Could not read block error question
@ 2010-09-28 14:40 Tom Lane <tgl@sss.pgh.pa.us>
parent: Lukasz Brodziak <lukasz.brodziak@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2010-09-28 14:40 UTC (permalink / raw)
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>; +Cc: pgsql-admin
Lukasz Brodziak <lukasz.brodziak@gmail.com> writes:
> One question about blocks in PG. I got an error "Could not read block
> <no.> of relation...." it appeared to be in pg_trigger but the thing
> is that the block number was 110 and the file has only 67 pages. So
> the question is how is it possible?
Well, that's why it failed to read the block ;-). The real question is
why was it trying to read a block that doesn't exist in the table.
I'd bet on a corrupt index myself, so try reindexing.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-09-28 14:40 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-09-28 07:48 Could not read block error question Lukasz Brodziak <lukasz.brodziak@gmail.com>
2010-09-28 14:03 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-09-28 14:38 ` Lukasz Brodziak <lukasz.brodziak@gmail.com>
2010-09-28 14:40 ` Tom Lane <tgl@sss.pgh.pa.us>
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