Gunnlaugur Thor Briem created SOLR-5932:
-------------------------------------------
Summary: 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
(v6.2#6252)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
