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
Systems Administrator
e-mail: renato.oliveira@xxxxxxxxxxx
Company registered in England, registration number 658133
Registered office address:
29 Station Road,
Shepreth,
CAMBS SG8 6GB
UK
P Please consider the environment before printing this email
