[ 
https://issues.apache.org/jira/browse/SOLR-4473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15998702#comment-15998702
 ] 

Alexandre Rafalovitch commented on SOLR-4473:
---------------------------------------------

Good catch.

I'll check next week if this went away on its own in the last 3 years. If it 
hasn't, then I'll need to think whether it is important to keep around. 

> 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
>            Assignee: Alexandre Rafalovitch
>             Fix For: 4.9, 6.0
>
>
> 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 was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to