Re: Dashboard graphs are not drawn with 4.20 or 4.21

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