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

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: 19/Jan/16 04:45 AM
Component/s: Engine
Affects Version/s: 2.1.1
Fix Version/s: 2.5 Beta 2, 2.1.4

Environment: Delphi 6 FIBPlus
Issue Links:

QA Status: No test

 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.



 All   Comments   Change History   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.