MIME-Version: 1.0
References: 
 <CAP50yQ-PUwP80+awO-U3Ud45HCZHZ=fjK3L2iWh4CfcEPF1p6A@mail.gmail.com>
 <CA+mi_8aX4FsE6=HWF08tf579G8Wgg9cQOtN2BkmtTehyxAb5FA@mail.gmail.com>
In-Reply-To: 
 <CA+mi_8aX4FsE6=HWF08tf579G8Wgg9cQOtN2BkmtTehyxAb5FA@mail.gmail.com>
From: Stefan Knecht <knecht.stefan@gmail.com>
Date: Mon, 17 Oct 2022 19:08:27 +0700
Message-ID: 
 <CAP50yQ8iGb+eCeUjpE2h+t2UR+Lqu2cfoqAq0B==iS9Q+vEEZg@mail.gmail.com>
Subject: Re: Puzzling situation with threads and psycopg2 on RDS
To: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Cc: psycopg@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e46c3305eb39d5e1"
Archived-At: 
 <https://www.postgresql.org/message-id/CAP50yQ8iGb%2BeCeUjpE2h%2Bt2UR%2BLqu2cfoqAq0B%3D%3DiS9Q%2BvEEZg%40mail.gmail.com>
Precedence: bulk

--000000000000e46c3305eb39d5e1
Content-Type: text/plain; charset="UTF-8"

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

--000000000000e46c3305eb39d5e1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>Ciao Daniele</div><div><br></div><di=
v>Thanks for looking at this.</div><div><br></div><br></div><div class=3D"g=
mail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
I understand this happens on RDS. Does it happen on normal Postgres<br>
too, from a normal process (not some serverless thing?)<br>
<br></blockquote><div><br></div><div>I&#39;ll test this now. <br></div><div=
>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px =
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Are there processes/forks involved? </blockquote><div><br></div><div>No, ju=
st Python&#39;s basic threading.<br></div><div>=C2=A0</div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex">Which version of psycopg are you<br>
using? Some old one have problems with closing connections in<br>
multiprocess environments. That was fixed in psycopg 2.8 (#829).<br>
<br></blockquote><div><br></div><div>This is psycopg 3.1.3</div><div>=C2=A0=
</div><div>And I just realized that all the other threading code I&#39;ve g=
ot is on psycopg2-binary 2.8. Has there something changed with threads in v=
3 ?</div><div><br></div><div><br></div><div><br></div><div>Stefan</div><br>=
</div></div>

--000000000000e46c3305eb39d5e1--