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