Syntax error on pgAdmin4 start

From: Marco Azzalini <mark(dot)azzalini(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Syntax error on pgAdmin4 start
Date: 2020-10-02 16:59:22
Message-ID: CAMU=gBH0mu1=KQcSN35t2Mzoq22SHQaoPpjYvqT+tA8VBuw65Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi, this is my first message here.
Today my pgAdmin4 console doesn't start anymore... it takes lots of time
and then a pop up appears complaining that pgAdmin server could not be
contacted

at the end of the log there is this error:

* File
"/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/row_security_policies/tests/__init__.py",
line 1*

* SELECT rel.oid, rel.relname AS name,*

* ^*

*SyntaxError: invalid syntax*

My system is Linux OpenSuse Tumbleweed and the pgAdmin version is 4.26-2.1
(the latest available for my system)
Recently I got some updates for python subsystem... now I have Python 3.8.5

may be this be the source of the problem?
How can I fix it?

thanks in advance for any hint
Marco

Full log :
----------------------------------------

Traceback (most recent call last):

File "/usr/lib/python3.8/site-packages/pgadmin4-web/pgAdmin4.py", line 93,
in <module> app = create_app()

File "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/__init__.py",
line 618, in create_app app.register_blueprint(module)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
wrapper_func return f(self, *args, **kwargs)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
register_blueprint blueprint.register(self, options, first_registration)

File
"/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
line 71, in register app.register_blueprint(module)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
wrapper_func return f(self, *args, **kwargs)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
register_blueprint blueprint.register(self, options, first_registration)

File
"/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
line 71, in register app.register_blueprint(module)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
wrapper_func return f(self, *args, **kwargs)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
register_blueprint blueprint.register(self, options, first_registration)

File
"/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/__init__.py",
line 309, in register super(ServerModule, self).register(app, options,
first_registration)

File
"/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
line 71, in register app.register_blueprint(module)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
wrapper_func return f(self, *args, **kwargs)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
register_blueprint blueprint.register(self, options, first_registration)

File
"/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
line 71, in register app.register_blueprint(module)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
wrapper_func return f(self, *args, **kwargs)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
register_blueprint blueprint.register(self, options, first_registration)

File
"/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
line 71, in register app.register_blueprint(module)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
wrapper_func return f(self, *args, **kwargs)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
register_blueprint blueprint.register(self, options, first_registration)

File
"/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
line 71, in register app.register_blueprint(module)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
wrapper_func return f(self, *args, **kwargs)

File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
register_blueprint blueprint.register(self, options, first_registration)

File
"/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
line 64, in register self.submodules =
list(app.find_submodules(self.import_name))

File "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/__init__.py",
line 67, in find_submodules module = import_module(module_name)

File "/usr/lib64/python3.8/importlib/__init__.py", line 127, in
import_module return _bootstrap._gcd_import(name[level:], package, level)

File "<frozen importlib._bootstrap>", line 1014, in _gcd_import

File "<frozen importlib._bootstrap>", line 991, in _find_and_load

File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked

File "<frozen importlib._bootstrap>", line 671, in _load_unlocked

File "<frozen importlib._bootstrap_external>", line 779, in exec_module

File "<frozen importlib._bootstrap_external>", line 916, in get_code

File "<frozen importlib._bootstrap_external>", line 846, in source_to_code

File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed

File
"/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/row_security_policies/tests/__init__.py",
line 1

SELECT rel.oid, rel.relname AS name,

^

SyntaxError: invalid syntax

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2020-10-05 04:48:45 Re: Mapped drives not showing up on windows install
Previous Message Russell Mercer 2020-10-01 17:23:34 Mapped drives not showing up on windows install