Skip site navigation (1) Skip section navigation (2)

Re: Duplicate values found when reindexing unique index

From: "Mason Hale" <masonhale(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Duplicate values found when reindexing unique index
Date: 2007-12-31 05:22:06
Message-ID: 8bca3aa10712302122r63017f84nc80effb2968e53fc@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
>
>
> Can you show us all the triggers on this table?


Here they are:

Triggers:
    entry_correct_published_at_trigger BEFORE INSERT OR UPDATE ON entry FOR
EACH ROW EXECUTE PROCEDURE correct_published_at()
    entry_feed_page_trigger BEFORE INSERT OR UPDATE ON entry FOR EACH ROW
EXECUTE PROCEDURE entry_feed_page_trigger()
    entry_updated_at_trigger BEFORE UPDATE ON entry FOR EACH ROW EXECUTE
PROCEDURE update_updated_at_timestamp()
    feed_entry_count_trigger AFTER INSERT ON entry FOR EACH ROW EXECUTE
PROCEDURE update_feed_entry_count()


>  Also, it would be real
> interesting to see "pg_filedump -i -f" output for the two blocks in
> question (1508573 and 1818219) --- see http://sources.redhat.com/rhdb/
> to get a copy of pg_filedump.
>

I have downloaded, compiled and installed pg_filedump -- but I am not sure
how to determine which file I should have it dump. I am not very familiar
with the postgres file structure. Can you please provide some guidance? How
do I determine the correct file?

I've determined the relation "entry" has an oid = 16838 -- but the
/data/base/16830 directory contains 92 1GB files named 16838.[1-92]

I've tried:

pg_filedump -i -f -R 1508573 16838

and got the following error:

[postgres(at)prod-db-2 16830]$ pg_filedump -i -f -R 1508573 16838

*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility - Version 8.2.0
*
* File: 16838
* Options used: -i -f -R 1508573
*
* Dump created on: Sun Dec 30 23:18:01 2007
*******************************************************************
Error: Seek error encountered before requested start block <1508573>.

I tried a few other files in the 1-92 range with the same results.


Mason

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-12-31 06:08:35
Subject: Re: Duplicate values found when reindexing unique index
Previous:From: Alvaro HerreraDate: 2007-12-31 03:56:48
Subject: Re: BUG #3841: core dump in uuid-ossp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group