Re: Index corruption - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Index corruption
Date
Msg-id 529.1151599289@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index corruption  (Marc Munro <marc@bloodnok.com>)
List pgsql-hackers
Marc Munro <marc@bloodnok.com> writes:
> As you see, slony is attempting to enter one tuple
> ('374520943','22007','0') two times.
> Each previous time we have had this problem, rebuilding the indexes on
> slony log table (sl_log_1) has fixed the problem.  I have not reindexed
> the table this time as I do not want to destroy any usable evidence.

Good.  How big is the log table --- would it be possible for you to send
me the physical table and index files?  (Not a pg_dump, the actual disk
files)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: [GENERAL] UUID's as primary keys
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [GENERAL] UUID's as primary keys