[
https://issues.apache.org/jira/browse/QPID-8297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alex Rudyy updated QPID-8297:
-----------------------------
Summary: [Broker-J][JDBC Message Store][Oracle] QPID_MESSAGE_CONTENT
reserved space keeps growing until it reaches the limit and crashes (was:
[Broker-J][Oracle Message Store] QPID_MESSAGE_CONTENT reserved space keeps
growing until it reaches the limit and crashes)
> [Broker-J][JDBC Message Store][Oracle] 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
> Assignee: Alex Rudyy
> Priority: Critical
> Fix For: qpid-java-broker-8.0.0, qpid-java-broker-7.1.3
>
>
> 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: dev-unsubscr...@qpid.apache.org
For additional commands, e-mail: dev-h...@qpid.apache.org
