Gloria W wrote: > > Hi all, > > We're hitting a weird bug here. I'm doing a standard query with > filters, and this is appended to the end: > > resultObj = resultObj.order_by(Member.lastname, > Member.firstname, > Member.middleinitial, > MemberProfile.member_id).limit(limit).offset(page * > limit) > > > where limit is usually 500 and page is usually 5 to 10. This query is > hitting a relatively big table. So we allow people to specify a page > and a limit, and we send back chunks of this query result. > > After several hits, 7 or 8 or so, I get this: > > TimeoutError: QueuePool limit of size 5 overflow 0 reached, connection > timed out, timeout 30 > > > Changing the pool to 20 causes it to happen later, but it still > happens. > > Doing a 'del' on the object just before exiting the method doesn't > change this outcome.
a single session uses just one connection. are you testing this with a web app and is it possible there are requests taking a very long time to load all records and complete ? --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
