[traceback][prod] Error: OperationalError: (1040, 'Too many connections')

VERIFIED WORKSFORME

Status

Participation Infrastructure
Phonebook
VERIFIED WORKSFORME
6 years ago
6 years ago

People

(Reporter: mbrandt, Unassigned)

Tracking

Details

(Reporter)

Description

6 years ago
Prod appears to be fine at the moment however two trace backs came in rapid succession for:
http://mozillians.org/es/csp/report
http://mozillians.org/es/jsi18n/

Traceback (most recent call last):

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/core/handlers/base.py", line 89, in get_response
   response = middleware_method(request)

 File "/data/www/mozillians.org/mozillians/vendor/src/django-session-csrf/session_csrf/__init__.py", line 42, in process_request
   if request.user.is_authenticated():

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/utils/functional.py", line 172, in inner
   self._setup()

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/utils/functional.py", line 236, in _setup
   self._wrapped = self._setupfunc()

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/contrib/auth/middleware.py", line 16, in <lambda>
   request.user = SimpleLazyObject(lambda: get_user(request))

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/contrib/auth/middleware.py", line 8, in get_user
   request._cached_user = auth.get_user(request)

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/contrib/auth/__init__.py", line 101, in get_user
   user = backend.get_user(user_id) or AnonymousUser()

 File "/data/www/mozillians.org/mozillians/vendor/src/django-browserid/django_browserid/auth.py", line 171, in get_user
   return User.objects.get(pk=user_id)

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/models/manager.py", line 132, in get
   return self.get_query_set().get(*args, **kwargs)

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/models/query.py", line 344, in get
   num = len(clone)

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/models/query.py", line 82, in __len__
   self._result_cache = list(self.iterator())

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/models/query.py", line 273, in iterator
   for row in compiler.results_iter():

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/models/sql/compiler.py", line 699, in results_iter
   for rows in self.execute_sql(MULTI):

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/models/sql/compiler.py", line 753, in execute_sql
   cursor = self.connection.cursor()

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/backends/__init__.py", line 252, in cursor
   cursor = util.CursorWrapper(self._cursor(), self)

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/backends/mysql/base.py", line 330, in _cursor
   self.connection = Database.connect(**kwargs)

 File "/usr/lib/python2.6/site-packages/MySQLdb/__init__.py", line 81, in Connect
   return Connection(*args, **kwargs)

 File "/usr/lib/python2.6/site-packages/MySQLdb/connections.py", line 187, in __init__
   super(Connection, self).__init__(*args, **kwargs2)

OperationalError: (1040, 'Too many connections')
(Reporter)

Updated

6 years ago
Component: mozillians.org → Phonebook
Product: Websites → Community Tools
QA Contact: mozillians-org → phonebook
Version: unspecified → other
Has anyone seen this recently? May have been a transient DB issue.
(Reporter)

Comment 2

6 years ago
Nope, haven't seen this little beast in a long while. I'm ok if you want to close it.
Feel free to reopen if it reappears.
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → WORKSFORME
(Reporter)

Comment 4

6 years ago
Thanks James - bumping to verified worksforme.
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.