lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexandre Rafalovitch (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SOLR-4473) Reloading a core will not close (leak) associated DIH JDBC connection
Date Wed, 03 Apr 2013 04:45:34 GMT

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

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

You are right. And, of course, there is no standard way to call that shutdown method. Which
means it is not safe to use embedded Derby.

Unfortunately, there seem to be no way to use networked Derby either (unless I missed something
in my test). After I change the URL and start network server, I get:
{noformat}
Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute
query: select * from ALERTS Processing Document # 4
	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.DebugLogger$2.getData(DebugLogger.java:188)
	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)
	at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:404)
	... 35 more
Caused by: java.lang.NullPointerException
	at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:241)
	... 43 more
{noformat}

Using the same URL from the command line works however. It seems that jdbc driver just cannot
get the connection for whatever reason. I added client libraries and all, but it does not
seem to help. And I haven't figured out how to connect to DIH in debug mode yet.

                
> 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message