Hi, I'm getting a lot of "MySQL server has gone away" errors on my site.
I tried increasing the connection timeout but the site is in a private beta and has very less activity. At times there aren't any requests for hours together. And when there are requests .. these errors comes up multiple times and after that it starts running smoothly. I'm sure this issue will vanish once the site build up traffic.. But during site demos errors like these are embarrassing. Please suggest a workaround. Thanks. Akram # Traceback (most recent call last): # # File "/usr/lib/python2.5/site-packages/django/core/handlers/base.py", line 86, in get_response # response = callback(request, *callback_args, **callback_kwargs) # # File "/root/main/mosambe/../mosambe/jobs/views/auth.py", line 5, in login # if request.user.is_authenticated(): # # File "/usr/lib/python2.5/site-packages/django/contrib/auth/ middleware.py", line 5, in __get__ # request._cached_user = get_user(request) # # File "/usr/lib/python2.5/site-packages/django/contrib/auth/ __init__.py", line 83, in get_user # user_id = request.session[SESSION_KEY] # # File "/usr/lib/python2.5/site-packages/django/contrib/sessions/ backends/base.py", line 46, in __getitem__ # return self._session[key] # # File "/usr/lib/python2.5/site-packages/django/contrib/sessions/ backends/base.py", line 172, in _get_session # self._session_cache = self.load() # # File "/usr/lib/python2.5/site-packages/django/contrib/sessions/ backends/db.py", line 16, in load # expire_date__gt=datetime.datetime.now() # # File "/usr/lib/python2.5/site-packages/django/db/models/manager.py", line 93, in get # return self.get_query_set().get(*args, **kwargs) # # File "/usr/lib/python2.5/site-packages/django/db/models/query.py", line 304, in get # num = len(clone) # # File "/usr/lib/python2.5/site-packages/django/db/models/query.py", line 160, in __len__ # self._result_cache = list(self.iterator()) # # File "/usr/lib/python2.5/site-packages/django/db/models/query.py", line 275, in iterator # for row in self.query.results_iter(): # # File "/usr/lib/python2.5/site-packages/django/db/models/sql/query.py", line 206, in results_iter # for rows in self.execute_sql(MULTI): # # File "/usr/lib/python2.5/site-packages/django/db/models/sql/query.py", line 1734, in execute_sql # cursor.execute(sql, params) # # File "/usr/lib/python2.5/site-packages/django/db/backends/mysql/ base.py", line 93, in execute # return self.cursor.execute(query, args) # # File "/usr/lib/python2.5/site-packages/MySQL_python-1.2.3c1-py2.5- linux-x86_64.egg/MySQLdb/cursors.py", line 173, in execute # self.errorhandler(self, exc, value) # # File "/usr/lib/python2.5/site-packages/MySQL_python-1.2.3c1-py2.5- linux-x86_64.egg/MySQLdb/connections.py", line 36, in defaulterrorhandler # raise errorclass, errorvalue # # OperationalError: (2006, 'MySQL server has gone away') --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
