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+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. -- 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.
