mysql.connector.errors.InterfaceError：执行操作失败;

问：

我正在尝试使用“mycursor.executemany（sql， data_list）”插入近 40,000 行，并在“mycursor.executemany（sql， data_list）”这一行中出现错误。我正在使用 mysql-connector-python=8.2.0、python=3.11 和 VPS machine= Alma-liux 8.8。

  File "/lib/python3.11/site-packages/mysql/connector/cursor_cext.py", line 406, in _batch_insert
    raise InterfaceError(f"Failed executing the operation; {err}") from None
mysql.connector.errors.InterfaceError: Failed executing the operation;

我正在使用 mysql-connector-python=8.2.0、python=3.11 和 VPS machine= Alma-liux 8.8。

这是插入代码

sql = f"""INSERT INTO {website} ({columns}) VALUES ({placeholders});"""
        mycursor.executemany(sql, data_not_present)
        mydb.commit()

这是一段时间后出现的错误

  File "/lib/python3.11/site-packages/mysql/connector/cursor_cext.py", line 406, in _batch_insert
    raise InterfaceError(f"Failed executing the operation; {err}") from None
mysql.connector.errors.InterfaceError: Failed executing the operation;