Hi all, In a TG2 app, I have SQLAlchemy configured with a pool size of 30 (overflow 30), and the Paste HTTP server configured to run with 50 threads. There is a limit of a maximum 50 concurrent connections coming to the server.
However, I am regularly seeing SQLAlchemy TimeoutErrors with no connections available in the QueuePool. It seems that there should really only ever 50 DB connections (maybe plus a couple for irregularly scheduled TGScheduler jobs). Does anyone have suggestions on how to track down where the connections are being used, and what might be causing the pool to be depleted? I've tried looking at the debug log output from the connection pool: I can see the pool check-ins and -outs, but not which areas of code are causing these. Ideally, a snapshot of where connections are being used in the app server would really help... My next try would probably be to record thread IDs along with connection pool and request logging, but any improvements on that strategy would be greatly appreciated! James -- You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/turbogears?hl=en.
