"duplicate key value violates unique constraint" ERROR
От | Renato Oliveira |
---|---|
Тема | "duplicate key value violates unique constraint" ERROR |
Дата | |
Msg-id | 7965A9DCF12CC14984420BCC37B1608F25AC1C6612@Elzar.grant.co.uk обсуждение исходный текст |
Ответы |
Re: "duplicate key value violates unique constraint" ERROR
|
Список | pgsql-admin |
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@grant.co.uk
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
В списке pgsql-admin по дате отправления: