[sqlalchemy] sqlalchemy.exceptions.TimeoutError with psycopg2

2007-08-29 Thread Jian Luo
Hi List: I am just doing a test of my pylons site under medium load. (ab2 -c 20 -n 5000 ...) and got following errors: 2007-08-29 17:32:34,468 INFO [paste.httpserver.ThreadPool] kill_hung_threads status: 10 threads (10 working, 0 idle, 0 starting) ave time 2.24sec, max time 7.22sec, killed 0

[sqlalchemy] Re: sqlalchemy.exceptions.TimeoutError with psycopg2

2007-08-29 Thread Jian Luo
Hi Jason, thanks for the reply. My pylons basecontroller takes care of the session clean up like this: class BaseController(WSGIController): def __call__(self, environ, start_response): try: return WSGIController.__call__(self, environ, start_response) finally:

[sqlalchemy] Re: sqlalchemy.exceptions.TimeoutError with psycopg2

2007-08-29 Thread Jian Luo
the remove is described in doc as close + extra cleanup Shouldn't the doc be updated to add that point, which will make the the life of newbies like me easier =D Or better: add the explicitly close in remove. Best Jian On Aug 30, 12:10 am, jason kirtland [EMAIL PROTECTED] wrote: Jian wrote:

[sqlalchemy] Re: How can I do join on a self-referential m2m relation?

2007-08-23 Thread Jian Luo
in r3410. i didnt yet add a test for more levels deep yet, though, so see how that goes. - mike On Aug 22, 2007, at 3:07 PM, Jian Luo wrote: class Widget(object): pass mapper(Widget, widget, properties={ 'children': relation(Widget, secondary=widget_rel, primaryjoin

[sqlalchemy] Re: How can I do join on a self-referential m2m relation?

2007-08-22 Thread Jian Luo
Hallo Mike, first of all, thank you for your great great sqlalchemy! On Aug 22, 6:49 pm, Michael Bayer [EMAIL PROTECTED] wrote: im not sure about how elixir does bi-directional relationships but it seems strange that you have set up the children and parents relationships twice in both