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

[firebird-automations]

Submitted by: Alfonso Presa (foncci)

Is related to CORE1658

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

[firebird-automations]

Commented by: @dyemanov

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.

[firebird-automations]

Modified by: @dyemanov

Link: This issue is related to CORE1658 [ CORE1658 ]

[firebird-automations]

Commented by: @dyemanov

And I forgot to say that it's improved in v2.5.

[firebird-automations]

Modified by: Sean Leyne (seanleyne)

Component: Engine [ 10000 ]

[firebird-automations]

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1.4 [ 10361 ]

Fix Version: 2.5 Beta 2 [ 10300 ]

[firebird-automations]

Modified by: @dyemanov

security: Developers [ 10012 ] =>

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test