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:46:00 UTC
[jira] [Resolved] (SOLR-4747) DIH close database connection
directly after entity is completed
[ https://issues.apache.org/jira/browse/SOLR-4747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexandre Rafalovitch resolved SOLR-4747.
-----------------------------------------
Resolution: Won't Fix
> DIH close database connection directly after entity is completed
> ----------------------------------------------------------------
>
> Key: SOLR-4747
> URL: https://issues.apache.org/jira/browse/SOLR-4747
> Project: Solr
> Issue Type: New Feature
> Components: contrib - DataImportHandler
> Affects Versions: 4.2
> Environment: Solr on CentOs 6.4 within jboss, debian 7.0 postgres server
> Reporter: Remko Kuipers
> Priority: Major
>
> I use DIH to create an index for a number of postgres databases. These databases all contain an identical schema/table setup. The config looks like <entity rootEntity="false"><entity/><entity/></entity> repeated for each datasource. The readonly flag is set to true on the subentity objects. For each database solr creates three connections. These connections remain active as "idle in transaction" until the indexer is finished. As the number of databases times three exceeds my max_connections setting in postgres the indexer inevitably fails halfway through with a no more connections available error.
--
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