public inbox for [email protected]  
help / color / mirror / Atom feed
From: Moin Akther <[email protected]>
To: [email protected] <[email protected]>
Subject: pgpool: APPARENT DEADLOCK!!! Complete Status:  Managed Threads: 3 Active Threads: 3
Date: Tue, 18 May 2021 07:30:24 +0000
Message-ID: <[email protected]> (raw)

Dear Team,

We are facing issue whenever application is connecting to pgpool 4th Node.

We have 4 Applications and 4 pgpool nodes, at any point of time Application can able to connect only 3 pgpool nodes, when we are starting application services on 4 pgpool node we are getting below error messages on application logs and also psql command on pgpool is getting hanged..

Application Logs:

APPARENT DEADLOCK!!! Complete Status:
                Managed Threads: 3
                Active Threads: 3

APPARENT  DEADLOCK!!! Creating emergency threads for unassigned pending tasks !
[Timer-0] [WARN] [async.ThreadPoolAsynchronousRunner] – (in deadlocked PoolThread) failed to complete in maximum time 6000ms. Trying interrupt().






Thanks and Best Regards,

Moin Akther

PostgreSQL DBA

Email: [email protected]<mailto:[email protected]>




reply

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 using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pgpool: APPARENT DEADLOCK!!! Complete Status:  Managed Threads: 3 Active Threads: 3
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox