[SOLR-5932] DIH: retry query on "terminating connection due to conflict with recovery"

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 4.7
• Component/s: contrib - DataImportHandler
• Assignee: Unassigned
• Reporter: Gunnlaugur Thor Briem
• Created: 28/Mar/14 18:47
• Updated: 29/Aug/20 19:48
• Resolved: 29/Aug/20 19:48

Description

When running DIH against a hot-standby PostgreSQL database, one may randomly see queries fail with this error:

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.

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.

Issue Links

• is superceded by: SOLR-14783 Remove DIH from 9.0