Bug 779760 (SOA-2122) - JbpmPersistenceException in RetryExecutor with high number of due jobs
Summary: JbpmPersistenceException in RetryExecutor with high number of due jobs
Keywords:
Status: NEW
Alias: SOA-2122
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: JBPM - within SOA
Version: 4.3 CP04 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: FUTURE
Assignee: Nobody
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-06-12 07:32 UTC by Martin Weiler
Modified: 2022-01-05 05:22 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
jBPM configured with JMS/JCA-Inflow based scheduler and message services
Last Closed:
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 779740 0 high CLOSED JbpmPersistenceException in RetryExecutor with high number of due jobs 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-2122 0 Major Closed JbpmPersistenceException in RetryExecutor with high number of due jobs 2012-12-06 16:45:52 UTC

Internal Links: 779740

Description Martin Weiler 2010-06-12 07:32:18 UTC 
Help Desk Ticket Reference: https://enterprise.redhat.com/issue-tracker/917023
project_key: SOA

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.
Comment 1 Kevin Conner 2010-06-12 07:33:29 UTC 
Link: Added: This issue is related to SOA-2102
Comment 2 Kevin Conner 2010-06-12 07:39:35 UTC 
Link: Added: This issue depends JBESB-3348
Comment 3 Rick Wagner 2011-12-05 20:54:06 UTC 
Rick reviewing old JIRAs.  jBPM bug, old version so maybe fixed today.  But not sure, so left Open.
Note You need to log in before you can comment on or make changes to this bug.