I have setup web2py version 1.98.2 on Ubuntu Lucid Lynx. My dal is
connecting to SQL Server 2005 using a connection string like this.
db_connection_string = r'mssql://dbuser:pword92.168.1.1/mydb?
DRIVER=FreeTDS'
After my application has been running for some hours or days, there
seems to some kind of deadlock occurring upon connection to the dal:
db = DAL(config.db_connection_string, migrate=False)
Once this happens in one request it happens in all requests and all
non-static web2py requests time out. I am not seeing any errors in the
logs, apart from being told it has timed out:
[info] [client 192.168.1.231] Request header read timeout
There are at present 33 open connections to the SQL Server db
(including 4 from web2py). From my understanding the maximum number of
connections is 32767.
So I'm curious if anyone else has seen this kind of behaviour or if
there are any suggestions as to how this may be debugged.
