Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Issue with Oozie start up ....CDH 5.4

Issue with Oozie start up ....CDH 5.4

Explorer

While starting up in oozie I see the following . What is the cause of this error.? Using CDH 5.4 

 

amazonaws.com] Running bundle status service first instance
2016-05-10 10:40:53,694 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] Released lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:40:53,727 ERROR org.apache.oozie.command.PurgeXCommand: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Exception,
<openjpa-2.2.2-r422266:1468616 fatal general error> org.apache.openjpa.persistence.PersistenceException: The column index is out of range: 3, number of columns: 2.
FailedObject: select w.id, w.parentId from WorkflowJobBean w where w.endTimestamp < :endTime and w.parentId like '%C@%' [java.lang.String]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4962)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4922)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2111)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:286)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302)
at org.apache.oozie.service.JPAService.executeGetList(JPAService.java:482)
at org.apache.oozie.executor.jpa.WorkflowJobQueryExecutor.getList(WorkflowJobQueryExecutor.java:356)
at org.apache.oozie.executor.jpa.WorkflowJobQueryExecutor.getList(WorkflowJobQueryExecutor.java:38)
at org.apache.oozie.command.PurgeXCommand.loadState(PurgeXCommand.java:110)
at org.apache.oozie.command.XCommand.call(XCommand.java:280)
at org.apache.oozie.service.CallableQueueService$CallableWrapper.run(CallableQueueService.java:175)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: The column index is out of range: 3, number of columns: 2.
at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:53)
at org.postgresql.core.v3.SimpleParameterList.setLiteralParameter(SimpleParameterList.java:114)
at org.postgresql.jdbc2.AbstractJdbc2Statement.bindLiteral(AbstractJdbc2Statement.java:2172)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setLong(AbstractJdbc2Statement.java:1227)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:123)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:123)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:299)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.setLong(LoggingConnectionDecorator.java:1370)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:299)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:299)
at org.apache.openjpa.jdbc.sql.DBDictionary.setLong(DBDictionary.java:1155)
at org.apache.openjpa.jdbc.sql.DBDictionary.setUnknown(DBDictionary.java:1454)
at org.apache.openjpa.jdbc.sql.DBDictionary.setUnknown(DBDictionary.java:1426)
at org.apache.openjpa.jdbc.sql.SQLBuffer.setParameters(SQLBuffer.java:575)
at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:484)
at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:460)
at org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:479)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:420)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:382)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2070)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34)
... 16 more
2016-05-10 10:40:53,744 WARN org.apache.oozie.service.CallableQueueService$CallableWrapper: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] exception callable [purge], E0607: Other error in operation [purge], The column index is out of range: 3, number of columns: 2.
org.apache.oozie.command.CommandException: E0607: Other error in operation [purge], The column index is out of range: 3, number of columns: 2.
at org.apache.oozie.command.XCommand.call(XCommand.java:326)
at org.apache.oozie.service.CallableQueueService$CallableWrapper.run(CallableQueueService.java:175)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: <openjpa-2.2.2-r422266:1468616 fatal general error> org.apache.openjpa.persistence.PersistenceException: The column index is out of range: 3, number of columns: 2.
FailedObject: select w.id, w.parentId from WorkflowJobBean w where w.endTimestamp < :endTime and w.parentId like '%C@%' [java.lang.String]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4962)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4922)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2111)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:286)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302)
at org.apache.oozie.service.JPAService.executeGetList(JPAService.java:482)
at org.apache.oozie.executor.jpa.WorkflowJobQueryExecutor.getList(WorkflowJobQueryExecutor.java:356)
at org.apache.oozie.executor.jpa.WorkflowJobQueryExecutor.getList(WorkflowJobQueryExecutor.java:38)
at org.apache.oozie.command.PurgeXCommand.loadState(PurgeXCommand.java:110)
at org.apache.oozie.command.XCommand.call(XCommand.java:280)
... 4 more
Caused by: org.postgresql.util.PSQLException: The column index is out of range: 3, number of columns: 2.
at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:53)
at org.postgresql.core.v3.SimpleParameterList.setLiteralParameter(SimpleParameterList.java:114)
at org.postgresql.jdbc2.AbstractJdbc2Statement.bindLiteral(AbstractJdbc2Statement.java:2172)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setLong(AbstractJdbc2Statement.java:1227)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:123)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:123)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:299)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.setLong(LoggingConnectionDecorator.java:1370)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:299)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:299)
at org.apache.openjpa.jdbc.sql.DBDictionary.setLong(DBDictionary.java:1155)
at org.apache.openjpa.jdbc.sql.DBDictionary.setUnknown(DBDictionary.java:1454)
at org.apache.openjpa.jdbc.sql.DBDictionary.setUnknown(DBDictionary.java:1426)
at org.apache.openjpa.jdbc.sql.SQLBuffer.setParameters(SQLBuffer.java:575)
at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:484)
at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:460)
at org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:479)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:420)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:382)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2070)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34)
... 16 more
2016-05-10 10:40:53,826 INFO org.apache.oozie.service.CoordMaterializeTriggerService$CoordMaterializeTriggerRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] CoordMaterializeTriggerService - Curr Date= 2016-05-10T10:45Z, Num jobs to materialize = 0
2016-05-10 10:40:53,896 INFO org.apache.oozie.service.CoordMaterializeTriggerService$CoordMaterializeTriggerRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.CoordMaterializeTriggerService]
2016-05-10 10:40:53,988 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] Released lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:41:53,700 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Acquired lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:41:53,701 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running coordinator status service from last instance time = 2016-05-10T10:40Z
2016-05-10 10:41:53,736 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running bundle status service from last instance time = 2016-05-10T10:40Z
2016-05-10 10:41:53,762 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:41:53,994 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] Acquired lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:41:54,009 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] Released lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:42:53,762 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] Acquired lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:42:53,763 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] Running coordinator status service from last instance time = 2016-05-10T10:41Z
2016-05-10 10:42:53,767 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] Running bundle status service from last instance time = 2016-05-10T10:41Z
2016-05-10 10:42:53,769 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] Released lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:42:54,009 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Acquired lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:42:54,020 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:43:53,770 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Acquired lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:43:53,771 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running coordinator status service from last instance time = 2016-05-10T10:42Z
2016-05-10 10:43:53,776 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running bundle status service from last instance time = 2016-05-10T10:42Z
2016-05-10 10:43:53,778 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:43:54,020 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Acquired lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:43:54,032 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:44:53,779 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Acquired lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:44:53,779 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running coordinator status service from last instance time = 2016-05-10T10:43Z
2016-05-10 10:44:53,785 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running bundle status service from last instance time = 2016-05-10T10:43Z
2016-05-10 10:44:53,787 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:44:54,032 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] Acquired lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:44:54,043 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] Released lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:45:53,788 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Acquired lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:45:53,788 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running coordinator status service from last instance time = 2016-05-10T10:44Z
2016-05-10 10:45:53,793 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running bundle status service from last instance time = 2016-05-10T10:44Z
2016-05-10 10:45:53,795 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:45:53,913 INFO org.apache.oozie.service.CoordMaterializeTriggerService$CoordMaterializeTriggerRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] CoordMaterializeTriggerService - Curr Date= 2016-05-10T10:50Z, Num jobs to materialize = 0
2016-05-10 10:45:53,914 INFO org.apache.oozie.service.CoordMaterializeTriggerService$CoordMaterializeTriggerRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.CoordMaterializeTriggerService]
2016-05-10 10:45:54,043 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Acquired lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:45:54,053 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:46:53,796 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Acquired lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:46:53,796 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running coordinator status service from last instance time = 2016-05-10T10:45Z
2016-05-10 10:46:53,801 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running bundle status service from last instance time = 2016-05-10T10:45Z
2016-05-10 10:46:53,803 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:46:54,054 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Acquired lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:46:54,064 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:47:53,804 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Acquired lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:47:53,804 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running coordinator status service from last instance time = 2016-05-10T10:46Z
2016-05-10 10:47:53,809 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Running bundle status service from last instance time = 2016-05-10T10:46Z
2016-05-10 10:47:53,811 INFO org.apache.oozie.service.StatusTransitService$StatusTransitRunnable: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.StatusTransitService]
2016-05-10 10:47:54,065 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Acquired lock for [org.apache.oozie.service.PauseTransitService]
2016-05-10 10:47:54,075 INFO org.apache.oozie.service.PauseTransitService: SERVER[ec2-52-11-109-139.us-west-2.compute.amazonaws.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Released lock for [org.apache.oozie.service.PauseTransitService]

5 REPLIES 5

Re: Issue with Oozie start up ....CDH 5.4

Explorer

Hi 

 

I have the same issue . Can you tell how you were able to solve this issue?

 

Thanks,

Renuka

Re: Issue with Oozie start up ....CDH 5.4

Cloudera Employee

Can you let us know the database version you're using?

Re: Issue with Oozie start up ....CDH 5.4

Explorer
we are using the embedded postgresql of cloudera 5.12

Re: Issue with Oozie start up ....CDH 5.4

Cloudera Employee

With some newer Postgres versions we've been hitting https://issues.apache.org/jira/browse/OPENJPA-2482 We'll update the openJPA version in 5.13, to fix this.

 

Until that, you may downgrade the postgres version or replace teh opnejpa jars manually in Oozie's folder.

Re: Issue with Oozie start up ....CDH 5.4

New Contributor

After replacing openjpa jars with the 2.4.2 ones (openjpa-jdbc-2.4.2.jar, openjpa-kernel-2.4.2.jar, openjpa-lib-2.4.2.jar, openjpa-persistence-2.4.2.jar, openjpa-persistence-jdbc-2.4.2.jar) in /opt/cloudera/parcels/CDH-5.12.1-1.cdh5.12.1.p0.3/lib/oozie/libtools and /opt/cloudera/parcels/CDH-5.12.1-1.cdh5.12.1.p0.3/lib/oozie/libserver, I am still getting the same error. Is there a particular version of openjpa that is recommended?