cdh oozie 报错：Failed to create Oozie database. Error: DB schema exists

最新推荐文章于 2023-04-17 10:20:41 发布

hezzzzzzz

最新推荐文章于 2023-04-17 10:20:41 发布

阅读量909

点赞数 1

分类专栏：大数据文章标签： oozie集成

本文链接：https://blog.youkuaiyun.com/hezzzzzzz/article/details/106330583

版权

大数据专栏收录该内容

5 篇文章

订阅专栏

stdout:
Mon May 25 20:01:33 CST 2020
Current working directory: /opt/cm-5.12.1/run/cloudera-scm-agent/process/60-oozie-OOZIE-SERVER-createdbtables
Launching one-off process: /opt/cm-5.12.1/lib64/cmf/service/oozie/oozie.sh db-command create
Mon May 25 20:01:33 CST 2020
JAVA_HOME=/opt/module/jdk1.8.0_144
using 5 as CDH_VERSION
CONF_DIR=/opt/cm-5.12.1/run/cloudera-scm-agent/process/60-oozie-OOZIE-SERVER-createdbtables
CMF_CONF_DIR=/opt/cm-5.12.1/etc/cloudera-scm-agent
Copying JDBC jar from /usr/share/java/mysql-connector-java.jar to /var/lib/oozie

Validate DB Connection
DONE
Check DB schema does not exist
Exit code: 1

stderr:

Error: DB schema exists

Stack trace for the error was (for debug purposes):
--------------------------------------
java.lang.Exception: DB schema exists
	at org.apache.oozie.tools.OozieDBCLI.validateDBSchema(OozieDBCLI.java:941)
	at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:186)
	at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:129)
	at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:80)
--------------------------------------

方法一：无效

rm -rf /var/lib/oozie/*

方法二：

删除mysql oozie的所有表格

mysql> show tables;
+------------------------+
| Tables_in_oozie        |
+------------------------+
| BUNDLE_ACTIONS         |
| BUNDLE_JOBS            |
| COORD_ACTIONS          |
| COORD_JOBS             |
| OOZIE_SYS              |
| OPENJPA_SEQUENCE_TABLE |
| SLA_EVENTS             |
| SLA_REGISTRATION       |
| SLA_SUMMARY            |
| VALIDATE_CONN          |
| WF_ACTIONS             |
| WF_JOBS                |
+------------------------+
12 rows in set (0.00 sec)

drop table BUNDLE_ACTIONS ;
drop table BUNDLE_JOBS  ;
drop table COORD_ACTIONS ;
drop table COORD_JOBS;
drop table OOZIE_SYS;
drop table OPENJPA_SEQUENCE_TABLE;
drop table SLA_EVENTS;
drop table SLA_REGISTRATION;
drop table SLA_SUMMARY;
drop table VALIDATE_CONN;
drop table WF_ACTIONS;
drop table WF_JOBS;

参考：https://my.oschina.net/bigdatas/blog/705295