From: | Marco Azzalini <mark(dot)azzalini(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | syntax error on pgAdmin4 start |
Date: | 2020-10-02 10:56:43 |
Message-ID: | CAMU=gBER_Aq_z57=YsZKX2XXjkNZjEQreOdoeKf6z67Q98Hk+A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
--
From | Date | Subject | |
---|---|---|---|
Next Message | Amine Tengilimoglu | 2020-10-02 13:00:36 | PostgreSQL's Identifier Length |
Previous Message | Erik Serrano | 2020-09-29 19:45:46 | Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces |