Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

HDP 2.5 : Oozie issue

avatar
Contributor

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.