what version of SQLAlchemy are you using ? one thing that has been improved not too long ago (and only within the 0.2 series) is that the connection pool has a timeout when grabbing a connection, if all allowed connections are hung open. the 0.1 series im pretty sure will just hang indefinitely. which means in 0.2 youll get an error page instead of an indefinite hang, but at least thats more of a clue.
another thing you may want to check for, depending on what DB youre using, is a deadlock condition. the 0.2 series also does an unconditional "rollback" on connections returned to the connection pool, which prevents a DB like postgres from keeping read locks open on tables that were accessed within a connection. also in moments of sheer multithreaded desperation, the threadframe module can be invaluable in illustrating where a hang is occurring, though it requires some instrumentation of your application: http://www.majid.info/mylos/stories/2004/06/10/threadframe.html mulicheng wrote: > Simon Belak wrote: > > A long shot, but is it possible that this particular process runs out of > > available threads (see prod.cfg: server.thread_pool)? > > > > I tried settings for the thread_pool between 50 and 150 and had the > same results. I also tweaked the socket_queue_size setting but havent > noticed any difference. From what I read, cherrypy is pretty good at > handling load and being stable so I gather something I've done is > probably the culprit. I'm using sqlAlchemy and a few 3rd party > libraries not shipped standard with TG or python so perhaps one of > those libraries is consuming resources or something. Hard to say but > I'll keep working on it. > > -Dennis --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
