MIME-Version: 1.0
References: 
 <CAP50yQ-PUwP80+awO-U3Ud45HCZHZ=fjK3L2iWh4CfcEPF1p6A@mail.gmail.com>
 <CA+mi_8aX4FsE6=HWF08tf579G8Wgg9cQOtN2BkmtTehyxAb5FA@mail.gmail.com>
 <CAP50yQ8iGb+eCeUjpE2h+t2UR+Lqu2cfoqAq0B==iS9Q+vEEZg@mail.gmail.com>
In-Reply-To: 
 <CAP50yQ8iGb+eCeUjpE2h+t2UR+Lqu2cfoqAq0B==iS9Q+vEEZg@mail.gmail.com>
From: Stefan Knecht <knecht.stefan@gmail.com>
Date: Mon, 17 Oct 2022 19:13:37 +0700
Message-ID: 
 <CAP50yQ8Kva5QLrGfNGzcphradbAEwDRoKfxCJeRcR2tyqrK=MA@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="00000000000050308f05eb39e80c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAP50yQ8Kva5QLrGfNGzcphradbAEwDRoKfxCJeRcR2tyqrK%3DMA%40mail.gmail.com>
Precedence: bulk

--00000000000050308f05eb39e80c
Content-Type: text/plain; charset="UTF-8"

Exact same behavior with psycopg2-binary 2.9.4.


On Mon, Oct 17, 2022 at 7:08 PM Stefan Knecht <knecht.stefan@gmail.com>
wrote:

> 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
>
>

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

<div dir=3D"ltr"><div>Exact same behavior with psycopg2-binary 2.9.4.</div>=
<div><br></div><div><br></div></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Mon, Oct 17, 2022 at 7:08 PM Stefan Knecht=
 &lt;<a href=3D"mailto:knecht.stefan@gmail.com">knecht.stefan@gmail.com</a>=
&gt; wrote:<br></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"><div=
 dir=3D"ltr"><div dir=3D"ltr"><div>Ciao Daniele</div><div><br></div><div>Th=
anks for looking at this.</div><div><br></div><br></div><div class=3D"gmail=
_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>
</blockquote></div>

--00000000000050308f05eb39e80c--