分享

oozie报错问题求解

allenswf 发表于 2015-4-23 09:34:45 [显示全部楼层] 回帖奖励 阅读模式 关闭右栏 5 25690
各位大神,我用oozie处理一个job,用sqoop 将mysql 数据库迁移至hive 但是报错 表示很费解 求各位大神帮忙解决一下。
2015-04-23 07:58:48,645  INFO ActionStartXCommand:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@:start:] Start action [0000019-150410184835815-oozie-oozi-W@:start:] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2015-04-23 07:58:48,645  INFO ActionStartXCommand:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@:start:] [***0000019-150410184835815-oozie-oozi-W@:start:***]Action status=DONE
2015-04-23 07:58:48,645  INFO ActionStartXCommand:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@:start:] [***0000019-150410184835815-oozie-oozi-W@:start:***]Action updated in DB!
2015-04-23 07:58:48,690  INFO ActionStartXCommand:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@drawback] Start action [0000019-150410184835815-oozie-oozi-W@drawback] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2015-04-23 07:59:09,403  INFO SqoopActionExecutor:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@drawback] checking action, hadoop job ID [job_1428662450290_0057] status [RUNNING]
2015-04-23 07:59:09,404  INFO ActionStartXCommand:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@drawback] [***0000019-150410184835815-oozie-oozi-W@drawback***]Action status=RUNNING
2015-04-23 07:59:09,404  INFO ActionStartXCommand:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@drawback] [***0000019-150410184835815-oozie-oozi-W@drawback***]Action updated in DB!
2015-04-23 08:00:43,526  INFO CallbackServlet:541 - USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@drawback] callback for action [0000019-150410184835815-oozie-oozi-W@drawback]
2015-04-23 08:01:03,712  INFO SqoopActionExecutor:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@drawback] action completed, external ID [job_1428662450290_0057]
2015-04-23 08:01:03,722  WARN SqoopActionExecutor:544 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@drawback] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]
2015-04-23 08:01:03,765  INFO ActionEndXCommand:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@drawback] ERROR is considered as FAILED for SLA
2015-04-23 08:01:03,786  INFO ActionStartXCommand:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@kill] Start action [0000019-150410184835815-oozie-oozi-W@kill] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2015-04-23 08:01:03,786  INFO ActionStartXCommand:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@kill] [***0000019-150410184835815-oozie-oozi-W@kill***]Action status=DONE
2015-04-23 08:01:03,786  INFO ActionStartXCommand:541 - USER[hdfs] GROUP[-] TOKEN[] APP[drawback] JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@kill] [***0000019-150410184835815-oozie-oozi-W@kill***]Action updated in DB!

已有(5)人评论

跳转到指定楼层
arsenduan 发表于 2015-4-23 10:26:54
具体怎么操作的,楼主贴出sqoop的命令或则如何使用的
回复

使用道具 举报

allenswf 发表于 2015-4-24 08:09:17
ok sqoop import --connect "jdbc:mysql://localhost:3306/db" --username "root" --delete-target-dir --table "activity_supportactivity" --hive-import --hive-database "lianbidb"
回复

使用道具 举报

hapjin 发表于 2015-10-10 14:11:29
你贴出的日志,是哪个文件报的?即文件名是什么啊??
回复

使用道具 举报

Sempre 发表于 2015-11-11 18:18:38
本帖最后由 Sempre 于 2015-11-11 18:29 编辑
hapjin 发表于 2015-10-10 14:11
你贴出的日志,是哪个文件报的?即文件名是什么啊??

报错的日志(Main class [org.apache.oozie.action.hadoop.ShellMain], exit code [1])是在hue页面上
那个长长的日志是:yarn-yarn-nodemanager-hadoop.log

----------------------------------
不好意思我回错帖了,以为是我自己的帖子。。。。貌似删除不了。。。。
回复

使用道具 举报

hapjin 发表于 2016-3-28 15:04:21
JOB[0000019-150410184835815-oozie-oozi-W] ACTION[0000019-150410184835815-oozie-oozi-W@drawback] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]

要么配置不对,要么job本身写错了吧。
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关闭

推荐上一条 /2 下一条