You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@lucene.apache.org by "Alexandre Rafalovitch (Jira)" <ji...@apache.org> on 2020/08/29 19:49:00 UTC
[jira] [Resolved] (SOLR-5932) DIH: retry query on "terminating
connection due to conflict with recovery"
[ https://issues.apache.org/jira/browse/SOLR-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexandre Rafalovitch resolved SOLR-5932.
-----------------------------------------
Resolution: Won't Fix
> DIH: retry query on "terminating connection due to conflict with recovery"
> --------------------------------------------------------------------------
>
> Key: SOLR-5932
> URL: https://issues.apache.org/jira/browse/SOLR-5932
> Project: Solr
> Issue Type: Improvement
> Components: contrib - DataImportHandler
> Affects Versions: 4.7
> Reporter: Gunnlaugur Thor Briem
> Priority: Minor
>
> When running DIH against a hot-standby PostgreSQL database, one may randomly see queries fail with this error:
> {code}
> org.apache.solr.handler.dataimport.DataImportHandlerException: org.postgresql.util.PSQLException: FATAL: terminating connection due to conflict with recovery
> Detail: User query might have needed to see row versions that must be removed.
> Hint: In a moment you should be able to reconnect to the database and repeat your command.
> {code}
> A reasonable course of action in this case is to catch the error and retry. This would support the use case of doing an initial (possibly lengthy) clean full-import against a hot-standby server, and then just running incremental dataimports against the master.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@lucene.apache.org
For additional commands, e-mail: issues-help@lucene.apache.org