From: jaime soler <jaime.soler@gmail.com>
To: Ankur Kaushik <ankurkaushik@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Application hangs
Date: Mon, 01 Feb 2016 14:00:19 +0100
Message-ID: <1454331619.5847.100.camel@gmail.com> (raw)
In-Reply-To: <CALXoLqzy4Hh3Z+zAc1dNXX61QXgrq+t_K5uyCsuPSsf_+qH+Bw@mail.gmail.com>
References: <CALXoLqzy4Hh3Z+zAc1dNXX61QXgrq+t_K5uyCsuPSsf_+qH+Bw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
El vie, 22-01-2016 a las 09:17 +0530, Ankur Kaushik escribió:
>
> Hi ,
>
> We are facing problem in our Live server , Applications hangs after
> some time
>
> Please Let me know Is this database related or Application ?
>
> Process list shows as below
>
> postgres=# select count(*) from pg_stat_activity ;
> count
> -------
> 37
> (1 row)
>
>
> "SELECT NULL AS TABLE_CAT" and "SHOW TRANSACTION ISOLATION LEVEL",
> Type query increases as
>
>
>
> 16384 | 15011 | idle | SELECT NULL AS TABLE_CAT, n.nspname AS
> TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR
> n.nspname = 'information_schema' WHEN true THEN CASE WHE
> N n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN
> CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM
> VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL
> END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN
> 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL
> END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPOR
> ARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN
> 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL
> END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TAB
> LE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN
> 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm'
> THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL
> END AS TABLE_TYPE, d.description AS REMARKS FROM
> pg_catalog.pg_namespace n, pg_catalog.pg_class c L
> 16384 | 15012 | idle | SELECT NULL AS TABLE_CAT, n.nspname AS
> TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR
> n.nspname = 'information_schema' WHEN true THEN CASE WHE
> N n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN
> CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM
> VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL
> END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN
> 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL
> END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPOR
> ARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN
> 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL
> END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TAB
> LE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN
> 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm'
> THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL
> END AS TABLE_TYPE, d.description AS REMARKS FROM
> pg_catalog.pg_namespace n, pg_catalog.pg_class c L
> 16384 | 15013 | idle | SELECT NULL AS TABLE_CAT, n.nspname AS
> TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR
> n.nspname = 'information_schema' WHEN true THEN CASE WHE
> N n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN
> CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM
> VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL
> END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN
> 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL
> END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPOR
> ARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN
> 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL
> END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TAB
> LE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN
> 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm'
> THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL
> END AS TABLE_TYPE, d.description AS REMARKS FROM
> pg_catalog.pg_namespace n, pg_catalog.pg_class c L
> 16384 | 15014 | idle | SELECT NULL AS TABLE_CAT, n.nspname AS
> TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR
> n.nspname = 'information_schema' WHEN true THEN CASE WHE
> N n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN
> CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM
> VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL
> END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN
> 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL
> END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPOR
> ARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN
> 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL
> END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TAB
> LE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN
> 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm'
> THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL
> END AS TABLE_TYPE, d.description AS REMARKS FROM
> pg_catalog.pg_namespace n, pg_catalog.pg_class c L
Please look that all activity on database server are select on postgres
catalog and their state are idle, so it looks like there is no problem
related to dataserver.
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: pgsql-admin@postgresql.org
Cc: jaime.soler@gmail.com, ankurkaushik@gmail.com
Subject: Re: Application hangs
In-Reply-To: <1454331619.5847.100.camel@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox