Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

HDP 2.5 : Oozie issue

avatar
New Member

I have installed HDP 2.5 components using Ambari. All the services started and working fine without any issue except Oozie.

Got the below error,

ERROR XBM0A: The database directory '/data/hadoop/oozie/data/oozie-db' exists. However, it does not contain the expected 'service.properties' file. Perhaps Derby was brought down in the middle of creating this database. You may want to delete this directory and try creating the database again. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.services.monitor.StorageFactoryService.vetService(Unknown Source) at org.apache.derby.impl.services.monitor.StorageFactoryService.access$900(Unknown Source) at org.apache.derby.impl.services.monitor.StorageFactoryService$10.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at org.apache.derby.jdbc.Driver20.connect(Unknown Source) at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:953) at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:959) at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:189) at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:128) at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:79)

1 ACCEPTED SOLUTION

avatar
Super Collaborator

Backup the directory "/data/hadoop/oozie/data/oozie-db" to another directory and then remove it using the command:

rm -rf /data/hadoop/oozie/data/oozie-db

Then restart oozie from Ambari and try again

View solution in original post

3 REPLIES 3

avatar
Master Mentor

@Uvaraj Seerangan

By any chance did you try deleting the directory '/data/hadoop/oozie/data/oozie-db' and then tried starting it again?

Better to try moving '/data/hadoop/oozie/data/oozie-db' to some other directory and then try starting it,

avatar
Super Collaborator

Backup the directory "/data/hadoop/oozie/data/oozie-db" to another directory and then remove it using the command:

rm -rf /data/hadoop/oozie/data/oozie-db

Then restart oozie from Ambari and try again

avatar
Master Guru

@Uvaraj Seerangan - Please check answers given below and accept an appropriate answer once your issue is resolved.