mysql 10053_Lost Connection to MySQL server at ':', system error: 10053 An established connection wa...

Here is one part of my python code for inserting data retrieved from Sharepoint into MySQL Database, it runs every 10 mins.

cnx = mysql.connector.connect(user='user', password='pwd', host='CP-MSQL03',port='3306',database='datacenter')

cnx.autocommit=True

MySQL_cursor = cnx.cursor()

r = requests.get(url, headers=headers, params=params)

delete_data = []

for item in r.json()['d']['results']:

id = item['Id']

lot_No = item['LOT_No']

start = datetime.strptime(item['START'], '%Y-%m-%dT%H:%M:%SZ')

lbs = item['LBS']

line_NAV = item['Line_No']['NAV_x0020_HS_x0020_LINE']

rpo_No = item['RPO_No']['RPO_No']

item_NO = item['RPO_No']['Item_No']

mrt_No = item['RPO_No']['MRT_No']

SQL_Insert = (

"INSERT INTO datacenter.mrt_consumption_archive (Line_No, RPO_No, Item_No, MRT_No, LOT_No, Start_Time, LBS) "

"VALUES('%s', '%s', '%s', '%s', '%s', '%s', %s);" % (

line_NAV, rpo_No, item_NO, mrt_No, lot_No, start, lbs))

MySQL_cursor.execute(SQL_Insert)

delete_data.append(id)

And Here is the error code I got after it ran successfully for a few hours.

My question is, why do I get this error? Is it a firewall issue? timeout setting issue? How can I troubleshoot it? And, why am I keep getting the same error at all the retries after it failed for the first time?