pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: John Lister <john.lister-ps@kickstone.com>
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: [ADMIN] database corruption help
Date: Thu, 12 Feb 2009 17:13:03 -0500
Message-ID: <17764.1234476783@sss.pgh.pa.us> (raw)
In-Reply-To: <4994987F.1030204@kickstone.com>
References: <507152DDF8AB4DF093BD01A8BEC7C659@squarepi.com>
	<17205.1234200693@sss.pgh.pa.us>
	<AB15E89CD7FB4EBD9D76CC5F8D8B3D4E@squarepi.com>
	<4990840C.4090900@kickstone.com>
	<20151.1234208044@sss.pgh.pa.us>
	<49908D72.7040904@kickstone.com>
	<25753.1234224090@sss.pgh.pa.us>
	<4991338B.704@kickstone.com>
	<4994906B.6090408@kickstone.com>
	<17204.1234474784@sss.pgh.pa.us>
	<4994987F.1030204@kickstone.com>

John Lister <john.lister-ps@kickstone.com> writes:
> GMT LOG:  relation "pg_class" TID 15538/4: dead HOT-updated tuple --- 
> cannot shrink relation

Hmm.  The comments in vacuum.c about this case suppose that it could
only be a transient condition, ie the tuple became dead while we were
looking at the page.  Evidently it's persistent for you, which means
that for some reason heap_page_prune() is failing to remove an
already-dead tuple.  I suspect this implies a corrupt HOT chain, but
maybe the data is okay and what you've got is really a bug in
heap_page_prune.

Could you send a dump of page 15538 of pg_class, using pg_filedump?
The source code for it is here:
http://sources.redhat.com/rhdb/utilities.html
Best would be -i -f format, ie
	pg_filedump -i -f -R 15538 $PGDATA/base/something/1259

			regards, tom lane



view thread (19+ messages)  latest in thread

Message-ID: <17764.1234476783@sss.pgh.pa.us>
Permalink:  ../17764.1234476783@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/17764.1234476783@sss.pgh.pa.us

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, john.lister-ps@kickstone.com, pgsql-hackers@postgreSQL.org
  Subject: Re: [ADMIN] database corruption help
  In-Reply-To: <17764.1234476783@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