You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kristian Waagan (JIRA)" <ji...@apache.org> on 2009/03/30 15:40:50 UTC

[jira] Created: (DERBY-4130) Using large stream with 'values cast(? as clob)' causes OutOfMemoryError

Using large stream with 'values cast(? as clob)'  causes OutOfMemoryError
-------------------------------------------------------------------------

                 Key: DERBY-4130
                 URL: https://issues.apache.org/jira/browse/DERBY-4130
             Project: Derby
          Issue Type: Bug
          Components: Store
    Affects Versions: 10.6.0.0
            Reporter: Kristian Waagan


Inserting a stream though a values clause and casting the value to a Clob causes the stream to be materialized in memory.
If the stream is sufficiently large, this will result in an OutOfMemoryError.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4130) Using large stream with 'values cast(? as clob)' causes OutOfMemoryError

Posted by "Kristian Waagan (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kristian Waagan updated DERBY-4130:
-----------------------------------

    Attachment: ClobInValuesClauseOOME.java

Attached a repro for the issue. Remember to run Java with a heap of less than 64 MB. 
Also include the Derby test jar/classes in the classpath when compiling.

> Using large stream with 'values cast(? as clob)'  causes OutOfMemoryError
> -------------------------------------------------------------------------
>
>                 Key: DERBY-4130
>                 URL: https://issues.apache.org/jira/browse/DERBY-4130
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.6.0.0
>            Reporter: Kristian Waagan
>         Attachments: ClobInValuesClauseOOME.java
>
>
> Inserting a stream though a values clause and casting the value to a Clob causes the stream to be materialized in memory.
> If the stream is sufficiently large, this will result in an OutOfMemoryError.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4130) Using large stream with 'values cast(? as clob)' causes OutOfMemoryError

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-4130:
---------------------------------

               Urgency: Normal
    Bug behavior facts: [Crash]

Triaged July 2, 2009: Marked as Crash and assigned normal urgency.

> Using large stream with 'values cast(? as clob)'  causes OutOfMemoryError
> -------------------------------------------------------------------------
>
>                 Key: DERBY-4130
>                 URL: https://issues.apache.org/jira/browse/DERBY-4130
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.6.0.0
>            Reporter: Kristian Waagan
>         Attachments: ClobInValuesClauseOOME.java
>
>
> Inserting a stream though a values clause and casting the value to a Clob causes the stream to be materialized in memory.
> If the stream is sufficiently large, this will result in an OutOfMemoryError.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4130) Using large stream with 'values cast(? as clob)' causes OutOfMemoryError

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik updated DERBY-4130:
---------------------------------

    Issue & fix info: [Repro attached]

> Using large stream with 'values cast(? as clob)'  causes OutOfMemoryError
> -------------------------------------------------------------------------
>
>                 Key: DERBY-4130
>                 URL: https://issues.apache.org/jira/browse/DERBY-4130
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.6.0.0
>            Reporter: Kristian Waagan
>         Attachments: ClobInValuesClauseOOME.java
>
>
> Inserting a stream though a values clause and casting the value to a Clob causes the stream to be materialized in memory.
> If the stream is sufficiently large, this will result in an OutOfMemoryError.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.