You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Anurag Sharma (JIRA)" <ji...@apache.org> on 2014/11/07 17:50:34 UTC
[jira] [Commented] (SOLR-6599) Wrong error logged on DIH connection
problem
[ https://issues.apache.org/jira/browse/SOLR-6599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14202246#comment-14202246 ]
Anurag Sharma commented on SOLR-6599:
-------------------------------------
I am not sure if the issue still exist. Please update if it's reproducible.
Tried the following number of scenarios and not able to produce the exception mentioned in the description.
Here are the scenario's and exceptions, error messages seen:
# using invalid hostname
{code}
Caused by: java.net.UnknownHostException::xxxxx
{code}
# pointing to non-routable IP
{code}
Creating a connection for entity item with URL: jdbc:mysql://172.31.255.241/employees
[java] 338169 [commitScheduler-8-thread-1] INFO org.apache.solr.update.UpdateHandler – start commit{,optimize=false,openSearcher=false,waitSearcher=true,expungeDeletes=false,softCommit=false,prepareCommit=false}
[java] 338170 [commitScheduler-8-thread-1] INFO org.apache.solr.update.UpdateHandler – No uncommitted changes. Skipping IW.commit.
[java] 338171 [commitScheduler-8-thread-1] INFO org.apache.solr.update.UpdateHandler – end_commit_flush
{code}
# valid hostname but not connectable
{code}
[java] Caused by: java.net.ConnectException: Connection timed out
[java] at java.net.PlainSocketImpl.socketConnect(Native Method)
[java] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
[java] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
[java] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
[java] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
[java] at java.net.Socket.connect(Socket.java:579)
[java] at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:213)
[java] at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:297)
{code}
# making sql-server down
{code}
Caused by: java.net.ConnectException: Connection refused
[java] at java.net.PlainSocketImpl.socketConnect(Native Method)
[java] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
[java] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
[java] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
[java] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
[java] at java.net.Socket.connect(Socket.java:579)
[java] at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:213)
[java] at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:297)
[java] ... 29 more
{code}
> Wrong error logged on DIH connection problem
> --------------------------------------------
>
> Key: SOLR-6599
> URL: https://issues.apache.org/jira/browse/SOLR-6599
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler
> Affects Versions: 4.10.1
> Environment: Debian Squeeze, Oracle-java-8, mysql-connector-5.1.28
> Reporter: Thomas Lamy
> Priority: Minor
> Labels: difficulty-medium, impact-low
>
> If I try a full import via DIH from a mysql server which is firewalled or down, I get a misleading error message (see below, only SQL statement shortened).
> I don't know Java very well, but I suspect the connection error is catched, the connection handle is null, which in turn leads to the null pointer exception at the end of the stack trace.
> {code}
> Full Import failed:java.lang.RuntimeException: java.lang.RuntimeException: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: SELECT SenderID, ProviderID, `Name`, RefSenderID, CameraURL, ChatURL, [.....] Processing Document # 1
> at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:271)
> at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:416)
> at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:480)
> at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:461)
> Caused by: java.lang.RuntimeException: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: SELECT SenderID, ProviderID, `Name`, RefSenderID, CameraURL, ChatURL, [...] Processing Document # 1
> at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:417)
> at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:330)
> at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:232)
> ... 3 more
> Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: SELECT SenderID, ProviderID, `Name`, RefSenderID, CameraURL, ChatURL, [...] 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:283)
> at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:240)
> at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:44)
> 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:476)
> at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:415)
> ... 5 more
> Caused by: java.lang.NullPointerException
> at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:271)
> ... 12 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org