[django 1.7.6] system error: 10054 An existing connection was forcibly closed by the remote host

[Weifeng Pan]

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.  

[Collin Anderson]

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