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: 31
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: 31
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.

New Contributor
Posts: 3
Registered: ‎11-23-2016

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

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?

Announcements