Uploaded image for project: 'JBoss Enterprise SOA Platform'
  1. JBoss Enterprise SOA Platform
  2. SOA-2102

JbpmPersistenceException in RetryExecutor with high number of due jobs

    Details

      Description

      With a high number of due jobs, the RetryExcecutor is failing to query the database for the first due job:

      DEBUG [org.jboss.soa.esb.services.jbpm.integration.msg.RetryExecutor] Unexpected error rescheduling jobs, extending idle period
      org.jbpm.persistence.JbpmPersistenceException: could not get first due job owned by 'RetryExecutor' ignoring jobs [490518
      6, 4673400, ---a looong list--, 4895759]
      at org.jbpm.db.JobSession.getFirstDueJob(JobSession.java:101)
      at org.jbpm.db.JobSession.getFirstDueJob(JobSession.java:98)
      ... 2 more
      Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000

      Although it does not affect the function of the RetryExecutor, an additional check should be added so that the query triggered by the RetryExecutor is not affected by such a backlog.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  kconner Kevin Conner
                  Reporter:
                  mputz Martin Weiler
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: