=========================================================================
2025-08-19 16:25:19 Tue START TASK.01 future_1d future_meta
=========================================================================
2025-08-19 16:25:21,614 - future_1d - INFO - save meta_TradingDay 2025-08-06 completed
2025-08-19 16:25:21,905 - future_1d - INFO - save meta_TradingDay 2025-08-07 completed
2025-08-19 16:25:22,252 - future_1d - INFO - save meta_TradingDay 2025-08-08 completed
2025-08-19 16:25:22,619 - future_1d - INFO - save meta_TradingDay 2025-08-11 completed
2025-08-19 16:25:22,910 - future_1d - INFO - save meta_TradingDay 2025-08-12 completed
2025-08-19 16:25:23,257 - future_1d - INFO - save meta_TradingDay 2025-08-13 completed
2025-08-19 16:25:23,571 - future_1d - INFO - save meta_TradingDay 2025-08-14 completed
2025-08-19 16:25:23,866 - future_1d - INFO - save meta_TradingDay 2025-08-15 completed
2025-08-19 16:25:24,208 - future_1d - INFO - save meta_TradingDay 2025-08-18 completed
=========================================================================
2025-08-19 17:11:11 Tue START TASK.01 future_1d future_meta
=========================================================================
=========================================================================
2025-08-19 17:55:57 Tue START TASK.01 future_1d future_meta
=========================================================================
=========================================================================
2025-08-19 18:25:37 Tue START TASK.01 future_1d future_meta
=========================================================================
=========================================================================
2025-08-19 18:41:27 Tue START TASK.01 future_1d future_meta
=========================================================================
=========================================================================
2025-08-19 19:11:07 Tue START TASK.01 future_1d future_meta
=========================================================================
=========================================================================
2025-08-19 19:56:31 Tue START TASK.01 future_1d future_meta
=========================================================================
=========================================================================
2025-08-19 20:41:36 Tue START TASK.01 future_1d future_meta
=========================================================================
2025-08-20 11:21:29,693 - future_1d - INFO - save meta_TradingDay 2025-08-06 completed
2025-08-20 11:21:29,694 - future_1d - INFO - save meta_TradingDay 2025-08-06 completed
2025-08-20 11:21:29,990 - future_1d - INFO - save meta_TradingDay 2025-08-07 completed
2025-08-20 11:21:29,997 - future_1d - INFO - save meta_TradingDay 2025-08-07 completed
2025-08-20 11:21:30,358 - future_1d - INFO - save meta_TradingDay 2025-08-08 completed
2025-08-20 11:21:30,361 - future_1d - INFO - save meta_TradingDay 2025-08-08 completed
2025-08-20 11:21:30,664 - future_1d - INFO - save meta_TradingDay 2025-08-11 completed
2025-08-20 11:21:30,666 - future_1d - INFO - save meta_TradingDay 2025-08-11 completed
2025-08-20 11:21:30,957 - future_1d - INFO - save meta_TradingDay 2025-08-12 completed
2025-08-20 11:21:30,960 - future_1d - INFO - save meta_TradingDay 2025-08-12 completed
2025-08-20 11:21:31,319 - future_1d - INFO - save meta_TradingDay 2025-08-13 completed
2025-08-20 11:21:31,324 - future_1d - INFO - save meta_TradingDay 2025-08-13 completed
2025-08-20 11:21:31,627 - future_1d - INFO - save meta_TradingDay 2025-08-14 completed
2025-08-20 11:21:31,648 - future_1d - INFO - save meta_TradingDay 2025-08-14 completed
2025-08-20 11:21:31,930 - future_1d - INFO - save meta_TradingDay 2025-08-15 completed
2025-08-20 11:21:32,086 - future_1d - INFO - save meta_TradingDay 2025-08-15 completed
2025-08-20 11:21:32,437 - future_1d - INFO - save meta_TradingDay 2025-08-18 completed
2025-08-20 11:21:32,651 - future_1d - INFO - save meta_TradingDay 2025-08-18 completed
2025-08-20 11:21:32,740 - future_1d - INFO - save meta_TradingDay 2025-08-19 completed
2025-08-20 11:21:32,952 - future_1d - INFO - save meta_TradingDay 2025-08-19 completed
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_meta.py", line 7, in
client.save_meta(check=True, check_last=10)
File "/root/project/future_1d/future1d_request.py", line 386, in save_meta
self._save_meta_tradingday(check=check, check_last=check_last)
File "/root/project/future_1d/future1d_request.py", line 421, in _save_meta_tradingday
self.save_log(date=td, status='completed', category=tablebase.__tablename__)
File "/root/project/future_1d/future1d_request.py", line 429, in save_log
df_log.to_sql('future_log', self.engine, index=False, if_exists='append', chunksize=1000)
File "/usr/local/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/pandas/core/generic.py", line 3106, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_meta.py", line 7, in
client.save_meta(check=True, check_last=10)
File "/root/project/future_1d/future1d_request.py", line 386, in save_meta
self._save_meta_tradingday(check=check, check_last=check_last)
File "/root/project/future_1d/future1d_request.py", line 421, in _save_meta_tradingday
self.save_log(date=td, status='completed', category=tablebase.__tablename__)
File "/root/project/future_1d/future1d_request.py", line 429, in save_log
df_log.to_sql('future_log', self.engine, index=False, if_exists='append', chunksize=1000)
File "/usr/local/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/pandas/core/generic.py", line 3106, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_meta.py", line 7, in
client.save_meta(check=True, check_last=10)
File "/root/project/future_1d/future1d_request.py", line 386, in save_meta
self._save_meta_tradingday(check=check, check_last=check_last)
File "/root/project/future_1d/future1d_request.py", line 417, in _save_meta_tradingday
data_add.to_sql(tablebase.__tablename__, self.engine, index=False, if_exists='append', chunksize=1000)
File "/usr/local/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/pandas/core/generic.py", line 3106, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_meta.py", line 7, in
client.save_meta(check=True, check_last=10)
File "/root/project/future_1d/future1d_request.py", line 386, in save_meta
self._save_meta_tradingday(check=check, check_last=check_last)
File "/root/project/future_1d/future1d_request.py", line 421, in _save_meta_tradingday
self.save_log(date=td, status='completed', category=tablebase.__tablename__)
File "/root/project/future_1d/future1d_request.py", line 429, in save_log
df_log.to_sql('future_log', self.engine, index=False, if_exists='append', chunksize=1000)
File "/usr/local/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/pandas/core/generic.py", line 3106, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
data = self._rfile.read(num_bytes)
return self._sock.recv_into(b)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
dbapi_connection.commit()
raise err.OperationalError(
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_meta.py", line 7, in
client.save_meta(check=True, check_last=10)
File "/root/project/future_1d/future1d_request.py", line 386, in save_meta
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
self._save_meta_tradingday(check=check, check_last=check_last)
File "/root/project/future_1d/future1d_request.py", line 421, in _save_meta_tradingday
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
self.save_log(date=td, status='completed', category=tablebase.__tablename__)
File "/root/project/future_1d/future1d_request.py", line 429, in save_log
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
df_log.to_sql('future_log', self.engine, index=False, if_exists='append', chunksize=1000)
File "/usr/local/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/pandas/core/generic.py", line 3106, in to_sql
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_meta.py", line 7, in
client.save_meta(check=True, check_last=10)
File "/root/project/future_1d/future1d_request.py", line 386, in save_meta
return sql.to_sql(
self._save_meta_tradingday(check=check, check_last=check_last)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 843, in to_sql
File "/root/project/future_1d/future1d_request.py", line 421, in _save_meta_tradingday
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.save_log(date=td, status='completed', category=tablebase.__tablename__)
File "/root/project/future_1d/future1d_request.py", line 429, in save_log
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
df_log.to_sql('future_log', self.engine, index=False, if_exists='append', chunksize=1000)
File "/usr/local/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
return func(*args, **kwargs)
raise exc_details[1]
File "/usr/local/lib/python3.10/site-packages/pandas/core/generic.py", line 3106, in to_sql
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
return sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 843, in to_sql
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)