Re: [sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600

2018-11-23 Thread Mike Bayer
On Fri, Nov 23, 2018 at 5:02 AM wrote: > > Is this correct approach for set connection timeout?This approach also not > working.Please help. > > try: > eng_obj = create_engine(conn_str, echo=False, > connect_args={'timeout': 60}).connect() > except Exception as ex: >

Re: [sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600

2018-11-23 Thread siddhesh
Is this correct approach for set connection timeout?This approach also not working.Please help. try: eng_obj = create_engine(conn_str, echo=False, connect_args={'timeout': 60}).connect() except Exception as ex: print(ex.__str__()) On Saturday, November 17, 2018 at

Re: [sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600

2018-11-17 Thread siddhesh
Oh.Ok. Thanks Mike. You mean to say pool_timeout is used for how long the pool will spend waiting for a connection to be available if all the connections in the pool are in use. Then which parameter should I use for connection timeout ? Could you please help me to modify below code for

Re: [sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600

2018-11-16 Thread Mike Bayer
On Fri, Nov 16, 2018 at 8:20 AM wrote: > > Hi, > My connection timeout happening after 30 seconds even if I set the > pool_timeout=3600. My create engine code is written below > I want set custom pool_timeout value. But its not working as per the > expectation. My create_engine code is written

[sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600

2018-11-16 Thread siddhesh
Hi, My connection timeout happening after 30 seconds even if I set the pool_timeout=3600. My create engine code is written below I want set custom pool_timeout value. But its not working as per the expectation. My create_engine code is written below def _dbconnect(self, connstr, ps=20,

[sqlalchemy] Connection Timeout

2007-09-05 Thread Koen Bok
My app saves bookmarks to different Postgres servers, and tries to connect at login. But if the server from the bookmark is not reachable or down, it only times out after like 2 minutes. So I could either check if the host is available before connecting (telnetlib connection to the Postgres port)