Issue Details (XML | Word | Printable)

Key: CORE-2301
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Alfonso Presa
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Use Select list(xxx, ';') from table into :xxx cause a memory leak

Created: 30/Jan/09 02:50 PM   Updated: 12/Nov/09 02:15 PM
Component/s: Engine
Affects Version/s: 2.1.1
Fix Version/s: 2.5 Beta 2, 2.1.4

Time Tracking:
Not Specified

Environment: Delphi 6 FIBPlus
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
This line:
select list(barcode) from PRODUCTOS_BARCODES where id_prod=:ID_PROD into :BARCODE;

makes FBServer process grows up to 2000 mgb if it is used in an stored proc but I have not seen the same problem when used in a view for example.

I have read many issues regarding with it but no one talking about stored procs.

Regards,

Al


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 30/Jan/09 03:03 PM
Does your table contain ~500K rows?

This is a known issue and I don't think it's related to a stored procedure. The LIST function returns a blob. Every temporary blob occupies a <page size> bytes of memory. When called multiple times, this memory consumption increases. The memory is freed upon transaction commit or rollback.

Dmitry Yemanov added a comment - 30/Jan/09 03:04 PM
And I forgot to say that it's improved in v2.5.