We see a lot of unique constraint collisions trying to insert into the
ingeststatus table
-----------------------------------------------------------------------------------------
Key: CONNECTORS-282
URL: https://issues.apache.org/jira/browse/CONNECTORS-282
Project: ManifoldCF
Issue Type: Bug
Components: Framework agents process
Affects Versions: ManifoldCF 0.4
Reporter: Karl Wright
Priority: Minor
Fix For: ManifoldCF 0.4
Postgresql logs the following over and over:
2011-10-24 23:48:56 EDT STATEMENT: INSERT INTO ingeststatus
(id,changecount,dockey,lastversion,firstingest,connectionname,authorityname,urihash,lastoutputversion,lastingest,docuri)
VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
This is clearly part of a failback sequence designed to prevent duplicates, but
we seem to be erring by trying the least probable thing first. This no doubt
impacts performance as well.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
