[jira] [Created] (CONNECTORS-811) Postgresql driver does not recognize some new types of error code as requiring transaction retries

["Karl Wright (JIRA)" <ji...@apache.org>]

Karl Wright created CONNECTORS-811:
--------------------------------------

             Summary: Postgresql driver does not recognize some new types of error code as requiring transaction retries
                 Key: CONNECTORS-811
                 URL: https://issues.apache.org/jira/browse/CONNECTORS-811
             Project: ManifoldCF
          Issue Type: Bug
          Components: Framework crawler agent
    Affects Versions: ManifoldCF 1.4.1
            Reporter: Karl Wright
            Assignee: Karl Wright
             Fix For: ManifoldCF 1.5


This exception was reported to me and seems to have a new kind of error code.

{code}
1C159E0: ERROR: could not serialize access due to read/write dependencies among transactions
  Detail: Reason code: Canceled on identification as a pivot, during conflict in checking.
  Hint: The transaction might succeed if retried.; sleeping for 56816 ms
org.apache.manifoldcf.core.interfaces.ManifoldCFException: ERROR: could not serialize access due to read/write dependencies among transactions
  Detail: Reason code: Canceled on identification as a pivot, during conflict in checking.
  Hint: The transaction might succeed if retried.
        at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.reinterpretException(DBInterfacePostgreSQL.java:622)
        at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performModification(DBInterfacePostgreSQL.java:651)
        at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performInsert(DBInterfacePostgreSQL.java:187)
        at org.apache.manifoldcf.core.database.BaseTable.performInsert(BaseTable.java:68)
        at org.apache.manifoldcf.crawler.jobs.Carrydown.recordCarrydownDataMultiple(Carrydown.java:343)
        at org.apache.manifoldcf.crawler.jobs.JobManager.addDocuments(JobManager.java:4174)
        at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.processDocumentReferences(WorkerThread.java:2017)
        at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.flush(WorkerThread.java:1948)
        at org.apache.manifoldcf.crawler.system.WorkerThread.run(WorkerThread.java:562)
Caused by: org.postgresql.util.PSQLException: ERROR: could not serialize access due to read/write dependencies among transactions
  Detail: Reason code: Canceled on identification as a pivot, during conflict in checking.
  Hint: The transaction might succeed if retried.
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
        at org.apache.manifoldcf.core.database.Database.execute(Database.java:883)
        at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:683)
{code}




--
This message was sent by Atlassian JIRA
(v6.1#6144)