pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Adam Witney <awitney@sgul.ac.uk>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Cc: Michael Fuhr <mike@fuhr.org>
Subject: Re: pg_dump error... Follow up
Date: Thu, 8 Sep 2005 11:56:21 -0400
Message-ID: <20050908155621.GB13949@surnet.cl> (raw)
In-Reply-To: <BF4616A8.4C8AB%awitney@sgul.ac.uk>
References: <6689.1126190796@sss.pgh.pa.us>
	<BF4616A8.4C8AB%awitney@sgul.ac.uk>

On Thu, Sep 08, 2005 at 04:26:16PM +0100, Adam Witney wrote:
> On 8/9/05 3:46 pm, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> 
> > 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).
> 
> I only have one file with a .3 in that database...

How many columns does that table have?

> Or could it be from a different database altogether? (although none of
> the others get much updates at all)

It's not impossible ...

To Tom: could this be caused by a WAL recovery that wrote a page image
to the wrong table?  I guess it is very unlikely because the CRC of the
WAL record would likely not match, but it's an idea.

-- 
Alvaro Herrera -- Valdivia, Chile         Architect, www.EnterpriseDB.com
"At least to kernel hackers, who really are human, despite occasional
rumors to the contrary" (LWN.net)



view thread (13+ messages)  latest in thread

Message-ID: <20050908155621.GB13949@surnet.cl>
Permalink:  ../20050908155621.GB13949@surnet.cl/
Also on:    postgresql.org/message-id/20050908155621.GB13949@surnet.cl

 · 

reply

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: alvherre@alvh.no-ip.org, awitney@sgul.ac.uk, tgl@sss.pgh.pa.us, mike@fuhr.org
  Subject: Re: pg_dump error... Follow up
  In-Reply-To: <20050908155621.GB13949@surnet.cl>
  References: <6689.1126190796@sss.pgh.pa.us> <BF4616A8.4C8AB%awitney@sgul.ac.uk> <20050908155621.GB13949@surnet.cl>

* 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