Hi all, This is Yixiao. I ran into some database problems after restarting my Oozie server:
/usr/lib/oozie/bin/oozie job -run -config job.properties -oozie myOozieServer:11000/oozie/ Error: E0803 : E0803: IO error, E0603: SQL error in operation, <openjpa-2.2.2-r422266:1468616 fatal store error> org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. FailedObject: org.apache.oozie.WorkflowJobBean@42f66abc This is my status of the Oozie server: SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/lib/oozie/lib/slf4j-log4j12-1.6.6.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/lib/oozie/lib/slf4j-simple-1.6.6.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] log4j:WARN No appenders could be found for logger (org.apache.hadoop.security.authentication.client.KerberosAuthenticator). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. System mode: NORMAL If I shut it down and restart it again using: $ /usr/lib/oozie/bin/ooziedb.sh create -sqlfile oozie.sql -run it gives me this error: Validate DB Connection Error: Could not connect to the database: java.sql.SQLException: Failed to start database '/grid/0/hadoop/oozie/data/oozie-db' with class loader sun.misc.Launcher$AppClassLoader@3182f0db, see the next exception for details. Stack trace for the error was (for debug purposes): -------------------------------------- java.lang.Exception: Could not connect to the database: java.sql.SQLException: Failed to start database '/grid/0/hadoop/oozie/data/oozie-db' with class loader sun.misc.Launcher$AppClassLoader@3182f0db, see the next exception for details. at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:682) at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:172) at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:116) at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:67) Caused by: java.sql.SQLException: Failed to start database '/grid/0/hadoop/oozie/data/oozie-db' with class loader sun.misc.Launcher$AppClassLoader@3182f0db, 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) at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection30.<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.AutoloadedDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:672) at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:678) ... 3 more Caused by: java.sql.SQLException: Failed to start database '/grid/0/hadoop/oozie/data/oozie-db' with class loader sun.misc.Launcher$AppClassLoader@3182f0db, see the next exception for details. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 17 more Caused by: java.sql.SQLException: Another instance of Derby may have already booted the database Any help would be appreciated! Yixiao Lin
