pgpool: APPARENT DEADLOCK!!! Complete Status: Managed Threads: 3 Active Threads: 3
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: moindba@hotmail.com<mailto:moindba@hotmail.com>
Hi Moin,
On 5/18/21 3:30 AM, Moin Akther wrote:
Dear Team,
We are facing issue whenever application is connecting to pgpool 4^th Node.
This email address is for contributing to the PostgreSQL documentation[1]https://www.postgresql.org/docs/.
The Pgpool project provides contact information on reporting issues here:
https://www.pgpool.net/mediawiki/index.php/Main_Page#Contacts
Thanks,
Jonathan