Shailesh Lahariya created SQOOP-3314:
----------------------------------------
Summary: Sqoop doesn't display full log on console
Key: SQOOP-3314
URL: https://issues.apache.org/jira/browse/SQOOP-3314
Project: Sqoop
Issue Type: Bug
Reporter: Shailesh Lahariya
I am running a sqoop command (using sqoop 1.4.7) and getting an error. I cant
see full error,
it seems some of the useful information is not being displayed on console, for
ex. instead of ...19 more in the log below, it should be given the complete
message to help debug the issue.
18/04/17 01:59:12 WARN tool.EvalSqlTool: SQL exception executing statement:
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not
establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:774)
at
oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)
at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at
org.apache.sqoop.manager.OracleManager.makeConnection(OracleManager.java:329)
at
org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59)
at org.apache.sqoop.tool.EvalSqlTool.run(EvalSqlTool.java:64)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish
the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:523)
at
oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:521)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:660)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:286)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1438)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:518)
... 14 more
Caused by: oracle.net.ns.NetException: The method specified in wallet_location
is not supported. Location: /home/hadoop/wallet/jnetadmin_c
at
oracle.net.nt.CustomSSLSocketFactory.getSSLSocketEngine(CustomSSLSocketFactory.java:487)
at oracle.net.nt.TcpsNTAdapter.connect(TcpsNTAdapter.java:143)
at oracle.net.nt.ConnOption.connect(ConnOption.java:161)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:470)
... 19 more
Also, sharing the command that is producing the above error (altered it to
remove any confidential info)-
sqoop eval -D mapred.map.child.java.opts='-Doracle.net.tns_admin=.
-Doracle.net.wallet_location=.' -files
/home/hadoop/wallet/jnetadmin_c/ewallet.jks,/home/hadoop/wallet/jnetadmin_c/ewallet.jks,$HOME/wallet/sqlnet.ora,$HOME/wallet/tnsnames.ora
--username xx --password xx --connect
"jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=xx)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=xx)))"
--query "select 1 from dual" --verbose --throw-on-error
Please let me know if there is any option to get more log than it is producing
currently.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
