You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "Karl Wright (Created) (JIRA)" <ji...@apache.org> on 2011/10/25 09:08:32 UTC

[jira] [Created] (CONNECTORS-282) We see a lot of unique constraint collisions trying to insert into the ingeststatus table

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

[jira] [Resolved] (CONNECTORS-282) We see a lot of unique constraint collisions trying to insert into the ingeststatus table

Posted by "Karl Wright (Resolved) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CONNECTORS-282?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karl Wright resolved CONNECTORS-282.
------------------------------------

    Resolution: Fixed
      Assignee: Karl Wright

r1188611.

                
> 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
>            Assignee: 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