Re: bug report: All queries incorrectly shown as blocking in server status - Mailing list pgadmin-support

Sachin, can you look into this please? Thanks.

On Thu, Oct 25, 2012 at 11:08 PM, Chris St Denis <chris@ctgameinfo.com> wrote:
> Platform: Windows 7
> Language: English
> Dist: Binary Windows download from official site
> Version: 1.16.0
>
>
> As shown in attached screenshot.png all queries are shown as blocked by one
> of my queries. This is obviously incorrect since idle queries and queries
> from different databases are shown as blocked.
>
> A select from pg_stat_activity confirms that only 1 query (49244) is
> actually waiting (it is likely it is waiting on the 47825 that they are all
> reported as waiting on)
>
> select pid, waiting, state from pg_stat_activity;
>   pid  | waiting | state
> -------+---------+--------
>  58614 | f       | idle
>  47225 | f       | idle
>  48655 | f       | idle
>  33051 | f       | idle
>  58615 | f       | idle
>  58726 | f       | idle
>  48306 | f       | idle
>  33054 | f       | idle
>  48865 | f       | idle
>  47819 | f       | active
>  53037 | f       | idle
>  47820 | f       | active
>  49244 | t       | active
>  45059 | f       | active
>  44561 | f       | idle
>  55098 | f       | idle
>  47822 | f       | active
>  52394 | f       | idle
>  55058 | f       | idle
>  34636 | f       | idle
>  34642 | f       | idle
>  45180 | f       | idle
>  34718 | f       | idle
>  45201 | f       | idle
>  45585 | f       | idle
>  44131 | f       | idle
>  52395 | f       | idle
>  50221 | f       | idle
>  45397 | f       | idle
>  47824 | f       | active
>  49978 | f       | idle
>  47825 | f       | active
>  45414 | f       | active
>  50520 | f       | idle
>  54395 | f       | idle
>  52825 | f       | idle
>  11791 | f       | active
>  53040 | f       | idle
>  53043 | f       | idle
>  53057 | f       | idle
>  47823 | f       | active
>  48659 | f       | idle
>  53892 | f       | idle
>  53056 | f       | idle
>  53058 | f       | idle
>  53893 | f       | idle
>  53894 | f       | idle
>  47835 | f       | idle
>  46732 | f       | idle
>  55059 | f       | idle
>  53895 | f       | idle
>  53896 | f       | idle
>  47837 | f       | idle
>  53897 | f       | idle
>  47843 | f       | idle
>  47845 | f       | active
>  48658 | f       | idle
>  48694 | f       | idle
>  48868 | f       | idle
>  48870 | f       | idle
>  48893 | f       | idle
>  48972 | f       | idle
>  50526 | f       | idle
> (63 rows)
>
>
>

> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company