[jira] [Closed] (ARTEMIS-2400) Oracle temporary LOBs not properly released

["Clebert Suconic (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ARTEMIS-2400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Clebert Suconic closed ARTEMIS-2400.
------------------------------------
    Resolution: Abandoned

we asked a question back in 2020... no answers.. closing it.

it did not seem an artemis issue... ORA errors are usually something your DBA should take care of... can't expand the segment.. that's a pure DB admin thing.


You should be careful of using JDBC Storage anyways.. the file journal is a lot more advanced for messaging systems.

> Oracle temporary LOBs not properly released
> -------------------------------------------
>
>                 Key: ARTEMIS-2400
>                 URL: https://issues.apache.org/jira/browse/ARTEMIS-2400
>             Project: ActiveMQ Artemis
>          Issue Type: Bug
>            Reporter: Aris Prassinos
>            Priority: Major
>
> When processing large messages (15MB) at high rates the following Oracle errors occur:
> {noformat}
> ORA-04030: out of process memory
> ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
> {noformat}
> The errors seem to be caused by Artemis not calling the {{Blob.free()}} method.
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)