Re: BUG #2379: Duplicate pkeys in table

Philip Warner wrote:

> We have an intermittent bug that occurs on a table which is updated several
> times per second. The bug occurs every few days/weeks. It is usually
> preceeded by a "tuple concurrently updated" messages, but I could not swear
> it is always preceeded by it.
>
> The result of the bug is demonstrated by:
>
> select id,count(*) from xxx group by id having count(*)>1;
> id | count
> -------+-------
> 24613 | 6
> (1 row)

Please do a

SELECT xmin, xmax, cmin, cmax FROM xxx where id = 24613;

if you still have that particular manifestation.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support