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.
