From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adam Witney <awitney@sgul.ac.uk>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Cc: Michael Fuhr <mike@fuhr.org>
Subject: Re: pg_dump error... Follow up
Date: Thu, 08 Sep 2005 10:46:36 -0400
Message-ID: <6689.1126190796@sss.pgh.pa.us> (raw)
In-Reply-To: <BF4607B8.4C892%awitney@sgul.ac.uk>
References: <BF4607B8.4C892%awitney@sgul.ac.uk>
Adam Witney <awitney@sgul.ac.uk> writes:
> Here you go....
> pg_filedump-3.0/pg_filedump -i -f -R 34318 34320 134401986.1
Thanks. What it looks like to me is that block 34320 (really 165392)
is data from some other file altogether. It's evidently still Postgres
heap data, but instead of having 3 non-null columns as any toast row
ought to have, these rows have 77 columns many of which are nulls.
They've got OIDs, too. Possibly you can work out which table these
rows really belong to. It looks like this ought to be block 415664
of whatever table it belongs to (which would make it block 22448 of
the xxx.3 file of that table, if I did the math right).
So the diagnosis is that somebody wrote a data block to the wrong offset
in the wrong file. Whether this is the fault of Postgres, the kernel,
or the disk drive is difficult to say. We've seen a number of cases in
which table pages got overwritten with data that was obviously of
non-Postgres origin, and in those cases we could blame the kernel or
disk drive with a clear conscience. In this case, since the bogus data
is Postgres data, it could be that it's a bug lurking within Postgres
itself --- or it could be that it's like those past cases.
It might be worth your while to run some memory and disk drive tests.
There's no particular reason to suspect a hardware fault more than a
software one, but this is at least something simple to do. Check for
availability of kernel updates, too.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, awitney@sgul.ac.uk, alvherre@alvh.no-ip.org, mike@fuhr.org
Subject: Re: pg_dump error... Follow up
In-Reply-To: <6689.1126190796@sss.pgh.pa.us>
References: <BF4607B8.4C892%awitney@sgul.ac.uk> <6689.1126190796@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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