Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjf6l-0007VS-LC for pgsql-bugs@arkaria.postgresql.org; Mon, 30 Nov 2020 09:04:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kjf6k-0003at-Ja for pgsql-bugs@arkaria.postgresql.org; Mon, 30 Nov 2020 09:04:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjf6k-0003al-Dc for pgsql-bugs@lists.postgresql.org; Mon, 30 Nov 2020 09:04:30 +0000 Received: from smtp02.srv.celeste.fr ([185.5.111.9]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjf6h-0000q5-Jk for pgsql-bugs@lists.postgresql.org; Mon, 30 Nov 2020 09:04:29 +0000 Received: from smtp02.srv.celeste.fr (localhost [127.0.0.1]) by smtp02.srv.celeste.fr (Postfix) with ESMTP id 340EC44B4E; Mon, 30 Nov 2020 10:04:26 +0100 (CET) Received: from [192.168.1.107] (unknown [178.16.171.131]) by smtp02.srv.celeste.fr (Postfix) with ESMTP id 15FF744AC3; Mon, 30 Nov 2020 10:04:26 +0100 (CET) Reply-To: martin.querleu@effisys.fr Subject: Re: Update on To: "David G. Johnston" Cc: PostgreSQL mailing lists References: From: EffiSYS / Martin Querleu Organization: EffiSYS Message-ID: <28447d44-eafd-641f-c881-f1cd5c1f11e2@effisys.fr> Date: Mon, 30 Nov 2020 10:04:30 +0100 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.5.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------D3FCF8164A2B2A6A0A72BDC2" Content-Language: en-US X-Virus-Scanned: ClamAV using ClamSMTP List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------D3FCF8164A2B2A6A0A72BDC2 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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 > > 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.gmail.com > > 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 > > > 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 --------------D3FCF8164A2B2A6A0A72BDC2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
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> 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.gmail.com 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...


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