Thanks for this great lib.
ver. 1.4.95
Description:
I got MySQL operation error as below error message.
And there are trade records inserted in "trades" table but no record show in dashboard.
$ python strategy.py --log strategy_log/ --ibport 7491 --output strategy_log/
Active month for ES is: 201612
Active month for CL is: 201612
Server Version: 76
TWS Time at connection:20161025 09:08:40 CST
BAR: {'symbol': 'CLZ2016_FUT', 'asset_class': 'FUT', 'low': 50.46, 'close': 50.47, 'volume': 37.0, 'signal': nan, 'symbol_group': 'CL_F', 'datetime': Timestamp('2016-10-25 01:08:00'), 'opt_price': nan, 'high': 50.47, 'open': 50.46}
CLZ2016_FUT still in position. Exiting...
CLZ2016_FUT not in position. Sending a bracket BUY order...
[2016-10-25 09:10:55,399] ERROR in app: Exception on /positions [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 222, in positions
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NULL
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
2016-10-25 09:10:55,399 [ERROR]: Exception on /positions [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 222, in positions
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NULL
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
[2016-10-25 09:10:55,413] ERROR in app: Exception on /trades [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 194, in trades
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NOT NULL AND entry_time>='2016-10-18'
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
2016-10-25 09:10:55,413 [ERROR]: Exception on /trades [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 194, in trades
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NOT NULL AND entry_time>='2016-10-18'
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
[2016-10-25 09:10:55,423] ERROR in app: Exception on /algos [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 151, in algos
algos = pd.read_sql("SELECT DISTINCT algo FROM trades", self.dbconn).to_dict(orient="records")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT DISTINCT algo FROM trades
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
2016-10-25 09:10:55,423 [ERROR]: Exception on /algos [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 151, in algos
algos = pd.read_sql("SELECT DISTINCT algo FROM trades", self.dbconn).to_dict(orient="records")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT DISTINCT algo FROM trades
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
[2016-10-25 09:10:58,058] ERROR in app: Exception on /positions [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 222, in positions
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NULL
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
2016-10-25 09:10:58,058 [ERROR]: Exception on /positions [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 222, in positions
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NULL
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
[2016-10-25 09:10:58,073] ERROR in app: Exception on /trades [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 194, in trades
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NOT NULL AND entry_time>='2016-10-18'
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
2016-10-25 09:10:58,073 [ERROR]: Exception on /trades [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 194, in trades
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NOT NULL AND entry_time>='2016-10-18'
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
[2016-10-25 09:10:58,093] ERROR in app: Exception on /algos [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 151, in algos
algos = pd.read_sql("SELECT DISTINCT algo FROM trades", self.dbconn).to_dict(orient="records")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT DISTINCT algo FROM trades
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
2016-10-25 09:10:58,093 [ERROR]: Exception on /algos [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 151, in algos
algos = pd.read_sql("SELECT DISTINCT algo FROM trades", self.dbconn).to_dict(orient="records")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT DISTINCT algo FROM trades
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
BAR: {'symbol': 'ESZ2016_FUT', 'asset_class': 'FUT', 'low': 2145.5, 'close': 2145.5, 'volume': 1.0, 'signal': nan, 'symbol_group': 'ES_F', 'datetime': Timestamp('2016-10-25 01:09:00'), 'opt_price': nan, 'high': 2145.5, 'open': 2145.5}
[2016-10-25 09:11:28,058] ERROR in app: Exception on /positions [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 222, in positions
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NULL
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
2016-10-25 09:11:28,058 [ERROR]: Exception on /positions [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 222, in positions
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NULL
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
[2016-10-25 09:11:28,069] ERROR in app: Exception on /trades [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 194, in trades
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NOT NULL AND entry_time>='2016-10-18'
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
2016-10-25 09:11:28,069 [ERROR]: Exception on /trades [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 194, in trades
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NOT NULL AND entry_time>='2016-10-18'
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
CLZ2016_FUT not in position. Sending a bracket SELL order...
[2016-10-25 09:11:58,061] ERROR in app: Exception on /trades [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 194, in trades
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NOT NULL AND entry_time>='2016-10-18'
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
2016-10-25 09:11:58,061 [ERROR]: Exception on /trades [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 194, in trades
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NOT NULL AND entry_time>='2016-10-18'
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
[2016-10-25 09:11:58,075] ERROR in app: Exception on /positions [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 222, in positions
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NULL
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback
2016-10-25 09:11:58,075 [ERROR]: Exception on /positions [GET]
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1400, in execute
cur.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 834, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1004, in _write_bytes
self._sock.sendall(data)
BrokenPipeError: [Errno 32] Broken pipe
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/qtpylib/reports.py", line 222, in positions
trades = pd.read_sql(trades_query, self.dbconn)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 399, in read_sql
chunksize=chunksize)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1435, in read_query
cursor = self.execute(*args)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1408, in execute
raise_with_traceback(ex)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/compat/__init__.py", line 339, in raise_with_traceback
raise exc.with_traceback(traceback)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pandas/io/sql.py", line 1404, in execute
self.con.rollback()
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 771, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1054, in _execute_command
self._write_bytes(packet)
File "/Users/qtpylib_user/anaconda3/envs/qtpylib/lib/python3.5/site-packages/pymysql/connections.py", line 1006, in _write_bytes
raise err.OperationalError(2006, "MySQL server has gone away (%r)" % (e,))
pandas.io.sql.DatabaseError: Execution failed on sql: SELECT * FROM trades WHERE exit_time IS NULL
(2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")
unable to rollback