Re: Syntax error on pgAdmin4 start

And your first message is off topic, because this is the Postgresql list, not the pgadmin list. These are different projects.

Am 2. Oktober 2020 18:36:01 MESZ schrieb Marco Azzalini <mark(dot)azzalini(at)gmail(dot)com>:
>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
>
>the log is the following and it ends with 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... may be this be the
>source of the problem?
>How can I fix it?
>
>thanks in advance for any hint
>Marco
>
>
>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

--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -