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 9:46:32 PM UTC+5:30, sidd...@erpdata.cloud wrote: > > 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 connection timeout ? Where I can > specify connection timeout parameter. SqlAlchemy is new for me. > > def _dbconnect(self, connstr, ps=20, ds_timeout=3600): > # simple sql alchemy connection. > return create_engine(connstr, pool_size=ps, echo=False, > poolclass=QueuePool, pool_timeout=ds_timeout) > > Please help. > > > On Friday, November 16, 2018 at 8:18:37 PM UTC+5:30, Mike Bayer wrote: >> >> On Fri, Nov 16, 2018 at 8:20 AM <siddhesh@erpdata.cloud> 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 below >> > >> > def _dbconnect(self, connstr, ps=20, ds_timeout=3600): >> > # simple sql alchemy connection. >> > return create_engine(connstr, pool_size=ps, echo=False, >> > poolclass=QueuePool, pool_timeout=ds_timeout) >> >> timeout is how long the pool will spend waiting for a connection to be >> available if all the connections in the pool are in use. it seems >> unusual you'd want to set this to 3600 seconds, are you confusing >> "timeout" with pool_recycle ? >> >> >> >> >> > >> > >> > Please help. >> > >> > -- >> > SQLAlchemy - >> > The Python SQL Toolkit and Object Relational Mapper >> > >> > http://www.sqlalchemy.org/ >> > >> > To post example code, please provide an MCVE: Minimal, Complete, and >> Verifiable Example. See http://stackoverflow.com/help/mcve for a full >> description. >> > --- >> > You received this message because you are subscribed to the Google >> Groups "sqlalchemy" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> an email to sqlalchemy+...@googlegroups.com. >> > To post to this group, send email to sqlal...@googlegroups.com. >> > Visit this group at https://groups.google.com/group/sqlalchemy. >> > For more options, visit https://groups.google.com/d/optout. >> > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.