Python3 程序执行数据库操作时报错 “<p>处理中..................</p>”：如何解决数据库事务问题？

import requests
import time
import json
import pymysql

mydb = pymysql.connect(
    host="92.68.40.12", port=3306,
    user="root",
    password="iss_root",
    database="dynamic_premium_db"
)
mycursor = mydb.cursor()

def excute_sql_db(stratagy_id, city_id, app_name, total_price, over_flow_price, date_time):
    sql = "insert into over_flow_price(straragy_id,city_id,app_name,total_price,over_flow_price,time_stamp)values('%s','%s','%s','%s','%s','%s')" % (stratagy_id, city_id, app_name, total_price, over_flow_price, date_time)
    mycursor.execute(sql)  # 报错行

def excute_sql_db(stratagy_id, city_id, app_name, total_price, over_flow_price, date_time):
    sql = "INSERT INTO over_flow_price(straragy_id,city_id,app_name,total_price,over_flow_price,time_stamp)VALUES('%s','%s','%s','%s','%s','%s')" % (stratagy_id, city_id, app_name, total_price, over_flow_price, date_time)
    try:
        mycursor.execute(sql)
        mydb.commit()  # 提交事务
        print('插入成功')
    except Exception as e:
        mydb.rollback()  # 回滚事务
        print('err: ' + sql)
        print(e)