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/06/24 15:38:20 UTC

[jira] [Resolved] (CONNECTORS-734) EXPLAIN may require retry

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

Karl Wright resolved CONNECTORS-734.
------------------------------------

       Resolution: Fixed
    Fix Version/s: ManifoldCF 1.3
         Assignee: Karl Wright

r1496050 should fix this, but that depends on whether a deadlock error will cause the entire transaction to be forcibly aborted.  If it does, then this can still occur.  Please let me know.

                
> EXPLAIN may require retry
> -------------------------
>
>                 Key: CONNECTORS-734
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-734
>             Project: ManifoldCF
>          Issue Type: Bug
>    Affects Versions: ManifoldCF 1.2
>         Environment: java version "1.6.0_31" Java HotSpot(TM) 64-Bit Server VM (build 20.6-b01)
> Red Hat Enterprise Linux Server release 5.7 (Tikanga)
> PostgreSQL version 9.2.8 running on Scientific Linux release 6.2 (Carbon)
>            Reporter: Ahmet Arslan
>            Assignee: Karl Wright
>             Fix For: ManifoldCF 1.3
>
>
> {code}
> ERROR 2013-06-24 10:39:33,473 (Worker thread '1') - Explain failed with error Database exception: SQLException doing query (40001): ERROR: could not serialize access due to read/write dependencies among transactions
>   Detail: Reason code: Canceled on identification as a pivot, during conflict out checking.
>   Hint: The transaction might succeed if retried.
> org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: SQLException doing query (40001): ERROR: could not serialize access due to read/write dependencies among transactions
>   Detail: Reason code: Canceled on identification as a pivot, during conflict out checking.
>   Hint: The transaction might succeed if retried.
> 	at org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:717)
> 	at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:745)
> 	at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.explainQuery(DBInterfacePostgreSQL.java:1233)
> 	at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1449)
> 	at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144)
> 	at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:186)
> 	at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performQuery(DBInterfacePostgreSQL.java:822)
> 	at org.apache.manifoldcf.crawler.jobs.JobManager.addDocuments(JobManager.java:4148)
> 	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 out 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.executeQuery(AbstractJdbc2Statement.java:273)
> 	at org.apache.manifoldcf.core.database.Database.execute(Database.java:862)
> 	at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:677)
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira