Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 779760 (SOA-2122)

Summary: JbpmPersistenceException in RetryExecutor with high number of due jobs
Product: [JBoss] JBoss Enterprise SOA Platform 4 Reporter: Martin Weiler <mweiler>
Component: JBPM - within SOAAssignee: Nobody <nobody>
Status: CLOSED UPSTREAM QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 4.3 CP04 GA   
Target Milestone: ---   
Target Release: FUTURE   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2122
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
jBPM configured with JMS/JCA-Inflow based scheduler and message services
Last Closed: 2025-02-10 03:14:43 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

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.
Comment 7 Red Hat Bugzilla 2025-02-10 03:14:43 UTC 
This product has been discontinued or is no longer tracked in Red Hat Bugzilla.