You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Alexandre Rafalovitch (JIRA)" <ji...@apache.org> on 2013/02/20 00:51:13 UTC
[jira] [Comment Edited] (SOLR-4473) Reloading a core will not close
(leak) associated DIH JDBC connection
[ https://issues.apache.org/jira/browse/SOLR-4473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13581772#comment-13581772 ]
Alexandre Rafalovitch edited comment on SOLR-4473 at 2/19/13 11:51 PM:
-----------------------------------------------------------------------
My top of config:
{code:xml}
<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" />
{code}
I can provide a full core zip if it is too hard to replicate from the above description.
was (Author: arafalov):
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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org