Hi, Interesting. If you switch back to previous version of django you don't have that problem?
Is it a slow query? Are you using MySQL or MSSQL? Collin On Tuesday, March 10, 2015 at 8:55:44 PM UTC-4, Weifeng Pan wrote: > > Hi, > > > I upgrade to latest version of django. Every time I navigate to django > admin site "User" page. I got this error: > > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\core\handlers\base.py", > line 111, in get_response > response = wrapped_callback(request, *callback_args, **callback_kwargs) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\contrib\admin\options.py", > > line 583, in wrapper > return self.admin_site.admin_view(view)(*args, **kwargs) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\utils\decorators.py", > line 105, in _wrapped_view > response = view_func(request, *args, **kwargs) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\views\decorators\cache.py", > > line 52, in _wrapped_view_func > response = view_func(request, *args, **kwargs) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\contrib\admin\sites.py", > line 206, in inner > return view(request, *args, **kwargs) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\utils\decorators.py", > line 29, in _wrapper > return bound_func(*args, **kwargs) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\utils\decorators.py", > line 105, in _wrapped_view > response = view_func(request, *args, **kwargs) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\utils\decorators.py", > line 25, in bound_func > return func.__get__(self, type(self))(*args2, **kwargs2) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\contrib\admin\options.py", > > line 1485, in changelist_view > self.list_max_show_all, self.list_editable, self) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\contrib\admin\views\main.py", > > line 109, in __init__ > self.queryset = self.get_queryset(request) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\contrib\admin\views\main.py", > > line 359, in get_queryset > filters_use_distinct) = self.get_filters(request) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\contrib\admin\views\main.py", > > line 175, in get_filters > self.model, self.model_admin, field_path=field_path) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\contrib\admin\filters.py", > > line 158, in create > model, model_admin, field_path=field_path) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\contrib\admin\filters.py", > > line 172, in __init__ > self.lookup_choices = field.get_choices(include_blank=False) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\db\models\fields\__init__.py", > > line 750, in get_choices > self.get_limit_choices_to())] > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\db\models\query.py", > line 141, in __iter__ > self._fetch_all() > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\db\models\query.py", > line 966, in _fetch_all > self._result_cache = list(self.iterator()) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\db\models\query.py", > line 265, in iterator > for row in compiler.results_iter(): > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\db\models\sql\compiler.py", > > line 700, in results_iter > for rows in self.execute_sql(MULTI): > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\db\models\sql\compiler.py", > > line 786, in execute_sql > cursor.execute(sql, params) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\db\backends\utils.py", > line 81, in execute > return super(CursorDebugWrapper, self).execute(sql, params) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\django\db\backends\utils.py", > line 65, in execute > return self.cursor.execute(sql, params) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\mysql\connector\django\base.py", > line 135, in execute > return self._execute_wrapper(self.cursor.execute, query, args) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\mysql\connector\django\base.py", > line 124, in _execute_wrapper > utils.DatabaseError(err.msg), sys.exc_info()[2]) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\mysql\connector\django\base.py", > line 115, in _execute_wrapper > return method(query, args) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\mysql\connector\cursor.py", > line 507, in execute > self._handle_result(self._connection.cmd_query(stmt)) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\mysql\connector\connection.py", > line 722, in cmd_query > result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\mysql\connector\connection.py", > line 510, in _send_cmd > return self._socket.recv() > File > "C:\MyProjects\WuWuKe\venv\lib\site-packages\mysql\connector\network.py", > line 253, in recv_plain > errno=2055, values=(self.get_address(), _strioerror(err))) > DatabaseError: Lost connection to MySQL server at '.........', system > error: 10054 An existing connection was forcibly closed by the remote host > > > I debug the code: > I found every time executing this sql 'SELECT `auth_group`.`id`, > `auth_group`.`name` FROM `auth_group`, this error will occur. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/bc84a0d7-ca7b-4fdf-a364-2030fb2f1e08%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
