Hi Stefan, On Mon, 17 Oct 2022 at 12:25, Stefan Knecht <[email protected]> wrote: > > Hello > > I have this situation now, that I can't wrap my head around and I'm hoping > someone can shed some light onto what is going on, before I spend hours > trying to reproduce this by taking the code apart into a test case. > > A few facts: > > - I've got a piece of code split into several classes. > - It initializes a dynamic number of threads. For the sake of this topic, > I'll stick to just 2 threads to illustrate. > - Each thread creates its own database connection (psycopg2.connect()) when > it's started > - Each thread, for each task it does, prints out its own name and the PID of > the database session. ...
> Perhaps you can already see the problem. One thread randomly disconnects. I understand this happens on RDS. Does it happen on normal Postgres too, from a normal process (not some serverless thing?) Are there processes/forks involved? Which version of psycopg are you using? Some old one have problems with closing connections in multiprocess environments. That was fixed in psycopg 2.8 (#829). Cheers -- Daniele
