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.zabuaw...@enterprisedb.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 <shaheedha...@gmail.com> > wrote: > >> Here is the information requested... >> >> On Fri, 1 May 2020 at 01:10, Murtuza Zabuawala < >> murtuza.zabuaw...@enterprisedb.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, <shaheedha...@gmail.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 <shaheedha...@gmail.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 <shaheedha...@gmail.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 >>>>>> >>>>>> >>>>>>
