Обсуждение: Syntax error on pgAdmin4 start

Поиск

Список

Период

Сортировка

Syntax error on pgAdmin4 start

От

Marco Azzalini

Дата:

02 октября 2020 г., 19:36:01

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

Re: Syntax error on pgAdmin4 start

От

"David G. Johnston"

Дата:

02 октября 2020 г., 19:41:11

On Fri, Oct 2, 2020 at 9:36 AM Marco Azzalini <mark.azzalini@gmail.com> wrote:

Hi, this is my first message here.

You've posted the same message twice to the wrong list. pgAdmin is a separate product with their own support channel.

https://www.pgadmin.org/support/list/

pgadmin-support, not pgsql-admin, the later being for general administrative topics for the server.

David J.

Re: Syntax error on pgAdmin4 start

От

Marco Azzalini

Дата:

02 октября 2020 г., 19:50:40

Thanks for the clarification. I am sorry.

bye

Marco

Il giorno ven 2 ott 2020 alle ore 18:41 David G. Johnston <david.g.johnston@gmail.com> ha scritto:

On Fri, Oct 2, 2020 at 9:36 AM Marco Azzalini <mark.azzalini@gmail.com> wrote:
Hi, this is my first message here.

You've posted the same message twice to the wrong list. pgAdmin is a separate product with their own support channel.

https://www.pgadmin.org/support/list/

pgadmin-support, not pgsql-admin, the later being for general administrative topics for the server.

David J.

--

https://ilmilione.org
----
Anche sogliono essere odiatissimi i buoni e i generosi perché ordinariamente sono sinceri, e chiamano le cose coi loro nomi.
Colpa non perdonata dal genere umano, il quale non odia mai tanto chi fa male, né il male stesso, quanto chi lo nomina. 
                                                           - Leopardi -

Re: Syntax error on pgAdmin4 start

От

Holger Jakobs

Дата:

02 октября 2020 г., 19:59:36

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.azzalini@gmail.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 -