[#DERBY-3571] LOB locators are not released if the LOB columns are not accessed by the client

Derby

LOB locators are not released if the LOB columns are not accessed by the client

Created: 26/Mar/08 04:02 PM Updated: 04/May/09 06:22 PM

Return to search

Component/s:

JDBC, Network Client

Affects Version/s:

10.3.2.1, 10.4.1.3, 10.5.1.1

Fix Version/s:

10.3.3.0, 10.4.1.3, 10.5.1.1

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
derby-3571-1a-client_track_lob_fix.diff	2008-03-26 04:26 PM	Kristian Waagan	16 kB
derby-3571-1a-client_track_lob_fix.stat	2008-03-26 04:26 PM	Kristian Waagan	0.5 kB
derby-3571-1b-client_track_lob_fix.diff	2008-03-27 04:16 PM	Kristian Waagan	19 kB
derby-3571-1c-client_track_lob_fix.diff	2008-03-28 10:08 AM	Kristian Waagan	19 kB
derby-3571-1d-client_track_lob_fix.diff	2008-03-31 11:03 AM	Kristian Waagan	22 kB
derby-3571-1e-client_track_lob_fix.diff	2008-03-31 12:42 PM	Kristian Waagan	22 kB
derby-3571-2a-simple_release.diff	2008-04-01 08:21 PM	Kristian Waagan	34 kB
derby-3571-2a-simple_release.stat	2008-04-01 08:21 PM	Kristian Waagan	0.6 kB

Issue Links:

Reference

This issue relates to:

~~DERBY-2892~~ Closing a resultset after retrieving a large > 32665 bytes value with Network Server does not release locks

~~DERBY-3575~~ Optimize client side LOB release mechanism by reducing the number of round-trips

~~DERBY-3601~~ Optimize LOBStateTracker for non-locator servers

Resolution Date:

07/Apr/08 10:12 AM

Description

« Hide

If the client creates a result set containing LOB locator columns and iterates through it without actually accessing the LOB columns, the locators are not released.
The amount of locators and their associated LOB objects causes the server to consume large amounts of memory and it eventually gets an OOME.

There are a few workarounds for this bug:
a) Access and/or properly close the LOBs (i.e. Blob.free).
This is partly dependent on ~~DERBY-2892~~.
b) Invoke Connection.commit (or rollback) periodically, which causes all locators on the connection to be released.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Kristian Waagan made changes - 26/Mar/08 04:03 PM

Field	Original Value	New Value
Status	Open [ 1 ]	In Progress [ 3 ]

Kristian Waagan made changes - 26/Mar/08 04:03 PM

Link

This issue relates to ~~DERBY-2892~~ [ ~~DERBY-2892~~ ]

Kristian Waagan made changes - 26/Mar/08 04:26 PM

Attachment		derby-3571-1a-client_track_lob_fix.diff [ 12378638 ]
Attachment		derby-3571-1a-client_track_lob_fix.stat [ 12378639 ]

Kristian Waagan made changes - 26/Mar/08 04:26 PM

Derby Info

[Patch Available]

Kristian Waagan made changes - 26/Mar/08 09:33 PM

Derby Info

[Patch Available]

Kristian Waagan made changes - 27/Mar/08 04:16 PM

Attachment

derby-3571-1b-client_track_lob_fix.diff [ 12378731 ]

Kristian Waagan made changes - 27/Mar/08 04:17 PM

Affects Version/s		10.4.0.0 [ 12312540 ]
Derby Info		[Patch Available]
Affects Version/s	10.4.1.0 [ 12313072 ]

Kristian Waagan made changes - 28/Mar/08 10:03 AM

Link

This issue relates to ~~DERBY-3575~~ [ ~~DERBY-3575~~ ]

Kristian Waagan made changes - 28/Mar/08 10:08 AM

Attachment

derby-3571-1c-client_track_lob_fix.diff [ 12378780 ]

Kristian Waagan made changes - 31/Mar/08 11:03 AM

Attachment

derby-3571-1d-client_track_lob_fix.diff [ 12378945 ]

Kristian Waagan made changes - 31/Mar/08 12:42 PM

Attachment

derby-3571-1e-client_track_lob_fix.diff [ 12378958 ]

Kristian Waagan made changes - 01/Apr/08 08:21 PM

Attachment		derby-3571-2a-simple_release.stat [ 12379063 ]
Attachment		derby-3571-2a-simple_release.diff [ 12379062 ]

Kristian Waagan made changes - 02/Apr/08 09:44 AM

Derby Info	[Patch Available]
Fix Version/s		10.5.0.0 [ 12313010 ]

Kristian Waagan made changes - 07/Apr/08 10:12 AM

Resolution		Fixed [ 1 ]
Fix Version/s		10.4.1.2 [ 12313095 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Kristian Waagan made changes - 07/Apr/08 10:39 AM

Link

This issue relates to ~~DERBY-3601~~ [ ~~DERBY-3601~~ ]

Kathey Marsden made changes - 25/Apr/08 03:45 PM

Fix Version/s

10.3.2.2 [ 12312885 ]

Kristian Waagan made changes - 25/Apr/08 04:21 PM

Status

Resolved [ 5 ]

Closed [ 6 ]

Myrna van Lunteren made changes - 04/May/09 06:22 PM

Fix Version/s	10.5.0.0 [ 12313010 ]
Fix Version/s		10.5.1.1 [ 12313771 ]
Affects Version/s	10.5.0.0 [ 12313010 ]
Affects Version/s		10.5.1.1 [ 12313771 ]