Pylons, SQLAlchemy, too many connections problem.

[bruno.42.desthuilliers at wtf.websiteburo.oops.com (Bruno Desthuilliers)]

Adam Kubica a ?crit :
> Hello.
> 
> I have pylons 0.96 (SVN) and current SQLAlchemy (0.3.10), and I have bug
> that
> doesn't exist earlier.
> 
> My connection code:
> <code>
> import sqlalchemy.mods.threadlocal
> from sqlalchemy import DynamicMetaData, objectstore
> 
> metadata = DynamicMetaData( case_sensitive = False )
> 
> def db_connect( dsn ):
>     engine = create_engine( dsn, echo=False, echo_pool=False,
> encoding='latin2',  convert_unicode=True )
>     metadata.connect( engine )
> </code>
> 
> command "netstat -an|grep 5432|grep ESTABLISHED|wc -l" displays one
> more connection after each refresh of page until I have exceptions
> such as:
> 
> sqlalchemy.exceptions.DBAPIError: (Connection failed)
> (OperationalError) FATAL: sorry, too many clients already
> 
> What is wrong?
> 
I don't know for sure, but I guess you'd get better answers posting 
either on the Pylons or SQLAlchemy's google groups.