I am trying to get the list of database using below command.
sqoop list-databases --connect jdbc:mysql://ip-172-31-13-154:3306 --username sqoopuser --password {my password}
for the job, I have added mysql jar as well in the ‘files’ option.
– /user/oozie/share/lib/sqoop/sqoop-1.4.6.2.3.2.0-2950.jar
I am getting oozie connection failed.
Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]
few more logs below:
2018-04-13 09:59:51,565 INFO ActionStartXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@:start:] Start action [0000526-180328070440458-oozie-oozi-W@:start:] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2018-04-13 09:59:51,567 INFO ActionStartXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@:start:] [***0000526-180328070440458-oozie-oozi-W@:start:***]Action status=DONE
2018-04-13 09:59:51,567 INFO ActionStartXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@:start:] [***0000526-180328070440458-oozie-oozi-W@:start:***]Action updated in DB!
2018-04-13 09:59:51,596 INFO WorkflowNotificationXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@:start:] No Notification URL is defined. Therefore nothing to notify for job 0000526-180328070440458-oozie-oozi-W@:start:
2018-04-13 09:59:51,597 INFO WorkflowNotificationXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[] No Notification URL is defined. Therefore nothing to notify for job 0000526-180328070440458-oozie-oozi-W
2018-04-13 09:59:51,604 INFO ActionStartXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] Start action [0000526-180328070440458-oozie-oozi-W@testing_sqoop] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2018-04-13 09:59:52,939 INFO SqoopActionExecutor:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] Trying to get job [job_1517296050843_12912], attempt [1]
2018-04-13 09:59:52,953 INFO SqoopActionExecutor:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] checking action, hadoop job ID [job_1517296050843_12912] status [RUNNING]
2018-04-13 09:59:52,954 INFO ActionStartXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] [0000526-180328070440458-oozie-oozi-W@testing_sqoop]Action status=RUNNING
2018-04-13 09:59:52,954 INFO ActionStartXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] [0000526-180328070440458-oozie-oozi-W@testing_sqoop]Action updated in DB!
2018-04-13 09:59:52,958 INFO WorkflowNotificationXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] No Notification URL is defined. Therefore nothing to notify for job 0000526-180328070440458-oozie-oozi-W@testing_sqoop
2018-04-13 10:00:06,986 INFO CallbackServlet:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] callback for action [0000526-180328070440458-oozie-oozi-W@testing_sqoop]
2018-04-13 10:00:07,067 INFO SqoopActionExecutor:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] Trying to get job [job_1517296050843_12912], attempt [1]
2018-04-13 10:00:07,131 INFO SqoopActionExecutor:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] action completed, external ID [job_1517296050843_12912]
2018-04-13 10:00:07,133 WARN SqoopActionExecutor:523 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]
2018-04-13 10:00:07,164 INFO ActionEndXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] ERROR is considered as FAILED for SLA
2018-04-13 10:00:07,184 INFO ActionStartXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@kill] Start action [0000526-180328070440458-oozie-oozi-W@kill] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2018-04-13 10:00:07,186 INFO ActionStartXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@kill] [0000526-180328070440458-oozie-oozi-W@kill]Action status=DONE
2018-04-13 10:00:07,186 INFO ActionStartXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[haridatta19929616] GROUP[-] TOKEN[] APP[testing_sqoop] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@kill] [0000526-180328070440458-oozie-oozi-W@kill]Action updated in DB!
2018-04-13 10:00:07,226 INFO WorkflowNotificationXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@kill] No Notification URL is defined. Therefore nothing to notify for job 0000526-180328070440458-oozie-oozi-W@kill
2018-04-13 10:00:07,226 INFO WorkflowNotificationXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[] No Notification URL is defined. Therefore nothing to notify for job 0000526-180328070440458-oozie-oozi-W
2018-04-13 10:00:07,226 INFO WorkflowNotificationXCommand:520 - SERVER[ip-172-31-13-154.ec2.internal] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000526-180328070440458-oozie-oozi-W] ACTION[0000526-180328070440458-oozie-oozi-W@testing_sqoop] No Notification URL is defined. Therefore nothing to notify for job 0000526-180328070440458-oozie-oozi-W@testing_sqoop
