Thing is, when I check any processes with open connections, the database
connection is idle.
Even if I stop the server, the connection process is still there until I
kill the process manually. Not sure where it's hanging.
I'm using other databases on the same machine with PostgreSQL which have no
problems. It's just this specific one.
May be just a deeper issue than Web2Py.
On Wednesday, May 20, 2015 at 2:16:25 AM UTC-5, Niphlod wrote:
>
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
