Hello,
I use pgadmin4 with server installation, on Centos7, installed from
official postgresql yum repo.
Since v4.24, IIRC, I got error when I try to visualize the SQL for a
table: INTERNAL SERVER ERROR ... expected token 'end of statement
block', got '.'
For views, foreign tables or any other stuff is working ...
Any ideas?
Thanks
Levi
The apache error log:
[Thu Oct 08 10:29:05.260331 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] 2020-10-08 10:29:05,259: ERROR\tflask.app:\texpected
token 'end of statement block', got '.'
[Thu Oct 08 10:29:05.260347 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] Traceback (most recent call last):
[Thu Oct 08 10:29:05.260350 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1813,
in full_dispatch_request
[Thu Oct 08 10:29:05.260352 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] rv = self.dispatch_request()
[Thu Oct 08 10:29:05.260353 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1799,
in dispatch_request
[Thu Oct 08 10:29:05.260361 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] return
self.view_functions[rule.endpoint](**req.view_args)
[Thu Oct 08 10:29:05.260363 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/flask/views.py", line 88,
in view
[Thu Oct 08 10:29:05.260365 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] return self.dispatch_request(*args, **kwargs)
[Thu Oct 08 10:29:05.260367 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/utils.py",
line 313, in dispatch_request
[Thu Oct 08 10:29:05.260369 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] return method(*args, **kwargs)
[Thu Oct 08 10:29:05.260371 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py",
line 158, in wrap
[Thu Oct 08 10:29:05.260373 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] return f(*args, **kwargs)
[Thu Oct 08 10:29:05.260374 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/__init__.py",
line 1388, in sql
[Thu Oct 08 10:29:05.260376 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] self, did=did, scid=scid, tid=tid,
main_sql=main_sql, data=data)
[Thu Oct 08 10:29:05.260378 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py",
line 770, in get_reverse_engineered_sql
[Thu Oct 08 10:29:05.260380 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] self._get_resql_for_table(did, scid, tid, data,
json_resp, main_sql)
[Thu Oct 08 10:29:05.260382 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py",
line 495, in _get_resql_for_table
[Thu Oct 08 10:29:05.260383 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] data=data, conn=self.conn, is_sql=True)
[Thu Oct 08 10:29:05.260385 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/flask/templating.py",
line 134, in render_template
[Thu Oct 08 10:29:05.260387 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] return
_render(ctx.app.jinja_env.get_or_select_template(template_name_or_list),
[Thu Oct 08 10:29:05.260388 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
line 851, in get_or_select_template
[Thu Oct 08 10:29:05.260390 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] return self.get_template(template_name_or_list,
parent, globals)
[Thu Oct 08 10:29:05.260392 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
line 812, in get_template
[Thu Oct 08 10:29:05.260393 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] return self._load_template(name,
self.make_globals(globals))
[Thu Oct 08 10:29:05.260395 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
line 786, in _load_template
[Thu Oct 08 10:29:05.260397 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] template = self.loader.load(self, name, globals)
[Thu Oct 08 10:29:05.260398 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/loaders.py", line
125, in load
[Thu Oct 08 10:29:05.260400 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] code = environment.compile(source, name, filename)
[Thu Oct 08 10:29:05.260407 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
line 565, in compile
[Thu Oct 08 10:29:05.260409 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] self.handle_exception(exc_info,
source_hint=source_hint)
[Thu Oct 08 10:29:05.260411 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
line 754, in handle_exception
[Thu Oct 08 10:29:05.260412 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] reraise(exc_type, exc_value, tb)
[Thu Oct 08 10:29:05.260414 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/_compat.py", line
37, in reraise
[Thu Oct 08 10:29:05.260415 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] raise value.with_traceback(tb)
[Thu Oct 08 10:29:05.260417 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/12_plus/create.sql",
line 88, in template
[Thu Oct 08 10:29:05.260419 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] {% if data.fillfactor %}{% set ns.add_comma = true%}
[Thu Oct 08 10:29:05.260421 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
line 470, in _parse
[Thu Oct 08 10:29:05.260422 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] return Parser(self, source, name,
encode_filename(filename)).parse()
[Thu Oct 08 10:29:05.260424 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
897, in parse
[Thu Oct 08 10:29:05.260426 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] result = nodes.Template(self.subparse(), lineno=1)
[Thu Oct 08 10:29:05.260427 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
879, in subparse
[Thu Oct 08 10:29:05.260429 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] rv = self.parse_statement()
[Thu Oct 08 10:29:05.260430 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
121, in parse_statement
[Thu Oct 08 10:29:05.260432 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] return getattr(self, 'parse_' +
self.stream.current.value)()
[Thu Oct 08 10:29:05.260434 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
203, in parse_if
[Thu Oct 08 10:29:05.260435 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] 'name:endif'))
[Thu Oct 08 10:29:05.260437 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
156, in parse_statements
[Thu Oct 08 10:29:05.260438 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] result = self.subparse(end_tokens)
[Thu Oct 08 10:29:05.260440 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
879, in subparse
[Thu Oct 08 10:29:05.260442 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] rv = self.parse_statement()
[Thu Oct 08 10:29:05.260443 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
121, in parse_statement
[Thu Oct 08 10:29:05.260445 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] return getattr(self, 'parse_' +
self.stream.current.value)()
[Thu Oct 08 10:29:05.260446 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
203, in parse_if
[Thu Oct 08 10:29:05.260450 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] 'name:endif'))
[Thu Oct 08 10:29:05.260451 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
156, in parse_statements
[Thu Oct 08 10:29:05.260453 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] result = self.subparse(end_tokens)
[Thu Oct 08 10:29:05.260455 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
879, in subparse
[Thu Oct 08 10:29:05.260456 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] rv = self.parse_statement()
[Thu Oct 08 10:29:05.260458 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
121, in parse_statement
[Thu Oct 08 10:29:05.260459 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] return getattr(self, 'parse_' +
self.stream.current.value)()
[Thu Oct 08 10:29:05.260461 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
175, in parse_set
[Thu Oct 08 10:29:05.260463 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] drop_needle=True)
[Thu Oct 08 10:29:05.260464 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
155, in parse_statements
[Thu Oct 08 10:29:05.260466 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] self.stream.expect('block_end')
[Thu Oct 08 10:29:05.260467 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/lexer.py", line
374, in expect
[Thu Oct 08 10:29:05.260469 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] self.name, self.filename)
[Thu Oct 08 10:29:05.260472 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105] jinja2.exceptions.TemplateSyntaxError: expected token
'end of statement block', got '.'
[Thu Oct 08 10:29:05.260477 2020] [wsgi:error] [pid 1047] [remote
ip.ad.re.ss:53105]
