Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-10010

Mechanism for housekeeping means RecordsPerTransaction is limited to 1000 on Oracle, unnecessarily

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 7.65.0.Final
    • Runtime Engine
    • None
    • False
    • False
    • NEW
    • NEW

    Description

      The mechanism used in org.jbpm.process.audit.JPAAuditLogService#doPartialDelete to batch the delete statements runs into `ORA-01795: maximum number of expressions in a list is 1000` when RecordsPerTransaction is > ~1000.

      This can be improved using a subquery with the delete, instead of passing the list of IDs as a parameter

      Attachments

        Issue Links

          relates to

          Feature Request - Feature requests from customers and/or users JBPM-9579 Adding a pagination parameter to LogCleanupCommand

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              kverlaen@redhat.com Kris Verlaenen
              luke.armitage@sky.uk Lake Armitage (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: