Reply
Explorer
Posts: 10
Registered: ‎04-11-2016

Issue with Oozie start up ....CDH 5.4

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]

Contributor
Posts: 28
Registered: ‎07-11-2017

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

Hi 

 

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

 

Thanks,

Renuka

Cloudera Employee
Posts: 22
Registered: ‎06-17-2016

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

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

Contributor
Posts: 28
Registered: ‎07-11-2017

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

we are using the embedded postgresql of cloudera 5.12
Highlighted
Cloudera Employee
Posts: 22
Registered: ‎06-17-2016

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

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.

Announcements