Re: Dashboard graphs are not drawn with 4.20 or 4.21

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