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

    XMLWordPrintable

    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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              kconner@redhat.com Kevin Conner
              Reporter:
              rhn-support-mputz Martin Weiler
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: