Hi,
I noticed a possible memory leak while moving our application to
production server.
Problem is simplified below as much as possible:
#--- db.py ---
db = DAL('mysql://root:root@localhost/memory_test', pool_size=0)
db.define_table('test_table',
SQLField('description'))
#--- end of file ---
#--- mem_test.py ---
while (True):
record = db.test_table[1]
#---- end of file ---
I inserted one record to test_table.
Background process is started:
python2.6 web2py.py -S Memory_test -M -N -R applications/Memory_test/
private/mem_test.py
Now if one monitors memory usage of the script is seems to steadily
consume more and more memory.
Guppy showed the same thing.
For test purposes I tried gc.collect() inside the while loop but it
did not help.
Also added db.commit() inside the loop just in case if that might do
the trick.
Am i completely missing something obvious or is this an actual bug?
Ubuntu 8.04
Web2py: Version 1.95.1 (2011-04-25 15:04:14)
Python2.6
- Kimmo
