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

Поиск
Список
Период
Сортировка
От Moin Akther
Тема pgpool: APPARENT DEADLOCK!!! Complete Status: Managed Threads: 3 Active Threads: 3
Дата
Msg-id 903EC80E-FE9B-4B22-8591-AF6829E018D7@hotmail.com
обсуждение исходный текст
Ответы Re: pgpool: APPARENT DEADLOCK!!! Complete Status: Managed Threads: 3 Active Threads: 3  ("Jonathan S. Katz" <jkatz@postgresql.org>)
Список pgsql-docs
Дерево обсуждения

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

 

 

В списке pgsql-docs по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: more detailed description of tup_returned and tup_fetched
Следующее
От: Masahiro Ikeda
Дата:
Сообщение: Re: more detailed description of tup_returned and tup_fetched