[
https://issues.apache.org/jira/browse/QPID-8297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16814391#comment-16814391
]
ASF subversion and git services commented on QPID-8297:
-------------------------------------------------------
Commit 9eb98551eb923430405e409b239cc52563b32f99 in qpid-broker-j's branch
refs/heads/master from overmeulen
[ https://gitbox.apache.org/repos/asf?p=qpid-broker-j.git;h=9eb9855 ]
QPID-8297: [Broker-J][Oracle Message Store] QPID_MESSAGE_CONTENT reserved space
keeps growing
This closes #24
> [Broker-J][Oracle Message Store] QPID_MESSAGE_CONTENT reserved space keeps
> growing until it reaches the limit and crashes
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: QPID-8297
> URL: https://issues.apache.org/jira/browse/QPID-8297
> Project: Qpid
> Issue Type: Bug
> Components: Broker-J
> Affects Versions: qpid-java-broker-7.1.0
> Reporter: Olivier VERMEULEN
> Priority: Critical
>
> Under a continuous high load, the Oracle message store crashes because the
> reserved space for the table QPID_MESSAGE_CONTENT keeps on growing (even if
> the table itself is empty since we consume as fast as we produce).
> This only happens for "big" messages (over 4KB) and comes from the way Oracle
> handles the LOB types (content column is declared as a BLOB). For LOB values
> over 4KB Oracle reserves some space in the table to handle the value but, by
> default, it won't actually release it (even if the value is removed) before a
> few hours.
> So when we have a high load of big messages that lasts a few hours we end up
> reaching the max size of the tablespace and the database crashes...
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
