Uploaded image for project: 'Oozie'
  1. Oozie
  2. OOZIE-3272

Purging fails if oozie.service.PurgeService.purge.old.coord.action enabled

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 4.3.0
    • None
    • coordinator
    • None

    Description

      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.

      select w.id, w.parentId from WorkflowJobBean w where w.endTimestamp < :endTime and w.parentId like '%C@%'"),
      

      Exception:

      
      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 
      
      

      Attachments

        Activity

          People

            prabhujoseph Prabhu Joseph
            prabhujoseph Prabhu Joseph
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: