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

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

     [ https://issues.apache.org/jira/browse/CONNECTORS-811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karl Wright resolved CONNECTORS-811.
------------------------------------

    Resolution: Cannot Reproduce

No forthcoming information, so I will close this ticket, and open a new one when we get better info.


> 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)