Flask-MySQLdb与Gunicorn配合运行异常问题求助

Hey there, let’s troubleshoot why your Flask app runs perfectly with python3 app.py but throws errors when using gunicorn. Since you only shared a snippet of the error log, these fixes are tailored to your macOS 10.13 + MySQL 5.7.20 setup:

1. Ensure Gunicorn Uses Your Virtual Environment’s Python #

The most common culprit is that gunicorn is running from your global Python installation instead of your virtualenv, so it can’t access the Flask-MySQLdb/mysqlclient dependencies you installed locally. Here’s how to fix it:

• Activate your virtual environment first: source /path/to/your/venv/bin/activate
• Install gunicorn inside the virtual environment: pip install gunicorn
• Now start gunicorn again: gunicorn --bind 0.0.0.0:8000 app:app

2. Fix MySQL Library Path Issues on macOS #

macOS sometimes blocks gunicorn from accessing MySQL’s dynamic link libraries. You can work around this by setting the DYLD_LIBRARY_PATH environment variable:

• First, confirm your MySQL lib path (usually /usr/local/mysql/lib if you used the official installer)
• Launch gunicorn with the path specified:

  DYLD_LIBRARY_PATH=/usr/local/mysql/lib gunicorn --bind 0.0.0.0:8000 app:app
  

• To make this permanent, add the export line to your virtualenv’s activate script:
  Open /path/to/your/venv/bin/activate and append:

  export DYLD_LIBRARY_PATH="/usr/local/mysql/lib:$DYLD_LIBRARY_PATH"
  

3. Handle Database Connections in Gunicorn’s Multi-Process Mode #

Gunicorn defaults to multi-worker mode, and Flask-MySQLdb can break if you initialize the database connection globally (since connections aren’t shared across processes). Try these fixes:

• Test with a single worker first:

  gunicorn --workers 1 --bind 0.0.0.0:8000 app:app
  

  If this works, the issue is multi-process connection sharing.
• Reinitialize connections per request:
  Modify your app.py to use a before_request hook to create a fresh connection for each worker/request:

  from flask import Flask
  from flask_mysqldb import MySQL
  
  app = Flask(__name__)
  # Configure your MySQL settings here
  app.config['MYSQL_HOST'] = 'localhost'
  app.config['MYSQL_USER'] = 'your_username'
  app.config['MYSQL_PASSWORD'] = 'your_password'
  app.config['MYSQL_DB'] = 'your_database'
  
  mysql = MySQL()
  
  @app.before_request
  def init_db_connection():
      if not hasattr(mysql, 'connection') or mysql.connection.closed:
          mysql.init_app(app)
  

4. Recompile mysqlclient for Your Virtual Environment #

If mysqlclient was compiled with your global Python, it might not work with your virtualenv’s interpreter. Reinstall it with explicit MySQL paths:

• First, make sure you have Xcode command line tools installed: xcode-select --install
• Activate your virtualenv, then uninstall the existing mysqlclient: pip uninstall mysqlclient
• Reinstall with MySQL include/lib paths:

  pip install mysqlclient --global-option=build_ext --global-option="-I/usr/local/mysql/include" --global-option="-L/usr/local/mysql/lib"
  

内容的提问来源于stack exchange，提问作者Parthapratim Neog