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/05 08:20:00 UTC
[jira] [Updated] (QPID-8294) [Broker-J][Oracle Message Store] Batch
delete fails for more than 1000 messages
[ https://issues.apache.org/jira/browse/QPID-8294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Olivier VERMEULEN updated QPID-8294:
------------------------------------
Priority: Critical (was: Major)
> [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
> Priority: Critical
>
> 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