date:20181015

[pgAdmin4][RM3703] Clear user connections on logout

2018-10-15 Thread Harshal Dhumal

Hi,

Please find patch to clear user connections on logout.

-- 
*Harshal Dhumal*
*Sr. Software Engineer*

EnterpriseDB India: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
diff --git a/web/pgadmin/__init__.py b/web/pgadmin/__init__.py
index 9b2cf35..36dfee3 100644
--- a/web/pgadmin/__init__.py
+++ b/web/pgadmin/__init__.py
@@ -550,6 +550,13 @@ def create_app(app_name=None):
 def force_session_write(app, user):
 session.force_write = True
 
+@user_logged_out.connect_via(app)
+def clear_current_user_connections(app, user):
+from config import PG_DEFAULT_DRIVER
+from pgadmin.utils.driver import get_driver
+_driver = get_driver(PG_DEFAULT_DRIVER)
+_driver.gc_own()
+
 ##
 # Load plugin modules
 ##
diff --git a/web/pgadmin/utils/driver/psycopg2/__init__.py b/web/pgadmin/utils/driver/psycopg2/__init__.py
index 5fefdee..f9dfd17 100644
--- a/web/pgadmin/utils/driver/psycopg2/__init__.py
+++ b/web/pgadmin/utils/driver/psycopg2/__init__.py
@@ -207,6 +207,22 @@ class Driver(BaseDriver):
 ]:
 mgr.release()
 
+def gc_own(self):
+"""
+Release the connections for current session
+This is useful when (eg. logout) we want to release all
+connections (except dedicated connections created by utilities
+like backup, restore etc) of all servers for current user.
+"""
+
+sess_mgr = self.managers.get(session.sid, None)
+
+if sess_mgr:
+for mgr in (
+m for m in sess_mgr.values() if isinstance(m, ServerManager)
+):
+mgr.release()
+
 @staticmethod
 def qtLiteral(value):
 adapted = adapt(value)

pgAdmin 4 commit: Fixed minor issue in SQL autocomplete.

2018-10-15 Thread Akshay Joshi

Fixed minor issue in SQL autocomplete.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=fd2c2c4ff786fc15989066b6546712049368b39d

Modified Files
--
web/pgadmin/utils/sqlautocomplete/autocomplete.py | 7 +++
1 file changed, 7 insertions(+)

Build failed in Jenkins: pgadmin4-master-python26 #915

2018-10-15 Thread pgAdmin 4 Jenkins

See 


Changes:

[akshay.joshi] Fixed minor issue in SQL autocomplete.

--
[...truncated 147 B...]
Fetching changes from the remote Git repository
 > git config remote.origin.url git://git.postgresql.org/git/pgadmin4.git # 
 > timeout=10
Cleaning workspace
 > git rev-parse --verify HEAD # timeout=10
Resetting working tree
 > git reset --hard # timeout=10
 > git clean -fdx # timeout=10
Fetching upstream changes from git://git.postgresql.org/git/pgadmin4.git
 > git --version # timeout=10
 > git fetch --tags --progress git://git.postgresql.org/git/pgadmin4.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision fd2c2c4ff786fc15989066b6546712049368b39d (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f fd2c2c4ff786fc15989066b6546712049368b39d
Commit message: "Fixed minor issue in SQL autocomplete."
 > git rev-list --no-walk d6c4911135dca8bbb703f0c4994ce8ffe19461d0 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=2.6

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python26] $ /bin/sh -xe /tmp/jenkins2750790639219598328.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 2.6 virtual environment...

New python executable in 

Installing setuptools, pip...done.
Running virtualenv with interpreter /usr/local/python-2.6/bin/python
DEPRECATION: Python 2.6 is no longer supported by the Python core team, please 
upgrade your Python. A future version of pip will drop support for Python 2.6
Collecting wheel==0.29.0
:339:
 SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name 
Indication) extension to TLS is not available on this platform. This may cause 
the server to present an incorrect TLS certificate, which can cause validation 
failures. You can upgrade to a newer version of Python to solve this. For more 
information, see 
https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings
  SNIMissingWarning
:137:
 InsecurePlatformWarning: A true SSLContext object is not available. This 
prevents urllib3 from configuring SSL appropriately and may cause certain SSL 
connections to fail. You can upgrade to a newer version of Python to solve 
this. For more information, see 
https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings
  InsecurePlatformWarning
  Using cached 
https://files.pythonhosted.org/packages/8a/e9/8468cd68b582b06ef554be0b96b59f59779627131aad48f8a5bce4b13450/wheel-0.29.0-py2.py3-none-any.whl
Collecting argparse; python_version == "2.6" (from wheel==0.29.0)
  Using cached 
https://files.pythonhosted.org/packages/f2/94/3af39d34be01a24a6e65433d19e107099374224905f1e0cc6bbe1fd22a2f/argparse-1.4.0-py2.py3-none-any.whl
Installing collected packages: argparse, wheel
Successfully installed argparse-1.4.0 wheel-0.29.0
You are using pip version 9.0.3, however version 18.1 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
DEPRECATION: Python 2.6 is no longer supported by the Python core team, please 
upgrade your Python. A future version of pip will drop support for Python 2.6
Ignoring psycopg2: markers 'python_version >= "2.7"' don't match your 
environment
Ignoring python-dateutil: markers 'python_version >= "2.7"' don't match your 
environment
Ignoring htmlmin: markers 'python_version >= "2.7"' don't match your environment
Ignoring Flask-HTMLmin: markers 'python_version >= "2.7"' don't match your 
environment
Ignoring SQLAlchemy: markers 'python_version >= "2.7"' don't match your 
environment
Ignoring Flask-Security: markers 'python_version >= "2.7"' don't match your 
environment
Ignoring sshtunnel: markers 'python_version >= "2.7"' don't match your 
environment
Collecting blinker==1.4 (from -r requirements.txt (line 6))
:339:
 SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name 
Indication) extension to TLS is not available on this platform. This may cause 
the server to present an incorrect TLS certificate, which can cause validation 
failures. You can upgrade to a newer version of Python to solve this. For more 
information, see 
https

Build failed in Jenkins: pgadmin4-master-python36 #773

2018-10-15 Thread pgAdmin 4 Jenkins

See 


Changes:

[akshay.joshi] Fixed minor issue in SQL autocomplete.

--
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building in workspace 

 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url git://git.postgresql.org/git/pgadmin4.git # 
 > timeout=10
Cleaning workspace
 > git rev-parse --verify HEAD # timeout=10
Resetting working tree
 > git reset --hard # timeout=10
 > git clean -fdx # timeout=10
Fetching upstream changes from git://git.postgresql.org/git/pgadmin4.git
 > git --version # timeout=10
 > git fetch --tags --progress git://git.postgresql.org/git/pgadmin4.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision fd2c2c4ff786fc15989066b6546712049368b39d (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f fd2c2c4ff786fc15989066b6546712049368b39d
Commit message: "Fixed minor issue in SQL autocomplete."
 > git rev-list --no-walk d6c4911135dca8bbb703f0c4994ce8ffe19461d0 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=3.6

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python36] $ /bin/sh -xe /tmp/jenkins8691613578021256474.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 3.6 virtual environment...

Using base prefix '/usr/local/python-3.6'
New python executable in 

Also creating executable in 

Installing setuptools, pip, wheel...done.
Running virtualenv with interpreter /usr/local/python-3.6/bin/python3
Ignoring backports.csv: markers 'python_version <= "2.7"' don't match your 
environment
Ignoring importlib: markers 'python_version <= "2.7"' don't match your 
environment
Ignoring psycopg2: markers 'python_version < "2.7"' don't match your environment
Ignoring Flask-Script: markers 'python_version < "2.7"' don't match your 
environment
Ignoring ordereddict: markers 'python_version < "2.7"' don't match your 
environment
Ignoring python-dateutil: markers 'python_version < "2.7"' don't match your 
environment
Ignoring SQLAlchemy: markers 'python_version < "2.7"' don't match your 
environment
Ignoring Flask-Security: markers 'python_version < "2.7"' don't match your 
environment
Ignoring Flask-BabelEx: markers 'python_version < "2.7"' don't match your 
environment
Collecting blinker==1.4 (from -r requirements.txt (line 6))
Collecting extras==1.0.0 (from -r requirements.txt (line 7))
  Using cached 
https://files.pythonhosted.org/packages/03/e9/e915af1f97914cd0bc021e125fd1bfd4106de614a275e4b6866dd9a209ac/extras-1.0.0-py2.py3-none-any.whl
Collecting fixtures==3.0.0 (from -r requirements.txt (line 8))
  Using cached 
https://files.pythonhosted.org/packages/a8/28/7eed6bf76792f418029a18d5b2ace87ce7562927cdd00f1cefe481cd148f/fixtures-3.0.0-py2.py3-none-any.whl
Collecting Flask==0.12.2 (from -r requirements.txt (line 9))
  Using cached 
https://files.pythonhosted.org/packages/77/32/e3597cb19e724ad4bf0beca4153419918e7fa4ba6a34b04ee4da3371/Flask-0.12.2-py2.py3-none-any.whl
Collecting Flask-Gravatar==0.5.0 (from -r requirements.txt (line 10))
  Using cached 
https://files.pythonhosted.org/packages/58/4a/b20260e8d383d0037f2791dd8a3f3ea729ca9f02d7638677a34a236a8702/Flask_Gravatar-0.5.0-py2.py3-none-any.whl
Collecting Flask-Login==0.3.2 (from -r requirements.txt (line 11))
Collecting Flask-Mail==0.9.1 (from -r requirements.txt (line 12))
Collecting Flask-Migrate==2.1.1 (from -r requirements.txt (line 13))
  Using cached 
https://files.pythonhosted.org/packages/c6/06/053630cb5fe3974c7d60c2d3f3907bae6ff86beb8720bd4fcf53c45c6702/Flask_Migrate-2.1.1-py2.py3-none-any.whl
Collecting Flask-Principal==0.4.0 (from -r requirements.txt (line 14))
Collecting Flask-SQLAlchemy==2.3.2 (from -r requirements.txt (line 15))
  Using cached 
https://files.pythonhosted.org/packages/a1/44/294fb7f6bf49cc7224417cd0637018db9fee0729b4fe166e43e2bbb1f1c8/Flask_SQLAlchemy-2.3.2-py2.py3-none-any.whl
Collecting Flask-WTF==0.14.2 (from -r requirements.txt (line 16))
  Using cached 
https://files.pythonhosted.org/packages/60/3a/58c629472d10539ae5167dc7c1fecfa95dd7d0b7864623931e3776438a24/Flask_WTF-0.14.2-py2.py3-none-any.whl
Collecting html5lib==1.0.1 (from -r requirements.txt (line 17))
  Using cached 
https://files.pythonhosted.org/packages/a5/62/bbd2be0e7943ec8504b517e62bab011b4946e1258842bc159e5dfde15b96/html5lib-1.0.

Build failed in Jenkins: pgadmin4-master-python34 #771

2018-10-15 Thread pgAdmin 4 Jenkins

See 


Changes:

[akshay.joshi] Fixed minor issue in SQL autocomplete.

--
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building in workspace 

 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url git://git.postgresql.org/git/pgadmin4.git # 
 > timeout=10
Cleaning workspace
 > git rev-parse --verify HEAD # timeout=10
Resetting working tree
 > git reset --hard # timeout=10
 > git clean -fdx # timeout=10
Fetching upstream changes from git://git.postgresql.org/git/pgadmin4.git
 > git --version # timeout=10
 > git fetch --tags --progress git://git.postgresql.org/git/pgadmin4.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision fd2c2c4ff786fc15989066b6546712049368b39d (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f fd2c2c4ff786fc15989066b6546712049368b39d
Commit message: "Fixed minor issue in SQL autocomplete."
 > git rev-list --no-walk d6c4911135dca8bbb703f0c4994ce8ffe19461d0 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=3.4

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python34] $ /bin/sh -xe /tmp/jenkins2181283853271502917.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 3.4 virtual environment...

Using base prefix '/usr/local/python-3.4'
New python executable in 

Also creating executable in 

Installing setuptools, pip, wheel...done.
Running virtualenv with interpreter /usr/local/python-3.4/bin/python3
Ignoring backports.csv: markers 'python_version <= "2.7"' don't match your 
environment
Ignoring importlib: markers 'python_version <= "2.7"' don't match your 
environment
Ignoring psycopg2: markers 'python_version < "2.7"' don't match your environment
Ignoring Flask-Script: markers 'python_version < "2.7"' don't match your 
environment
Ignoring ordereddict: markers 'python_version < "2.7"' don't match your 
environment
Ignoring python-dateutil: markers 'python_version < "2.7"' don't match your 
environment
Ignoring SQLAlchemy: markers 'python_version < "2.7"' don't match your 
environment
Ignoring Flask-Security: markers 'python_version < "2.7"' don't match your 
environment
Ignoring Flask-BabelEx: markers 'python_version < "2.7"' don't match your 
environment
Collecting blinker==1.4 (from -r requirements.txt (line 6))
Collecting extras==1.0.0 (from -r requirements.txt (line 7))
  Using cached 
https://files.pythonhosted.org/packages/03/e9/e915af1f97914cd0bc021e125fd1bfd4106de614a275e4b6866dd9a209ac/extras-1.0.0-py2.py3-none-any.whl
Collecting fixtures==3.0.0 (from -r requirements.txt (line 8))
  Using cached 
https://files.pythonhosted.org/packages/a8/28/7eed6bf76792f418029a18d5b2ace87ce7562927cdd00f1cefe481cd148f/fixtures-3.0.0-py2.py3-none-any.whl
Collecting Flask==0.12.2 (from -r requirements.txt (line 9))
  Using cached 
https://files.pythonhosted.org/packages/77/32/e3597cb19e724ad4bf0beca4153419918e7fa4ba6a34b04ee4da3371/Flask-0.12.2-py2.py3-none-any.whl
Collecting Flask-Gravatar==0.5.0 (from -r requirements.txt (line 10))
  Using cached 
https://files.pythonhosted.org/packages/58/4a/b20260e8d383d0037f2791dd8a3f3ea729ca9f02d7638677a34a236a8702/Flask_Gravatar-0.5.0-py2.py3-none-any.whl
Collecting Flask-Login==0.3.2 (from -r requirements.txt (line 11))
Collecting Flask-Mail==0.9.1 (from -r requirements.txt (line 12))
Collecting Flask-Migrate==2.1.1 (from -r requirements.txt (line 13))
  Using cached 
https://files.pythonhosted.org/packages/c6/06/053630cb5fe3974c7d60c2d3f3907bae6ff86beb8720bd4fcf53c45c6702/Flask_Migrate-2.1.1-py2.py3-none-any.whl
Collecting Flask-Principal==0.4.0 (from -r requirements.txt (line 14))
Collecting Flask-SQLAlchemy==2.3.2 (from -r requirements.txt (line 15))
  Using cached 
https://files.pythonhosted.org/packages/a1/44/294fb7f6bf49cc7224417cd0637018db9fee0729b4fe166e43e2bbb1f1c8/Flask_SQLAlchemy-2.3.2-py2.py3-none-any.whl
Collecting Flask-WTF==0.14.2 (from -r requirements.txt (line 16))
  Using cached 
https://files.pythonhosted.org/packages/60/3a/58c629472d10539ae5167dc7c1fecfa95dd7d0b7864623931e3776438a24/Flask_WTF-0.14.2-py2.py3-none-any.whl
Collecting html5lib==1.0.1 (from -r requirements.txt (line 17))
  Using cached 
https://files.pythonhosted.org/packages/a5/62/bbd2be0e7943ec8504b517e62bab011b4946e1258842bc159e5dfde15b96/html5lib-1.0.

Build failed in Jenkins: pgadmin4-master-python37 #19

2018-10-15 Thread pgAdmin 4 Jenkins

See 


Changes:

[akshay.joshi] Fixed minor issue in SQL autocomplete.

--
[...truncated 147 B...]
Fetching changes from the remote Git repository
 > git config remote.origin.url git://git.postgresql.org/git/pgadmin4.git # 
 > timeout=10
Cleaning workspace
 > git rev-parse --verify HEAD # timeout=10
Resetting working tree
 > git reset --hard # timeout=10
 > git clean -fdx # timeout=10
Fetching upstream changes from git://git.postgresql.org/git/pgadmin4.git
 > git --version # timeout=10
 > git fetch --tags --progress git://git.postgresql.org/git/pgadmin4.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision fd2c2c4ff786fc15989066b6546712049368b39d (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f fd2c2c4ff786fc15989066b6546712049368b39d
Commit message: "Fixed minor issue in SQL autocomplete."
 > git rev-list --no-walk d6c4911135dca8bbb703f0c4994ce8ffe19461d0 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=3.7

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python37] $ /bin/sh -xe /tmp/jenkins3414062876370494707.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 3.7 virtual environment...

Using base prefix '/usr/local/python-3.7'
New python executable in 

Also creating executable in 

Installing setuptools, pip, wheel...done.
/usr/lib/python2.7/site-packages/virtualenv.py:1039: DeprecationWarning: the 
imp module is deprecated in favour of importlib; see the module's documentation 
for alternative uses
  import imp
Running virtualenv with interpreter /usr/local/python-3.7/bin/python3
Ignoring backports.csv: markers 'python_version <= "2.7"' don't match your 
environment
Ignoring importlib: markers 'python_version <= "2.7"' don't match your 
environment
Ignoring psycopg2: markers 'python_version < "2.7"' don't match your environment
Ignoring Flask-Script: markers 'python_version < "2.7"' don't match your 
environment
Ignoring ordereddict: markers 'python_version < "2.7"' don't match your 
environment
Ignoring python-dateutil: markers 'python_version < "2.7"' don't match your 
environment
Ignoring SQLAlchemy: markers 'python_version < "2.7"' don't match your 
environment
Ignoring Flask-Security: markers 'python_version < "2.7"' don't match your 
environment
Ignoring Flask-BabelEx: markers 'python_version < "2.7"' don't match your 
environment
Collecting blinker==1.4 (from -r requirements.txt (line 6))
Collecting extras==1.0.0 (from -r requirements.txt (line 7))
  Using cached 
https://files.pythonhosted.org/packages/03/e9/e915af1f97914cd0bc021e125fd1bfd4106de614a275e4b6866dd9a209ac/extras-1.0.0-py2.py3-none-any.whl
Collecting fixtures==3.0.0 (from -r requirements.txt (line 8))
  Using cached 
https://files.pythonhosted.org/packages/a8/28/7eed6bf76792f418029a18d5b2ace87ce7562927cdd00f1cefe481cd148f/fixtures-3.0.0-py2.py3-none-any.whl
Collecting Flask==0.12.2 (from -r requirements.txt (line 9))
  Using cached 
https://files.pythonhosted.org/packages/77/32/e3597cb19e724ad4bf0beca4153419918e7fa4ba6a34b04ee4da3371/Flask-0.12.2-py2.py3-none-any.whl
Collecting Flask-Gravatar==0.5.0 (from -r requirements.txt (line 10))
  Using cached 
https://files.pythonhosted.org/packages/58/4a/b20260e8d383d0037f2791dd8a3f3ea729ca9f02d7638677a34a236a8702/Flask_Gravatar-0.5.0-py2.py3-none-any.whl
Collecting Flask-Login==0.3.2 (from -r requirements.txt (line 11))
Collecting Flask-Mail==0.9.1 (from -r requirements.txt (line 12))
Collecting Flask-Migrate==2.1.1 (from -r requirements.txt (line 13))
  Using cached 
https://files.pythonhosted.org/packages/c6/06/053630cb5fe3974c7d60c2d3f3907bae6ff86beb8720bd4fcf53c45c6702/Flask_Migrate-2.1.1-py2.py3-none-any.whl
Collecting Flask-Principal==0.4.0 (from -r requirements.txt (line 14))
Collecting Flask-SQLAlchemy==2.3.2 (from -r requirements.txt (line 15))
  Using cached 
https://files.pythonhosted.org/packages/a1/44/294fb7f6bf49cc7224417cd0637018db9fee0729b4fe166e43e2bbb1f1c8/Flask_SQLAlchemy-2.3.2-py2.py3-none-any.whl
Collecting Flask-WTF==0.14.2 (from -r requirements.txt (line 16))
  Using cached 
https://files.pythonhosted.org/packages/60/3a/58c629472d10539ae5167dc7c1fecfa95dd7d0b7864623931e3776438a24/Flask_WTF-0.14.2-py2.py3-none-any.whl
Collecting html5lib==1.0.1 (from -r requirements.txt (line 17))
  Using cached 
https://files.pythonhosted.org/packages/a5/62/bbd2be0e7943ec8504b517e62bab011b4946e1258842bc159e5dfde15b96/html5lib-1

pgAdmin 4 commit: Fixed pep8 issue

2018-10-15 Thread Akshay Joshi

Fixed pep8 issue

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=ef0e53e8fc89231ad04f56dd76f7e8f3d4f34c94

Modified Files
--
web/pgadmin/utils/sqlautocomplete/autocomplete.py | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)

Build failed in Jenkins: pgadmin4-master-python27 #784

2018-10-15 Thread pgAdmin 4 Jenkins

See 


Changes:

[akshay.joshi] Fixed minor issue in SQL autocomplete.

--
[...truncated 587 B...]
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision fd2c2c4ff786fc15989066b6546712049368b39d (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f fd2c2c4ff786fc15989066b6546712049368b39d
Commit message: "Fixed minor issue in SQL autocomplete."
 > git rev-list --no-walk d6c4911135dca8bbb703f0c4994ce8ffe19461d0 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=2.7

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python27] $ /bin/sh -xe /tmp/jenkins4523367826866244170.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 2.7 virtual environment...

New python executable in 

Installing setuptools, pip, wheel...done.
Running virtualenv with interpreter /usr/local/python-2.7/bin/python
Ignoring psycopg2: markers 'python_version < "2.7"' don't match your environment
Ignoring Flask-Script: markers 'python_version < "2.7"' don't match your 
environment
Ignoring ordereddict: markers 'python_version < "2.7"' don't match your 
environment
Ignoring python-dateutil: markers 'python_version < "2.7"' don't match your 
environment
Ignoring SQLAlchemy: markers 'python_version < "2.7"' don't match your 
environment
Ignoring Flask-Security: markers 'python_version < "2.7"' don't match your 
environment
Ignoring Flask-BabelEx: markers 'python_version < "2.7"' don't match your 
environment
Collecting blinker==1.4 (from -r requirements.txt (line 6))
Collecting extras==1.0.0 (from -r requirements.txt (line 7))
  Using cached 
https://files.pythonhosted.org/packages/03/e9/e915af1f97914cd0bc021e125fd1bfd4106de614a275e4b6866dd9a209ac/extras-1.0.0-py2.py3-none-any.whl
Collecting fixtures==3.0.0 (from -r requirements.txt (line 8))
  Using cached 
https://files.pythonhosted.org/packages/a8/28/7eed6bf76792f418029a18d5b2ace87ce7562927cdd00f1cefe481cd148f/fixtures-3.0.0-py2.py3-none-any.whl
Collecting Flask==0.12.2 (from -r requirements.txt (line 9))
  Using cached 
https://files.pythonhosted.org/packages/77/32/e3597cb19e724ad4bf0beca4153419918e7fa4ba6a34b04ee4da3371/Flask-0.12.2-py2.py3-none-any.whl
Collecting Flask-Gravatar==0.5.0 (from -r requirements.txt (line 10))
  Using cached 
https://files.pythonhosted.org/packages/58/4a/b20260e8d383d0037f2791dd8a3f3ea729ca9f02d7638677a34a236a8702/Flask_Gravatar-0.5.0-py2.py3-none-any.whl
Collecting Flask-Login==0.3.2 (from -r requirements.txt (line 11))
Collecting Flask-Mail==0.9.1 (from -r requirements.txt (line 12))
Collecting Flask-Migrate==2.1.1 (from -r requirements.txt (line 13))
  Using cached 
https://files.pythonhosted.org/packages/c6/06/053630cb5fe3974c7d60c2d3f3907bae6ff86beb8720bd4fcf53c45c6702/Flask_Migrate-2.1.1-py2.py3-none-any.whl
Collecting Flask-Principal==0.4.0 (from -r requirements.txt (line 14))
Collecting Flask-SQLAlchemy==2.3.2 (from -r requirements.txt (line 15))
  Using cached 
https://files.pythonhosted.org/packages/a1/44/294fb7f6bf49cc7224417cd0637018db9fee0729b4fe166e43e2bbb1f1c8/Flask_SQLAlchemy-2.3.2-py2.py3-none-any.whl
Collecting Flask-WTF==0.14.2 (from -r requirements.txt (line 16))
  Using cached 
https://files.pythonhosted.org/packages/60/3a/58c629472d10539ae5167dc7c1fecfa95dd7d0b7864623931e3776438a24/Flask_WTF-0.14.2-py2.py3-none-any.whl
Collecting html5lib==1.0.1 (from -r requirements.txt (line 17))
  Using cached 
https://files.pythonhosted.org/packages/a5/62/bbd2be0e7943ec8504b517e62bab011b4946e1258842bc159e5dfde15b96/html5lib-1.0.1-py2.py3-none-any.whl
Collecting linecache2==1.0.0 (from -r requirements.txt (line 18))
  Using cached 
https://files.pythonhosted.org/packages/c7/a3/c5da2a44c85bfbb6eebcfc1dde24933f8704441b98fdde6528f4831757a6/linecache2-1.0.0-py2.py3-none-any.whl
Collecting passlib==1.7.1 (from -r requirements.txt (line 19))
  Using cached 
https://files.pythonhosted.org/packages/ee/a7/d6d238d927df355d4e4e000670342ca4705a72f0bf694027cf67d9bcf5af/passlib-1.7.1-py2.py3-none-any.whl
Collecting pbr==3.1.1 (from -r requirements.txt (line 20))
  Using cached 
https://files.pythonhosted.org/packages/0c/5d/b077dbf309993d52c1d71e6bf6fe443a8029ea215135ebbe0b1b10e7aefc/pbr-3.1.1-py2.py3-none-any.whl
Collecting pycrypto>=2.6.1 (from -r requirements.txt (line 21))
Collecting pyrsistent==0.14.2 (from -r requirements.txt (line 22))
Collecting python-mimeparse==1.6.0 (from -r requirements.txt (line 23))
  Using cached 
https://files.pythonhosted.org/packages/26/2e/03bce213a9bf02a2750dcb04e761785e9c763fc11071edc4b447eacbb842/python_mimepars

Build failed in Jenkins: pgadmin4-master-python35 #772

2018-10-15 Thread pgAdmin 4 Jenkins

See 


Changes:

[akshay.joshi] Fixed minor issue in SQL autocomplete.

--
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building in workspace 

 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url git://git.postgresql.org/git/pgadmin4.git # 
 > timeout=10
Cleaning workspace
 > git rev-parse --verify HEAD # timeout=10
Resetting working tree
 > git reset --hard # timeout=10
 > git clean -fdx # timeout=10
Fetching upstream changes from git://git.postgresql.org/git/pgadmin4.git
 > git --version # timeout=10
 > git fetch --tags --progress git://git.postgresql.org/git/pgadmin4.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision fd2c2c4ff786fc15989066b6546712049368b39d (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f fd2c2c4ff786fc15989066b6546712049368b39d
Commit message: "Fixed minor issue in SQL autocomplete."
 > git rev-list --no-walk d6c4911135dca8bbb703f0c4994ce8ffe19461d0 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=3.5

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python35] $ /bin/sh -xe /tmp/jenkins521616902158037033.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 3.5 virtual environment...

Using base prefix '/usr/local/python-3.5'
New python executable in 

Also creating executable in 

Installing setuptools, pip, wheel...done.
Running virtualenv with interpreter /usr/local/python-3.5/bin/python3
Ignoring backports.csv: markers 'python_version <= "2.7"' don't match your 
environment
Ignoring importlib: markers 'python_version <= "2.7"' don't match your 
environment
Ignoring psycopg2: markers 'python_version < "2.7"' don't match your environment
Ignoring Flask-Script: markers 'python_version < "2.7"' don't match your 
environment
Ignoring ordereddict: markers 'python_version < "2.7"' don't match your 
environment
Ignoring python-dateutil: markers 'python_version < "2.7"' don't match your 
environment
Ignoring SQLAlchemy: markers 'python_version < "2.7"' don't match your 
environment
Ignoring Flask-Security: markers 'python_version < "2.7"' don't match your 
environment
Ignoring Flask-BabelEx: markers 'python_version < "2.7"' don't match your 
environment
Collecting blinker==1.4 (from -r requirements.txt (line 6))
Collecting extras==1.0.0 (from -r requirements.txt (line 7))
  Using cached 
https://files.pythonhosted.org/packages/03/e9/e915af1f97914cd0bc021e125fd1bfd4106de614a275e4b6866dd9a209ac/extras-1.0.0-py2.py3-none-any.whl
Collecting fixtures==3.0.0 (from -r requirements.txt (line 8))
  Using cached 
https://files.pythonhosted.org/packages/a8/28/7eed6bf76792f418029a18d5b2ace87ce7562927cdd00f1cefe481cd148f/fixtures-3.0.0-py2.py3-none-any.whl
Collecting Flask==0.12.2 (from -r requirements.txt (line 9))
  Using cached 
https://files.pythonhosted.org/packages/77/32/e3597cb19e724ad4bf0beca4153419918e7fa4ba6a34b04ee4da3371/Flask-0.12.2-py2.py3-none-any.whl
Collecting Flask-Gravatar==0.5.0 (from -r requirements.txt (line 10))
  Using cached 
https://files.pythonhosted.org/packages/58/4a/b20260e8d383d0037f2791dd8a3f3ea729ca9f02d7638677a34a236a8702/Flask_Gravatar-0.5.0-py2.py3-none-any.whl
Collecting Flask-Login==0.3.2 (from -r requirements.txt (line 11))
Collecting Flask-Mail==0.9.1 (from -r requirements.txt (line 12))
Collecting Flask-Migrate==2.1.1 (from -r requirements.txt (line 13))
  Using cached 
https://files.pythonhosted.org/packages/c6/06/053630cb5fe3974c7d60c2d3f3907bae6ff86beb8720bd4fcf53c45c6702/Flask_Migrate-2.1.1-py2.py3-none-any.whl
Collecting Flask-Principal==0.4.0 (from -r requirements.txt (line 14))
Collecting Flask-SQLAlchemy==2.3.2 (from -r requirements.txt (line 15))
  Using cached 
https://files.pythonhosted.org/packages/a1/44/294fb7f6bf49cc7224417cd0637018db9fee0729b4fe166e43e2bbb1f1c8/Flask_SQLAlchemy-2.3.2-py2.py3-none-any.whl
Collecting Flask-WTF==0.14.2 (from -r requirements.txt (line 16))
  Using cached 
https://files.pythonhosted.org/packages/60/3a/58c629472d10539ae5167dc7c1fecfa95dd7d0b7864623931e3776438a24/Flask_WTF-0.14.2-py2.py3-none-any.whl
Collecting html5lib==1.0.1 (from -r requirements.txt (line 17))
  Using cached 
https://files.pythonhosted.org/packages/a5/62/bbd2be0e7943ec8504b517e62bab011b4946e1258842bc159e5dfde15b96/html5lib-1.0.1