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 1f8nRY-0008LI-Lw for pgadmin-support@arkaria.postgresql.org; Wed, 18 Apr 2018 13:48:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f8nRX-0007Cn-Ca for pgadmin-support@arkaria.postgresql.org; Wed, 18 Apr 2018 13:48:15 +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 1f8nRX-0007Cd-2a for pgadmin-support@lists.postgresql.org; Wed, 18 Apr 2018 13:48:15 +0000 Received: from mail-vk0-x22e.google.com ([2607:f8b0:400c:c05::22e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1f8nRS-0007w8-IN for pgadmin-support@postgresql.org; Wed, 18 Apr 2018 13:48:14 +0000 Received: by mail-vk0-x22e.google.com with SMTP id q189so1068255vkb.0 for ; Wed, 18 Apr 2018 06:48:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :content-language:thread-index; bh=z8EVdUPE05JqssMiCvjOv04bCN+Lop4pruGuFmqzoLg=; b=Vkuw6wb0rY2yJ82fXXTTzPuWj9E+D+BbSbobjwyARjLnN5tjhs3YS07wwcbnA8Hxzn 5IydpFPHXdWuqOUlEu/nVAvNdSw9+RoOB+wHJQ81QUw3rLleLVdN/Yq144OpPXGDa0VW YoXc3OUnciZP+vEzCpVPmPFllduCVQy1/fsvsTk9RHWTnCyyks4xs1ZTqXBP56vduIYx lzWKJacx8qsOf/YPUQWRASSpzrzuW4u2mZyHxqyXihNQS32t4OZWdSMClbFs+ub/iGFc GPmh6jbjYwFSmxOHrrGmtdKW48hbXYGKSAZ7wEOGxwaa+gtSRHH+SxvNRg40ovRzTQPp jaJg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:references:in-reply-to:subject:date :message-id:mime-version:content-language:thread-index; bh=z8EVdUPE05JqssMiCvjOv04bCN+Lop4pruGuFmqzoLg=; b=N89EeHs0CO00yAcBK2HbRc0bAViMve4MJlAqLyRhbje+iXkwl9Gy7vpZrS+uBHWqWx YW7DJXja2UtiZYyxd/AMiNAJAY6JnX/jxkqy5Mlwye17Slxcj0zYywyoTf0IAh4fLm8v 9RfRUQZZlDck+zfnQ3jH3WBq0TD5bh68McLhRGW3Iv1R/7dOXPKmRrH3Fq+YwuHIK8r0 7+VC2lSBuyK4Zsx+IVPGTiZPGOP1rDoToNbbwzvjipTmYSU2MSx6Ad3WKeAYHOciCCJJ zercxJHRuy7CIBQ/Fas43jCf9F1Ck2KAzSK4BLfkrfncyPd/qcB+JuZkE0wr2hKK2OJc 7WsA== X-Gm-Message-State: ALQs6tC5H0Oxjo4f96ghmLY+HXNYI8WqkZAnRhcY8KDwRfn3j0ke3QQx rSpAMFPg0nBgWYQgt0EJtf4gMw== X-Google-Smtp-Source: AIpwx48YAb/R+rkPHILLUJUE5R7b+GXrDe3sHXUJb694NCJTUFL4aEpgyUEjTgzE6XZ0JTzPmNqXyA== X-Received: by 10.31.224.66 with SMTP id x63mr1352035vkg.105.1524059287549; Wed, 18 Apr 2018 06:48:07 -0700 (PDT) Received: from irylachi ([200.55.161.75]) by smtp.gmail.com with ESMTPSA id 16sm576189vkn.38.2018.04.18.06.48.05 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Wed, 18 Apr 2018 06:48:06 -0700 (PDT) From: "Lazaro Garcia" To: References: In-Reply-To: Subject: Possible bug on code autocomplete pgadmin V 3.0 Date: Wed, 18 Apr 2018 09:48:03 -0400 Message-ID: <006701d3d71b$e097cd10$a1c76730$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0068_01D3D6FA.59889E10" X-Mailer: Microsoft Outlook 15.0 Content-Language: es-mx Thread-Index: AdPWcoI4dIFPrQxzSOacbMwPcv5OJgAqR8/A List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_0068_01D3D6FA.59889E10 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 on Ubuntu Server 16.04 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_0068_01D3D6FA.59889E10 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 on Ubuntu Server = 16.04

 

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_0068_01D3D6FA.59889E10--