[
https://issues.apache.org/jira/browse/CONNECTORS-299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13161558#comment-13161558
]
Karl Wright commented on CONNECTORS-299:
----------------------------------------
r1209427 to rejigger transaction logging output so people can see what is going
on.
> Crawling using Postgresql 9.1 hangs occasionally for a while
> ------------------------------------------------------------
>
> Key: CONNECTORS-299
> URL: https://issues.apache.org/jira/browse/CONNECTORS-299
> Project: ManifoldCF
> Issue Type: Bug
> Components: Framework core
> Affects Versions: ManifoldCF 0.4
> Reporter: Karl Wright
> Assignee: Karl Wright
> Fix For: ManifoldCF 0.4
>
>
> The hang takes place because of this postgresql error:
> ERROR 2011-11-28 14:46:23,959 (Worker thread '25') - Worker thread aborting
> and restarting due to database connection reset: Database exception:
> Exception doing query: ERROR: could not serialize access due to read/write
> dependencies among transactions
> Detail: Reason code: Canceled on identification as a pivot, during commit
> attempt.
> Hint: The transaction might succeed if retried.
> org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database
> exception: Exception doing query: ERROR: could not serialize access due to
> read/write dependencies among transactions
> Detail: Reason code: Canceled on identification as a pivot, during commit
> attempt.
> Hint: The transaction might succeed if retried.
> at
> org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:608)
> at
> org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.commitCurrentTransaction(DBInterfacePostgreSQL.java:1141)
> at
> org.apache.manifoldcf.core.database.Database.endTransaction(Database.java:321)
> at
> org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.endTransaction(DBInterfacePostgreSQL.java:1112)
> at
> org.apache.manifoldcf.crawler.jobs.JobManager.finishDocuments(JobManager.java:4072)
> at
> org.apache.manifoldcf.crawler.system.WorkerThread.run(WorkerThread.java:567)
> Caused by: org.postgresql.util.PSQLException: ERROR: could not serialize
> access due to read/write dependencies among transactions
> This is happening during the commit phase of the transaction, at a point
> where none of the transaction blocks in ManifoldCF know to look for it. It is
> therefore likely that all transaction blocks throughout ManifoldCF that deal
> with deadlock will need to be changed.
--
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
