You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@qpid.apache.org by "Olivier VERMEULEN (JIRA)" <ji...@apache.org> on 2019/04/04 13:15:00 UTC

[jira] [Created] (QPID-8294) [Broker-J][Oracle Message Store] Batch delete fails for more than 1000 messages

Olivier VERMEULEN created QPID-8294:
---------------------------------------

             Summary: [Broker-J][Oracle Message Store] Batch delete fails for more than 1000 messages
                 Key: QPID-8294
                 URL: https://issues.apache.org/jira/browse/QPID-8294
             Project: Qpid
          Issue Type: Bug
          Components: Broker-J
    Affects Versions: qpid-java-broker-7.1.0
            Reporter: Olivier VERMEULEN


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



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@qpid.apache.org
For additional commands, e-mail: dev-help@qpid.apache.org