=========================================================================
2025-08-19 08:40:11 Tue START TASK.01 future_1d future_fee
=========================================================================
2025-08-19 08:40:13,726 - future_1d - INFO - save future fee done.
暂无新增品种
已保存最新日期(2025-08-19)的全部合约列表到 /root/project/ctp_md_receiver/position/full_contracts.csv.20250820
=========================================================================
2025-08-19 16:25:11 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLKUxR3u' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLKUxR3u' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8155.0, 'previous_closing_price': 8230.0, 'latest_price': 8150.0, 'volume': 46438, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7900.0, 'previous_closing_price': 7955.0, 'latest_price': 7941.0, 'volume': 218, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7960.0, 'previous_closing_price': 8019.0, 'latest_price': 7961.0, 'volume': 18, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8038.0, 'previous_closing_price': 8104.0, 'latest_price': 8027.0, 'volume': 6923, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 8000.0, 'latest_price': 7938.0, 'volume': 16, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 8004.0, 'latest_price': 7964.0, 'volume': 7, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8028.0, 'previous_closing_price': 8062.0, 'latest_price': 8015.0, 'volume': 53, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13830.0, 'latest_price': 13820.0, 'volume': 31663, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22360.0, 'previous_closing_price': 22335.0, 'latest_price': 22200.0, 'volume': 9, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22355.0, 'previous_closing_price': 22330.0, 'latest_price': 22225.0, 'volume': 15, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)
=========================================================================
2025-08-19 16:25:45 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLeMxoE8' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLeMxoE8' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8155.0, 'previous_closing_price': 8230.0, 'latest_price': 8150.0, 'volume': 46438, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7900.0, 'previous_closing_price': 7955.0, 'latest_price': 7941.0, 'volume': 218, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7960.0, 'previous_closing_price': 8019.0, 'latest_price': 7961.0, 'volume': 18, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8038.0, 'previous_closing_price': 8104.0, 'latest_price': 8027.0, 'volume': 6923, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 8000.0, 'latest_price': 7938.0, 'volume': 16, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 8004.0, 'latest_price': 7964.0, 'volume': 7, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8028.0, 'previous_closing_price': 8062.0, 'latest_price': 8015.0, 'volume': 53, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13830.0, 'latest_price': 13820.0, 'volume': 31663, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22360.0, 'previous_closing_price': 22335.0, 'latest_price': 22200.0, 'volume': 9, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22355.0, 'previous_closing_price': 22330.0, 'latest_price': 22225.0, 'volume': 15, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)
=========================================================================
2025-08-19 16:26:21 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLZte3bY' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLZte3bY' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8155.0, 'previous_closing_price': 8230.0, 'latest_price': 8150.0, 'volume': 46438, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7900.0, 'previous_closing_price': 7955.0, 'latest_price': 7941.0, 'volume': 218, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7960.0, 'previous_closing_price': 8019.0, 'latest_price': 7961.0, 'volume': 18, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8038.0, 'previous_closing_price': 8104.0, 'latest_price': 8027.0, 'volume': 6923, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 8000.0, 'latest_price': 7938.0, 'volume': 16, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 8004.0, 'latest_price': 7964.0, 'volume': 7, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8028.0, 'previous_closing_price': 8062.0, 'latest_price': 8015.0, 'volume': 53, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13830.0, 'latest_price': 13820.0, 'volume': 31663, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22360.0, 'previous_closing_price': 22335.0, 'latest_price': 22200.0, 'volume': 9, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22355.0, 'previous_closing_price': 22330.0, 'latest_price': 22225.0, 'volume': 15, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)
=========================================================================
2025-08-19 16:26:55 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLZ2wriP' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLZ2wriP' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8155.0, 'previous_closing_price': 8230.0, 'latest_price': 8150.0, 'volume': 46438, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7900.0, 'previous_closing_price': 7955.0, 'latest_price': 7941.0, 'volume': 218, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7960.0, 'previous_closing_price': 8019.0, 'latest_price': 7961.0, 'volume': 18, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8038.0, 'previous_closing_price': 8104.0, 'latest_price': 8027.0, 'volume': 6923, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 8000.0, 'latest_price': 7938.0, 'volume': 16, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 8004.0, 'latest_price': 7964.0, 'volume': 7, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8028.0, 'previous_closing_price': 8062.0, 'latest_price': 8015.0, 'volume': 53, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13830.0, 'latest_price': 13820.0, 'volume': 31663, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22360.0, 'previous_closing_price': 22335.0, 'latest_price': 22200.0, 'volume': 9, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22355.0, 'previous_closing_price': 22330.0, 'latest_price': 22225.0, 'volume': 15, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)
=========================================================================
2025-08-19 18:25:11 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLuIeQ55' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLuIeQ55' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8155.0, 'previous_closing_price': 8230.0, 'latest_price': 8150.0, 'volume': 46438, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7900.0, 'previous_closing_price': 7955.0, 'latest_price': 7941.0, 'volume': 218, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7960.0, 'previous_closing_price': 8019.0, 'latest_price': 7961.0, 'volume': 18, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8038.0, 'previous_closing_price': 8104.0, 'latest_price': 8027.0, 'volume': 6923, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 8000.0, 'latest_price': 7938.0, 'volume': 16, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 8004.0, 'latest_price': 7964.0, 'volume': 7, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8028.0, 'previous_closing_price': 8062.0, 'latest_price': 8015.0, 'volume': 53, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13830.0, 'latest_price': 13820.0, 'volume': 31663, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22360.0, 'previous_closing_price': 22335.0, 'latest_price': 22200.0, 'volume': 9, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22355.0, 'previous_closing_price': 22330.0, 'latest_price': 22225.0, 'volume': 15, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)
=========================================================================
2025-08-19 18:25:46 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLsz7LtH' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLsz7LtH' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8155.0, 'previous_closing_price': 8230.0, 'latest_price': 8150.0, 'volume': 46438, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7900.0, 'previous_closing_price': 7955.0, 'latest_price': 7941.0, 'volume': 218, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7960.0, 'previous_closing_price': 8019.0, 'latest_price': 7961.0, 'volume': 18, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8038.0, 'previous_closing_price': 8104.0, 'latest_price': 8027.0, 'volume': 6923, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 8000.0, 'latest_price': 7938.0, 'volume': 16, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 8004.0, 'latest_price': 7964.0, 'volume': 7, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8028.0, 'previous_closing_price': 8062.0, 'latest_price': 8015.0, 'volume': 53, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13830.0, 'latest_price': 13820.0, 'volume': 31663, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22360.0, 'previous_closing_price': 22335.0, 'latest_price': 22200.0, 'volume': 9, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22355.0, 'previous_closing_price': 22330.0, 'latest_price': 22225.0, 'volume': 15, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)
=========================================================================
2025-08-19 18:26:20 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLE4MknA' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLE4MknA' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8155.0, 'previous_closing_price': 8230.0, 'latest_price': 8150.0, 'volume': 46438, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7900.0, 'previous_closing_price': 7955.0, 'latest_price': 7941.0, 'volume': 218, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7960.0, 'previous_closing_price': 8019.0, 'latest_price': 7961.0, 'volume': 18, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8038.0, 'previous_closing_price': 8104.0, 'latest_price': 8027.0, 'volume': 6923, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 8000.0, 'latest_price': 7938.0, 'volume': 16, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 8004.0, 'latest_price': 7964.0, 'volume': 7, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8028.0, 'previous_closing_price': 8062.0, 'latest_price': 8015.0, 'volume': 53, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13830.0, 'latest_price': 13820.0, 'volume': 31663, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22360.0, 'previous_closing_price': 22335.0, 'latest_price': 22200.0, 'volume': 9, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22355.0, 'previous_closing_price': 22330.0, 'latest_price': 22225.0, 'volume': 15, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)
=========================================================================
2025-08-19 18:26:56 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLRim0pw' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLRim0pw' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8155.0, 'previous_closing_price': 8230.0, 'latest_price': 8150.0, 'volume': 46438, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7900.0, 'previous_closing_price': 7955.0, 'latest_price': 7941.0, 'volume': 218, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7960.0, 'previous_closing_price': 8019.0, 'latest_price': 7961.0, 'volume': 18, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8038.0, 'previous_closing_price': 8104.0, 'latest_price': 8027.0, 'volume': 6923, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 8000.0, 'latest_price': 7938.0, 'volume': 16, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 8004.0, 'latest_price': 7964.0, 'volume': 7, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8028.0, 'previous_closing_price': 8062.0, 'latest_price': 8015.0, 'volume': 53, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13830.0, 'latest_price': 13820.0, 'volume': 31663, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22360.0, 'previous_closing_price': 22335.0, 'latest_price': 22200.0, 'volume': 9, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22355.0, 'previous_closing_price': 22330.0, 'latest_price': 22225.0, 'volume': 15, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)
=========================================================================
2025-08-19 20:40:11 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLWUNLeX' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLWUNLeX' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8156.0, 'previous_closing_price': 8150.0, 'latest_price': 8150.0, 'volume': 0, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7930.0, 'previous_closing_price': 7941.0, 'latest_price': 7941.0, 'volume': 0, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 7961.0, 'latest_price': 7961.0, 'volume': 0, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8046.0, 'previous_closing_price': 8027.0, 'latest_price': 8027.0, 'volume': 0, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7950.0, 'previous_closing_price': 7938.0, 'latest_price': 7938.0, 'volume': 0, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 7964.0, 'latest_price': 7964.0, 'volume': 0, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8011.0, 'previous_closing_price': 8015.0, 'latest_price': 8015.0, 'volume': 0, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13820.0, 'latest_price': 13820.0, 'volume': 0, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22215.0, 'previous_closing_price': 22200.0, 'latest_price': 22200.0, 'volume': 0, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22225.0, 'previous_closing_price': 22225.0, 'latest_price': 22225.0, 'volume': 0, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)
=========================================================================
2025-08-19 20:40:56 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLUGIGYJ' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLUGIGYJ' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8156.0, 'previous_closing_price': 8150.0, 'latest_price': 8150.0, 'volume': 0, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7930.0, 'previous_closing_price': 7941.0, 'latest_price': 7941.0, 'volume': 0, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 7961.0, 'latest_price': 7961.0, 'volume': 0, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8046.0, 'previous_closing_price': 8027.0, 'latest_price': 8027.0, 'volume': 0, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7950.0, 'previous_closing_price': 7938.0, 'latest_price': 7938.0, 'volume': 0, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 7964.0, 'latest_price': 7964.0, 'volume': 0, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8011.0, 'previous_closing_price': 8015.0, 'latest_price': 8015.0, 'volume': 0, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13820.0, 'latest_price': 13820.0, 'volume': 0, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22215.0, 'previous_closing_price': 22200.0, 'latest_price': 22200.0, 'volume': 0, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22225.0, 'previous_closing_price': 22225.0, 'latest_price': 22225.0, 'volume': 0, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)
=========================================================================
2025-08-19 20:41:41 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLraBtjJ' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLraBtjJ' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8156.0, 'previous_closing_price': 8150.0, 'latest_price': 8150.0, 'volume': 0, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7930.0, 'previous_closing_price': 7941.0, 'latest_price': 7941.0, 'volume': 0, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 7961.0, 'latest_price': 7961.0, 'volume': 0, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8046.0, 'previous_closing_price': 8027.0, 'latest_price': 8027.0, 'volume': 0, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7950.0, 'previous_closing_price': 7938.0, 'latest_price': 7938.0, 'volume': 0, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 7964.0, 'latest_price': 7964.0, 'volume': 0, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8011.0, 'previous_closing_price': 8015.0, 'latest_price': 8015.0, 'volume': 0, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13820.0, 'latest_price': 13820.0, 'volume': 0, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22215.0, 'previous_closing_price': 22200.0, 'latest_price': 22200.0, 'volume': 0, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22225.0, 'previous_closing_price': 22225.0, 'latest_price': 22225.0, 'volume': 0, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)
=========================================================================
2025-08-19 20:42:26 Tue START TASK.01 future_1d future_fee
=========================================================================
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3, "Error writing file '/tmp/MLFvQkgj' (OS errno 28 - No space left on device)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_fee.py", line 24, in
client.save_future_fee()
File "/root/project/future_1d/future1d_request.py", line 1129, in save_future_fee
df_fee.to_sql(FutureFee.__tablename__, self.engine, if_exists='append', index=False)
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 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
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 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
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 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (3, "Error writing file '/tmp/MLFvQkgj' (OS errno 28 - No space left on device)")
[SQL: INSERT INTO future_fee (exchange, contract, contract_name, comd, comd_name, contract_multiplier, min_price_movement, open_position_rate_amount, open_position_fee_per_hand, close_position_rate_amount, close_position_fee_per_hand, close_today_rate_amount, close_today_fee_per_hand, long_margin_rate_amount, long_margin_per_hand, short_margin_rate_amount, short_margin_per_hand, previous_settlement_price, previous_closing_price, latest_price, volume, open_interest, open_fee_per_hand_1, close_fee_per_hand_1, close_today_fee_per_hand_1, long_margin_per_hand_1, short_margin_per_hand_1, hand_market_value, tick_close_pnl_1, tick_close_net_profit_1, tick_close_net_profit_2, tick_close_roi_1, tick_close_roi_2, tick_close_today_net_profit_1, tick_close_today_net_profit_2, tick_close_today_roi_1, tick_close_today_roi_2, date) VALUES (%(exchange)s, %(contract)s, %(contract_name)s, %(comd)s, %(comd_name)s, %(contract_multiplier)s, %(min_price_movement)s, %(open_position_rate_amount)s, %(open_position_fee_per_hand)s, %(close_position_rate_amount)s, %(close_position_fee_per_hand)s, %(close_today_rate_amount)s, %(close_today_fee_per_hand)s, %(long_margin_rate_amount)s, %(long_margin_per_hand)s, %(short_margin_rate_amount)s, %(short_margin_per_hand)s, %(previous_settlement_price)s, %(previous_closing_price)s, %(latest_price)s, %(volume)s, %(open_interest)s, %(open_fee_per_hand_1)s, %(close_fee_per_hand_1)s, %(close_today_fee_per_hand_1)s, %(long_margin_per_hand_1)s, %(short_margin_per_hand_1)s, %(hand_market_value)s, %(tick_close_pnl_1)s, %(tick_close_net_profit_1)s, %(tick_close_net_profit_2)s, %(tick_close_roi_1)s, %(tick_close_roi_2)s, %(tick_close_today_net_profit_1)s, %(tick_close_today_net_profit_2)s, %(tick_close_today_roi_1)s, %(tick_close_today_roi_2)s, %(date)s)]
[parameters: [{'exchange': 'CZCE', 'contract': 'AP510', 'contract_name': 'AP510', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8156.0, 'previous_closing_price': 8150.0, 'latest_price': 8150.0, 'volume': 0, 'open_interest': 83632, 'open_fee_per_hand_1': 5.08, 'close_fee_per_hand_1': 5.08, 'close_today_fee_per_hand_1': 20.08, 'long_margin_per_hand_1': 8150.0, 'short_margin_per_hand_1': 8150.0, 'hand_market_value': 81500, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.121, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.186, 'tick_close_today_roi_2': -0.063, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP511', 'contract_name': 'AP511', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7930.0, 'previous_closing_price': 7941.0, 'latest_price': 7941.0, 'volume': 0, 'open_interest': 3263, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7941.0, 'short_margin_per_hand_1': 7941.0, 'hand_market_value': 79410, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP512', 'contract_name': 'AP512', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7956.0, 'previous_closing_price': 7961.0, 'latest_price': 7961.0, 'volume': 0, 'open_interest': 109, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7961.0, 'short_margin_per_hand_1': 7961.0, 'hand_market_value': 79610, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP601', 'contract_name': 'AP601', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8046.0, 'previous_closing_price': 8027.0, 'latest_price': 8027.0, 'volume': 0, 'open_interest': 19394, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8027.0, 'short_margin_per_hand_1': 8027.0, 'hand_market_value': 80270, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP603', 'contract_name': 'AP603', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7950.0, 'previous_closing_price': 7938.0, 'latest_price': 7938.0, 'volume': 0, 'open_interest': 112, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7938.0, 'short_margin_per_hand_1': 7938.0, 'hand_market_value': 79380, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.191, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP604', 'contract_name': 'AP604', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 7974.0, 'previous_closing_price': 7964.0, 'latest_price': 7964.0, 'volume': 0, 'open_interest': 80, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 7964.0, 'short_margin_per_hand_1': 7964.0, 'hand_market_value': 79640, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.124, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.19, 'tick_close_today_roi_2': -0.065, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'AP605', 'contract_name': 'AP605', 'comd': 'AP', 'comd_name': '苹果', 'contract_multiplier': 10, 'min_price_movement': 1.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 5.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 5.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 20.01, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 8011.0, 'previous_closing_price': 8015.0, 'latest_price': 8015.0, 'volume': 0, 'open_interest': 371, 'open_fee_per_hand_1': 5.07, 'close_fee_per_hand_1': 5.07, 'close_today_fee_per_hand_1': 20.07, 'long_margin_per_hand_1': 8015.0, 'short_margin_per_hand_1': 8015.0, 'hand_market_value': 80150, 'tick_close_pnl_1': 10, 'tick_close_net_profit_1': -0.15, 'tick_close_net_profit_2': 9.85, 'tick_close_roi_1': -0.002, 'tick_close_roi_2': 0.123, 'tick_close_today_net_profit_1': -15.15, 'tick_close_today_net_profit_2': -5.15, 'tick_close_today_roi_1': -0.189, 'tick_close_today_roi_2': -0.064, 'date': '2025-08-19'}, {'exchange': 'CZCE', 'contract': 'CF509', 'contract_name': '棉花9月', 'comd': 'CF', 'comd_name': '一号棉花', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 4.31, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 4.31, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.1, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.1, 'short_margin_per_hand': 0, 'previous_settlement_price': 13835.0, 'previous_closing_price': 13820.0, 'latest_price': 13820.0, 'volume': 0, 'open_interest': 119917, 'open_fee_per_hand_1': 4.37, 'close_fee_per_hand_1': 4.37, 'close_today_fee_per_hand_1': 0.06, 'long_margin_per_hand_1': 6910.0, 'short_margin_per_hand_1': 6910.0, 'hand_market_value': 69100, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 16.27, 'tick_close_net_profit_2': 41.27, 'tick_close_roi_1': 0.235, 'tick_close_roi_2': 0.597, 'tick_close_today_net_profit_1': 20.58, 'tick_close_today_net_profit_2': 45.58, 'tick_close_today_roi_1': 0.298, 'tick_close_today_roi_2': 0.66, 'date': '2025-08-19'} ... displaying 10 of 815 total bound parameter sets ... {'exchange': 'SHFE', 'contract': 'zn2607', 'contract_name': 'zn2607', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22215.0, 'previous_closing_price': 22200.0, 'latest_price': 22200.0, 'volume': 0, 'open_interest': 101, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 9990.0, 'short_margin_per_hand_1': 9990.0, 'hand_market_value': 111000, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.469, 'date': '2025-08-19'}, {'exchange': 'SHFE', 'contract': 'zn2608', 'contract_name': 'zn2608', 'comd': 'zn', 'comd_name': '锌', 'contract_multiplier': 5, 'min_price_movement': 5.0, 'open_position_rate_amount': 1e-06, 'open_position_fee_per_hand': 3.01, 'close_position_rate_amount': 1e-06, 'close_position_fee_per_hand': 3.01, 'close_today_rate_amount': 1e-06, 'close_today_fee_per_hand': 0.0, 'long_margin_rate_amount': 0.09, 'long_margin_per_hand': 0, 'short_margin_rate_amount': 0.09, 'short_margin_per_hand': 0, 'previous_settlement_price': 22225.0, 'previous_closing_price': 22225.0, 'latest_price': 22225.0, 'volume': 0, 'open_interest': 13, 'open_fee_per_hand_1': 3.1, 'close_fee_per_hand_1': 3.1, 'close_today_fee_per_hand_1': 0.09, 'long_margin_per_hand_1': 10001.25, 'short_margin_per_hand_1': 10001.25, 'hand_market_value': 111125, 'tick_close_pnl_1': 25, 'tick_close_net_profit_1': 18.8, 'tick_close_net_profit_2': 43.8, 'tick_close_roi_1': 0.188, 'tick_close_roi_2': 0.438, 'tick_close_today_net_profit_1': 21.81, 'tick_close_today_net_profit_2': 46.81, 'tick_close_today_roi_1': 0.218, 'tick_close_today_roi_2': 0.468, 'date': '2025-08-19'}]]
(Background on this error at: https://sqlalche.me/e/20/2j85)