I'm having a very annoying issue where the connection to a PostgreSQL
database hangs and I get a "Attempted to connect to this database 5 times
unsuccessfully" which renders the whole web application un-usable.
I'm using PostgreSQL 9.3. Web2Py Version
2.8.2-stable+timestamp.2013.11.28.13.54.07
Below is the only code I use for this database. I'm not sure why it's
happening.
jobid = sprint.joblist.insert(**mydict)
sprint.commit()
result = sprint(sprint.joblist.id==jobid).select()
db.py:
sprint =
DAL('postgres://***********:*******@138.85.**.**:5432/nds_smart_sprint',pool_size=30)
Updated pg8000 driver to latest version still no luck.
I have to manually terminate the idle connection using "ps aux | grep
postgres"
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
