Here is Massimo's reply (sorry, I accidently hit "Reply to author" button last time):
> I am not familiar with SQLserver 2005 but probably it has a log file where to > store errors. If it running out of connections it > should say so there. > let me know. No, the db server itself is fine. We have many other systems relying on this server and they work fine. On Jul 1, 12:13 pm, Candid <roman.bat...@gmail.com> wrote: > 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.
