sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Voros (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-3314) Sqoop doesn't display full log on console
Date Tue, 17 Apr 2018 15:19:00 GMT

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

Daniel Voros commented on SQOOP-3314:
-------------------------------------

Hi [~shailu.lahar], thank you for reporting this!

The {{... 19 more}} part is refering to the previous lines above, it's not truncated. I'm
afraid the {{--verbose}} is your best bet. The "method specified in wallet_location is not
supported" message suggests you have misconfigured your Oracle wallet. Could you please confirm
if it's working outside of Sqoop?

> 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
>            Priority: Major
>
> 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)

Mime
View raw message