Re: bug report: All queries incorrectly shown as blocking in server status

I have sent a patch fixing the issue to the pgadmin-hacker mailing list.

Chris,
Thanks for providing the bug details.

On Mon, Oct 29, 2012 at 6:51 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Sachin, can you look into this please? Thanks.
>
> On Thu, Oct 25, 2012 at 11:08 PM, Chris St Denis <chris(at)ctgameinfo(dot)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(at)postgresql(dot)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
>

--
Regards,
Sachin Srivastava
EnterpriseDB, India