From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
---|---|
To: | maciek(at)heroku(dot)com, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #8656: Duplicate data violating unique constraints |
Date: | 2013-12-05 01:33:07 |
Message-ID: | 20131205013307.GC8935@awork2.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 2013-12-04 20:04:15 +0000, maciek(at)heroku(dot)com wrote:
> Bug reference: 8656
> Logged by: Maciek Sakrejda
> Email address: maciek(at)heroku(dot)com
> PostgreSQL version: 9.3.1
> Operating system: Ubuntu 12.04 LTS 64-bit
> Description:
>
> A customer has run into an issue where data in a single table was apparently
> duplicated somehow, violating the unique constraint imposed by the primary
> key:
This quite possibly is an instance of the second item mentioned on
http://www.postgresql.org/docs/devel/static/release-9-3-2.html (upcoming
release). Note that, due to time constraints, the fix isn't perfect, but
it will prevent that sort of issue.
Did you ever do a VACUUM FREEZE? Do you have significant concurrency?
Could you please send the output of pg_controldata and SELECT
relfrozenxid, relminmxid FROM pg_class WHERE oid =
'tablename'::regclass;?
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Maciek Sakrejda | 2013-12-05 05:29:21 | Re: BUG #8656: Duplicate data violating unique constraints |
Previous Message | plalg | 2013-12-04 22:52:27 | BUG #8657: Postgres 9.3 JDBC driver is unable to find the Foreign tables |