okay, okay, psycopg2 is slightly less buggy than pg8000 but "attempted to
connect...." is not something driver related. Your instance is completely
going offline for a long period of time.
On Wednesday, May 20, 2015 at 8:04:10 AM UTC+2, Auden RovelleQuartz wrote:
>
> have you tried using the psycopg2 driver?
>
>
>
> On Wednesday, May 20, 2015 at 12:38:51 AM UTC-5, Bilal Hasan wrote:
>>
>> 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.
