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 <shaheedha...@gmail.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.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 >>>>>>> >>>>>>> >>>>>>>
