Search the archives!
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Pylons, SQLAlchemy, too many connections problem.
- From: coyote_x at artcom.pl (Adam Kubica)
- Subject: Pylons, SQLAlchemy, too many connections problem.
- Date: Fri, 31 Aug 2007 14:03:48 +0200
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?
- Follow-Ups:
- Pylons, SQLAlchemy, too many connections problem.
- From: Bruno Desthuilliers
- Pylons, SQLAlchemy, too many connections problem.
- From: Adam Kubica
- Pylons, SQLAlchemy, too many connections problem.
- Prev by Date: python + gcov
- Next by Date: Pylons, SQLAlchemy, too many connections problem.
- Previous by thread: MySQLdb ImportError
- Next by thread: Pylons, SQLAlchemy, too many connections problem.
- Index(es):