[
https://issues.apache.org/jira/browse/SOLR-3573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13402393#comment-13402393
]
Bjorn Hijmans commented on SOLR-3573:
-------------------------------------
Some more information, for me this started to happen after we started storing
XMLTYPE data as binary instead of CLOB. I managed to fix it by casting the
java.sql.Clob to a oracle.sql.CLOB so I could use freeTemporary() to free the
clob. Not an acceptable solution to commit though. Not sure if this is a solr
problem, a JDBC problem or an oracle problem.
> Data import does not free CLOB
> ------------------------------
>
> Key: SOLR-3573
> URL: https://issues.apache.org/jira/browse/SOLR-3573
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler
> Environment: Java HotSpot(TM) Client VM (build 21.0-b17, mixed mode,
> sharing), oracle 11.2.0.3.0, Solr-trunk
> Reporter: Bjorn Hijmans
> Attachments: oracle_clob_freetemporary.diff
>
>
> When selecting a CLOB in the deltaImportQuery, the CLOB will not be freed
> which will cause the Oracle process to use up all memory on the Oracle server.
> I'm not very good at java, but I think changes need to be made in
> FieldReaderDataSource.java. In the getData method, the characterStream from
> the Clob needs to be copied to a new stream, so the clob can be freed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
