Re: Dashboard graphs are not drawn with 4.20 or 4.21

Good news: I verified that it works fine under Chromium. However, under
Firefox, despite clearing of the cache for localhost, the console has this
error:

ChunkLoadError: Loading chunk 14 failed. (missing:
http://localhost:5050/static/js/generated/vendors~chart.chunk.js) 5
app.bundle.js:1:1137
<http://localhost:5050/static/js/generated/app.bundle.js?ver=42100>

Any thoughts?

Thanks, Shaheed

On Mon, 4 May 2020 at 06:38, Murtuza Zabuawala <
murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:

> 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
>>>>>>
>>>>>>
>>>>>>