WebApp Error: <class 'psycopg2.OperationalError'>: FATAL: connection limit exceeded for non-superusers

[snapshot@debian.org]

URL: http://snapshot-dev.debian.org/file/7b4d5b2f24af4b5a299979134bc7f6d7b1eaf875

Module weberror.errormiddleware:162 in __call__

<<              __traceback_supplement__ = Supplement, self, environ
                   sr_checker = ResponseStartChecker(start_response)
                   app_iter = self.application(environ, sr_checker)
                   return self.make_catching_iter(app_iter, environ, sr_checker)
               except:

>>  app_iter = self.application(environ, sr_checker)

Module beaker.middleware:73 in __call__

<<                                                     self.cache_manager)
               environ[self.environ_key] = self.cache_manager
               return self.app(environ, start_response)

>>  return self.app(environ, start_response)

Module beaker.middleware:152 in __call__

<<                          headers.append(('Set-cookie', cookie))
                   return start_response(status, headers, exc_info)
               return self.wrap_app(environ, session_start_response)
          
           def _get_session(self):

>>  return self.wrap_app(environ, session_start_response)

Module routes.middleware:130 in __call__

<<                  environ['SCRIPT_NAME'] = environ['SCRIPT_NAME'][:-1]
              
               response = self.app(environ, start_response)
              
               # Wrapped in try as in rare cases the attribute will be gone already

>>  response = self.app(environ, start_response)

Module pylons.wsgiapp:125 in __call__

<<         
               controller = self.resolve(environ, start_response)
               response = self.dispatch(controller, environ, start_response)
              
               if 'paste.testing_variables' in environ and hasattr(response,

>>  response = self.dispatch(controller, environ, start_response)

Module pylons.wsgiapp:324 in dispatch

<<          if log_debug:
                   log.debug("Calling controller class with WSGI interface")
               return controller(environ, start_response)
          
           def load_test_env(self, environ):

>>  return controller(environ, start_response)

Module snapshot.lib.base:15 in __call__

<<          # the request is routed to. This routing information is
               # available in environ['pylons.routes_dict']
               return WSGIController.__call__(self, environ, start_response)

>>  return WSGIController.__call__(self, environ, start_response)

Module pylons.controllers.core:221 in __call__

<<                  return response(environ, self.start_response)
              
               response = self._dispatch_call()
               if not start_response_called:
                   self.start_response = start_response

>>  response = self._dispatch_call()

Module pylons.controllers.core:172 in _dispatch_call

<<              req.environ['pylons.action_method'] = func
                  
                   response = self._inspect_call(func)
               else:
                   if log_debug:

>>  response = self._inspect_call(func)

Module pylons.controllers.core:107 in _inspect_call

<<                        func.__name__, args)
               try:
                   result = self._perform_call(func, args)
               except HTTPException, httpe:
                   if log_debug:

>>  result = self._perform_call(func, args)

Module pylons.controllers.core:60 in _perform_call

<<          """Hide the traceback for everything above this method"""
               __traceback_hide__ = 'before_and_this'
               return func(**args)
          
           def _inspect_call(self, func):

>>  return func(**args)

Module snapshot.controllers.archive:246 in file

<<      def file(self, hash):
               if re.match('[0-9a-f]{40}$', hash): # match matches only at start of string
                   return self._regular_file(hash)
               else:
                   abort(404, 'Invalid hash format.')

>>  return self._regular_file(hash)

Module snapshot.controllers.archive:116 in _regular_file

<<      def _regular_file(self, digest, visiblepath=None):
               try:
                   realpath = g.shm.get_filepath(self._db(), digest)
                   fa = SnapshotFileApp(realpath, digest, visiblepath)
                   return fa(request.environ, self.start_response)

>>  realpath = g.shm.get_filepath(self._db(), digest)

Module snapshot.controllers.archive:53 in _db

<<      def _db(self):
               if self.db is None:
                   self.db = DBInstance(g.pool)
               return self.db

>>  self.db = DBInstance(g.pool)

Module snapshot.lib.dbinstance:5 in __init__

<<  class DBInstance:
           def __init__(self, pool):
               self.conn = pool.connection()
      
           def execute(self, *args, **kw):

>>  self.conn = pool.connection()

Module DBUtils.PooledDB:293 in connection

<<  con = self._idle_cache.pop(0)
       except IndexError: # else get a fresh connection
       con = self.steady_connection()
       con = PooledDedicatedDBConnection(self, con)
       self._connections += 1

>>  con = self.steady_connection()

Module DBUtils.PooledDB:250 in steady_connection

<<  return connect(self._creator,
       self._maxusage, self._setsession, self._failures, True,
       *self._args, **self._kwargs)
      
       def connection(self, shareable=True):

>>  *self._args, **self._kwargs)

Module DBUtils.SteadyDB:128 in connect

<<  """
       return SteadyDBConnection(creator, maxusage, setsession, failures,
       closeable, *args, **kwargs)

>>  closeable, *args, **kwargs)

Module DBUtils.SteadyDB:179 in __init__

<<  self._closeable = closeable
       self._args, self._kwargs = args, kwargs
       self._store(self._create())
      
       def _create(self):

>>  self._store(self._create())

Module DBUtils.SteadyDB:183 in _create

<<  def _create(self):
       """Create a new connection using the creator function."""
       con = self._creator(*self._args, **self._kwargs)
       try:
       try:

>>  con = self._creator(*self._args, **self._kwargs)

OperationalError: FATAL:  connection limit exceeded for non-superusers

CGI Variables
DOCUMENT_ROOT	'/htdocs'
GATEWAY_INTERFACE	'CGI/1.1'
HTTP_ACCEPT_ENCODING	'gzip'
HTTP_CONNECTION	'TE, close'
HTTP_HOST	'snapshot-dev.debian.org'
HTTP_REFERER	'http://snapshot-dev.debian.org/mr/file/7b4d5b2f24af4b5a299979134bc7f6d7b1eaf875/info'
HTTP_TE	'deflate,gzip;q=0.3'
HTTP_USER_AGENT	'WWW-Mechanize/1.58'
PATH	'/usr/local/bin:/usr/bin:/bin'
PATH_INFO	'/file/7b4d5b2f24af4b5a299979134bc7f6d7b1eaf875'
PATH_TRANSLATED	'/srv/snapshot.debian.org/bin/snapshot.wsgi/file/7b4d5b2f24af4b5a299979134bc7f6d7b1eaf875'
REMOTE_ADDR	'82.59.125.125'
REMOTE_PORT	'11524'
REQUEST_METHOD	'GET'
REQUEST_URI	'/file/7b4d5b2f24af4b5a299979134bc7f6d7b1eaf875'
SCRIPT_FILENAME	'/srv/snapshot.debian.org/bin/snapshot.wsgi'
SERVER_ADDR	'193.62.202.28'
SERVER_ADMIN	'team@snapshot.debian.org'
SERVER_NAME	'snapshot-dev.debian.org'
SERVER_PORT	'80'
SERVER_PROTOCOL	'HTTP/1.1'
SERVER_SIGNATURE	'<address>Apache Server at snapshot-dev.debian.org Port 80</address>\n'
SERVER_SOFTWARE	'Apache'

WSGI Variables
application	<beaker.middleware.CacheMiddleware object at 0x2b4e310>
beaker.cache	<beaker.cache.CacheManager object at 0x2b4e350>
beaker.get_session	<bound method SessionMiddleware._get_session of <beaker.middleware.SessionMiddleware object at 0x2b4e2d0>>
beaker.session	{'_accessed_time': 1270903734.8126409, '_creation_time': 1270903734.8126409}
mod_wsgi.application_group	'snapshot.debian.org|'
mod_wsgi.callable_object	'application'
mod_wsgi.listener_host	''
mod_wsgi.listener_port	'80'
mod_wsgi.process_group	'snapshot.debian.org'
mod_wsgi.reload_mechanism	'1'
mod_wsgi.script_reloading	'1'
mod_wsgi.version	(2, 5)
paste.registry	<paste.registry.Registry object at 0x2cc1e50>
paste.throw_errors	True
pylons.action_method	<bound method ArchiveController.file of <snapshot.controllers.archive.ArchiveController object at 0x2cc3150>>
pylons.controller	<snapshot.controllers.archive.ArchiveController object at 0x2cc3150>
pylons.environ_config	{'session': 'beaker.session', 'cache': 'beaker.cache'}
pylons.pylons	<pylons.util.PylonsContext object at 0x2cc3090>
pylons.routes_dict	{'action': u'file', 'controller': u'archive', 'hash': u'7b4d5b2f24af4b5a299979134bc7f6d7b1eaf875'}
routes.route	<routes.route.Route object at 0x2b40f90>
routes.url	<routes.util.URLGenerator object at 0x2cc1f10>
webob.adhoc_attrs	{'language': 'en-us'}
wsgi process	'Multi process AND threads (?)'
wsgi.file_wrapper	<built-in method file_wrapper of mod_wsgi.Adapter object at 0x2cb86c0>
wsgiorg.routing_args	(<routes.util.URLGenerator object at 0x2cc1f10>, {'action': u'file', 'controller': u'archive', 'hash': u'7b4d5b2f24af4b5a299979134bc7f6d7b1eaf875'})