[ 
https://issues.apache.org/jira/browse/DERBY-4050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12671850#action_12671850
 ] 

Kathey Marsden commented on DERBY-4050:
---------------------------------------

Thanks Kristian for reviewing the patch.  Just to clarify, the new debug 
statements won't cause a sane build with derby.debug.true=DaemonTrace set to 
fail.  It will just cause additional debug statements to print to the 
derby.log.  After this issue is closed I'll file another issue to investigate 
and fix space reclamation for the other two cases where we give up after 3 
tries.




> Multithreaded clob update causes growth in table that does not get reclaimed
> ----------------------------------------------------------------------------
>
>                 Key: DERBY-4050
>                 URL: https://issues.apache.org/jira/browse/DERBY-4050
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.2.2.0, 10.3.3.0, 10.4.2.0, 10.5.0.0
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>         Attachments: ClobGrowth.java, derby-4050_diff.txt, 
> derby-4050_more_debug.diff, derby.log.growth, derby.log.nogrowth
>
>
> Doing a multithreaded update of a Clob table causes table growth that does 
> not get reclaimed except by compressing the table.  The reproduction has a 
> table with two threads. One  thread  updates row 1 repeatedly with 33,000 
> character clob. The other thread updates row 2 with a small clob, "hello".  
> The problem occurs back to 10.2 but seems much worse on trunk than 10.2.   
> The trunk database grew to 273MB on trunk after 10000 updates of each row. 
> The 10.2 database grew only to 25MB.  If the update is synchronized there is 
> no growth.
> I will attach the repro.

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

Reply via email to