[Zope-dev] Memory Leak Problem

[Andre Schubert]

Andre Schubert schrieb:

If have changed the that it skips the ZSQLMethod and sends the query
used in the ZSQLMethod direct
to the manage_test function from the ZPsycopgDA with the result that
zope grows up
after running the script.
If it is possible that the mem-leak is somewhere in the DA, then i post
this message to the psycopg mailinglist.

Thanks

> 
> Hi all,
> 
> I have isolated the memory leak problem on a naked 2.3.3 Zope.
> I have on ZPsycopgDA and two SQL Methods, one SQL Method contains
> DTML-IFs and DTML-ELSEs and REQUEST.sets
> the other SQL Method contains the rendered query of the first, this
> means there is pure sql in it.
> Both methods cache there results 60 secs.
> Zope runs with 4 threads.
> 
> I wrote a test-script wich opens 4 threads and each thread call the
> second SQL Methods "manage_test" via wget.
> 
> After a restart my zope-processes are around 12MB.
> Then i start my script and before i receive any result all processes are
> grown up to 26MB.
> 
> Even if after i start my script nothing happens, but before i receive
> the result the processes grow up,
> maybe i think this is the time where zope gets the results from the
> database and
> "puts" it into the Results-Class( i am right at this point ?).
> 
> But is the problem in the ZSQLMethod( where the results were cached ) or
> the ZPsycopgDA ??
> 
> Regards,
> 
> --
> Andre Schubert            EMail:   Andre.Schubert@km3.de
>                           Tel:     03774 6625-78
> km3 teledienst GmbH       Fax:     03774 6625-79
> 
> _______________________________________________
> Zope-Dev maillist  -  Zope-Dev@zope.org
> http://lists.zope.org/mailman/listinfo/zope-dev
> **  No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope )