Yixiao created AMBARI-6616:
------------------------------
Summary: Fail to restart oozie server due to DB schema already
exists
Key: AMBARI-6616
URL: https://issues.apache.org/jira/browse/AMBARI-6616
Project: Ambari
Issue Type: Bug
Components: client, controller
Affects Versions: 1.6.0
Environment: RHEL6
Reporter: Yixiao
When restarting oozie server, error occur when executing :
cd /var/tmp/oozie && /usr/lib/oozie/bin/ooziedb.sh create -sqlfile oozie.sql
-run
Error message:
Validate DB Connection
DONE
Check DB schema does not exist
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:708)
at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:173)
at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:116)
at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:67)
Fix: delete the previous oozie-db
Con: will lose your previous data, and might create memory leak.
$ rm -rf /grid/0/hadoop/oozie/data/oozie-db/
$ rm /var/lib/oozie/oozie-server/webapps/oozie.war
--
This message was sent by Atlassian JIRA
(v6.2#6252)
