| From: | Stefan Knecht <knecht(dot)stefan(at)gmail(dot)com> |
|---|---|
| To: | Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com> |
| Cc: | psycopg(at)postgresql(dot)org |
| Subject: | Re: Puzzling situation with threads and psycopg2 on RDS |
| Date: | 2022-10-17 12:08:27 |
| Message-ID: | CAP50yQ8iGb+eCeUjpE2h+t2UR+Lqu2cfoqAq0B==iS9Q+vEEZg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | psycopg |
Ciao Daniele
Thanks for looking at this.
> I understand this happens on RDS. Does it happen on normal Postgres
> too, from a normal process (not some serverless thing?)
>
>
I'll test this now.
> Are there processes/forks involved?
No, just Python's basic threading.
> 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).
>
>
This is psycopg 3.1.3
And I just realized that all the other threading code I've got is on
psycopg2-binary 2.8. Has there something changed with threads in v3 ?
Stefan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Knecht | 2022-10-17 12:13:37 | Re: Puzzling situation with threads and psycopg2 on RDS |
| Previous Message | Daniele Varrazzo | 2022-10-17 11:55:53 | Re: Puzzling situation with threads and psycopg2 on RDS |