API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 24th, 2016
165
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.52 KB | None | 0 0
raw download clone embed print report
  1. ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]
  2.  
  3. nameNode=hdfs://localhost:8020
  4. jobTracker=localhost:8032
  5.  
  6. oozie.use.system.libpath=true
  7. oozie.wf.application.path=${nameNode}/user/harry/
  8.  
  9. <workflow-app name="Trend_Analysi_Scoop_Script" xmlns="uri:oozie:workflow:0.5">
  10. <start to="sqoop-c68d"/>
  11. <kill name="Kill">
  12. <message>Action failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message>
  13. </kill>
  14. <action name="sqoop-c68d">
  15. <sqoop xmlns="uri:oozie:sqoop-action:0.2">
  16. <job-tracker>${jobTracker}</job-tracker>
  17. <name-node>${nameNode}</name-node>
  18. <command>/usr/hdp/2.4.0.0-169/sqoop/bin/sqoop import --connect jdbc:oracle:thin:@connectionstring --username *** --password *** --query SELECT a,b,c where data = '01/01/01' AND $CONDITIONS; --hbase-table test -m 1 --column-family cf1 --split-by a</command>
  19. </sqoop>
  20. <ok to="End"/>
  21. <error to="Kill"/>
  22. </action>
  23. <end name="End"/>
  24.  
  25. hadoop fs -ls /user/oozie/share/lib/lib_20160402092340/sqoop
  26.  
  27. -rw-r--r-- 3 hdfs hadoop 3692096 2016-05-24 09:25 /user/oozie/share/lib/lib_20160402092340/sqoop/ojdbc6.jar
  28. -rw-r--r-- 3 hdfs hadoop 1017186 2016-04-02 09:24 /user/oozie/share/lib/lib_20160402092340/sqoop/sqoop-1.4.6.2.4.0.0-169.jar
  29. -rw-r--r-- 3 hdfs hadoop 9719 2016-05-24 10:25 /user/oozie/share/lib/lib_20160402092340/sqoop/oozie-hadoop-auth-hadoop-2-4.2.0.2.4.0.0-169.jar
  30. -rw-r--r-- 3 hdfs hadoop 12284 2016-05-24 10:25 /user/oozie/share/lib/lib_20160402092340/sqoop/oozie-hadoop-utils-hadoop-2-4.2.0.2.4.0.0-169.jar
  31. -rw-r--r-- 3 hdfs hadoop 49469 2016-05-24 10:25 /user/oozie/share/lib/lib_20160402092340/sqoop/oozie-sharelib-oozie-4.2.0.2.4.0.0-169.jar
  32. -rw-r--r-- 3 hdfs hadoop 13119 2016-04-02 09:24 /user/oozie/share/lib/lib_20160402092340/sqoop/oozie-sharelib-sqoop-4.2.0.2.4.0.0-169.jar
  33. -rw-r--r-- 3 hdfs hadoop 792411 2016-05-24 10:25 /user/oozie/share/lib/lib_20160402092340/sqoop/zookeeper-3.4.6.2.4.0.0-169.jar
  34.  
  35. 2016-05-24 10:37:17,994 INFO ActionStartXCommand:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@:start:] Start action [0000001-160524103133053-oozie-oozi-W@:start:] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
  36. 2016-05-24 10:37:17,997 INFO ActionStartXCommand:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@:start:] [***0000001-160524103133053-oozie-oozi-W@:start:***]Action status=DONE
  37. 2016-05-24 10:37:17,997 INFO ActionStartXCommand:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@:start:] [***0000001-160524103133053-oozie-oozi-W@:start:***]Action updated in DB!
  38. 2016-05-24 10:37:18,164 INFO WorkflowNotificationXCommand:520 - SERVER[***] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@:start:] No Notification URL is defined. Therefore nothing to notify for job 0000001-160524103133053-oozie-oozi-W@:start:
  39. 2016-05-24 10:37:18,165 INFO WorkflowNotificationXCommand:520 - SERVER[***] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[] No Notification URL is defined. Therefore nothing to notify for job 0000001-160524103133053-oozie-oozi-W
  40. 2016-05-24 10:37:18,188 INFO ActionStartXCommand:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] Start action [0000001-160524103133053-oozie-oozi-W@sqoop-c68d] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
  41. 2016-05-24 10:37:26,080 INFO SqoopActionExecutor:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] Trying to get job [job_1462295072181_0163], attempt [1]
  42. 2016-05-24 10:37:26,106 INFO SqoopActionExecutor:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] checking action, hadoop job ID [job_1462295072181_0163] status [RUNNING]
  43. 2016-05-24 10:37:26,108 INFO ActionStartXCommand:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] [***0000001-160524103133053-oozie-oozi-W@sqoop-c68d***]Action status=RUNNING
  44. 2016-05-24 10:37:26,114 INFO ActionStartXCommand:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] [***0000001-160524103133053-oozie-oozi-W@sqoop-c68d***]Action updated in DB!
  45. 2016-05-24 10:37:26,184 INFO WorkflowNotificationXCommand:520 - SERVER[***] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] No Notification URL is defined. Therefore nothing to notify for job 0000001-160524103133053-oozie-oozi-W@sqoop-c68d
  46. 2016-05-24 10:37:37,181 INFO CallbackServlet:520 - SERVER[***] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] callback for action [0000001-160524103133053-oozie-oozi-W@sqoop-c68d]
  47. 2016-05-24 10:37:37,314 INFO SqoopActionExecutor:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] Trying to get job [job_1462295072181_0163], attempt [1]
  48. 2016-05-24 10:37:37,388 INFO SqoopActionExecutor:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] action completed, external ID [job_1462295072181_0163]
  49. 2016-05-24 10:37:37,395 WARN SqoopActionExecutor:523 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]
  50. 2016-05-24 10:37:37,484 INFO ActionEndXCommand:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] ERROR is considered as FAILED for SLA
  51. 2016-05-24 10:37:37,679 INFO ActionStartXCommand:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@Kill] Start action [0000001-160524103133053-oozie-oozi-W@Kill] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
  52. 2016-05-24 10:37:37,683 INFO ActionStartXCommand:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@Kill] [***0000001-160524103133053-oozie-oozi-W@Kill***]Action status=DONE
  53. 2016-05-24 10:37:37,683 INFO ActionStartXCommand:520 - SERVER[***] USER[oozie] GROUP[-] TOKEN[] APP[Trend_Analysi_Scoop_Script] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@Kill] [***0000001-160524103133053-oozie-oozi-W@Kill***]Action updated in DB!
  54. 2016-05-24 10:37:37,930 INFO WorkflowNotificationXCommand:520 - SERVER[***] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@Kill] No Notification URL is defined. Therefore nothing to notify for job 0000001-160524103133053-oozie-oozi-W@Kill
  55. 2016-05-24 10:37:37,931 INFO WorkflowNotificationXCommand:520 - SERVER[***] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[] No Notification URL is defined. Therefore nothing to notify for job 0000001-160524103133053-oozie-oozi-W
  56. 2016-05-24 10:37:37,931 INFO WorkflowNotificationXCommand:520 - SERVER[***] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000001-160524103133053-oozie-oozi-W] ACTION[0000001-160524103133053-oozie-oozi-W@sqoop-c68d] No Notification URL is defined. Therefore nothing to notify for job 0000001-160524103133053-oozie-oozi- W@sqoop-c68d
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!