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 <javascript:>.
> > To post to this group, send email to sqlal...@googlegroups.com
> <javascript:>.
> > 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.
