[ 
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]

Reply via email to