Thank you Theron, I'm not using "--preload", actually not doing anything special, since I'm trying to use Gunicorn as a drop-in replacement for Waitress, like I always did, BUT I'm realizing that I was using `psycopg2` in the past, whereas I`m using `psycopg` (i.e. version 3) now, and version 3 creates a pool of connections. That must be the explanation why it worked then, but not anymore. With `psycopg2`, I had a connection created by each worker. Now I probably have a shared pool of connections.
Laurent. Le jeudi 16 novembre 2023 à 18:18:59 UTC+1, Theron Luhn a écrit : > If you aren’t using `—preload` then gunicorn should load the application > fresh for each worker and you shouldn’t have any issues. > > If you are using preload, you have to recreate any existing connections on > fork. For SQLAlchemy I use: > > def after_fork(registry): > registry['db_engine'].pool.recreate() > > def includeme(config): > os.register_at_fork( > after_in_child=functools.partial(after_fork, config.registry), > ) > > > — Theron > > > > On Nov 16, 2023, at 7:41 AM, Laurent Daverio <ldav...@gmail.com> wrote: > > Hello list, > > this page seems to describe perfectly a problem I've stumbled on: > > > https://stackoverflow.com/questions/64995178/decryption-failed-or-bad-record-mac-in-multiprocessing > > Namely, if you deploy with Gunicorn a Pyramid + PostgreSQL app based on > the standard cookiecutter, you will run into problems, because the > connection to the DB can't be shared between the processes, so each process > needs to have its own connection to the DB. > > Before I start trying to develop a workaround, has anybody encountered the > problem? How should I modify my app to make it compatible with both > Waitress and Gunicorn? > > Thanks in advance, > > Laurent. > > -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to pylons-discus...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/pylons-discuss/CAB7cU6z1DqHpEazrrJ1sPHmSPQvYtfkmeKfsJP_jLmsDyPA96w%40mail.gmail.com > > <https://groups.google.com/d/msgid/pylons-discuss/CAB7cU6z1DqHpEazrrJ1sPHmSPQvYtfkmeKfsJP_jLmsDyPA96w%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > > -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to pylons-discuss+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/e56a6f67-64ec-4a2b-9ebf-9947bdf993d6n%40googlegroups.com.