From: Steve Lane <slane@soliantconsulting.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: pgsql-admin@postgresql.org
Cc: Jesse LaVere <jlavere@soliantconsulting.com>
Subject: Re: PG 7.4: duplicate rows in violation of unique
Date: Wed, 09 Feb 2005 23:35:47 -0600
Message-ID: <BE304ED3.12B92%slane@soliantconsulting.com> (raw)
In-Reply-To: <22859.1108011047@sss.pgh.pa.us>
> From: Tom Lane <tgl@sss.pgh.pa.us>
> Date: Wed, 09 Feb 2005 23:50:47 -0500
> To: Steve Lane <slane@soliantconsulting.com>
> Cc: "Joshua D. Drake" <jd@commandprompt.com>, <pgsql-admin@postgresql.org>,
> Jesse LaVere <jlavere@soliantconsulting.com>
> Subject: Re: [ADMIN] PG 7.4: duplicate rows in violation of unique
>
> Steve Lane <slane@soliantconsulting.com> writes:
>> Sorry -- 7.4.5
>
> I'm wondering if this could be related to this post-7.4.5 fix:
>
> 2004-10-13 18:22 tgl
>
> * contrib/pgstattuple/pgstattuple.c,
> src/backend/access/heap/heapam.c,
> src/backend/utils/adt/ri_triggers.c (REL7_4_STABLE): Repair
> possible failure to update hint bits back to disk, per
> http://archives.postgresql.org/pgsql-hackers/2004-10/msg00464.php.
>
> What you are describing sure sounds like a foulup in commit status
> marking for multiple versions of a row. I'm not convinced it would be
> fixed by the abovementioned patch, but it sounds close.
By the way -- this problem looks very much like one I reported a few months
ago. I'll replay that email here:
> I'm hoping I'm wrong, but I think I'm looking at a corrupted table or
> database. We have a column that's sequence-driven, with a unique index, but
> we're seeing duplicate values in that column. We're also seeing duplicate OIDs
> in the affected table. And we're seeing this ominous message:
>
> iep_db=# select distinct * into lavere_form_004 from iep_form_004;
> ERROR: missing chunk number 0 for toast value 42551774
We're getting the same thing tonight -- same "missing chunk number XX for
toast value YYYY."
If this is some form of MVCC "leakage", can that also explain this error?
Would the "leaked" rows somehow be incomplete in the sense of not linking
correctly to their corresponding toast data?
-- sgl
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: slane@soliantconsulting.com, tgl@sss.pgh.pa.us, jd@commandprompt.com, jlavere@soliantconsulting.com
Subject: Re: PG 7.4: duplicate rows in violation of unique
In-Reply-To: <BE304ED3.12B92%slane@soliantconsulting.com>
References: <22859.1108011047@sss.pgh.pa.us> <BE304ED3.12B92%slane@soliantconsulting.com>
* 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