I will check memory usage next time it freezes but I am pretty sure it's OK. What do you mean by db log?
Also, am I missing something or rocket should close the connections if request is taking longer than 10 seconds (default timeout)? So if I put time.sleep(20) in my controller it should times out? That's not what's happening - the controller waits all those 20 seconds and returns without any errors. Am I misunderstanding the timeout option? On Jul 1, 1:28 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > Can you check memory usage when it freezes? Is there anything in the > db log about too many connections? > > On 30 Giu, 16:06, Candid <roman.bat...@gmail.com> wrote: > > > > > I am using web2py in my organization for internal applications. One of > > the applications uses dedicated instance of web2py (v1.78.1) running > > on dedicated ubuntu server. It connects to our SQL Server 2005 > > database via freetds. It runs with the following parameters: > > > python web2py.py -i ... -p ... -a ... -n 100 -q 100 > > > The application uses connection pool with 50 connections. > > > Recently it has started freezing occasionally. The weird thing is that > > the whole web2py server freezes and basically stops responding, so not > > only you cannot access the app, you cannot even open the admin > > console. Sometimes it starts working again after a few minutes, > > sometimes I have to restart web2py. > > I suspect it has something to with either web server threads not > > getting released or databases connections not getting returned to the > > pool (the latter would not explain why I cannot access admin console > > though). > > > Has anyone had similar issues? Any suggestions on how to troubleshoot > > the problem? Any input would be highly appreciated.
