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 (JIRA)" <ji...@apache.org> on 2013/11/17 19:39:21 UTC
[jira] [Comment Edited] (CONNECTORS-811) Postgresql driver does not
recognize some new types of error code as requiring transaction retries
[ https://issues.apache.org/jira/browse/CONNECTORS-811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13824898#comment-13824898 ]
Karl Wright edited comment on CONNECTORS-811 at 11/17/13 6:38 PM:
------------------------------------------------------------------
The stack trace is consistent with there being no actual problem, EXCEPT the fact that the stack trace is dumped to the log at all. That shouldn't happen if the system decides to retry the transaction.
I've requested more information from the person reporting the problem.
was (Author: kwright@metacarta.com):
The stack trace is consistent with there being no actual problem, EXCEPT the fact that the stack trace is dumped to the log at all. That shouldn't happen if the system decides to retry the transaction.
> 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)