Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uIOmW-003nav-Pq for pgsql-general@arkaria.postgresql.org; Fri, 23 May 2025 09:33:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uIOmU-000DuA-Iq for pgsql-general@arkaria.postgresql.org; Fri, 23 May 2025 09:33:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uIOmU-000Dtz-8J for pgsql-general@lists.postgresql.org; Fri, 23 May 2025 09:33:34 +0000 Received: from mail-lf1-x133.google.com ([2a00:1450:4864:20::133]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uIOmQ-000VNO-2n for pgsql-general@lists.postgresql.org; Fri, 23 May 2025 09:33:33 +0000 Received: by mail-lf1-x133.google.com with SMTP id 2adb3069b0e04-549b116321aso10797757e87.3 for ; Fri, 23 May 2025 02:33:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1747992809; x=1748597609; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=9c5A/4IdhvgfjqyG6bkhqwmdn5UVdMS9qqcvhm2lLA4=; b=XRaK4XWfNnaY2mqfLshGA82V9zhTJczFVuftpY337uD32F/PiAkRqGUgxRkyLtVQJs CXqj/J4he0nBjzPCgx5X+O0Vo30Vr/cvvLQCNMu098reCBqU6DqIpmK0HRFaHioDGHuT OZG+d6E57oYTPxtSBekXRFUg90yOgZ6yEFb6KCM6v1AEsV9pwF4v5vaGit5bYfHNM0Wr aVWv/50U4TypyYYUDqllwvzfj3g/SEOEAQQcY+X4vtd8zm7S5hF61F4un6NhZ0pgVLmx ibhwU+Aett7JVtKmgQtpRYRtmBNtApcgW9TdQdqlRcT0blVBnJjZ6/1MdlCH0wCjOsx8 2evQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747992809; x=1748597609; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=9c5A/4IdhvgfjqyG6bkhqwmdn5UVdMS9qqcvhm2lLA4=; b=emgKQBRXuiZGTiE8rrf08L+3skk6fRGCEp00eUtWXfcswfjZvC++a3uPV2Z7C/2IiH 19eG90t2ShaBBTWxpSn3CbzFo3JvLoJm0ctU0e3tXGGXIv1R2jYtLPk5oMT2g9sVrZFk 46BrvsC/mpzjqCziPxr6OlAbjZPv9TGabWAs+savCXjjs0oynaSCr0+a5f69BgMKqB2B ZO5d8CCt0XXng3h/VxK4bruyB7R2EZkRQ9mjG4/lrhMQVVh67tweto/JzJUaB7Sn3q/Z xcBo3GmRVZwy5sRTRjI9JC6Mv9MaSFoH1krAaKPS2tX1GaefRdgERcA42iVdlXs9u+kU eIaA== X-Forwarded-Encrypted: i=1; AJvYcCXDPa+NYKEbJtGOTYT1WrkIQIU/CianQ2KdRf61D+ZhhIuvGXbEM/bx3TvbPXILldVjK3YWMlU9RHSGCwrM@lists.postgresql.org X-Gm-Message-State: AOJu0YzDvDX0cm7emJnG0Xi0hfS8K79+6jJcyi9JvQIpAkz8yNW6B4I8 QH3CPuV1dePwmSsxoVFs8MY55sK6UZ7pBFoK6kyeoTLJv/nJ4t/G1OPnF40B6BuC9WTFaclA9oD NaIVs00u3xra94SBJ8ypyfZVce79FGQ== X-Gm-Gg: ASbGncsefe+avs90brfMNEUrL0tJSR4B9LR3V3655jzbQ1Tvsvajo/FLDq8LYKlosht DcMZtkKSESlNsEQBV5CxVZfVvi6KcG2tBG+ckS08hmTKyPYfSh6+YzZQMqzBw4FhTd/E6lCY3+Q cix/fQqfhiHv3vUZ2+TVhE+R9iJIATHU+4OIB+YDoK3d2VGCvxZyUZXB4AKprcZUGY X-Google-Smtp-Source: AGHT+IHg9YfxKFVh5TDbcgiXTGhXkGsrIraUzsC0xoFYj9nX1FGi2IPl9EIKIlQyb5TsrE7MdcTLa3BTEsrc4UQN0ZU= X-Received: by 2002:a05:6512:31d6:b0:549:8809:ee32 with SMTP id 2adb3069b0e04-550e97cc50amr10283705e87.22.1747992808595; Fri, 23 May 2025 02:33:28 -0700 (PDT) MIME-Version: 1.0 References: <6b61ddc1-3857-4045-b991-59b2478556ec@aklaver.com> In-Reply-To: <6b61ddc1-3857-4045-b991-59b2478556ec@aklaver.com> From: =?UTF-8?Q?Torsten_F=C3=B6rtsch?= Date: Fri, 23 May 2025 11:33:17 +0200 X-Gm-Features: AX0GCFumdjwzerVer970R1pqKjML-HIn0geeJxJGJjh5hmmRIxCKzbITLOaE0gU Message-ID: Subject: Re: ProcSignalBarrier and ITC Issue To: Adrian Klaver Cc: Brahmaiah psql , webmaster@postgresql.org, pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000006d28cc0635ca4a6e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006d28cc0635ca4a6e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Could be this one: https://www.postgresql.org/message-id/CA%2BkvmZELXQ4ZD3U%3DXCXuG3KvFgkuPoN1= QrEj8c-rMRodrLOnsg%40mail.gmail.com Should be fixed in 15.2 On Fri, May 23, 2025 at 2:19=E2=80=AFAM Adrian Klaver wrote: > On 5/22/25 12:43, Brahmaiah psql wrote: > > Hi Postgres Community, > > > > I Face error the ProcSignalBarrier and IPC > > > > When we are dropping the database, it is not dropped. Also, the databas= e > > is not connecting. The log file shows this error(LOG: still waiting for > > backend with PID 4077 to accept ProcSignalBarrier). Now how to debug > > this error. please support any one to this error. > > This is going to need a lot more information, for a start: > > 1) Postgres version. > > 2) Is the community version or a fork/hosted version? > > 3) The client being used and the complete query/command/code that is > dropping the database. > > 4) The complete log message. > > > > > Thank you, > > Brahmaiah K > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > > > --0000000000006d28cc0635ca4a6e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Fri, May 23, 2025 = at 2:19=E2=80=AFAM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 5/22/25 12:43, Brahmaiah psql wrote: > Hi Postgres Community,
>
> I Face error the ProcSignalBarrier and IPC
>
> When we are dropping the database, it is not dropped. Also, the databa= se
> is not connecting. The log file shows this error(LOG: still waiting fo= r
> backend with PID 4077 to accept ProcSignalBarrier). Now how to debug <= br> > this error. please support any one to this error.

This is going to need a lot more information, for a start:

1) Postgres version.

2) Is the community version or a fork/hosted version?

3) The client being used and the complete query/command/code that is
dropping the database.

4) The complete log message.

>
> Thank=C2=A0you,
> Brahmaiah K

--
Adrian Klaver
adrian.klave= r@aklaver.com



--0000000000006d28cc0635ca4a6e--