Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f8UXT-0003lw-6D for pgsql-admin@arkaria.postgresql.org; Tue, 17 Apr 2018 17:37:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f8UXS-00019k-9A for pgsql-admin@arkaria.postgresql.org; Tue, 17 Apr 2018 17:37:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f8UXS-00019Z-0L for pgsql-admin@lists.postgresql.org; Tue, 17 Apr 2018 17:37:06 +0000 Received: from mail-ua0-x22f.google.com ([2607:f8b0:400c:c08::22f]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1f8UXN-0002Ce-Ch for pgsql-admin@postgresql.org; Tue, 17 Apr 2018 17:37:05 +0000 Received: by mail-ua0-x22f.google.com with SMTP id d3so12828785uae.4 for ; Tue, 17 Apr 2018 10:37:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:date:message-id:mime-version:content-language :thread-index; bh=Gxf/tpZ+KZqdFU7QpJ3iDu4f+o/J0oVFWdSjrGmzld0=; b=C9gcvJ+rRuRpyyrNJcyIpJTprkdIfsS9WToHXKLH8v91fq+ZPEkQ6HwUsLIkkur26h iYfdL+r2ekxfu4zgOHJ71JwVa+iaPvXX0UL9e7WxitXmTkRu+S4Vc36DT39PhNFF0DBD IcLVeESJ6klJbKhwnF0R/giXk5v2hNaNHQM75uKgKHw8VLQor5kT07glAIqTk+2aNbEw y2izq50Kz6VIrXRQfK2XkzxBz5CwA17NMWPqeXsWOYId5vmxFGSeDOOByS85HRV3zB7c dmB9axaXCZG/wWAa8nae/bk51GLgsepU6tIDhityhJjO+0XcR7Tz5XE77nBkMQ3b77Zl v5KA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:date:message-id:mime-version :content-language:thread-index; bh=Gxf/tpZ+KZqdFU7QpJ3iDu4f+o/J0oVFWdSjrGmzld0=; b=YlY7v8vl70YVp3KE+xaykX9Hi2Z1cEKUeZQujGhkd913/bKXUJ/55rj45zcRsyTR4W BYkE9NeOxhibjWeApN4meIWPRq7i//MQfjvbB8JARXtvIkps65NHG9MZNqtOOy5kKCXu nNMEMAeOe0lESqAZsBSdUqL7Kh6sGowitFhQTiSLTHndrlOappDasnimtCH+EBYIvI55 bxSbtuGgPndsCJOrVKu8mesvEX/SLwe2e1RZMn3O3Tf8LLJAPdcQ8FEKbHOpLeS4S3Rs LV342DxQ7uj55s9HbhLmeigfeIS5x7MEoidlSq7TXPijatEWiRxENxTdqqMRllgVmM++ cNOg== X-Gm-Message-State: ALQs6tB1sTpFuloHdCbjS6Av6XAe9gYjNcumV/pqMBNHxTyhAhWLhAuL 7wTfsnvRbivzjXhLMMXDY/Emxg== X-Google-Smtp-Source: AIpwx4+TjO9k2x3/dhlN66p/i3Wj5rhBx9hVuGsgL9iGoPZE69PxtTeLs6wNZdTF/LOFiKj/r3JwLg== X-Received: by 10.176.22.71 with SMTP id l7mr2231214uae.157.1523986619211; Tue, 17 Apr 2018 10:36:59 -0700 (PDT) Received: from irylachi ([200.55.161.75]) by smtp.gmail.com with ESMTPSA id y62sm3918160vkg.51.2018.04.17.10.36.57 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Tue, 17 Apr 2018 10:36:58 -0700 (PDT) From: "Lazaro Garcia" To: "'pgsql-admin'" Subject: Possible bug on code autocomplete pgadmin V 3.0 Date: Tue, 17 Apr 2018 13:36:58 -0400 Message-ID: <001601d3d672$b08f3f30$11adbd90$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0017_01D3D651.297FE920" X-Mailer: Microsoft Outlook 15.0 Content-Language: es-mx Thread-Index: AdPWcoI4dIFPrQxzSOacbMwPcv5OJg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_0017_01D3D651.297FE920 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello everyone in the list. After installing pgadmin4 V 3.0 from source, the autocomplete code on query tool is not working, these errors are logged in my apache-error.log. I think this is a bug. Is there any help to solve that? PgAdmin4 was installed from source code and running behind apache2.4 server. Regards [Tue Apr 17 13:27:27.741741 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] mod_wsgi (pid=4921): Exception occurred processing WSGI script '/var/www/vhosts/pgadmin4/web/pgAdmin4.wsgi'. [Tue Apr 17 13:27:27.741915 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] Traceback (most recent call last): [Tue Apr 17 13:27:27.741945 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1997, in __call__ [Tue Apr 17 13:27:27.741987 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] return self.wsgi_app(environ, start_response) [Tue Apr 17 13:27:27.742006 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1985, in wsgi_app [Tue Apr 17 13:27:27.742033 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] response = self.handle_exception(e) [Tue Apr 17 13:27:27.742051 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1540, in handle_exception [Tue Apr 17 13:27:27.742078 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] reraise(exc_type, exc_value, tb) [Tue Apr 17 13:27:27.742095 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1982, in wsgi_app [Tue Apr 17 13:27:27.742121 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] response = self.full_dispatch_request() [Tue Apr 17 13:27:27.742138 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1614, in full_dispatch_request [Tue Apr 17 13:27:27.742165 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] rv = self.handle_user_exception(e) [Tue Apr 17 13:27:27.742182 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1517, in handle_user_exception [Tue Apr 17 13:27:27.742208 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] reraise(exc_type, exc_value, tb) [Tue Apr 17 13:27:27.742225 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1612, in full_dispatch_request [Tue Apr 17 13:27:27.742252 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] rv = self.dispatch_request() [Tue Apr 17 13:27:27.742269 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1598, in dispatch_request [Tue Apr 17 13:27:27.742295 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] return self.view_functions[rule.endpoint](**req.view_args) [Tue Apr 17 13:27:27.742313 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/usr/local/lib/python2.7/dist-packages/flask_login.py", line 792, in decorated_view [Tue Apr 17 13:27:27.742340 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] return func(*args, **kwargs) [Tue Apr 17 13:27:27.742357 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/var/www/vhosts/pgadmin4/web/pgadmin/tools/sqleditor/__init__.py", line 1231, in auto_complete [Tue Apr 17 13:27:27.742391 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] res = auto_complete_obj.get_completions(full_sql, text_before_cursor) [Tue Apr 17 13:27:27.742409 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/autocomplete.py" , line 239, in get_completions [Tue Apr 17 13:27:27.742436 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] suggestions = self.suggest_type(text, text_before_cursor) [Tue Apr 17 13:27:27.742453 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/autocomplete.py" , line 721, in suggest_type [Tue Apr 17 13:27:27.742481 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] last_token, text_before_cursor, full_text, identifier [Tue Apr 17 13:27:27.742505 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/autocomplete.py" , line 833, in suggest_based_on_last_token [Tue Apr 17 13:27:27.742533 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] tables = extract_tables(full_text) [Tue Apr 17 13:27:27.742551 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/parseutils.py", line 193, in extract_tables [Tue Apr 17 13:27:27.742578 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] return tuple(identifiers) [Tue Apr 17 13:27:27.742595 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/parseutils.py", line 130, in extract_table_identifiers [Tue Apr 17 13:27:27.742623 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] for item in token_stream: [Tue Apr 17 13:27:27.742640 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/parseutils.py", line 93, in extract_from_part [Tue Apr 17 13:27:27.742667 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] if is_subselect(item): [Tue Apr 17 13:27:27.742684 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] File "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/parseutils.py", line 76, in is_subselect [Tue Apr 17 13:27:27.742711 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] if not parsed.is_group(): [Tue Apr 17 13:27:27.742736 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] TypeError: 'bool' object is not callable ------=_NextPart_000_0017_01D3D651.297FE920 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello everyone in the list. After = installing pgadmin4 V 3.0 from source, the autocomplete code  on = query tool is not working, these errors are logged in my = apache-error.log. I think this is a bug. Is there any help to solve = that?

 

PgAdmin4 was installed from source code and running behind = apache2.4 server.

 

Regards

 

 

[Tue Apr 17 13:27:27.741741 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348] mod_wsgi (pid=3D4921): Exception occurred = processing WSGI script = '/var/www/vhosts/pgadmin4/web/pgAdmin4.wsgi'.

[Tue Apr 17 13:27:27.741915 2018] = [wsgi:error] [pid 4921] [remote 192.168.5.130:45348] Traceback (most = recent call last):

[Tue Apr 17 13:27:27.741945 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]   File = "/usr/local/lib/python2.7/dist-packages/flask/app.py", line = 1997, in __call__

[Tue Apr 17 13:27:27.741987 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]     return = self.wsgi_app(environ, start_response)

[Tue Apr 17 13:27:27.742006 2018] = [wsgi:error] [pid 4921] [remote 192.168.5.130:45348]   File = "/usr/local/lib/python2.7/dist-packages/flask/app.py", line = 1985, in wsgi_app

[Tue Apr 17 13:27:27.742033 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]     response =3D = self.handle_exception(e)

[Tue Apr 17 13:27:27.742051 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]   File = "/usr/local/lib/python2.7/dist-packages/flask/app.py", line = 1540, in handle_exception

[Tue Apr 17 13:27:27.742078 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     reraise(exc_type, = exc_value, tb)

[Tue Apr 17 13:27:27.742095 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]   File = "/usr/local/lib/python2.7/dist-packages/flask/app.py", line = 1982, in wsgi_app

[Tue Apr 17 13:27:27.742121 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]     response =3D = self.full_dispatch_request()

[Tue Apr 17 13:27:27.742138 2018] = [wsgi:error] [pid 4921] [remote 192.168.5.130:45348]   File = "/usr/local/lib/python2.7/dist-packages/flask/app.py", line = 1614, in full_dispatch_request

[Tue Apr 17 13:27:27.742165 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     rv =3D = self.handle_user_exception(e)

[Tue Apr 17 13:27:27.742182 2018] = [wsgi:error] [pid 4921] [remote 192.168.5.130:45348]   File = "/usr/local/lib/python2.7/dist-packages/flask/app.py", line = 1517, in handle_user_exception

[Tue Apr 17 13:27:27.742208 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     reraise(exc_type, = exc_value, tb)

[Tue Apr 17 13:27:27.742225 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]   File = "/usr/local/lib/python2.7/dist-packages/flask/app.py", line = 1612, in full_dispatch_request

[Tue Apr 17 13:27:27.742252 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     rv =3D = self.dispatch_request()

[Tue Apr 17 13:27:27.742269 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]   File = "/usr/local/lib/python2.7/dist-packages/flask/app.py", line = 1598, in dispatch_request

[Tue Apr 17 13:27:27.742295 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     return = self.view_functions[rule.endpoint](**req.view_args)

=

[Tue Apr 17 13:27:27.742313 = 2018] [wsgi:error] [pid 4921] [remote 192.168.5.130:45348]   = File "/usr/local/lib/python2.7/dist-packages/flask_login.py", = line 792, in decorated_view

[Tue Apr 17 13:27:27.742340 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     return func(*args, = **kwargs)

[Tue Apr 17 13:27:27.742357 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]   File = "/var/www/vhosts/pgadmin4/web/pgadmin/tools/sqleditor/__init__.py&qu= ot;, line 1231, in auto_complete

[Tue Apr 17 13:27:27.742391 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     res =3D = auto_complete_obj.get_completions(full_sql, = text_before_cursor)

[Tue Apr 17 13:27:27.742409 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]   File = "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/autocomp= lete.py", line 239, in get_completions

[Tue Apr 17 13:27:27.742436 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     suggestions =3D = self.suggest_type(text, text_before_cursor)

[Tue Apr 17 13:27:27.742453 2018] = [wsgi:error] [pid 4921] [remote 192.168.5.130:45348]   File = "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/autocomp= lete.py", line 721, in suggest_type

[Tue Apr 17 13:27:27.742481 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     last_token, = text_before_cursor, full_text, identifier

[Tue Apr 17 13:27:27.742505 2018] = [wsgi:error] [pid 4921] [remote 192.168.5.130:45348]   File = "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/autocomp= lete.py", line 833, in = suggest_based_on_last_token

[Tue Apr 17 13:27:27.742533 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     tables =3D = extract_tables(full_text)

[Tue Apr 17 13:27:27.742551 2018] = [wsgi:error] [pid 4921] [remote 192.168.5.130:45348]   File = "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/parseuti= ls.py", line 193, in extract_tables

[Tue Apr 17 13:27:27.742578 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     return = tuple(identifiers)

[Tue Apr 17 13:27:27.742595 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]   File = "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/parseuti= ls.py", line 130, in = extract_table_identifiers

[Tue Apr 17 13:27:27.742623 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     for item in = token_stream:

[Tue Apr 17 13:27:27.742640 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]   File = "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/parseuti= ls.py", line 93, in extract_from_part

[Tue Apr 17 13:27:27.742667 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     if = is_subselect(item):

[Tue Apr 17 13:27:27.742684 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348]   File = "/var/www/vhosts/pgadmin4/web/pgadmin/utils/sqlautocomplete/parseuti= ls.py", line 76, in is_subselect

[Tue Apr 17 13:27:27.742711 2018] = [wsgi:error] [pid 4921] [remote = 192.168.5.130:45348]     if not = parsed.is_group():

[Tue Apr 17 13:27:27.742736 2018] [wsgi:error] [pid 4921] = [remote 192.168.5.130:45348] TypeError: 'bool' object is not = callable

------=_NextPart_000_0017_01D3D651.297FE920--