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.
