hi,
i'm having trouble with mysql connections using SQLAlchemy 0.5.0beta3.
when there are >15 connections in scope, the call to grab a new
connection hangs. here is a sample script which hangs for mysql but
not for sqllite:
from sqlalchemy import create_engine
conn = []
# will pass for sqlite
engine = create_engine('sqlite:///tmp_db',strategy='threadlocal')
[conns.append(engine.connect()) for i in range(0,16,1)]
# will hang at sqlalchemy/pool.py line 598
engine = create_engine('mysql://user:[EMAIL PROTECTED]:3306/
tmp_db',strategy='threadlocal')
[conns.append(engine.connect()) for i in range(0,16,1)]
also, repeated calls to engine.connect() do not return the same
connection object in the example above. what else do i need to do in
order to force the engine to return the same connection object.
-andres
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
