On Fri, Nov 23, 2018 at 5:02 AM <siddhesh@erpdata.cloud> 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:
> print(ex.__str__())
I don't know, because this is not a standard parameter for DBAPIs.
you'd have to tell me what Python database API you're using. Also
confirm this is the TCP connection timeout, e.g. how long it takes for
the client library to establish a TCP socket to the database server
before aborting.
>
>
> 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.
--
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.
