On Monday, April 9, 2012 12:03:29 PM UTC-7, Michael Bayer wrote:
>
> close your connections after you are finished with them.
>

So I suppose my confusion is where is the "connection" being made. I have a 
singleton engine instance running around, and when I query, I basically do 
something like this:

query = select([fields])
result = engine.execute(query).fetchall()

Therefore I'm using implicit connections. The reference to the ResultProxy 
is quickly gone, which I thought would implicitly close the connection as 
well.

What exactly am I supposed to do here?

Mitchell
 

>
>
> On Apr 9, 2012, at 2:43 PM, Mitchell Hashimoto wrote:
>
> Hi,
>
> I am continually getting this sort of error after some amount of time: 
> QueuePool 
> limit of size 30 overflow 10 reached, connection timed out, timeout 30
>
> We're using only the SQLAlchemy Core expressions API, so we're not 
> wrapping anything in sessions, so I'm not sure how this is happening.
>
> Any pointers?
>
> Thanks,
> Mitchell
>
> -- 
> You received this message because you are subscribed to the Google Groups 
> "sqlalchemy" group.
> To view this discussion on the web visit 
> https://groups.google.com/d/msg/sqlalchemy/-/QlU8RHFQOwQJ.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> To unsubscribe from this group, send email to 
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/sqlalchemy?hl=en.
>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/sqlalchemy/-/IQNlf2z7RscJ.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to