On Sun, 28 May 2006 14:03:58 -0400, Michael Bayer <[EMAIL PROTECTED]> wrote:
I have committed a new version of TLEngine which handles transaction context in the same way as that of SQLEngine in version 0.1, and added new unit tests that test the threadlocal and nesting behavior of this engine. the "commit()/rollback()" methods directly off the engine were not working before. now its working much better. recall that TLEngine is a subclass of ComposedSQLEngine and is only activated when you use the "strategy='threadlocal'" argument with create_engine().

I am almost definitely going to put out another release tonight, but it would be great if one or both of you could give changeset 1537 a try, with create_engine('foo', strategy='threadlocal') and see if you get better results...would be great to get it totally right before the release.

This doesn't seem to have changed anything unfortunately.

When I run my unittests and look at ps aux output I see:
postgres 7901 0.0 1.0 38312 5428 ?? S 8:28PM 0:00.33 postgres: dialtone stiq ::1(65086) DROP TABLE waiting postgres 7902 0.0 0.8 38328 4252 ?? S 8:28PM 0:00.06 postgres: dialtone stiq ::1(65087) idle in transaction postgres 7903 0.0 0.8 38328 3948 ?? S 8:28PM 0:00.04 postgres: dialtone stiq ::1(65088) idle
As before plain strategy doesn't work again.

I then tried moving back to avoid passing QueuePool manually and plain strategy 
started working again.

The new way of specifiying the dabatase parameters that uses an url is worse 
than the previous one IMHO since it doesn't allow me to avoid specifying an 
host and a port and I have to rely on passing my own QueuePool() which causes 
the other problems though.

Any solution?


-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to