Re: duplicate key entries for primary key -- need urgent help

On Thu, Jul 04, 2019 at 06:28:03PM +0000, Kumar, Pawan (Nokia - IN/Bangalore) wrote:
>Thanks for reply.
>
>This has happened very often and at different production system.
>There is no version change. System running with same version since 1 year but duplicate key issue came quiet a time.
>And impact is big because of that and only way to fix is to delete the duplicate primary key.
>Any suggestions to check which logs? Any command to run to get more info during the issue?
>
>Any potential configuration to check?
>Plz suggest
>

Well, I've already pointed out you're missing 2 years worth of fixes, so
upgrading to current minor version is the first thing I'd do. (I doubt
people will be rushing to help you in their free time when you're
missing two years of fixes, possibly causing this issue.)

If the issue happens even after upgrading, we'll need to see more details
about an actual case - commands creating/modifying the duplicate rows,
or anything you can find. It's impossible to help you when we only know
there are duplicate values in a PK.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services