Re: Syntax error on pgAdmin4 start

Hi Marco,

Can you share the contents of file - /usr/lib/python3.8/site-
packages/pgadmin4-web/pgadmin/browser/server_groups/servers/
databases/schemas/tables/row_security_policies/tests/__init__.py ?
There is no such select statement in the original source code.

On Fri, Oct 2, 2020 at 10:29 PM Marco Azzalini <mark(dot)azzalini(at)gmail(dot)com>
wrote:

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

--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"