Hi folks, I'm not sure if this is the right place to ask really. I have
some functional tests, using webtest, in which I make an engine and make a
couple of session that get used in addition to the webtest app. I close the
sessions in the tearDown method after each test.
Now that the number of functional tests is over about 100, they have
started failing, but *only* when I run the whole mess together. Run file by
file, they are all fine.
The error I'm getting is pasted below. I'm running stock postgres on os x
(installed from the universal binary, no special tweaking).
I've tried changing pool_size to 20 and max_overflow to -1 but that doesn't
seem to make a difference.
Any clues would be lovely!
thanks
iain
traceback:
src/warp.test/warp/test/functional.py:70: in setUp
self.init_db()
src/warp.test/warp/test/functional.py:51: in init_db
cls.engine.execute("drop owned by alimetrix")
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1990: in execute
connection = self.contextual_connect(close_with_result=True)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:2039: in
contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:2078: in
_wrap_pool_connect
e, dialect, self)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1405: in
_handle_dbapi_exception_noconnection
exc_info
env/lib/python2.7/site-packages/sqlalchemy/util/compat.py:202: in
raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:2074: in
_wrap_pool_connect
return fn()
env/lib/python2.7/site-packages/sqlalchemy/pool.py:376: in connect
return _ConnectionFairy._checkout(self)
env/lib/python2.7/site-packages/sqlalchemy/pool.py:713: in _checkout
fairy = _ConnectionRecord.checkout(pool)
env/lib/python2.7/site-packages/sqlalchemy/pool.py:480: in checkout
rec = pool._do_get()
env/lib/python2.7/site-packages/sqlalchemy/pool.py:1060: in _do_get
self._dec_overflow()
env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:60: in
__exit__
compat.reraise(exc_type, exc_value, exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/pool.py:1057: in _do_get
return self._create_connection()
env/lib/python2.7/site-packages/sqlalchemy/pool.py:323: in
_create_connection
return _ConnectionRecord(self)
env/lib/python2.7/site-packages/sqlalchemy/pool.py:449: in __init__
self.connection = self.__connect()
env/lib/python2.7/site-packages/sqlalchemy/pool.py:607: in __connect
connection = self.__pool._invoke_creator(self)
env/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py:97: in
connect
return dialect.connect(*cargs, **cparams)
env/lib/python2.7/site-packages/sqlalchemy/engine/default.py:385: in connect
return self.dbapi.connect(*cargs, **cparams)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
dsn = 'dbname=alimetrix_test user=alimetrix password=alimetrix
host=localhost', database = 'alimetrix_test', user = 'alimetrix', password
= 'alimetrix', host = 'localhost', port = None
connection_factory = None, cursor_factory = None, async = False, kwargs =
{}, items = [('dbname', 'alimetrix_test'), ('user', 'alimetrix'),
('password', 'alimetrix'), ('host', 'localhost')]
k = 'host', v = 'localhost'
def connect(dsn=None,
database=None, user=None, password=None, host=None, port=None,
connection_factory=None, cursor_factory=None, async=False,
**kwargs):
"""
Create a new database connection.
The connection parameters can be specified either as a string:
conn = psycopg2.connect("dbname=test user=postgres
password=secret")
or using a set of keyword arguments:
conn = psycopg2.connect(database="test", user="postgres",
password="secret")
The basic connection parameters are:
- *dbname*: the database name (only in dsn string)
- *database*: the database name (only as keyword argument)
- *user*: user name used to authenticate
- *password*: password used to authenticate
- *host*: database host address (defaults to UNIX socket if not
provided)
- *port*: connection port number (defaults to 5432 if not provided)
Using the *connection_factory* parameter a different class or
connections
factory can be specified. It should be a callable object taking a
dsn
argument.
Using the *cursor_factory* parameter, a new default cursor factory
will be
used by cursor().
Using *async*=True an asynchronous connection will be created.
Any other keyword parameter will be passed to the underlying client
library: the list of supported parameters depends on the library
version.
"""
items = []
if database is not None:
items.append(('dbname', database))
if user is not None:
items.append(('user', user))
if password is not None:
items.append(('password', password))
if host is not None:
items.append(('host', host))
if port is not None:
items.append(('port', port))
items.extend([(k, v) for (k, v) in kwargs.iteritems() if v is not
None])
if dsn is not None and items:
raise TypeError(
"'%s' is an invalid keyword argument when the dsn is
specified"
% items[0][0])
if dsn is None:
if not items:
raise TypeError('missing dsn and no parameters')
else:
dsn = " ".join(["%s=%s" % (k, _param_escape(str(v)))
for (k, v) in items])
> conn = _connect(dsn, connection_factory=connection_factory,
async=async)
E OperationalError: (psycopg2.OperationalError) FATAL: remaining
connection slots are reserved for non-replication superuser connections
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
