lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Erick Erickson (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (SOLR-4939) Not able to import oracle DB on RedHat
Date Wed, 19 Jun 2013 12:14:20 GMT

     [ https://issues.apache.org/jira/browse/SOLR-4939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Erick Erickson resolved SOLR-4939.
----------------------------------

    Resolution: Invalid

Please raise this issue on the user's list first to determine whether it's a bona-fide bug,
I suspect a configuration error. If it is really a bug, we can re-open this.
                
> 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message