[
https://issues.apache.org/jira/browse/SOLR-4939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13688217#comment-13688217
]
Uwe Schindler commented on SOLR-4939:
-------------------------------------
Ask your firewall administrator, we have no idea about your environment and
cannot help!
A quick test if it works at all is to enter the following on shell (needs
netcat installed):
{code}
nc <hostname_of_oracle_server> 2126
{code}
If this also timeouts, ask somebody who knows your network.
> Not able to import oracle DB on RedHat
> --------------------------------------
>
> Key: SOLR-4939
> URL: https://issues.apache.org/jira/browse/SOLR-4939
> Project: Solr
> Issue Type: Bug
> Affects Versions: 4.3.1
> Environment: Redhat Linux
> Reporter: Subhash Karemore
>
> I have configured my RedHat system for Solr. After that I started the solr,
> it is started properly. I have to import the Oracle DB for indexing. My data
> config file is.
> <dataConfig>
> <dataSource type="JdbcDataSource"
> driver="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@//<hostname>:2126/DBNAme" user="user"
> password="Passwd" batchSize="1" />
> <document>
> <entity name="table1" query="SELECT ID, col2, col3 FROM table1
> WHERE rownum BETWEEN 1 AND 1000" >
> <field column="ID" name="id" />
> <field column="col2" name="col2" />
> <field column="col3" name="col3" />
> </entity>
> </document>
> </dataConfig>
> I have done similar changes for schema.xml file.
> I have copied the solr-dataimporthandler-4.3.0.jar,
> solr-dataimporthandler-extras-4.3.0.jar, solr-solrj-4.3.0.jar from dist
> folder to ../lib folder. Also I have downloaded ojdbc6.jar and put in same
> folder.
> With this setting, it is working properly on Windows. However on RedHat, it
> is not working. It is giving me errors when I try to index DB.
> Below are the errors which I got on console.
> ERROR org.apache.solr.handler.dataimport.DocBuilder â Exception while
> processing: table1 document :
> SolrInputDocument[]:org.apache.solr.handler.dataimport.DataImportHandlerException:
> Unable to execute query: SELECT ID, col2, col3 FROM table1 WHERE rownum
> BETWEEN 1 AND 1000 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)
> at
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:404)
> at
> org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:319)
> at
> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:227)
> at
> org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:422)
> at
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:487)
> at
> org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:468)
> Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter
> could not establish the connection
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
> at
> oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
> at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
> at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:161)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:127)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:366)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:38)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:240)
> ... 12 more
> Caused by: oracle.net.ns.NetException: The Network Adapter could not
> establish the connection
> at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:392)
> at
> oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:434)
> at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
> at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
> at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
> ... 21 more
> Caused by: java.net.ConnectException: Connection timed out
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at
> java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
> at
> java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
> at
> java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)
> at java.net.Socket.connect(Socket.java:546)
> at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:150)
> at oracle.net.nt.ConnOption.connect(ConnOption.java:133)
> at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:370)
> ... 26 more
> 63262 [Thread-15] INFO org.apache.solr.update.processor.LogUpdateProcessor
> â [collection1] webapp=/solr path=/dataimport
> params={optimize=false&clean=false&indent=true&commit=true&verbose=false&command=full-import&debug=false&wt=json}
> status=0 QTime=21 {} 0 21
> 63263 [Thread-15] ERROR org.apache.solr.handler.dataimport.DataImporter â
> Full Import failed:java.lang.RuntimeException: java.lang.RuntimeException:
> org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
> execute query: SELECT ID, col2, col3 FROM table1 WHERE rownum BETWEEN 1 AND
> 1000 Processing Document # 1
> at
> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:266)
> at
> org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:422)
> at
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:487)
> at
> org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:468)
> Caused by: java.lang.RuntimeException:
> org.apache.solr.handler.dataimport.DataImportHandlerException: SELECT ID,
> col2, col3 FROM table1 WHERE rownum BETWEEN 1 AND 1000 Processing Document # 1
> at
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:406)
> at
> org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:319)
> at
> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:227)
> ... 3 more
> Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException:
> Unable to execute query: SELECT ID, col2, col3 FROM table1 WHERE rownum
> BETWEEN 1 AND 1000 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)
> at
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:404)
> ... 5 more
> Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter
> could not establish the connection
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
> at
> oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
> at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
> at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:161)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:127)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:366)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:38)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:240)
> ... 12 more
> Caused by: oracle.net.ns.NetException: The Network Adapter could not
> establish the connection
> at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:392)
> at
> oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:434)
> at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
> at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
> at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
> ... 21 more
> Caused by: java.net.ConnectException: Connection timed out
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at
> java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
> at
> java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
> at
> java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)
> at java.net.Socket.connect(Socket.java:546)
> at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:150)
> at oracle.net.nt.ConnOption.connect(ConnOption.java:133)
> at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:370)
> ... 26 more
> Please let me know, what I am missing?
--
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]
