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

Status: VERIFIED WORKSFORME

(Participation Infrastructure :: Phonebook, defect)

Description

[Matt Brandt [:mbrandt]]

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')

Comment 1

[James Socol [:jsocol, :james]]

Has anyone seen this recently? May have been a transient DB issue.

Comment 2

[Matt Brandt [:mbrandt]]

Nope, haven't seen this little beast in a long while. I'm ok if you want to close it.

Comment 3

[James Socol [:jsocol, :james]]

Feel free to reopen if it reappears.

Comment 4

[Matt Brandt [:mbrandt]]

Thanks James - bumping to verified worksforme.