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 <ldave...@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-discuss+unsubscr...@googlegroups.com
> <mailto:pylons-discuss+unsubscr...@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/A4B81718-3D59-4697-B7AE-A9ECF959AF9C%40luhn.com.
