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

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • qpid-java-broker-7.1.0
    • qpid-java-broker-7.1.3
    • Broker-J
    • None

    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

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

            Dates

              Created:
              Updated:
              Resolved: