> On Wed, Sep 30, 2009 at 9:19 PM, Alan McDonald <alan@...>
> wrote:
> > Following on from a previous thread on memory use:
>
> I can reproduce the leak too:
>
> 0) create this procedure:
> CREATE PROCEDURE TESTMON
> as declare variable id bigint;
> begin
> for select mon$statement_id
> from mon$statements
> into :id do begin end
> end
>
> 1) Open an attachment, start a transaction and leave it be.
> 2) Open another attachment
> 3) check memory usage
> 4) Run the following a couple thousand times:
> start transaction;
> execute procedure testmon;
> commit;
> 5) check memory usage again. It's higher than before. If you go back
> to step 4 an repeat, it keeps on climbing.
>
> hth,
> --
> Douglas Tosi
> www.sinatica.com

ah - thanks for finding this. and showing it more defintively. It makes
monitoring impossible. There is not only a memory leak but that server AV
(see other post) occurs also when monitoring starts on an already heavily
loaded server. If you start monitoring before the load begins you just
suffer the memory loss.
Did you post this on tracker Douglas?
Alan