Pylons, SQLAlchemy, too many connections problem.

[Adam Kubica]

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='latin 2', convert_unicode =True )
metadata.connec t( 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.exce ptions.DBAPIErr or: (Connection failed)
(OperationalErr or) FATAL: sorry, too many clients already

What is wrong?

[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='latin 2', convert_unicode =True )
metadata.connec t( 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.exce ptions.DBAPIErr or: (Connection failed)
(OperationalErr or) 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.

[Adam Kubica]

On Fri, 31 Aug 2007 14:03:48 +0200, Adam Kubica wrote:

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='latin 2', convert_unicode =True )
metadata.connec t( 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.exce ptions.DBAPIErr or: (Connection failed)
(OperationalErr or) FATAL: sorry, too many clients already

What is wrong?

Don't use DynamicMetaData (), use MetaData(), it's the problem.