[
https://issues.apache.org/jira/browse/SOLR-4473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13619108#comment-13619108
]
Hoss Man commented on SOLR-4473:
--------------------------------
I'm not certain, but i suspect what you are seeing is specific to the way
derby's EmbeddedDiver works. As i understand it: you have to use a special
jdbc connection string to tell derby to shutdown the database, otherwise it
will continue to run as long the JVM is up, even if the Driver is properly
closed (which should be happening when the DataSource is closed, when the
import is finished)...
{noformat}
jdbc:derby:${solr.solr.home}/test-dihnested/dihdb-content;shutdown=true
{noformat}
> 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.3
>
>
> 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]
