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

From: Chris St Denis <chris(at)ctgameinfo(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: bug report: All queries incorrectly shown as blocking in server status
Date: 2012-10-25 22:08:43
Message-ID: 5089B86B.9090807@ctgameinfo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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)

Attachment Content-Type Size
image/png 66.2 KB

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Phil Freeman 2012-10-28 20:59:56 No more Delete/Drop constraints in 1.16
Previous Message Linos 2012-10-25 18:35:08 serial column detection