[Zope] MemoryError: out of memory

[Tres Seaver]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/27/2011 11:12 AM, Tres Seaver wrote:

> The "aliases" feature of the stock Shared.DC.ZRDB.Results.Results class
> has a leak, due to an uncollectable cycle created between the alias
> objects and the record class generated *for each query*.  If your app
> makes heavy use of stock ZSQL methods, you are probably going to have to
> plan to monitor the server's RAM usage and reboot as it gets close to
> the limit.
> 
> If you are confident either that your application does not need the
> alias feature (your SQL queries all spell the column names using the
> "canonical" spelling for your SQL server), or that you can modify them
> to do so, you might try applying the attached patch, which removes the
> aliase feature.

I should note that I never use the stock results class (or SQL methods)
any longer:  instead, I use the 'sqladapters' product we wrote when we
first discovered the leak:


http://agendaless.com/Members/tseaver/software/sqladapters/sqladapters-1.0/


Tres.
- -- 
===================================================================
Tres Seaver          +1 540-429-0999          tseaver at palladion.com
Palladion Software   "Excellence by Design"    http://palladion.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk1BmyoACgkQ+gerLs4ltQ7JpQCgw76+ltS33nnUoDJQepGAWW2c
hkMAoNn0PsLtLY1Fp91NxZjbvnv6kbCW
=DWNc
-----END PGP SIGNATURE-----