You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Bjorn Hijmans (JIRA)" <ji...@apache.org> on 2012/06/27 19:45:42 UTC
[jira] [Commented] (SOLR-3573) Data import does not free CLOB
[ 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-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org