Re: pgadmin4 error
От | Levente Birta |
---|---|
Тема | Re: pgadmin4 error |
Дата | |
Msg-id | 0b92c603-ff08-c5e3-3a28-6f080fb0c9bb@gmail.com обсуждение исходный текст |
Ответ на | Re: pgadmin4 error (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>) |
Список | pgadmin-support |
Cool, it's working Thank you!!! Levi On 28/10/2020 12:45, Aditya Toshniwal wrote: > Hi Levente, > > Please try installing from pgAdmin team built installer - > https://www.pgadmin.org/download/pgadmin-4-rpm/ > <https://www.pgadmin.org/download/pgadmin-4-rpm/> > > On Wed, Oct 28, 2020 at 4:10 PM Levente Birta <blevi.linux@gmail.com > <mailto:blevi.linux@gmail.com>> wrote: > > > Hello, > > I use pgadmin4 with server installation, on Centos7, installed from > official postgresql yum repo. > > I'm on 4.27 now, but 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 <http://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] > > > > > -- > Thanks, > Aditya Toshniwal > pgAdmin hacker | Sr. Software Engineer| *edbpostgres.com* > <http://edbpostgres.com> > "Don't Complain about Heat, Plant a TREE"
В списке pgadmin-support по дате отправления: