Dear all,
I am sorry to have another post.
I have been following a problem which has been growing fast on our system.
At the beginning I thought it was related to load on PG server, then I thought it was load on the switch/network, now I don’t know.
We seem to get loads of Exception errors and when I look at the Postgres Log there are loads of “duplicate key value violates unique constraint”
I have researched on the Internet and some posts say: Reindex, some say bug in JIRA.
Some say: Your primary key index isn't in sync.
Have you guys suffered from this problem before, or have seen it anywhere?
From 30th of April to today I got 1400 errors.
What do you guys think might cause this behavior?
I also think it is causing the system to slow down a bit, do you think that might be possible?
Very much appreciate any help, insight, opinion or anything you could think.
Thank you very much
Best regards
Renato