图文精华

About云-梭伦科技»专题 › 交流区 › 技术交流 › Sqoop › 疑问解答› 求助，Sqoop的Unknown rpc kind RPC_WRITABLE问题！急！
分享

求助，Sqoop的Unknown rpc kind RPC_WRITABLE问题！急！

star4g 2014-6-27 15:38:10 发表于 疑问解答 [显示全部楼层] 只看大图 回帖奖励 阅读模式 关闭右栏 10 26013
本帖最后由 star4g 于 2014-6-27 15:43 编辑

最近公司使用Kettle。
但是Big Data插件中Sqoop import一直出现问题。
Google了几天了，也没查到解决方法。
求助大家，有遇到这样的问题的么？
  1. 2014/06/27 15:25:58 - Spoon - Spoon

  2. 2014/06/27 15:26:13 - Spoon - 保存文件或资源库...

  3. 2014/06/27 15:26:13 - Spoon - 保存到资源库...

  4. 2014/06/27 15:26:14 - Spoon - 正在开始任务...

  5. 2014/06/27 15:26:14 - test - 开始执行任务

  6. 2014/06/27 15:26:14 - test - exec(0, 0, Sqoop Import.0)

  7. 2014/06/27 15:26:14 - Sqoop Import - Starting job entry

  8. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - fs.default.name is deprecated. Instead, use fs.defaultFS

  9. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.

  10. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Enabled debug logging.

  11. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Setting your password on the command-line is insecure. Consider using -P instead.

  12. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.

  13. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory

  14. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory

  15. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Using default fetchSize of 1000

  16. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Instantiated ConnManager org.apache.sqoop.manager.GenericJdbcManager@14849f5

  17. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Beginning code generation

  18. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - No connection paramenters specified. Using regular API for making connection.

  19. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Using fetchSize for next query: 1000

  20. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Executing SQL statement: SELECT * FROM TBLS WHERE 1 AND  (1 = 0) 

  21. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Using fetchSize for next query: 1000

  22. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Executing SQL statement: SELECT * FROM TBLS WHERE 1 AND  (1 = 0) 

  23. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - selected columns:

  24. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   TBL_ID

  25. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   CREATE_TIME

  26. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   DB_ID

  27. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   LAST_ACCESS_TIME

  28. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   OWNER

  29. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   RETENTION

  30. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   SD_ID

  31. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   TBL_NAME

  32. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   TBL_TYPE

  33. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   VIEW_EXPANDED_TEXT

  34. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   VIEW_ORIGINAL_TEXT

  35. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Writing source file: \tmp\sqoop-hadoop\compile\642c7772f5169fe3c2d427f3c27aee9f\QueryResult.java

  36. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Table name: null

  37. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Columns: TBL_ID:-5, CREATE_TIME:4, DB_ID:-5, LAST_ACCESS_TIME:4, OWNER:12, RETENTION:4, SD_ID:-5, TBL_NAME:12, TBL_TYPE:12, VIEW_EXPANDED_TEXT:-1, VIEW_ORIGINAL_TEXT:-1, 

  38. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - sourceFilename is QueryResult.java

  39. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Found existing \tmp\sqoop-hadoop\compile\642c7772f5169fe3c2d427f3c27aee9f\

  40. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - $HADOOP_HOME is not set

  41. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Adding source file: \tmp\sqoop-hadoop\compile\642c7772f5169fe3c2d427f3c27aee9f\QueryResult.java

  42. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Invoking javac with args:

  43. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   -sourcepath

  44. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   \tmp\sqoop-hadoop\compile\642c7772f5169fe3c2d427f3c27aee9f\

  45. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   -d

  46. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   \tmp\sqoop-hadoop\compile\642c7772f5169fe3c2d427f3c27aee9f\

  47. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 -   -classpath

  48. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Writing jar file: \tmp\sqoop-hadoop\compile\642c7772f5169fe3c2d427f3c27aee9f\QueryResult.jar

  49. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Found existing jar (\tmp\sqoop-hadoop\compile\642c7772f5169fe3c2d427f3c27aee9f\QueryResult.jar); removing.

  50. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Scanning for .class files in directory: \tmp\sqoop-hadoop\compile\642c7772f5169fe3c2d427f3c27aee9f

  51. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Got classfile: \tmp\sqoop-hadoop\compile\642c7772f5169fe3c2d427f3c27aee9f\QueryResult.class -> QueryResult.class

  52. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Finished writing jar file \tmp\sqoop-hadoop\compile\642c7772f5169fe3c2d427f3c27aee9f\QueryResult.jar

  53. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Beginning query import.

  54. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Using table class: QueryResult

  55. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Using InputFormat: class com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat

  56. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Adding to job classpath: file:/C:/Users/gmx/Desktop/kettle/distrib/plugins/pentaho-big-data-plugin/hadoop-configurations/cdh41/lib/sqoop-1.4.1-cdh4.0.0.jar

  57. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Adding to job classpath: file:/C:/Users/gmx/Desktop/kettle/distrib/lib/mysql-connector-java-5.1.7-bin.jar

  58. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Adding to job classpath: file:/C:/Users/gmx/Desktop/kettle/distrib/plugins/pentaho-big-data-plugin/hadoop-configurations/cdh41/lib/sqoop-1.4.1-cdh4.0.0.jar

  59. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Adding to job classpath: file:/C:/Users/gmx/Desktop/kettle/distrib/plugins/pentaho-big-data-plugin/hadoop-configurations/cdh41/lib/sqoop-1.4.1-cdh4.0.0.jar

  60. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - SQOOP_HOME is unset. May not be able to find all job dependencies.

  61. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - PrivilegedAction as:hadoop (auth:SIMPLE) from:org.apache.hadoop.mapreduce.Job.connect(Job.java:492)

  62. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - PrivilegedAction as:hadoop (auth:SIMPLE) from:org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:844)

  63. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - The ping interval is 60000 ms.

  64. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Use SIMPLE authentication for protocol JobSubmissionProtocol

  65. 2014/06/27 15:26:14 - Sqoop Import - 2014/06/27 15:26:14 - Connecting to /192.168.128.52:8021

  66. 2014/06/27 15:26:16 - Sqoop Import - 2014/06/27 15:26:16 - Retrying connect to server: svr52/192.168.128.52:8021. Already tried 0 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1 SECONDS)

  67. 2014/06/27 15:26:18 - Sqoop Import - 2014/06/27 15:26:18 - Retrying connect to server: svr52/192.168.128.52:8021. Already tried 1 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1 SECONDS)

  68. 2014/06/27 15:26:20 - Sqoop Import - 2014/06/27 15:26:20 - Retrying connect to server: svr52/192.168.128.52:8021. Already tried 2 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1 SECONDS)

  69. 2014/06/27 15:26:22 - Sqoop Import - 2014/06/27 15:26:22 - Retrying connect to server: svr52/192.168.128.52:8021. Already tried 3 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1 SECONDS)

  70. 2014/06/27 15:26:24 - Sqoop Import - 2014/06/27 15:26:24 - Retrying connect to server: svr52/192.168.128.52:8021. Already tried 4 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1 SECONDS)

  71. 2014/06/27 15:26:26 - Sqoop Import - 2014/06/27 15:26:26 - Retrying connect to server: svr52/192.168.128.52:8021. Already tried 5 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1 SECONDS)

  72. 2014/06/27 15:26:28 - Sqoop Import - 2014/06/27 15:26:28 - Retrying connect to server: svr52/192.168.128.52:8021. Already tried 6 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1 SECONDS)

  73. 2014/06/27 15:26:30 - Sqoop Import - 2014/06/27 15:26:30 - Retrying connect to server: svr52/192.168.128.52:8021. Already tried 7 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1 SECONDS)

  74. 2014/06/27 15:26:32 - Sqoop Import - 2014/06/27 15:26:32 - Retrying connect to server: svr52/192.168.128.52:8021. Already tried 8 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1 SECONDS)

  75. 2014/06/27 15:26:34 - Sqoop Import - 2014/06/27 15:26:34 - Retrying connect to server: svr52/192.168.128.52:8021. Already tried 9 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1 SECONDS)

  76. 2014/06/27 15:26:35 - Sqoop Import - 2014/06/27 15:26:35 - closing ipc connection to svr52/192.168.128.52:8021: Connection refused: no further information

  77. 2014/06/27 15:26:35 - Sqoop Import - 2014/06/27 15:26:35 - IPC Client (27655609) connection to /192.168.128.52:8021 from hadoop: closed

  78. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 - PriviledgedActionException as:hadoop (auth:SIMPLE) cause:java.net.ConnectException: Call From gmx-PC/192.3.5.50 to svr52:8021 failed on connection exception: java.net.ConnectException: Connection refused: no further information; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused

  79. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 - Encountered IOException running import job: java.net.ConnectException: Call From gmx-PC/192.3.5.50 to svr52:8021 failed on connection exception: java.net.ConnectException: Connection refused: no further information; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused

  80. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

  81. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

  82. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

  83. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

  84. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.net.NetUtils.wrapWithMessage(NetUtils.java:782)

  85. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.net.NetUtils.wrapException(NetUtils.java:729)

  86. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client.call(Client.java:1241)

  87. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.WritableRpcEngine$Invoker.invoke(WritableRpcEngine.java:225)

  88. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapred.$Proxy18.getStagingAreaDir(Unknown Source)

  89. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapred.JobClient.getStagingAreaDir(JobClient.java:1223)

  90. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapreduce.JobSubmissionFiles.getStagingDir(JobSubmissionFiles.java:102)

  91. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:850)

  92. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:844)

  93. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at java.security.AccessController.doPrivileged(Native Method)

  94. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at javax.security.auth.Subject.doAs(Subject.java:396)

  95. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408)

  96. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:844)

  97. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapreduce.Job.submit(Job.java:481)

  98. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:511)

  99. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:141)

  100. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:201)

  101. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.manager.SqlManager.importQuery(SqlManager.java:509)

  102. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:405)

  103. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)

  104. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.Sqoop.run(Sqoop.java:145)

  105. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)

  106. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)

  107. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)

  108. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:49)

  109. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.common.CommonSqoopShim.runTool(CommonSqoopShim.java:44)

  110. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim.access$001(ClassPathModifyingSqoopShim.java:41)

  111. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim$1.call(ClassPathModifyingSqoopShim.java:80)

  112. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim$1.call(ClassPathModifyingSqoopShim.java:77)

  113. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim.runWithModifiedClassPathProperty(ClassPathModifyingSqoopShim.java:64)

  114. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim.runTool(ClassPathModifyingSqoopShim.java:77)

  115. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.di.job.entries.sqoop.AbstractSqoopJobEntry.executeSqoop(AbstractSqoopJobEntry.java:259)

  116. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.di.job.entries.sqoop.AbstractSqoopJobEntry$1.run(AbstractSqoopJobEntry.java:231)

  117. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at java.lang.Thread.run(Thread.java:662)

  118. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : Caused by: java.net.ConnectException: Connection refused: no further information

  119. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)

  120. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:599)

  121. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.net.SocketIOWithTimeout.connect(SocketIOWithTimeout.java:207)

  122. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:528)

  123. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:492)

  124. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client$Connection.setupConnection(Client.java:509)

  125. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client$Connection.setupIOstreams(Client.java:603)

  126. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client$Connection.access$2100(Client.java:252)

  127. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client.getConnection(Client.java:1290)

  128. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client.call(Client.java:1208)

  129. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         ... 31 more

  130. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 - Got exception running Sqoop: java.lang.RuntimeException: java.net.ConnectException: Call From gmx-PC/192.3.5.50 to svr52:8021 failed on connection exception: java.net.ConnectException: Connection refused: no further information; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused

  131. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 - java.lang.RuntimeException: java.net.ConnectException: Call From gmx-PC/192.3.5.50 to svr52:8021 failed on connection exception: java.net.ConnectException: Connection refused: no further information; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused

  132. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:487)

  133. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.sqoop.Sqoop.run(Sqoop.java:145)

  134. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)

  135. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)

  136. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)

  137. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:49)

  138. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.pentaho.hadoop.shim.common.CommonSqoopShim.runTool(CommonSqoopShim.java:44)

  139. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim.access$001(ClassPathModifyingSqoopShim.java:41)

  140. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim$1.call(ClassPathModifyingSqoopShim.java:80)

  141. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim$1.call(ClassPathModifyingSqoopShim.java:77)

  142. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim.runWithModifiedClassPathProperty(ClassPathModifyingSqoopShim.java:64)

  143. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim.runTool(ClassPathModifyingSqoopShim.java:77)

  144. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.pentaho.di.job.entries.sqoop.AbstractSqoopJobEntry.executeSqoop(AbstractSqoopJobEntry.java:259)

  145. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.pentaho.di.job.entries.sqoop.AbstractSqoopJobEntry$1.run(AbstractSqoopJobEntry.java:231)

  146. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at java.lang.Thread.run(Thread.java:662)

  147. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 - Caused by: java.net.ConnectException: Call From gmx-PC/192.3.5.50 to svr52:8021 failed on connection exception: java.net.ConnectException: Connection refused: no further information; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused

  148. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

  149. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

  150. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

  151. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

  152. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.net.NetUtils.wrapWithMessage(NetUtils.java:782)

  153. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.net.NetUtils.wrapException(NetUtils.java:729)

  154. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.ipc.Client.call(Client.java:1241)

  155. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.ipc.WritableRpcEngine$Invoker.invoke(WritableRpcEngine.java:225)

  156. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.mapred.$Proxy18.getStagingAreaDir(Unknown Source)

  157. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.mapred.JobClient.getStagingAreaDir(JobClient.java:1223)

  158. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.mapreduce.JobSubmissionFiles.getStagingDir(JobSubmissionFiles.java:102)

  159. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:850)

  160. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:844)

  161. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at java.security.AccessController.doPrivileged(Native Method)

  162. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at javax.security.auth.Subject.doAs(Subject.java:396)

  163. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408)

  164. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:844)

  165. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.mapreduce.Job.submit(Job.java:481)

  166. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:511)

  167. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:141)

  168. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:201)

  169. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.sqoop.manager.SqlManager.importQuery(SqlManager.java:509)

  170. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:405)

  171. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)

  172. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         ... 14 more

  173. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 - Caused by: java.net.ConnectException: Connection refused: no further information

  174. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)

  175. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:599)

  176. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.net.SocketIOWithTimeout.connect(SocketIOWithTimeout.java:207)

  177. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:528)

  178. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:492)

  179. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.ipc.Client$Connection.setupConnection(Client.java:509)

  180. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.ipc.Client$Connection.setupIOstreams(Client.java:603)

  181. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.ipc.Client$Connection.access$2100(Client.java:252)

  182. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.ipc.Client.getConnection(Client.java:1290)

  183. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         at org.apache.hadoop.ipc.Client.call(Client.java:1208)

  184. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : 2014/06/27 15:26:35 -         ... 31 more

  185. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : Error running Sqoop

  186. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.net.ConnectException: Call From gmx-PC/192.3.5.50 to svr52:8021 failed on connection exception: java.net.ConnectException: Connection refused: no further information; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused

  187. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim.runWithModifiedClassPathProperty(ClassPathModifyingSqoopShim.java:67)

  188. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim.runTool(ClassPathModifyingSqoopShim.java:77)

  189. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.di.job.entries.sqoop.AbstractSqoopJobEntry.executeSqoop(AbstractSqoopJobEntry.java:259)

  190. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.di.job.entries.sqoop.AbstractSqoopJobEntry$1.run(AbstractSqoopJobEntry.java:231)

  191. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at java.lang.Thread.run(Thread.java:662)

  192. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.net.ConnectException: Call From gmx-PC/192.3.5.50 to svr52:8021 failed on connection exception: java.net.ConnectException: Connection refused: no further information; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused

  193. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:186)

  194. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)

  195. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:49)

  196. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.common.CommonSqoopShim.runTool(CommonSqoopShim.java:44)

  197. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim.access$001(ClassPathModifyingSqoopShim.java:41)

  198. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim$1.call(ClassPathModifyingSqoopShim.java:80)

  199. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim$1.call(ClassPathModifyingSqoopShim.java:77)

  200. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.pentaho.hadoop.shim.cdh4.ClassPathModifyingSqoopShim.runWithModifiedClassPathProperty(ClassPathModifyingSqoopShim.java:64)

  201. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         ... 4 more

  202. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : Caused by: java.lang.RuntimeException: java.net.ConnectException: Call From gmx-PC/192.3.5.50 to svr52:8021 failed on connection exception: java.net.ConnectException: Connection refused: no further information; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused

  203. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:487)

  204. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.Sqoop.run(Sqoop.java:145)

  205. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)

  206. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)

  207. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         ... 11 more

  208. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : Caused by: java.net.ConnectException: Call From gmx-PC/192.3.5.50 to svr52:8021 failed on connection exception: java.net.ConnectException: Connection refused: no further information; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused

  209. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

  210. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

  211. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

  212. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

  213. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.net.NetUtils.wrapWithMessage(NetUtils.java:782)

  214. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.net.NetUtils.wrapException(NetUtils.java:729)

  215. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client.call(Client.java:1241)

  216. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.WritableRpcEngine$Invoker.invoke(WritableRpcEngine.java:225)

  217. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapred.$Proxy18.getStagingAreaDir(Unknown Source)

  218. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapred.JobClient.getStagingAreaDir(JobClient.java:1223)

  219. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapreduce.JobSubmissionFiles.getStagingDir(JobSubmissionFiles.java:102)

  220. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:850)

  221. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:844)

  222. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at java.security.AccessController.doPrivileged(Native Method)

  223. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at javax.security.auth.Subject.doAs(Subject.java:396)

  224. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408)

  225. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:844)

  226. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapreduce.Job.submit(Job.java:481)

  227. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:511)

  228. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:141)

  229. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:201)

  230. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.manager.SqlManager.importQuery(SqlManager.java:509)

  231. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:405)

  232. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)

  233. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         ... 14 more

  234. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) : Caused by: java.net.ConnectException: Connection refused: no further information

  235. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)

  236. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:599)

  237. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.net.SocketIOWithTimeout.connect(SocketIOWithTimeout.java:207)

  238. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:528)

  239. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:492)

  240. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client$Connection.setupConnection(Client.java:509)

  241. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client$Connection.setupIOstreams(Client.java:603)

  242. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client$Connection.access$2100(Client.java:252)

  243. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client.getConnection(Client.java:1290)

  244. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         at org.apache.hadoop.ipc.Client.call(Client.java:1208)

  245. 2014/06/27 15:26:35 - Sqoop Import - ERROR (version 4.4.0, build 1 from 2014-04-04 09.07.23 by PC) :         ... 31 more

  246. 2014/06/27 15:26:35 - test - 任务执行完毕

  247. 2014/06/27 15:26:35 - Spoon - 任务已经结束.

  248. 2014/06/27 15:27:34 - Spoon - Spoon

  249. 2014/06/27 15:29:24 - Spoon - Spoon

  250. 2014/06/27 15:31:47 - Spoon - Spoon
复制代码




QQ图片20140627152804.jpg

现在平台的版本是CDH4.4，用的yarn，Jobtracter Port 填 8032也试过，一样不行。
自己猜测可能是通信问题，也可能是MR1和MR2的问题，但是不知怎么解决。

回复

使用道具 举报

自定义广告语

已有(12)人评论

跳转到指定楼层
正序浏览
howtodown 发表于 2014-6-27 23:05:09
SELECT * FROM TBLS WHERE 1 AND  (1 = 0)

你这个sql语句在看看是不是有问题
你对下面看看
  1. bin/sqoop import --connect jdbc:mysql://10.95.3.49:3306/workflow --username shirdrn -P --query 'SELECT users.*, tags.tag FROM users JOIN tags ON (users.id = tags.user_id) WHERE $CONDITIONS' --split-by users.id --target-dir /hive/tag_db/user_tags  -- --default-character-set=utf-8
复制代码

详细可参考
高可用性：Sqoop工具import和export使用详解

回复

使用道具 举报

star4g 发表于 2014-6-28 01:48:22
howtodown 发表于 2014-6-27 23:05
SELECT * FROM TBLS WHERE 1 AND  (1 = 0)

你这个sql语句在看看是不是有问题

应该不是语句的问题。
  1. --target-dir /user/impala/kettle/sqoop --split-by TBL_ID --query "SELECT * FROM TBLS WHERE 1 AND $CONDITIONS" --connect jdbc:mysql://192.168.128.51:3306/hive --driver com.mysql.jdbc.Driver --username hive --password hive --verbose --fields-terminated-by ~
复制代码

看了日志上是本地打好了jar包连接hadoop然后出错的。
回复

使用道具 举报

hyj 发表于 2014-6-28 06:54:53
star4g 发表于 2014-6-28 01:48
应该不是语句的问题。
看了日志上是本地打好了jar包连接hadoop然后出错的。
检查下通信，hostname等，好像是连接不上。
回复

使用道具 举报

star4g 发表于 2014-6-29 20:50:17
hyj 发表于 2014-6-28 06:54
检查下通信，hostname等，好像是连接不上。

测试过。通信啊什么的都没有问题的。
回复

使用道具 举报

star4g 发表于 2014-7-2 17:17:23
hyj 发表于 2014-6-28 06:54
检查下通信，hostname等，好像是连接不上。

版主你好，我想问一下，如果客户端kettle提交的请求是基于MR1的，服务端配置是YARN，提交到8032端口，会不会出现这样的情况？
感觉可能是这样的问题。
拜谢了！快被这问题逼疯了。

点评

hyj
YARN不知道兼容性好不好，你最好使用MR2，这样更稳定。  发表于 2014-7-2 23:57
回复

使用道具 举报

nettman 发表于 2014-7-4 01:02:47
star4g 发表于 2014-7-2 17:17
版主你好，我想问一下，如果客户端kettle提交的请求是基于MR1的，服务端配置是YARN，提交到8032端口，会 ...
用的是Cloudera Manager (CM) 管理的集群吗？如果是的话，你的配置需要改改。

是sqoop2吗？
改一下下面两个配置试一下。

  1. org.apache.sqoop.connector.autoupgrade=true

  2. org.apache.sqoop.framework.autoupgrade=true
复制代码




回复

使用道具 举报

star4g 发表于 2014-7-5 16:17:10
nettman 发表于 2014-7-4 01:02
用的是Cloudera Manager (CM) 管理的集群吗？如果是的话，你的配置需要改改。

是sqoop2吗？

不是sqoop2，是sqoop1.
也没用Cloudera Manager管理。
服务端用的CDH4.4版本。


现在好像是在终端连接 hadoop服务端没连接上，或者连接上被拒绝了的感觉。


想解决问题，但是没有方向没有头绪。


真心求帮助，不然经理要弄死我了。

点评

hyj
实在解决不了，你加入群问一下，39327136  发表于 2014-7-5 16:47
回复

使用道具 举报

nettman 发表于 2014-7-5 16:42:43
star4g 发表于 2014-7-5 16:17
不是sqoop2，是sqoop1.
也没用Cloudera Manager管理。
服务端用的CDH4.4版本。
没有连上看看端口、防火墙、主机名（hostname）、ip这些是基本的。一遍遍屡屡，说不定就是一个不起眼的小错误。
回复

使用道具 举报

wubaozhou 发表于 2015-1-1 21:27:07
回复

使用道具 举报

12下一页
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

发表新帖
star4g

注册会员

关注

  • 1

    主题

  • 10

    帖子

  • 3

    粉丝

TA的主题
关闭

推荐上一条 /2 下一条

关于我们· 联系我们· 加入我们· 小黑屋· 合作伙伴   

Copyright © 2001-2025 About云-梭伦科技 Powered by Discuz! X3.4 Licensed Discuz Team.

简书 / Smrz 京ICP备2020039040号 Wxb 简书网举报电话：021-34700000