Python 和 Django OperationalError(2006，'MySQL 服务器已经消失')-数据库问题

Python and Django OperationalError (2006, #39;MySQL server has gone away#39;)(Python 和 Django OperationalError(2006，MySQL 服务器已经消失))

本文介绍了Python 和 Django OperationalError(2006，'MySQL 服务器已经消失')的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

原文:我最近开始从我的一些旧代码中获取 MySQL OperationalErrors，但似乎无法追溯到问题所在.由于它之前可以工作，我认为它可能是一个破坏某些东西的软件更新.我正在将 python 2.7 与 django runfcgi 与 nginx 一起使用.这是我的原始代码:

Original: I have recently started getting MySQL OperationalErrors from some of my old code and cannot seem to trace back the problem. Since it was working before, I thought it may have been a software update that broke something. I am using python 2.7 with django runfcgi with nginx. Here is my original code:

views.py

DBNAME = "test"
DBIP = "localhost"
DBUSER = "django"
DBPASS = "password"
db = MySQLdb.connect(DBIP,DBUSER,DBPASS,DBNAME)
cursor = db.cursor()

def list(request):
    statement = "SELECT item from table where selected = 1"
    cursor.execute(statement)
    results = cursor.fetchall()

我尝试了以下方法，但还是不行:

I have tried the following, but it still does not work:

views.py

class DB:
    conn = None
    DBNAME = "test"
    DBIP = "localhost"
    DBUSER = "django"
    DBPASS = "password"
def connect(self):
    self.conn = MySQLdb.connect(DBIP,DBUSER,DBPASS,DBNAME)
def cursor(self):
    try:
        return self.conn.cursor()
    except (AttributeError, MySQLdb.OperationalError):
        self.connect()
        return self.conn.cursor()

db = DB()
cursor = db.cursor()

def list(request):
    cursor = db.cursor()
    statement = "SELECT item from table where selected = 1"
    cursor.execute(statement)
    results = cursor.fetchall()

目前，我唯一的解决方法是在每个使用 mysql 的函数中执行 MySQLdb.connect().我还注意到，当使用 django 的 manage.py runserver 时，我不会遇到这个问题，而 nginx 会抛出这些错误.我怀疑我的连接超时，因为 list() 在启动服务器的几秒钟内被调用.我正在使用的软件是否有任何更新会导致此问题中断/是否有任何解决方案?

Currently, my only workaround is to do MySQLdb.connect() in each function that uses mysql. Also I noticed that when using django's manage.py runserver, I would not have this problem while nginx would throw these errors. I doubt that I am timing out with the connection because list() is being called within seconds of starting the server up. Were there any updates to the software I am using that would cause this to break/is there any fix for this?

我意识到我最近写了一个中间件来守护一个函数，这就是问题的原因.但是，我无法弄清楚原因.这是中间件的代码

I realized that I recently wrote a piece of middle-ware to daemonize a function and this was the cause of the problem. However, I cannot figure out why. Here is the code for the middle-ware

def process_request_handler(sender, **kwargs):
    t = threading.Thread(target=dispatch.execute,
        args=[kwargs['nodes'],kwargs['callback']],
        kwargs={})
    t.setDaemon(True)
    t.start()
    return
process_request.connect(process_request_handler)

Python 和 Django OperationalError(2006，'MySQL 服务器已经消失')

问题描述

推荐答案

基础教程推荐