Re: Dashboard graphs are not drawn with 4.20 or 4.21

I found the issue. When I looked at the Network traffic in the developer
console, the vendors~chart.chunk.js was still showing as being fetched from
cache. So, I disabled the che using the radio button there, and now the
graphs show up as expected.

Thanks for all your help, and please consider this issue closed.
<http://localhost:5050/static/js/generated/app.bundle.js?ver=42100>
<http://localhost:5050/static/js/generated/app.bundle.js?ver=42100>

On Mon, 4 May 2020 at 11:36, Shaheed Haque <shaheedhaque(at)gmail(dot)com> wrote:

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