一尘不染

InterfaceError(0,'')

django

我已经使用Django构建了一个站点,并且在尝试执行查询时收到此烦人的错误。

如果我重新启动Apache服务器,该错误将在短时间内消失。

Traceback:
File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response
100.                     response = callback(request, *callback_args, **callback_kwargs)
File "/home/fran/cron/views/set_caches.py" in set_caches
24.         cursor.execute(query, [category['id']])
File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py" in execute
15.             return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py" in execute
86.             return self.cursor.execute(query, args)
File "build/bdist.linux-i686/egg/MySQLdb/cursors.py" in execute
155.         charset = db.character_set_name()

Exception Type: InterfaceError at /blablabla/
Exception Value: (0, '')

阅读 331

收藏
2020-03-30

共1个答案

一尘不染

这是由全局游标引起的。尝试在每个方法内创建和关闭游标,这需要原始查询。

cursor = connection.cursor()
cursor.execute(query)
cursor.close()
2020-03-30