These numbers are 100x larger than they should be. For me the memory is between 27MB and 90MB. Do you keep then entire DB in Ram? Are you caching some large objects in Ram? Or perhaps you are selecting lots of records and store them in session? Something is very wrong.
On Monday, 15 October 2012 17:46:20 UTC-5, Bill Thayer wrote: > > Generally I pay attention to the physical memory in the task manager. I > generally use about 3.5 to 4.5 GB but if I leave the rocket server on for a > very long time it will grow to 5.5 GB and give me problems. If I forget and > leave it on all night I will have to hard boot my PC. > > The basic behavior is that I will be working for a while then a page will > take too long to load. I will stop the browser from loading the page and > shut down the server. it turns white and fails to respond. > > I just happened to be debugging my other isuue with a basic application > and the problem got much worse with session.connect enabled. I shouldn't > have any cron jobs running since I am using this mornings release of 2.1.1 > and you said cron was disabled by default. > > I do have logging enabled but I'm not getting an extraordinary amount of > logged messages. > > Regards, > Bill > > On Monday, October 15, 2012 3:55:05 PM UTC-5, Massimo Di Pierro wrote: >> >> It would help if we could isolate the problem. How are you measuring it? >> make sure you are not running cron jobs in background (with <2.1 cron was >> always enabled) moreover web2py's memory usage may grows for the first 100 >> requests than some stuff is garbage collected and it stabilizes. >> >> massimo >> >> On Monday, 15 October 2012 15:39:30 UTC-5, Bill Thayer wrote: >>> >>> That's all I have right now. Haven't tried it with SQLLite. >>> >>> >>> >>> On Monday, October 15, 2012 3:35:25 PM UTC-5, Massimo Di Pierro wrote: >>>> >>>> I this only work Oracle? >>>> >>>> On Monday, 15 October 2012 14:56:44 UTC-5, Bill Thayer wrote: >>>>> >>>>> >>>>> Perhaps someone can check session.connect with Oracle for a rocket >>>>> server memory leak? >>>>> To reproduce on windows 7 using web2py 2.1.1 from source: >>>>> 1) Create a new simple application called simpleapp where simpleapp is >>>>> the name of an application with an Oracle table for storing sessions >>>>> 2) Create a new 0.py model file & >>>>> set:settings.database_uri='oracle:username/password@server:1521/servicename' >>>>> 3) in db.py: >>>>> line 14: >>>>> >>>>> db = DAL(settings.database_uri, check_reserved=['oracle']) >>>>> >>>>> >>>>> line 15: & 16: >>>>> ## store sessions and tickets there >>>>> session.connect(request, response, db=db, migrate= >>>>> 'db.web2py_session_simpleapp') >>>>> >>>>> >>>>> >>>>> line 29: >>>>> >>>>> auth.define_tables(username=True, signature=False, migrate=False) >>>>> >>>>> Takes about an hour or less for rocket server to run out of memory so >>>>> that it will just just spin and not respond to the stop server button >>>>> click. >>>>> >>>>> >>>>> --
