From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
---|---|
To: | Maciek Sakrejda <maciek(at)heroku(dot)com> |
Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>,pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #8656: Duplicate data violating unique constraints |
Date: | 2013-12-10 17:44:39 |
Message-ID: | 6bd0b0c6-3d79-4100-8650-27b01b5dd0d8@email.android.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Maciek Sakrejda <maciek(at)heroku(dot)com> schrieb:
>By the way, the customer has run into the issue *again* now since
>deleting
>the duplicate rows about a week ago. There are three duplicates now.
>Again,
>everything is identical between the versions except for the ctid. The
>xmin/xmax are also identical:
>
>=> select ctid, xmin, xmax, id from post where id in (1877554, 1885823,
>1885824);
> ctid | xmin | xmax | id
>------------+---------+---------+---------
> (28771,35) | 1651525 | 1651525 | 1877554
> (28778,29) | 1651525 | 1651525 | 1877554
> (28771,37) | 1651525 | 1651525 | 1885823
> (28778,33) | 1651525 | 1651525 | 1885823
> (28771,36) | 1651525 | 1651525 | 1885824
> (28778,31) | 1651525 | 1651525 | 1885824
>(6 rows)
Have you upgraded to 9.3.2?
Andres
--
Please excuse brevity and formatting - I am writing this on my mobile phone.
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Maciek Sakrejda | 2013-12-10 18:05:44 | Re: BUG #8656: Duplicate data violating unique constraints |
Previous Message | Maciek Sakrejda | 2013-12-10 17:36:04 | Re: BUG #8656: Duplicate data violating unique constraints |