uWSGI, Flask, sqlalchemy, and postgres: SSL error: decryption failed or bad record mac

by

The issue ended up being uwsgi’s forking.

When working with multiple processes with a master process, uwsgi initializes the application in the master process and then copies the application over to each worker process. The problem is if you open a database connection when initializing your application, you then have multiple processes sharing the same connection, which causes the error above.

The solution is to set the lazy configuration option for uwsgi, which forces a complete loading of the application in each process:

lazy

Set lazy mode (load apps in workers instead of master).

This option may have memory usage implications as Copy-on-Write semantics can not be used. When lazy is enabled, only workers will be reloaded by uWSGI’s reload signals; the master will remain alive. As such, uWSGI configuration changes are not picked up on reload by the master.

There’s also a lazy-apps option:

lazy-apps

Load apps in each worker instead of the master.

This option may have memory usage implications as Copy-on-Write semantics can not be used. Unlike lazy, this only affects the way applications are loaded, not master’s behavior on reload.

This uwsgi configuration ended up working for me:

[uwsgi]
socket = /tmp/my_app.sock
logto = /var/log/my_app.log
plugins = python3
virtualenv =  /path/to/my/venv
pythonpath = /path/to/my/app
wsgi-file = /path/to/my/app/application.py
callable = app
max-requests = 1000
chmod-socket = 666
chown-socket = www-data:www-data
master = true
processes = 2
no-orphans = true
log-date = true
uid = www-data
gid = www-data

# the fix
lazy = true
lazy-apps = true

More Related Contents:

  1. Are a WSGI server and HTTP server required to serve a Flask app?
  2. Flask application traceback doesn’t show up in server log
  3. SQLAlchemy support of Postgres Schemas
  4. uwsgi upstart on amazon linux
  5. SQLAlchemy, Psycopg2 and Postgresql COPY
  6. in VS Code ImportError: cannot import name ‘Mapping’ from ‘collections’
  7. X-Forwarded-Proto and Flask
  8. Setting application_name on Postgres/SQLAlchemy
  9. PostgreSQL LIKE query performance variations
  10. Calculating and saving space in PostgreSQL
  11. SQLAlchemy create_all() does not create tables
  12. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  13. I forgot the password I entered during postgres installation
  14. how to emulate “insert ignore” and “on duplicate key update” (sql merge) with postgresql?
  15. Possible reason for NGINX 499 error codes
  16. How do I efficiently select the previous non-null value?
  17. How do I do large non-blocking updates in PostgreSQL?
  18. How to configure PostgreSQL to accept all incoming connections
  19. Dynamic SQL (EXECUTE) as condition for IF statement
  20. Complex foreign key constraint in SQLAlchemy
  21. Returning from a function with OUT parameter
  22. ERROR: permission denied for relation tablename on Postgres while trying a SELECT as a readonly user
  23. Connection problems with SQLAlchemy and multiple processes
  24. Joining Results from Two Separate Databases
  25. Postgresql query array of objects in JSONB field
  26. Multicolumn index on 3 fields with heterogenous data types
  27. Select from a table variable
  28. Spring Docker container cannot access Postgres Docker container
  29. PostgreSQL composite primary key
  30. flask sqlalchemy query with keyword as variable

Leave a Comment