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/24 12:33:42 UTC
[jira] [Created] (SOLR-3573) Data import does not free CLOB
Bjorn Hijmans created SOLR-3573:
-----------------------------------
Summary: 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
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
[jira] [Updated] (SOLR-3573) Data import does not free CLOB
Posted by "Bjorn Hijmans (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SOLR-3573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bjorn Hijmans updated SOLR-3573:
--------------------------------
Attachment: oracle_clob_freetemporary.diff
> 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
[jira] [Commented] (SOLR-3573) Data import does not free CLOB
Posted by "Bjorn Hijmans (JIRA)" <ji...@apache.org>.
[ 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