OperationalError: FATAL: too many connections for role "osqa-production"

XMLWordPrintable

    • Severity 3 - Minor

      NOTE: This bug report is for Confluence Cloud. Using Confluence Server? See the corresponding bug report.

      We keep getting these at random times:

      ---------- Forwarded message ----------
      From: <root@localhost.private.atlassian.com>
      Date: Thu, Oct 4, 2012 at 2:59 AM
      Subject: [Django] Error (EXTERNAL IP): /upfiles/answers_favicon_7.ico
      To: jlargman@atlassian.com
      
      
      Traceback (most recent call last):
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/core/handlers/base.py", line 80, in get_response
          response = middleware_method(request)
      
        File "/opt/python/domains/atlassian.com/answers/ADM-26156/forum/middleware/extended_user.py", line 10, in process_request
          if request.user.is_authenticated():
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/contrib/auth/middleware.py", line 9, in __get__
          request._cached_user = get_user(request)
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/contrib/auth/__init__.py", line 99, in get_user
          user_id = request.session[SESSION_KEY]
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/contrib/sessions/backends/base.py", line 46, in __getitem__
          return self._session[key]
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/contrib/sessions/backends/base.py", line 172, in _get_session
          self._session_cache = self.load()
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/contrib/sessions/backends/db.py", line 20, in load
          expire_date__gt=datetime.datetime.now()
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/manager.py", line 132, in get
          return self.get_query_set().get(*args, **kwargs)
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/query.py", line 342, in get
          num = len(clone)
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/query.py", line 80, in __len__
          self._result_cache = list(self.iterator())
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/query.py", line 271, in iterator
          for row in compiler.results_iter():
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line 677, in results_iter
          for rows in self.execute_sql(MULTI):
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line 731, in execute_sql
          cursor = self.connection.cursor()
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/backends/__init__.py", line 75, in cursor
          cursor = self._cursor()
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 136, in _cursor
          self.connection = Database.connect(**conn_params)
      
      OperationalError: FATAL:  too many connections for role "osqa-production"
      
      
      
      <WSGIRequest
      GET:<QueryDict: {}>,
      POST:<QueryDict: {}>,
      COOKIES:{'__qca': 'P0-999424123-1348761942919',
       '__utma': '80426056.1310315401.1349254509.1349254509.1349344746.2',
       '__utmb': '80426056.5.10.1349344746',
       '__utmc': '80426056',
       '__utmz': '80426056.1349344746.2.2.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not%20provided)',
       'crowd.token_key': '7mhCdNAMYcBWHeKKXl99Fw00',
       'csrftoken': 'c76ebc86a8f6802557fc4868a3317b60',
       'optimizelyBuckets': '%7B%22110497364%22%3A%22110544093%22%2C%22112369296%22%3A%22112336478%22%7D',
       'optimizelyEndUserId': 'oeu1348137751606r0.5742143479398828',
       'sessionid': 'a2c252d78d1bf819652e137228f3da32'},
      META:{'HTTP_ACCEPT': 'image/png,image/*;q=0.8,*/*;q=0.5',
       'HTTP_ACCEPT_ENCODING': 'gzip, deflate',
       'HTTP_ACCEPT_LANGUAGE': 'en-gb,en;q=0.5',
       'HTTP_CONNECTION': 'close',
       'HTTP_COOKIE': '__utma=80426056.1310315401.1349254509.1349254509.1349344746.2; __utmz=80426056.1349344746.2.2.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not%20provided); csrftoken=c76ebc86a8f6802557fc4868a3317b60; sessionid=a2c252d78d1bf819652e137228f3da32; optimizelyEndUserId=oeu1348137751606r0.5742143479398828; optimizelyBuckets=%7B%22110497364%22%3A%22110544093%22%2C%22112369296%22%3A%22112336478%22%7D; __qca=P0-999424123-1348761942919; __utmc=80426056; crowd.token_key=7mhCdNAMYcBWHeKKXl99Fw00; __utmb=80426056.5.10.1349344746',
       'HTTP_DNT': '1',
       'HTTP_HOST': 'answers.atlassian.com',
       'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 6.1; rv:15.0) Gecko/20100101 Firefox/15.0.1',
       'HTTP_X_FORWARDED_FOR': '89.101.129.242, 172.16.3.45',
       'HTTP_X_REAL_IP': '89.101.129.242',
       'PATH_INFO': u'/upfiles/answers_favicon_7.ico',
       'QUERY_STRING': '',
       'RAW_URI': '/upfiles/answers_favicon_7.ico',
       'REMOTE_ADDR': '172.16.3.45',
       'REMOTE_PORT': '80',
       'REQUEST_METHOD': 'GET',
       'SCRIPT_NAME': u'',
       'SERVER_NAME': 'answers.atlassian.com',
       'SERVER_PORT': '80',
       'SERVER_PROTOCOL': 'HTTP/1.0',
       'SERVER_SOFTWARE': 'gunicorn/0.14.1',
       'gunicorn.socket': <socket._socketobject object at 0x1ca72590>,
       'wsgi.errors': <open file '<stderr>', mode 'w' at 0x2ad8b11df1e0>,
       'wsgi.file_wrapper': <class gunicorn.http.wsgi.FileWrapper at 0xd697f50>,
       'wsgi.input': <gunicorn.http.body.Body object at 0xf547d50>,
       'wsgi.multiprocess': True,
       'wsgi.multithread': False,
       'wsgi.run_once': False,
       'wsgi.url_scheme': 'http',
       'wsgi.version': (1, 0)}>
      

            Assignee:
            Dennis Kromhout van der Meer (Inactive)
            Reporter:
            Dennis Kromhout van der Meer (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: