[jira] [Created] (AMBARI-6616) Fail to restart oozie server due to DB schema already exists

["Yixiao (JIRA)" <ji...@apache.org>]

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)