I can reproduce this problem on both Linux and Windows (have no access to a
Mac), and Massimo cannot reproduce this on his Mac. Perhaps something is
borked about all my python installations (some site-packages I use or
something). Can you help test? Just go into the web2py directory, and start
python with the following script (or just start python and paste the script
into the python console)
#!/usr/bin/python
#encoding: utf-8
# get a web2py database environment
import sys
sys.path.append('../../')
from gluon.dal import DAL
while 1:
mydal = DAL('sqlite:memory')
sys.stdout.write('.')
sys.stdout.flush()
mydal._adapter.close()
For me: memory usage grows at about 20MB/sec, measured with htop on linux
and TaskManager on windows. If I wait enough time, all the memory is eaten
up. If you drop the last line (mydal._adapter.close()) the memory will be
eaten much more quickly for me.
Thanks.
Issue reference: 731 <http://code.google.com/p/web2py/issues/detail?id=731>:
Standalone DAL is leaking memory+resources (don't know whether or not
inside web2py)