I'm getting the following error from my running connection.close():
> 'SQLite objects created in a thread can only be used in that same
> thread.The object was created in thread id 1098918240 and this is
> thread id 47075765124944' in <bound method ConnectionFairy.__del__ of
> <sqlalchemy.pool.ConnectionFairy object at 0x2aaaaabd6f10>>
The error shows up about 1/4 of the time, equally often whether I'm
using strategy='threadlocal' or not.
It looks like SA is spawning a thread somewhere as I am going to great
lengths to keep everything running in a single worker thread. What can I
do to avoid this error? The code in question is at
http://foss.eepatents.com/sAsync/browser/trunk/sasync/database.py, line 311.
SqlAlchemy never spawns new threads.
(It's trivial to check for yourself: find sqlalchemy -name "*.py" |xargs egrep '\bThread\('.)
--
Jonathan Ellis
http://spyced.blogspot.com
_______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
