Uploaded image for project: 'Qpid'
  1. Qpid
  2. QPID-8294

[Broker-J][JDBC Message Store][Oracle] Batch delete fails for more than 1000 messages

    XMLWordPrintableJSON

    Details

      Description

      When under high load, the Broker-J can end up having to delete more than 1000 messages in a single batch. But some databases (and Oracle in particular) put a limit to the number of elements you can have in the IN clause. So we end up with the following exception: ORA-01795: maximum number of expressions in a list is 1000

        Attachments

          Activity

            People

            • Assignee:
              orudyy Alex Rudyy
              Reporter:
              overmeulen Olivier VERMEULEN
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: