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
