Application crashing due to idle connection

Поиск
Список
Период
Сортировка
От itishree sukla
Тема Application crashing due to idle connection
Дата
Msg-id CAL-g6VQ-We8gXgW7Q77_uByiLSHbOY=5KQyUPthE_eEgVchfUQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Application crashing due to idle connection
Список pgsql-general
Дерево обсуждения
Hi all,

Our application is crashing due to lot of idle connection from last 1 month it is very frequent.

When i checked pg_stat_activity I found below query :SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid:

is on idle state number of time. After killing connection this query is also vanishing  from pg_stat_activity.

Can any one please give me some clue what cloud be the possible reason, and how to get rid of this problem.

Thanks in advance.

Regards,
Itishree



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_restore: custom archiver unexpected end of file , ERROR: missing data for column
Следующее
От: David G Johnston
Дата:
Сообщение: Re: Application crashing due to idle connection