Pylons, SQLAlchemy, too many connections problem.
Bruno Desthuilliers
bruno.42.desthuilliers at wtf.websiteburo.oops.com
Fri Aug 31 08:10:35 EDT 2007
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.
More information about the Python-list
mailing list