PyMysql拋出一個警告異常，無法插入數(shù)據(jù)。

捕捉PyMysql的警告異常的時候，之前可以插入數(shù)據(jù)，但是現(xiàn)在突然無法插入數(shù)據(jù)。
一直會報一個主鍵沖突的警告。但是之前對于這個警告，確實是可以正確的插入數(shù)據(jù)，自己還寫了一篇博客說明了捕捉警告異常時需要注意的問題。詳見
這是我數(shù)據(jù)庫的已有的數(shù)據(jù)

然后執(zhí)行下面的語句，會報一個主鍵沖突的警告。

>>> import pymysql as pm
>>> from warnings import filterwarnings
>>> filterwarnings('error', category=pm.Warning)
>>>
>>> hosts = '127.0.0.1'
>>> port = 3306
>>> db = '*****'
>>> user = 'root'
>>> pw = '****'
>>> ope = pm.connect(host = hosts,
...                               port = port,
...                               db = db,
...                               user = user,
...                               password = pw,
...                               charset = 'utf8mb4')
>>> cursor = ope.cursor()
>>>
>>> sql = 'INSERT IGNORE INTO `db_fan` VALUES (1040140724, 2713582921), (1040140724, 1658632135), (1040140724, 5797386896), (1040140724, 5651860686), (1040140724, 2972805212), (1040140724, 5772420820), (1040140724, 5732820113), (1040140724, 5607417885), (1040140724, 5727563505), (1040140724, 1038473082), (1040140724, 5698742027), (1040140724, 2174810337), (1040140724, 5668873560), (1040140724, 1688464225)'
>>>
>>> try:
...     cursor.execute(sql)
... except pm.Warning as w:
...     ope.commit()
...     print (repr(w))
...
Warning(1062, "Duplicate entry '1040140724-2713582921' for key 'PRIMARY'")

我把密碼是數(shù)據(jù)庫名用星號代替了。如果換成MySqldb也會有同樣的問題。

python的版本是3.5.2.系統(tǒng)是Ubuntu16.04