[
https://issues.apache.org/jira/browse/OOZIE-3272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16525807#comment-16525807
]
Prabhu Joseph commented on OOZIE-3272:
--------------------------------------
This issue is due to Older OpenJPA Version and got fixed with OOZIE-2488
> Purging fails if oozie.service.PurgeService.purge.old.coord.action enabled
> --------------------------------------------------------------------------
>
> Key: OOZIE-3272
> URL: https://issues.apache.org/jira/browse/OOZIE-3272
> Project: Oozie
> Issue Type: Bug
> Components: coordinator
> Affects Versions: 4.3.0
> Reporter: Prabhu Joseph
> Assignee: Prabhu Joseph
> Priority: Major
>
> Oozie PurgeService fails if oozie.service.PurgeService.purge.old.coord.action
> enabled as it queries below with endTime as per the days configured in
> oozie.service.PurgeService.older.than without converting to timestamp.
> {code}
> select w.id, w.parentId from WorkflowJobBean w where w.endTimestamp <
> :endTime and w.parentId like '%C@%'"),
> {code}
> Exception:
> {code}
> 2018-05-22 15:59:51,100 ERROR PurgeXCommand:517 -
> SERVER[bigdata2.openstacklocal] 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:496)
> at
> org.apache.oozie.executor.jpa.WorkflowJobQueryExecutor.getList(WorkflowJobQueryExecutor.java:377)
>
> at
> org.apache.oozie.executor.jpa.WorkflowJobQueryExecutor.getList(WorkflowJobQueryExecutor.java:39)
>
> at org.apache.oozie.command.PurgeXCommand.loadState(PurgeXCommand.java:110)
> at org.apache.oozie.command.XCommand.call(XCommand.java:281)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> org.apache.oozie.service.CallableQueueService$CallableWrapper.run(CallableQueueService.java:178)
>
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>
> 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)
> ... 17 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
