[
https://issues.apache.org/jira/browse/SOLR-4473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13581772#comment-13581772
]
Alexandre Rafalovitch commented on SOLR-4473:
---------------------------------------------
My top of config:
<dataConfig>
<dataSource name="dbds" type="JdbcDataSource"
driver="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:${solr.solr.home}/test-dihnested/dihdb-content"
user="app" password="app" />
I can provide a full core zip if it is too hard to replicate from the above
description.
> Reloading a core will not close (leak) associated DIH JDBC connection
> ---------------------------------------------------------------------
>
> Key: SOLR-4473
> URL: https://issues.apache.org/jira/browse/SOLR-4473
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler
> Affects Versions: 4.1
> Reporter: Alexandre Rafalovitch
> Fix For: 4.2
>
>
> I have DIH configured with Derby database. After I start Solr, I can run DIH
> import fine. After I reload the core, DIH can no longer run with the
> following message (excerpts):
> ...
> EVERE: Exception while processing: vac document :
> SolrInputDocument[]:org.apache.solr.handler.dataimport.DataImportHandlerException:
> Unable to execute query: select * from ALERTS Processing Document # 1
> at
> org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:71)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:38)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
> at
> org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
> at
> org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:243)
> at
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:465)
> Caused by: java.sql.SQLException: Another instance of Derby may have already
> booted the database <PATH>.
--
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]