From: EffiSYS / Martin Querleu <martin.querleu@effisys.fr>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: Update on
Date: Mon, 30 Nov 2020 10:04:30 +0100
Message-ID: <28447d44-eafd-641f-c881-f1cd5c1f11e2@effisys.fr> (raw)
In-Reply-To: <CAKFQuwZjQF3fmdTUqQ6nsZkDhN0azLvnn+Oecgvk7_7GcYoakw@mail.gmail.com>
References: <ec385de1-663b-4304-b288-4b225d0fd9a8@effisys.fr>
<CAKFQuwZjQF3fmdTUqQ6nsZkDhN0azLvnn+Oecgvk7_7GcYoakw@mail.gmail.com>
Hello David
After reading the commit I understand it modifies the management so that
parallel workers don't count against connection_limit so I don't
understand why I experience the problem
What do you mean by "hijacked"?
Best regards
Martin
On 27/11/2020 19:30, David G. Johnston wrote:
> On Friday, November 27, 2020, EffiSYS / Martin Querleu
> <martin.querleu@effisys.fr <mailto:martin.querleu@effisys.fr>> wrote:
>
> Hello
>
> We use PG 11.9 and are encountering the problem with connection
> limit and parallel workers aborting a totally valid query
> ("CONTEXT: parallel worker" error)
>
> I found there was a thread concerning this problem and even a
> patch was developed:
> https://www.postgresql.org/message-id/CAB7nPqQKJPgNkg0VQguUP1u%2BpDdk1qF16Qh5MtDQEtSMG4S-fg%40mail.g...
> <https://www.postgresql.org/message-id/CAB7nPqQKJPgNkg0VQguUP1u%2BpDdk1qF16Qh5MtDQEtSMG4S-fg%40mail.g...;
> but no news since 2017
>
> Do you know the status of the patch or a modification to remove
> the parallel worker from the connection count against user (also
> server?) CONNECTION_LIMIT or to just not launch workers if not
> possible?
>
>
> That thread was resolved with a committed patch [1] mid-thread, then
> got hijacked a bit...
>
> https://github.com/postgres/postgres/commit/f1169ab501ce90e035a7c6489013a1d4c250ac92
> <https://github.com/postgres/postgres/commit/f1169ab501ce90e035a7c6489013a1d4c250ac92;
>
> David J.
>
--
Martin Querleu - Directeur Général
EffiSYS (www.effitrace.fr - www.logistique-e-commerce.fr)
martin.querleu@effisys.fr
3, rue Gustave Delory
59000 Lille
Tél: +33 9 54 28 38 76
Vous rencontrez un problème d'utilisation sur effitr@ce?
=====> écrivez à support@effisys.fr
Vous rencontrez un problème technique au niveau des échanges de données?
=====> écrivez à supervision@effisys.fr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-bugs@postgresql.org
Cc: martin.querleu@effisys.fr, david.g.johnston@gmail.com
Subject: Re: Update on
In-Reply-To: <28447d44-eafd-641f-c881-f1cd5c1f11e2@effisys.fr>
References: <ec385de1-663b-4304-b288-4b225d0fd9a8@effisys.fr> <CAKFQuwZjQF3fmdTUqQ6nsZkDhN0azLvnn+Oecgvk7_7GcYoakw@mail.gmail.com> <28447d44-eafd-641f-c881-f1cd5c1f11e2@effisys.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox