Re: [sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600
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:
> 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 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.
Re: [sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600
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 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.
Re: [sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600
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 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.
Re: [sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600
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 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.
[sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600
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) 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] Connection Timeout
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) or put the testconnection in a thread and kill it if there is no connection after x seconds. Or is there a nice way to solve this from withing SQLAlchemy? Ciao Koen --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
