Re: Dashboard graphs are not drawn with 4.20 or 4.21

Hello,

Not able to find any helpful information in the logs,

1) Try executing below sql (which is from the pgadmin4 log) in the Query
tool manually and check if you are getting proper result,
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 1680798)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND
datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS
"Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname
= (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database
WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2) Can you hard refresh the browser (remove all browser cache & try again)
& check for any browser console errors next time when you try to access the
dashboard?
3) Can you cross verify in any other browser if the same issue exists?

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Sun, May 3, 2020 at 1:33 AM Shaheed Haque <shaheedhaque(at)gmail(dot)com> wrote:

> Here is the information requested...
>
> On Fri, 1 May 2020 at 01:10, Murtuza Zabuawala <
> murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>
>> Hello,
>>
>> Could you please provide additional information like,
>> What is your platform?
>>
>
> Ubuntu 19.10 on x86-64.
>
>
>> How did you install/upgrade pgAdmin4?
>>
>
> Using the downloaded .whl file, I did a "sudo -H pip3 install --upgrade
> xxx.whl".
>
>
>> What's the DB server version on which graphs are not displaying?
>>
>
> Postgresql 11, running on another Ubuntu machine.
>
>
>> What browser/version are you using?
>>
>
> Primarily Firefox 75. I have access to Chromium too if needed (I need to
> figure out how to reet my pgAdmin password...).
>
>
>> Also provide pgAdmin4 logs (Ref: https://www.pgadmin.org/faq/ on how to
>> enable logging) & attach screenshot of browser console error if any.
>>
>
> See attached. Do let me know if you need anything further.
>
> Thanks!
>
> Shaheed
>
>
>
>> Regards,
>> Murtuza
>>
>> On Thu, 30 Apr 2020, 20:41 Shaheed Haque, <shaheedhaque(at)gmail(dot)com> wrote:
>>
>>> I resolved the wrkzeug issue by updating Flask-BabelEx, but the graphs
>>> are still not drawn.
>>>
>>> Also, after restarting pgadmin, the SQL messages are no longer emitted.
>>>
>>> On Thu, 30 Apr 2020 at 15:44, Shaheed Haque <shaheedhaque(at)gmail(dot)com>
>>> wrote:
>>>
>>>> I forgot to add: I also tried 4.20 in case it was any better, but it
>>>> had the same lack of graph drawing, so went back to 4.21 pending advice.
>>>>
>>>> On Thu, 30 Apr 2020 at 15:43, Shaheed Haque <shaheedhaque(at)gmail(dot)com>
>>>> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> I have been running 4.14 for a while, and today in order to get to a
>>>>> newer version of werkzeug, I tried upgrading to 4.21 only to find that the
>>>>> Dashboard graphs are not being drawn. All else seems fine (I can navigate
>>>>> down to tables, and view data for example), but none of the graphs a re
>>>>> drawn.
>>>>>
>>>>> I notice that on the console from where I am running pgAdmin 4.21, I
>>>>> see messages like this every few seconds:
>>>>>
>>>>> SQL:flask.app:Execute (dict) for server #1 - DB:foo (Query-id:
>>>>> 8996147):
>>>>> /*pga4dash*/
>>>>> SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
>>>>> FROM (SELECT
>>>>> (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT
>>>>> datname FROM pg_database WHERE oid = 1680798)) AS "Total",
>>>>> (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND
>>>>> datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS
>>>>> "Active",
>>>>> (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND
>>>>> datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Idle"
>>>>> ) t
>>>>> UNION ALL
>>>>> ...
>>>>> more like this
>>>>> ...
>>>>>
>>>>> which suggests something is trying to fetch the needed data. I tried
>>>>> restarting the browser, to no avail.
>>>>>
>>>>> I did also notice:
>>>>>
>>>>> - A dependency on pyasn1.error which I resolved by updating from
>>>>> pyasn1-0.4.5 to pyasn1-0.4.8:
>>>>>
>>>>> Traceback (most recent call last):
>>>>> File "/usr/local/lib/python3.7/dist-packages/pgadmin4/pgAdmin4.py",
>>>>> line 109, in <module>
>>>>> app = create_app()
>>>>> File
>>>>> "/usr/local/lib/python3.7/dist-packages/pgadmin4/pgadmin/__init__.py", line
>>>>> 401, in create_app
>>>>> authenticate.init_app(app)
>>>>> File
>>>>> "/usr/local/lib/python3.7/dist-packages/pgadmin4/pgadmin/authenticate/__init__.py",
>>>>> line 154, in init_app
>>>>> AuthSourceRegistry.load_auth_sources()
>>>>> File
>>>>> "/usr/local/lib/python3.7/dist-packages/pgadmin4/pgadmin/authenticate/registry.py",
>>>>> line 65, in load_auth_sources
>>>>> module = import_module(module_name)
>>>>> File "/usr/lib/python3.7/importlib/__init__.py", line 127, in
>>>>> import_module
>>>>> return _bootstrap._gcd_import(name[level:], package, level)
>>>>> File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
>>>>> File "<frozen importlib._bootstrap>", line 983, in _find_and_load
>>>>> File "<frozen importlib._bootstrap>", line 967, in
>>>>> _find_and_load_unlocked
>>>>> File "<frozen importlib._bootstrap>", line 677, in _load_unlocked
>>>>> File "<frozen importlib._bootstrap_external>", line 728, in
>>>>> exec_module
>>>>> File "<frozen importlib._bootstrap>", line 219, in
>>>>> _call_with_frames_removed
>>>>> File
>>>>> "/usr/local/lib/python3.7/dist-packages/pgadmin4/pgadmin/authenticate/ldap.py",
>>>>> line 14, in <module>
>>>>> from ldap3 import Connection, Server, Tls, ALL, ALL_ATTRIBUTES
>>>>> File "/usr/local/lib/python3.7/dist-packages/ldap3/__init__.py",
>>>>> line 139, in <module>
>>>>> from .core.connection import Connection
>>>>> File
>>>>> "/usr/local/lib/python3.7/dist-packages/ldap3/core/connection.py", line 44,
>>>>> in <module>
>>>>> from ..operation.compare import compare_operation,
>>>>> compare_request_to_dict
>>>>> File
>>>>> "/usr/local/lib/python3.7/dist-packages/ldap3/operation/compare.py", line
>>>>> 28, in <module>
>>>>> from ..operation.search import ava_to_dict
>>>>> File
>>>>> "/usr/local/lib/python3.7/dist-packages/ldap3/operation/search.py", line
>>>>> 41, in <module>
>>>>> from pyasn1.error import PyAsn1UnicodeDecodeError
>>>>> ImportError: cannot import name 'PyAsn1UnicodeDecodeError' from
>>>>> 'pyasn1.error' (/usr/local/lib/python3.7/dist-packages/pyasn1/error.py)
>>>>>
>>>>> - A compatibility problem with werkzeug. I had been running 0.15.2,
>>>>> and tried upgrading to 1.0.1 to address some long standing issues (I
>>>>> believe you guys were also hit by changes in legacy API support too) only
>>>>> to get this:
>>>>>
>>>>> Traceback (most recent call last):
>>>>> File "/usr/local/lib/python3.7/dist-packages/pgadmin4/pgAdmin4.py",
>>>>> line 40, in <module>
>>>>> import config
>>>>> File "/usr/local/lib/python3.7/dist-packages/pgadmin4/config.py",
>>>>> line 30, in <module>
>>>>> from pgadmin.utils import env, IS_PY2, IS_WIN, fs_short_path
>>>>> File
>>>>> "/usr/local/lib/python3.7/dist-packages/pgadmin4/pgadmin/__init__.py", line
>>>>> 21, in <module>
>>>>> from flask_babelex import Babel, gettext
>>>>> File
>>>>> "/usr/local/lib/python3.7/dist-packages/flask_babelex/__init__.py", line
>>>>> 23, in <module>
>>>>> from werkzeug import ImmutableDict
>>>>> ImportError: cannot import name 'ImmutableDict' from 'werkzeug'
>>>>> (/usr/local/lib/python3.7/dist-packages/werkzeug/__init__.py)
>>>>>
>>>>> I downgraded to werkzeug 0.16.1 to address this.
>>>>>
>>>>> The results I noted were AFTER these fixes were applied. FWIW, I am
>>>>> running on a recent Ubuntu desktop.
>>>>>
>>>>> Any advice welcome.
>>>>>
>>>>> Thanks, Shaheed
>>>>>
>>>>>
>>>>>