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 [email protected]. To post to this group, send email to [email protected]. 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.
