Skip to content

Instantly share code, notes, and snippets.

@lxyu

lxyu/t1.md

Last active August 29, 2015 14:10
Show Gist options
  • Save lxyu/7cbd6cbe83b47e581c8d to your computer and use it in GitHub Desktop.
Save lxyu/7cbd6cbe83b47e581c8d to your computer and use it in GitHub Desktop.
Download ZIP
pymysql + gevent + sqlalchemy connection error log
Raw
t1.md 
$ pip freeze
gevent==1.0.1
PyMySQL==0.6.2
SQLAlchemy==0.9.8

..........................................X.................................................................X..................................................................................X........................................................................X.....................................................................................ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 567, in _finalize_fairy
    fairy._reset(pool)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 699, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1322, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1360, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 509, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 507, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2354, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 658, in _read_ok_packet
    pkt = self._read_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 825, in _read_packet
    packet = packet_type(self)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 242, in __init__
    self._recv_packet(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 248, in _recv_packet
    packet_header = connection._read_bytes(4)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 841, in _read_bytes
    "Lost connection to MySQL server during query")
OperationalError: (OperationalError) (2013, 'Lost connection to MySQL server during query') None None
.................X.ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 567, in _finalize_fairy
    fairy._reset(pool)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 699, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1322, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1360, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 509, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 507, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2354, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 660, in _read_ok_packet
    raise OperationalError(2014, "Command Out of Sync")
OperationalError: (OperationalError) (2014, 'Command Out of Sync') None None
.......................................X.X..X........XX.............................................X.................................ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 567, in _finalize_fairy
    fairy._reset(pool)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 699, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1322, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1360, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 509, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 507, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2354, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 678, in rollback
    self._execute_command(COM_QUERY, "ROLLBACK")
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 875, in _execute_command
    raise InterfaceError("(0, '')")
InterfaceError: (InterfaceError) (0, '') None None
...........X......X..XX...................XX..X.......X...X..X.....X.X..X......................X.......................ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 567, in _finalize_fairy
    fairy._reset(pool)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 699, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1322, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1360, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 509, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 507, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2354, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 660, in _read_ok_packet
    raise OperationalError(2014, "Command Out of Sync")
OperationalError: (OperationalError) (2014, 'Command Out of Sync') None None
.....X.......X.........XX..................................................................X.............ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 567, in _finalize_fairy
    fairy._reset(pool)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 699, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1322, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1360, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 509, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 507, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2354, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 678, in rollback
    self._execute_command(COM_QUERY, "ROLLBACK")
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 875, in _execute_command
    raise InterfaceError("(0, '')")
InterfaceError: (InterfaceError) (0, '') None None
...X.X......XX.....X.X.....X...XX..........XXX........X...XX.X....X.........XXXX..........X..............................XERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 567, in _finalize_fairy
    fairy._reset(pool)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 699, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1322, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1360, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 509, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 507, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2354, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 678, in rollback
    self._execute_command(COM_QUERY, "ROLLBACK")
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 875, in _execute_command
    raise InterfaceError("(0, '')")
InterfaceError: (InterfaceError) (0, '') None None
.XERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 567, in _finalize_fairy
    fairy._reset(pool)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 699, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1322, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1360, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 509, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 507, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2354, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 678, in rollback
    self._execute_command(COM_QUERY, "ROLLBACK")
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 875, in _execute_command
    raise InterfaceError("(0, '')")
InterfaceError: (InterfaceError) (0, '') None None
.....................X..................XX......X.........X...X.............ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 567, in _finalize_fairy
    fairy._reset(pool)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 699, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1322, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1360, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 509, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 507, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2354, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 660, in _read_ok_packet
    raise OperationalError(2014, "Command Out of Sync")
OperationalError: (OperationalError) (2014, 'Command Out of Sync') None None
..X...X.X....XXX..X..............X....X...........ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 567, in _finalize_fairy
    fairy._reset(pool)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 699, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1322, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1360, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 509, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 507, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2354, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 660, in _read_ok_packet
    raise OperationalError(2014, "Command Out of Sync")
OperationalError: (OperationalError) (2014, 'Command Out of Sync') None None
..ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 567, in _finalize_fairy
    fairy._reset(pool)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 699, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1322, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1360, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 509, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 507, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2354, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 678, in rollback
    self._execute_command(COM_QUERY, "ROLLBACK")
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 875, in _execute_command
    raise InterfaceError("(0, '')")
InterfaceError: (InterfaceError) (0, '') None None
......X.................ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 567, in _finalize_fairy
    fairy._reset(pool)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 699, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1322, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1360, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 509, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 507, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2354, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 660, in _read_ok_packet
    raise OperationalError(2014, "Command Out of Sync")
OperationalError: (OperationalError) (2014, 'Command Out of Sync') None None
......X....XKeyboardInterrupt
Raw
t2.md 
$ pip freeze
gevent==1.0.1
PyMySQL==0.6.2
SQLAlchemy==0.9.3

.........................................................................................................................X......................................................................X...........
........................................................................X...................................................................X...............................................................
..........X.........................................................................X................................................................................X......................................
.................................................X.....................................................................X.............................................................................X......
.............................................................................X..................................................................X...........................................................
.................X.................................................................X..........................................................................X.............................................
...........................X..................................................................................ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 243, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 401, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/gevent/greenlet.py", line 327, in run
    result = self._run(*self.args, **self.kwargs)
  File "t.py", line 36, in worker
    conn.close()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 637, in close
    del self.__connection
AttributeError: _Connection__connection
<Greenlet at 0x1103cc190: worker> failed with AttributeError

..........................................................................X.................................................................................X...............................................
......................X............................................................................X.........................................................................X..............................
.......................................................ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 243, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 401, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/gevent/greenlet.py", line 327, in run
    result = self._run(*self.args, **self.kwargs)
  File "t.py", line 36, in worker
    conn.close()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 637, in close
    del self.__connection
AttributeError: _Connection__connection
<Greenlet at 0x1103cc230: worker> failed with AttributeError
Raw
t3.md 
$ pip freeze
gevent==1.0.1
PyMySQL==0.6.2
SQLAlchemy==0.9.4

.....................................ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/gevent/greenlet.py", line 327, in run
    result = self._run(*self.args, **self.kwargs)
  File "t.py", line 36, in worker
    conn.close()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 640, in close
    del self.__connection
AttributeError: _Connection__connection
<Greenlet at 0x1033720f0: worker> failed with AttributeError

...................................................................................X..............ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/gevent/greenlet.py", line 327, in run
    result = self._run(*self.args, **self.kwargs)
  File "t.py", line 36, in worker
    conn.close()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 640, in close
    del self.__connection
AttributeError: _Connection__connection
<Greenlet at 0x10336dcd0: worker> failed with AttributeError

.......X.........X.......X..........X....ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
X.....X.......X.ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
XERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
X........XX.................ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/gevent/greenlet.py", line 327, in run
    result = self._run(*self.args, **self.kwargs)
  File "t.py", line 36, in worker
    conn.close()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 640, in close
    del self.__connection
AttributeError: _Connection__connection
<Greenlet at 0x103209d70: worker> failed with AttributeError

..................................X..........ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/gevent/greenlet.py", line 327, in run
    result = self._run(*self.args, **self.kwargs)
  File "t.py", line 36, in worker
    conn.close()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 640, in close
    del self.__connection
AttributeError: _Connection__connection
<Greenlet at 0x10336d4b0: worker> failed with AttributeError

ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
X..............................................X.....................................................................X..........XERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
X.....ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
X..........................X............ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/gevent/greenlet.py", line 327, in run
    result = self._run(*self.args, **self.kwargs)
  File "t.py", line 36, in worker
    conn.close()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 640, in close
    del self.__connection
AttributeError: _Connection__connection
<Greenlet at 0x10336deb0: worker> failed with AttributeError

ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
X...........X........X............................ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/gevent/greenlet.py", line 327, in run
    result = self._run(*self.args, **self.kwargs)
  File "t.py", line 36, in worker
    conn.close()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 640, in close
    del self.__connection
AttributeError: _Connection__connection
<Greenlet at 0x10336d0f0: worker> failed with AttributeError

.ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
X..................XX............X...................ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/gevent/greenlet.py", line 327, in run
    result = self._run(*self.args, **self.kwargs)
  File "t.py", line 36, in worker
    conn.close()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 640, in close
    del self.__connection
AttributeError: _Connection__connection
<Greenlet at 0x10336d230: worker> failed with AttributeError

.....................................X..............ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/gevent/greenlet.py", line 327, in run
    result = self._run(*self.args, **self.kwargs)
  File "t.py", line 36, in worker
    conn.close()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 640, in close
    del self.__connection
AttributeError: _Connection__connection
<Greenlet at 0x103209eb0: worker> failed with AttributeError

.ERROR:sqlalchemy.pool.QueuePool:Exception closing connection None
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 244, in _close_connection
    self._dialect.do_close(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 411, in do_close
    dbapi_connection.close()
AttributeError: 'NoneType' object has no attribute 'close'

Traceback (most recent call last):
  File "t.py", line 54, in <module>
    main()
  File "t.py", line 48, in main
    engine.execute("kill %d" % result[-2][0])
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1682, in execute
    return connection.execute(statement, *multiparams, **params)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 712, in execute
    return self._execute_text(object, multiparams, params)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 861, in _execute_text
    statement, parameters
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
    context)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1098, in _handle_dbapi_exception
    self._autorollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 610, in _autorollback
    self._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 508, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1076, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 506, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2192, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 658, in _read_ok_packet
    pkt = self._read_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 825, in _read_packet
    packet = packet_type(self)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 242, in __init__
    self._recv_packet(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 248, in _recv_packet
    packet_header = connection._read_bytes(4)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 832, in _read_bytes
    data = self._rfile.read(num_bytes)
sqlalchemy.exc.DBAPIError: (RuntimeError) reentrant call inside <_io.BufferedReader name=43> None None
Raw
t4.md 
$ pip freeze
gevent==1.0.1
PyMySQL==0.6.2
SQLAlchemy==0.9.5

..........................ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 557, in _finalize_fairy
    fairy._reset(pool, echo)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 686, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1264, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1302, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 508, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1116, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 506, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2196, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 658, in _read_ok_packet
    pkt = self._read_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 825, in _read_packet
    packet = packet_type(self)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 242, in __init__
    self._recv_packet(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 248, in _recv_packet
    packet_header = connection._read_bytes(4)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 841, in _read_bytes
    "Lost connection to MySQL server during query")
OperationalError: (OperationalError) (2013, 'Lost connection to MySQL server during query') None None
................................................ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 557, in _finalize_fairy
    fairy._reset(pool, echo)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 686, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1264, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1302, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 508, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1119, in _handle_dbapi_exception
    util.reraise(*exc_info)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 506, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2196, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 658, in _read_ok_packet
    pkt = self._read_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 825, in _read_packet
    packet = packet_type(self)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 242, in __init__
    self._recv_packet(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 248, in _recv_packet
    packet_header = connection._read_bytes(4)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 832, in _read_bytes
    data = self._rfile.read(num_bytes)
RuntimeError: reentrant call inside <_io.BufferedReader name=48>
.X.......................X..........................XX...................................................X.............X....XX..X.................................................ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 557, in _finalize_fairy
    fairy._reset(pool, echo)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 686, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1264, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1302, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 508, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1116, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 506, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2196, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 660, in _read_ok_packet
    raise OperationalError(2014, "Command Out of Sync")
OperationalError: (OperationalError) (2014, 'Command Out of Sync') None None
............X.................................................ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 557, in _finalize_fairy
    fairy._reset(pool, echo)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 686, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1264, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1302, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 508, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1116, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 506, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2196, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 678, in rollback
    self._execute_command(COM_QUERY, "ROLLBACK")
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 875, in _execute_command
    raise InterfaceError("(0, '')")
InterfaceError: (InterfaceError) (0, '') None None
.........ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 557, in _finalize_fairy
    fairy._reset(pool, echo)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 686, in _reset
    self._reset_agent.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1264, in rollback
    self._do_rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1302, in _do_rollback
    self.connection._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 508, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1116, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 506, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2196, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 678, in rollback
    self._execute_command(COM_QUERY, "ROLLBACK")
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 875, in _execute_command
    raise InterfaceError("(0, '')")
InterfaceError: (InterfaceError) (0, '') None None
..X........X..XX...ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar
Traceback (most recent call last):
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 557, in _finalize_fairy
    fairy._reset(pool, echo)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/pool.py", line 688, in _reset
    pool._dialect.do_rollback(self)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2196, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 658, in _read_ok_packet
    pkt = self._read_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 825, in _read_packet
    packet = packet_type(self)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 242, in __init__
    self._recv_packet(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 248, in _recv_packet
    packet_header = connection._read_bytes(4)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 832, in _read_bytes
    data = self._rfile.read(num_bytes)
RuntimeError: reentrant call inside <_io.BufferedReader name=43>

Traceback (most recent call last):
  File "t.py", line 54, in <module>
    main()
  File "t.py", line 47, in main
    result = list(engine.execute("show processlist"))
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1690, in execute
    return connection.execute(statement, *multiparams, **params)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 719, in execute
    return self._execute_text(object, multiparams, params)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 868, in _execute_text
    statement, parameters
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 954, in _execute_context
    context)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1106, in _handle_dbapi_exception
    self._autorollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 612, in _autorollback
    self._rollback_impl()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 508, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1084, in _handle_dbapi_exception
    exc_info
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 506, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2196, in do_rollback
    dbapi_connection.rollback()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 679, in rollback
    self._read_ok_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 658, in _read_ok_packet
    pkt = self._read_packet()
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 825, in _read_packet
    packet = packet_type(self)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 242, in __init__
    self._recv_packet(connection)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 248, in _recv_packet
    packet_header = connection._read_bytes(4)
  File "/usr/local/opt/pyenv/versions/zeus@py2/lib/python2.7/site-packages/pymysql/connections.py", line 832, in _read_bytes
    data = self._rfile.read(num_bytes)
sqlalchemy.exc.DBAPIError: (RuntimeError) reentrant call inside <_io.BufferedReader name=43> None None
Raw
test.py
import gevent.monkey
gevent.monkey.patch_all()
import logging
logging.basicConfig()
from sqlalchemy import event
import random
import sys
from sqlalchemy import create_engine
engine = create_engine('mysql+pymysql://root@localhost/test',
pool_size=50, max_overflow=0)
@event.listens_for(engine, "connect")
def conn(*arg):
sys.stdout.write("o")
def worker():
while True:
conn = engine.connect()
try:
conn.begin()
for i in range(5):
conn.execute("SELECT 1+1")
gevent.sleep(random.random() * 1.01)
except:
sys.stderr.write('X')
else:
conn.close()
sys.stderr.write('.')
def main():
for i in range(40):
gevent.spawn(worker)
gevent.sleep(3)
while True:
result = list(engine.execute("show processlist"))
engine.execute("kill %d" % result[-2][0])
print "\n\n\n BOOM!!!!! \n\n\n"
gevent.sleep(5)
print(engine.pool.status())
main()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment