florian -

download the trunk and you will see your memory usage is steady as a rock.

- m

On May 2, 2006, at 7:04 AM, Florian Boesch wrote:

Hi,

Since more then one processes modifies my database I invoke objectstore.clear()
prior to fetching data I need to display.

I noticed that I have a huge objectleak all around (about 10k objects never get
collected at every request)

I wrote a testprogramm (atached) wich in a nutshell does
while 1:
  select
  objectstore.clear()
  gc.collect()
  print len(gc.get_objects())

The numbers rolling down my screen never stabilize or decrease until the
processes gets an out of memory exception.

However when I take the objectstore.clear() out, the number is constant (this is
not a solution for me, see first paragraph).

I also noticed that this doesn't happen on windows, only on linux.

I'm using:
cxOracle
Python 2.4
RedHat EL4
sqlalchemy 0.1.6

Cheers, Florian
<objectleak.py>



-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to