[
https://issues.apache.org/jira/browse/CONNECTORS-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13694726#comment-13694726
]
Ahmet Arslan commented on CONNECTORS-734:
-----------------------------------------
It seems that i am still getting same error followed by "Database exception:
SQLException doing query (25P02): ERROR: current transaction is aborted,
commands ignored until end of transaction block" error.
{code}
WARN 2013-06-27 16:32:27,755 (Worker thread '46') - 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:1236)
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.addDocumentReference(WorkerThread.java:1541)
at
org.apache.manifoldcf.crawler.connectors.webcrawler.WebcrawlerConnector$ProcessActivityLinkHandler.noteDiscoveredLink(WebcrawlerConnector.java:5788)
at
org.apache.manifoldcf.crawler.connectors.webcrawler.WebcrawlerConnector$ProcessActivityHTMLHandler.noteAHREF(WebcrawlerConnector.java:5912)
at
org.apache.manifoldcf.crawler.connectors.webcrawler.LinkParseState.noteNonscriptTag(LinkParseState.java:47)
at
org.apache.manifoldcf.crawler.connectors.webcrawler.FormParseState.noteNonscriptTag(FormParseState.java:53)
at
org.apache.manifoldcf.crawler.connectors.webcrawler.ScriptParseState.noteTag(ScriptParseState.java:53)
at
org.apache.manifoldcf.core.fuzzyml.HTMLParseState.noteTag(HTMLParseState.java:53)
at
org.apache.manifoldcf.core.fuzzyml.TagParseState.dealWithCharacter(TagParseState.java:618)
at
org.apache.manifoldcf.core.fuzzyml.SingleCharacterReceiver.dealWithCharacters(SingleCharacterReceiver.java:51)
at
org.apache.manifoldcf.core.fuzzyml.DecodingByteReceiver.dealWithBytes(DecodingByteReceiver.java:48)
at
org.apache.manifoldcf.core.fuzzyml.Parser.parseWithoutCharsetDetection(Parser.java:98)
at
org.apache.manifoldcf.crawler.connectors.webcrawler.WebcrawlerConnector.handleHTML(WebcrawlerConnector.java:6803)
at
org.apache.manifoldcf.crawler.connectors.webcrawler.WebcrawlerConnector.extractLinks(WebcrawlerConnector.java:5745)
at
org.apache.manifoldcf.crawler.connectors.webcrawler.WebcrawlerConnector.processDocuments(WebcrawlerConnector.java:1316)
at
org.apache.manifoldcf.crawler.connectors.BaseRepositoryConnector.processDocuments(BaseRepositoryConnector.java:423)
at
org.apache.manifoldcf.crawler.system.WorkerThread.run(WorkerThread.java:559)
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}
> 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
