=========================================================================
2025-09-16 16:25:46 Tue	START TASK.01	future_1d  future_rank
=========================================================================
2025-09-16 16:27:44,105 - future_1d - INFO - future_rank check=True check_last=7 start...
2025-09-16 16:27:50,144 - future_1d - INFO - future_rank date = 2025-09-08
2025-09-16 16:27:50,242 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='GFEX) done
2025-09-16 16:27:50,317 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='INE) done
2025-09-16 16:27:50,459 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='DCE) done
2025-09-16 16:27:50,618 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='SHFE) done
2025-09-16 16:27:50,713 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CFFEX) done
2025-09-16 16:27:50,886 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CZCE) done
2025-09-16 16:32:46,835 - future_1d - INFO - save future_rank 2025-09-08 completed
2025-09-16 16:32:56,625 - future_1d - INFO - future_rank date = 2025-09-09
2025-09-16 16:32:56,709 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='GFEX) done
2025-09-16 16:32:56,776 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='INE) done
2025-09-16 16:32:56,922 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='DCE) done
2025-09-16 16:32:57,060 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='SHFE) done
2025-09-16 16:32:57,158 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='CFFEX) done
2025-09-16 16:32:57,321 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='CZCE) done
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 752, in _read_bytes
    raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query')

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/root/project/future_1d/future_rank.py", line 8, in 
    client.save_future_rank(check=True, check_last=7)
  File "/root/project/future_1d/future1d_request.py", line 978, in save_future_rank
    df_db = pd.read_sql(f"select * from {tablebase.__tablename__} where date = '{td}'", self.engine)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
    return pandas_sql.read_query(
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
    result = self.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
    return self.con.exec_driver_sql(sql, *args)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
    ret = self._execute_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
    return self._exec_single_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
  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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 752, in _read_bytes
    raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query')
[SQL: select * from future_rank where date = '2025-09-09']
(Background on this error at: https://sqlalche.me/e/20/e3q8)
=========================================================================
2025-09-16 16:35:24 Tue	START TASK.01	future_1d  future_rank
=========================================================================
2025-09-16 16:35:50,684 - future_1d - INFO - future_rank check=True check_last=7 start...
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 616, in connect
    sock = socket.create_connection(
  File "/usr/local/lib/python3.10/socket.py", line 845, in create_connection
    raise err
  File "/usr/local/lib/python3.10/socket.py", line 833, in create_connection
    sock.connect(sa)
TimeoutError: timed out

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 143, in __init__
    self._dbapi_connection = engine.raw_connection()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3301, in raw_connection
    return self.pool.connect()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 447, in connect
    return _ConnectionFairy._checkout(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1264, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 711, in checkout
    rec = pool._do_get()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get
    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/pool/impl.py", line 175, in _do_get
    return self._create_connection()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 388, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 673, in __init__
    self.__connect()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 899, in __connect
    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/pool/base.py", line 895, in __connect
    self.dbapi_connection = connection = pool._invoke_creator(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 661, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 629, in connect
    return self.loaded_dbapi.connect(*cargs, **cparams)  # type: ignore[no-any-return]  # NOQA: E501
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 352, in __init__
    self.connect()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 668, in connect
    raise exc
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'main.mcga.work' (timed out)")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/root/project/future_1d/future_rank.py", line 8, in 
    client.save_future_rank(check=True, check_last=7)
  File "/root/project/future_1d/future1d_request.py", line 941, in save_future_rank
    new_date = self.get_caldate()[-check_last:]
  File "/root/project/future_1d/future1d_request.py", line 319, in get_caldate
    cal_date = pd.read_sql(cal_sql, engine).sort_values(by=sort_columns)['date'].values
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 706, in read_sql
    with pandasSQL_builder(con) as pandas_sql:
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 908, in pandasSQL_builder
    return SQLDatabase(con, schema, need_transaction)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1648, in __init__
    con = self.exit_stack.enter_context(con.connect())
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3277, in connect
    return self._connection_cls(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
    Connection._handle_dbapi_exception_noconnection(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2440, in _handle_dbapi_exception_noconnection
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 143, in __init__
    self._dbapi_connection = engine.raw_connection()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3301, in raw_connection
    return self.pool.connect()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 447, in connect
    return _ConnectionFairy._checkout(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1264, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 711, in checkout
    rec = pool._do_get()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get
    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/pool/impl.py", line 175, in _do_get
    return self._create_connection()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 388, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 673, in __init__
    self.__connect()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 899, in __connect
    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/pool/base.py", line 895, in __connect
    self.dbapi_connection = connection = pool._invoke_creator(self)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 661, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 629, in connect
    return self.loaded_dbapi.connect(*cargs, **cparams)  # type: ignore[no-any-return]  # NOQA: E501
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 352, in __init__
    self.connect()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 668, in connect
    raise exc
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'main.mcga.work' (timed out)")
(Background on this error at: https://sqlalche.me/e/20/e3q8)
=========================================================================
2025-09-16 16:36:34 Tue	START TASK.01	future_1d  future_rank
=========================================================================
2025-09-16 16:48:37,134 - future_1d - INFO - future_rank check=True check_last=7 start...
2025-09-16 16:49:14,492 - future_1d - INFO - future_rank date = 2025-09-08
2025-09-16 16:49:18,030 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='INE) done
2025-09-16 16:49:18,203 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='SHFE) done
2025-09-16 16:49:18,380 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CZCE) done
2025-09-16 16:49:18,474 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='GFEX) done
2025-09-16 16:49:18,615 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='DCE) done
2025-09-16 16:49:18,744 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CFFEX) done
=========================================================================
2025-09-16 17:22:16 Tue	START TASK.01	future_1d  future_rank
=========================================================================
2025-09-16 17:22:40,504 - future_1d - INFO - future_rank check=True check_last=7 start...
2025-09-16 17:22:47,147 - future_1d - INFO - future_rank date = 2025-09-08
2025-09-16 17:22:47,291 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='DCE) done
2025-09-16 17:22:47,492 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CZCE) done
2025-09-16 17:22:47,631 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='SHFE) done
2025-09-16 17:22:47,719 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='GFEX) done
2025-09-16 17:22:47,787 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='INE) done
2025-09-16 17:22:47,884 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CFFEX) done
=========================================================================
2025-09-16 18:25:20 Tue	START TASK.01	future_1d  future_rank
=========================================================================
2025-09-16 18:25:53,718 - future_1d - INFO - future_rank check=True check_last=7 start...
2025-09-16 18:26:01,372 - future_1d - INFO - future_rank date = 2025-09-08
2025-09-16 18:26:01,464 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CFFEX) done
2025-09-16 18:26:01,608 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='SHFE) done
2025-09-16 18:26:01,691 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='GFEX) done
2025-09-16 18:26:01,862 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CZCE) done
2025-09-16 18:26:01,999 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='DCE) done
2025-09-16 18:26:02,067 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='INE) done
2025-09-16 18:28:07,888 - future_1d - INFO - save future_rank 2025-09-08 completed
2025-09-16 18:28:13,464 - future_1d - INFO - future_rank date = 2025-09-09
2025-09-16 18:28:13,851 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='CFFEX) done
2025-09-16 18:28:13,990 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='SHFE) done
2025-09-16 18:28:14,077 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='GFEX) done
2025-09-16 18:28:14,235 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='CZCE) done
2025-09-16 18:28:15,395 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='DCE) done
2025-09-16 18:28:15,488 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-09',exchange='INE) done
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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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_rank.py", line 8, in 
    client.save_future_rank(check=True, check_last=7)
  File "/root/project/future_1d/future1d_request.py", line 978, in save_future_rank
    df_db = pd.read_sql(f"select * from {tablebase.__tablename__} where date = '{td}'", self.engine)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
    return pandas_sql.read_query(
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
    result = self.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
    return self.con.exec_driver_sql(sql, *args)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
    ret = self._execute_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
    return self._exec_single_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
  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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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)')
[SQL: select * from future_rank where date = '2025-09-08']
(Background on this error at: https://sqlalche.me/e/20/e3q8)
=========================================================================
2025-09-16 19:10:55 Tue	START TASK.01	future_1d  future_rank
=========================================================================
2025-09-16 19:11:41,246 - future_1d - INFO - future_rank check=True check_last=7 start...
2025-09-16 19:11:47,062 - future_1d - INFO - future_rank date = 2025-09-08
2025-09-16 19:11:48,366 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='INE) done
2025-09-16 19:11:48,537 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='SHFE) done
2025-09-16 19:11:48,622 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='GFEX) done
2025-09-16 19:11:48,799 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CZCE) done
2025-09-16 19:11:48,954 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='DCE) done
2025-09-16 19:11:49,758 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CFFEX) done
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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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_rank.py", line 8, in 
    client.save_future_rank(check=True, check_last=7)
  File "/root/project/future_1d/future1d_request.py", line 978, in save_future_rank
    df_db = pd.read_sql(f"select * from {tablebase.__tablename__} where date = '{td}'", self.engine)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
    return pandas_sql.read_query(
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
    result = self.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
    return self.con.exec_driver_sql(sql, *args)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
    ret = self._execute_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
    return self._exec_single_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
  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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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)')
[SQL: select * from future_rank where date = '2025-09-08']
(Background on this error at: https://sqlalche.me/e/20/e3q8)
=========================================================================
2025-09-16 19:56:24 Tue	START TASK.01	future_1d  future_rank
=========================================================================
2025-09-16 19:56:53,501 - future_1d - INFO - future_rank check=True check_last=7 start...
2025-09-16 19:56:58,590 - future_1d - INFO - future_rank date = 2025-09-08
2025-09-16 19:56:58,695 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='GFEX) done
2025-09-16 19:56:58,841 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='SHFE) done
2025-09-16 19:56:58,958 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CFFEX) done
2025-09-16 19:56:59,092 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='DCE) done
2025-09-16 19:56:59,524 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CZCE) done
2025-09-16 19:56:59,594 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='INE) done
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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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_rank.py", line 8, in 
    client.save_future_rank(check=True, check_last=7)
  File "/root/project/future_1d/future1d_request.py", line 978, in save_future_rank
    df_db = pd.read_sql(f"select * from {tablebase.__tablename__} where date = '{td}'", self.engine)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
    return pandas_sql.read_query(
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
    result = self.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
    return self.con.exec_driver_sql(sql, *args)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
    ret = self._execute_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
    return self._exec_single_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
  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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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)')
[SQL: select * from future_rank where date = '2025-09-09']
(Background on this error at: https://sqlalche.me/e/20/e3q8)
=========================================================================
2025-09-16 20:41:18 Tue	START TASK.01	future_1d  future_rank
=========================================================================
2025-09-16 20:41:29,034 - future_1d - INFO - future_rank check=True check_last=7 start...
2025-09-16 20:41:55,350 - future_1d - INFO - future_rank date = 2025-09-08
2025-09-16 20:41:55,445 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CFFEX) done
2025-09-16 20:41:55,527 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='GFEX) done
2025-09-16 20:41:55,684 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='SHFE) done
2025-09-16 20:41:55,821 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='DCE) done
2025-09-16 20:41:55,982 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='CZCE) done
2025-09-16 20:41:56,046 - future_1d - INFO - pro.fut_holding(trade_date='2025-09-08',exchange='INE) done
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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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_rank.py", line 8, in 
    client.save_future_rank(check=True, check_last=7)
  File "/root/project/future_1d/future1d_request.py", line 978, in save_future_rank
    df_db = pd.read_sql(f"select * from {tablebase.__tablename__} where date = '{td}'", self.engine)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
    return pandas_sql.read_query(
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
    result = self.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
    return self.con.exec_driver_sql(sql, *args)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
    ret = self._execute_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
    return self._exec_single_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
  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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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)')
[SQL: select * from future_rank where date = '2025-09-08']
(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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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_rank.py", line 8, in 
    client.save_future_rank(check=True, check_last=7)
  File "/root/project/future_1d/future1d_request.py", line 978, in save_future_rank
    df_db = pd.read_sql(f"select * from {tablebase.__tablename__} where date = '{td}'", self.engine)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
    return pandas_sql.read_query(
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
    result = self.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
    return self.con.exec_driver_sql(sql, *args)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
    ret = self._execute_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
    return self._exec_single_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
  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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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)')
[SQL: select * from future_rank where date = '2025-09-08']
(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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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_rank.py", line 8, in 
    client.save_future_rank(check=True, check_last=7)
  File "/root/project/future_1d/future1d_request.py", line 978, in save_future_rank
    df_db = pd.read_sql(f"select * from {tablebase.__tablename__} where date = '{td}'", self.engine)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 736, in read_sql
    return pandas_sql.read_query(
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1848, in read_query
    result = self.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1671, in execute
    return self.con.exec_driver_sql(sql, *args)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql
    ret = self._execute_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
    return self._exec_single_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
  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 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1164, in read
    self._read_result_packet(first_packet)
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1240, in _read_result_packet
    self._read_rowdata_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
    packet = self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 715, in _read_packet
    recv_data = self._read_bytes(bytes_to_read)
  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)')
[SQL: select * from future_rank where date = '2025-09-08']
(Background on this error at: https://sqlalche.me/e/20/e3q8)