Oozie Forum

oozie with derby not able to access database

  • #55763
    Ranjan Sen
    Participant

    I have derby new database for oozie in HDP 2.1 upgraded from HDP 2.0 after upgrading Amabri 1.4 to 1.6. When I try to start Oozie I get log message in derby log as follows
    2014-06-13 01:18:14.680 GMT Thread[main,5,main] Cleanup action starting
    java.sql.SQLException: Failed to start database ‘/hadoop/oozie/data/oozie-db’ with class loader WebappClassLoader^M
    context: /oozie^M
    delegate: false^M
    repositories:^M
    /WEB-INF/classes/^M
    ———-> Parent Classloader:^M
    org.apache.catalina.loader.StandardClassLoader@71adff7c^M
    , see the next exception for details.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #55801
    Ranjan Sen
    Participant

    got the issue resolved by deleting the /hadoop/oozie/data//oozie-db directory from a previous oozie installation.

You must be to reply to this topic. | Create Account

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.