python - 尝试通过python写入SQL时出现错误的版本号错误

Question

我有一个 python 代码，它每 1 分钟将数据写入 mysql 数据库到不同的表中（用于股票交易）。问题，mysql 写作在一段时间内工作得很好，我可以看到相应表中的条目，但是一段时间后我开始看到下面的错误消息。

有人可以指导我如何解决这个问题吗？为什么会发生，我可以调查的任何来源？

MySql连接建立代码

mydb = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="password123",
    database="testdb"
)

my_cursor = mydb.cursor()

触发错误的行

my_cursor.execute("INSERT INTO " + str(
                trd_portfolio[company_data['instrument_token']]['Symbol']) + "_ohlc_final_1min values (\"" + str(
                ohlc[company_data['instrument_token']][0]) + "\",\"" + str(ohlc[company_data['instrument_token']][1]) + "\"," + str(
                ohlc[company_data['instrument_token']][2]) + "," + str(ohlc[company_data['instrument_token']][3]) + "," + str(
                ohlc[company_data['instrument_token']][4]) + "," + str(ohlc[company_data['instrument_token']][5]) + "," + str(
                ohlc[company_data['instrument_token']][6]) + "," + str(ohlc[company_data['instrument_token']][7]) + "," + str(
                ohlc[company_data['instrument_token']][8]) + "," + str(ohlc[company_data['instrument_token']][9]) + ")")
            mydb.commit()

错误信息：

Exception in thread Thread-679:
Traceback (most recent call last):
  File "C:\Users\win10\AppData\Local\Programs\Python\Python37\lib\site-packages\mysql\connector\network.py", line 265, in recv_plain
    chunk = self.sock.recv(4 - packet_len)
  File "C:\Users\win10\AppData\Local\Programs\Python\Python37\lib\ssl.py", line 1056, in recv
    return self.read(buflen)
  File "C:\Users\win10\AppData\Local\Programs\Python\Python37\lib\ssl.py", line 931, in read
    return self._sslobj.read(len)
ssl.SSLError: [SSL: WRONG_VERSION_NUMBER] wrong version number (_ssl.c:2570)

标签： pythonmysqlsql