Hi Simon,
Thanks for the update! This is interesting. One question, are you making
use of cache.py? I had huge memory problems a while ago and I didn't have
time to debug. A colleague was testing on windows and each time it crapped
out his system where he was forced to do a hard reboot (but seemed to work
fine on Linux). I ended up pulling it out until such time as I could
upgrade to a later web2py release (I believe Massimo had made a fix in a
later release than I was using that addressed the memory leak issue (but I
can't remember any more details on this, so I may be out of my tree :) ).
Anyways, I was just wondering if you were using an older web2py version ?
Thanks,
Mart :)
On Monday, January 7, 2013 8:01:01 PM UTC-8, Simon Ashley wrote:
>
> Thanks Mart,
>
> That gives me some clues and a renewed focus. Issue may be with postgres
> (at least the install I had - has been deleted and will be installed). Will
> also try ubuntu environment. Will report back ...
>
> ... confirmed the memory leak with postgres (eventually absorbs all
> available memory) under win7. The same csv file imports fine under SQLite
> and mySQL. Connection strings are:
>
> db = DAL('sqlite://storage.sqlite', lazy_tables=True,
> migrate=True,fake_migrate
> =False, check_reserved=['all','mysql', 'postgres', 'postgres_nonreserved'
> ])
> db = DAL('postgres://postgres:xx@localhost:5433/yyy', lazy_tables=True
> , migrate=True, fake_migrate=False, check_reserved=['all','mysql',
> 'postgres', 'postgres_nonreserved'])
> db = DAL('mysql://root:xx@localhost:3306/zzz', lazy_tables=True,migrate
> =True, fake_migrate=False, check_reserved=['all','mysql', 'postgres',
> 'postgres_nonreserved'])
>
>
--
