Re: FATAL: failed to create a backend connection

Поиск
Список
Период
Сортировка
От Pavan Teja
Тема Re: FATAL: failed to create a backend connection
Дата
Msg-id CACh9nsZhKoknZ6DYbJoXjzyajMojN2X_xABxwnMXp+UMQLrn_A@mail.gmail.com
обсуждение исходный текст
Ответ на FATAL: failed to create a backend connection  (Vikas Sharma <shavikas@gmail.com>)
Список pgsql-general


On Feb 2, 2018 5:57 PM, "Vikas Sharma" <shavikas@gmail.com> wrote:
Hi There,

We are using Postgresql 9.3 with pgpool-II-93-3.5.10.
One Master replicating to 3 Standbys using streaming replication. Pgpool is used for load balancing only.

Lately we are seeing below on application servers.

Caused by: org.postgresql.util.PSQLException: FATAL: failed to create a backend connection
Detail: executing failover on backend

Are we hitting the max_connections in PgSql instance or pgpool has reached to max_connections and can't spawn more

Please advise.

Regards
Vikas

    Hi,
           It seems like there is a disagreement between postgres and pgpool as to where the Unix domain sockets for talking to postgres ought to be found. 
 It's a situation like it can connect to postgres buy not pgpool, as it was directing all traffic to the local postgres node.
1) Check whether any of the postgres backends are cancelling query with 'statement time out' error.

2) If statement time out is not set in postgres.conf file then the application might have altered.

3) Check for any long running queries are being cancelled by Server.

Regards,
Pavan



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

Предыдущее
От: Vikas Sharma
Дата:
Сообщение: FATAL: failed to create a backend connection
Следующее
От: Rowan Seymour
Дата:
Сообщение: Increasing size of array items without locking