ProcSignalBarrier and ITC Issue

Started by Brahmaiah psqlabout 1 year ago3 messagesgeneral
Jump to latest
#1Brahmaiah psql
brahmaiahpsql@gmail.com

Hi Postgres Community,

I Face error the ProcSignalBarrier and IPC

When we are dropping the database, it is not dropped. Also, the database 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.

Thank you,
Brahmaiah K

#2Adrian Klaver
adrian.klaver@aklaver.com
In reply to: Brahmaiah psql (#1)
Re: ProcSignalBarrier and ITC Issue

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

#3Torsten Förtsch
tfoertsch123@gmail.com
In reply to: Adrian Klaver (#2)
Re: ProcSignalBarrier and ITC Issue

Could be this one:
/messages/by-id/CA+kvmZELXQ4ZD3U=XCXuG3KvFgkuPoN1QrEj8c-rMRodrLOnsg@mail.gmail.com

Should be fixed in 15.2

On Fri, May 23, 2025 at 2:19 AM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

Show quoted text

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