public inbox for [email protected]  
help / color / mirror / Atom feed
Regression errors - database node
4+ messages / 2 participants
[nested] [flat]

* Regression errors - database node
@ 2016-09-19 15:52 Dave Page <[email protected]>
  2016-09-21 11:16 ` Re: Regression errors - database node Navnath Gadakh <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Dave Page @ 2016-09-19 15:52 UTC (permalink / raw)
  To: Navnath Gadakh <[email protected]>; +Cc: pgadmin-hackers

Hi Navnath

I keep seeing the errors below when running tests. It seems to be
consistent on EPAS, but intermittent on PG. Any ideas what the issue
is? I'm fairly convinced it's a test issue not an actual problem.

2016-09-19 16:47:49,567:ERROR:STDERR:======================================================================
2016-09-19 16:47:49,568:ERROR:STDERR:ERROR: runTest
(pgadmin.browser.server_groups.servers.databases.tests.test_db_get.DatabasesGetTestCase)
2016-09-19 16:47:49,568:ERROR:STDERR:This function will fetch added
database. (Check Databases Node URL)
2016-09-19 16:47:49,568:ERROR:STDERR:----------------------------------------------------------------------
2016-09-19 16:47:49,568:ERROR:STDERR:Traceback (most recent call last):
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/test_db_get.py",
line 33, in runTest
2016-09-19 16:47:49,568:ERROR:STDERR:    self.db_id)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/utils.py",
line 142, in verify_database
2016-09-19 16:47:49,568:ERROR:STDERR:    follow_redirects=True)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 788, in post
2016-09-19 16:47:49,568:ERROR:STDERR:    return self.open(*args, **kw)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/testing.py",
line 113, in open
2016-09-19 16:47:49,568:ERROR:STDERR:    follow_redirects=follow_redirects)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 751, in open
2016-09-19 16:47:49,568:ERROR:STDERR:    response =
self.run_wsgi_app(environ, buffered=buffered)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 668, in run_wsgi_app
2016-09-19 16:47:49,568:ERROR:STDERR:    rv =
run_wsgi_app(self.application, environ, buffered=buffered)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 871, in run_wsgi_app
2016-09-19 16:47:49,568:ERROR:STDERR:    app_rv = app(environ, start_response)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 2000, in __call__
2016-09-19 16:47:49,568:ERROR:STDERR:    return self.wsgi_app(environ,
start_response)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1991, in wsgi_app
2016-09-19 16:47:49,568:ERROR:STDERR:    response =
self.make_response(self.handle_exception(e))
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1567, in handle_exception
2016-09-19 16:47:49,568:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1988, in wsgi_app
2016-09-19 16:47:49,569:ERROR:STDERR:    response = self.full_dispatch_request()
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1641, in full_dispatch_request
2016-09-19 16:47:49,569:ERROR:STDERR:    rv = self.handle_user_exception(e)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1544, in handle_user_exception
2016-09-19 16:47:49,569:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1639, in full_dispatch_request
2016-09-19 16:47:49,569:ERROR:STDERR:    rv = self.dispatch_request()
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1625, in dispatch_request
2016-09-19 16:47:49,569:ERROR:STDERR:    return
self.view_functions[rule.endpoint](**req.view_args)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/views.py",
line 84, in view
2016-09-19 16:47:49,569:ERROR:STDERR:    return
self.dispatch_request(*args, **kwargs)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/utils.py", line 235, in
dispatch_request
2016-09-19 16:47:49,569:ERROR:STDERR:    return method(*args, **kwargs)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/__init__.py",
line 364, in connect
2016-09-19 16:47:49,569:ERROR:STDERR:    conn =
manager.connection(did=did, auto_reconnect=True)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/utils/driver/psycopg2/__init__.py",
line 1447, in connection
2016-09-19 16:47:49,569:ERROR:STDERR:    "Couldn't find the specified database."
2016-09-19 16:47:49,569:ERROR:STDERR:Exception: Couldn't find the
specified database.
2016-09-19 16:47:49,569:ERROR:STDERR:======================================================================
2016-09-19 16:47:49,569:ERROR:STDERR:ERROR: runTest
(pgadmin.browser.server_groups.servers.databases.tests.test_db_put.DatabasesUpdateTestCase)
2016-09-19 16:47:49,569:ERROR:STDERR:This function will update the
comments field of database. (Check Databases Node)
2016-09-19 16:47:49,569:ERROR:STDERR:----------------------------------------------------------------------
2016-09-19 16:47:49,570:ERROR:STDERR:Traceback (most recent call last):
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/test_db_put.py",
line 37, in runTest
2016-09-19 16:47:49,570:ERROR:STDERR:    db_id)
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/utils.py",
line 142, in verify_database
2016-09-19 16:47:49,570:ERROR:STDERR:    follow_redirects=True)
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 788, in post
2016-09-19 16:47:49,570:ERROR:STDERR:    return self.open(*args, **kw)
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/testing.py",
line 113, in open
2016-09-19 16:47:49,570:ERROR:STDERR:    follow_redirects=follow_redirects)
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 751, in open
2016-09-19 16:47:49,570:ERROR:STDERR:    response =
self.run_wsgi_app(environ, buffered=buffered)
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 668, in run_wsgi_app
2016-09-19 16:47:49,570:ERROR:STDERR:    rv =
run_wsgi_app(self.application, environ, buffered=buffered)
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 871, in run_wsgi_app
2016-09-19 16:47:49,570:ERROR:STDERR:    app_rv = app(environ, start_response)
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 2000, in __call__
2016-09-19 16:47:49,570:ERROR:STDERR:    return self.wsgi_app(environ,
start_response)
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1991, in wsgi_app
2016-09-19 16:47:49,570:ERROR:STDERR:    response =
self.make_response(self.handle_exception(e))
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1567, in handle_exception
2016-09-19 16:47:49,570:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1988, in wsgi_app
2016-09-19 16:47:49,570:ERROR:STDERR:    response = self.full_dispatch_request()
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1641, in full_dispatch_request
2016-09-19 16:47:49,570:ERROR:STDERR:    rv = self.handle_user_exception(e)
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1544, in handle_user_exception
2016-09-19 16:47:49,570:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1639, in full_dispatch_request
2016-09-19 16:47:49,570:ERROR:STDERR:    rv = self.dispatch_request()
2016-09-19 16:47:49,570:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1625, in dispatch_request
2016-09-19 16:47:49,571:ERROR:STDERR:    return
self.view_functions[rule.endpoint](**req.view_args)
2016-09-19 16:47:49,571:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/views.py",
line 84, in view
2016-09-19 16:47:49,571:ERROR:STDERR:    return
self.dispatch_request(*args, **kwargs)
2016-09-19 16:47:49,571:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/utils.py", line 235, in
dispatch_request
2016-09-19 16:47:49,571:ERROR:STDERR:    return method(*args, **kwargs)
2016-09-19 16:47:49,571:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/__init__.py",
line 364, in connect
2016-09-19 16:47:49,571:ERROR:STDERR:    conn =
manager.connection(did=did, auto_reconnect=True)
2016-09-19 16:47:49,571:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/utils/driver/psycopg2/__init__.py",
line 1447, in connection
2016-09-19 16:47:49,571:ERROR:STDERR:    "Couldn't find the specified database."
2016-09-19 16:47:49,571:ERROR:STDERR:Exception: Couldn't find the
specified database.
2016-09-19 16:47:49,571:ERROR:STDERR:======================================================================
2016-09-19 16:47:49,571:ERROR:STDERR:FAIL: runTest
(pgadmin.browser.server_groups.servers.databases.tests.test_db_delete.DatabaseDeleteTestCase)
2016-09-19 16:47:49,571:ERROR:STDERR:This function will delete the
database. (Check Databases Node URL)
2016-09-19 16:47:49,571:ERROR:STDERR:----------------------------------------------------------------------
2016-09-19 16:47:49,571:ERROR:STDERR:Traceback (most recent call last):
2016-09-19 16:47:49,571:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/test_db_delete.py",
line 38, in runTest
2016-09-19 16:47:49,571:ERROR:STDERR:
self.assertEquals(response.status_code, 200)
2016-09-19 16:47:49,571:ERROR:STDERR:AssertionError: 410 != 200
2016-09-19 16:47:49,571:ERROR:STDERR:----------------------------------------------------------------------
2016-09-19 16:47:49,571:ERROR:STDERR:Ran 25 tests in 12.664s
2016-09-19 16:47:49,571:ERROR:STDERR:FAILED
2016-09-19 16:47:49,571:ERROR:STDERR: (failures=1, errors=2)
2016-09-19 16:47:50,033:ERROR:STDERR:
2016-09-19 16:47:50,033:ERROR:STDERR:Test Result Summary
2016-09-19 16:47:50,033:ERROR:STDERR:============================
2016-09-19 16:47:50,033:ERROR:STDERR:Regression - EPAS 9.5: 22 tests
passed, 3 tests failed :
2016-09-19 16:47:50,033:ERROR:STDERR:  DatabaseDeleteTestCase
2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesGetTestCase
2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesUpdateTestCase
2016-09-19 16:47:50,033:ERROR:STDERR:Regression - PG 9.5: 22 tests
passed, 3 tests failed :
2016-09-19 16:47:50,033:ERROR:STDERR:  DatabaseDeleteTestCase
2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesGetTestCase
2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesUpdateTestCase
2016-09-19 16:47:50,034:ERROR:STDERR:Regression - PG 9.4: 25 tests
passed, 0 tests failed
2016-09-19 16:47:50,034:ERROR:STDERR:============================



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Regression errors - database node
  2016-09-19 15:52 Regression errors - database node Dave Page <[email protected]>
@ 2016-09-21 11:16 ` Navnath Gadakh <[email protected]>
  2016-09-22 11:36   ` Re: Regression errors - database node Navnath Gadakh <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Navnath Gadakh @ 2016-09-21 11:16 UTC (permalink / raw)
  To: Dave Page <[email protected]>; +Cc: pgadmin-hackers

Hi Dave,
     After a long debugging of these errors with Harshal, we found the
issue is in the handling pyscopg connection. Need to add some code in the
pyscopg connection manager as per Harshal.

For more details, Please refer RM #1720.
<https://redmine.postgresql.org/issues/1720;

@Harshal, thanks for the time invested.

Thanks.



On Mon, Sep 19, 2016 at 9:22 PM, Dave Page <[email protected]> wrote:

> Hi Navnath
>
> I keep seeing the errors below when running tests. It seems to be
> consistent on EPAS, but intermittent on PG. Any ideas what the issue
> is? I'm fairly convinced it's a test issue not an actual problem.
>
> 2016-09-19 16:47:49,567:ERROR:STDERR:==================================
> ====================================
> 2016-09-19 16:47:49,568:ERROR:STDERR:ERROR: runTest
> (pgadmin.browser.server_groups.servers.databases.tests.test_db_get.
> DatabasesGetTestCase)
> 2016-09-19 16:47:49,568:ERROR:STDERR:This function will fetch added
> database. (Check Databases Node URL)
> 2016-09-19 16:47:49,568:ERROR:STDERR:----------------------------------
> ------------------------------------
> 2016-09-19 16:47:49,568:ERROR:STDERR:Traceback (most recent call last):
> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_
> groups/servers/databases/tests/test_db_get.py",
> line 33, in runTest
> 2016-09-19 16:47:49,568:ERROR:STDERR:    self.db_id)
> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_
> groups/servers/databases/tests/utils.py",
> line 142, in verify_database
> 2016-09-19 16:47:49,568:ERROR:STDERR:    follow_redirects=True)
> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/werkzeug/test.py",
> line 788, in post
> 2016-09-19 16:47:49,568:ERROR:STDERR:    return self.open(*args, **kw)
> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/testing.py",
> line 113, in open
> 2016-09-19 16:47:49,568:ERROR:STDERR:    follow_redirects=follow_
> redirects)
> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/werkzeug/test.py",
> line 751, in open
> 2016-09-19 16:47:49,568:ERROR:STDERR:    response =
> self.run_wsgi_app(environ, buffered=buffered)
> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/werkzeug/test.py",
> line 668, in run_wsgi_app
> 2016-09-19 16:47:49,568:ERROR:STDERR:    rv =
> run_wsgi_app(self.application, environ, buffered=buffered)
> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/werkzeug/test.py",
> line 871, in run_wsgi_app
> 2016-09-19 16:47:49,568:ERROR:STDERR:    app_rv = app(environ,
> start_response)
> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 2000, in __call__
> 2016-09-19 16:47:49,568:ERROR:STDERR:    return self.wsgi_app(environ,
> start_response)
> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1991, in wsgi_app
> 2016-09-19 16:47:49,568:ERROR:STDERR:    response =
> self.make_response(self.handle_exception(e))
> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1567, in handle_exception
> 2016-09-19 16:47:49,568:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1988, in wsgi_app
> 2016-09-19 16:47:49,569:ERROR:STDERR:    response =
> self.full_dispatch_request()
> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1641, in full_dispatch_request
> 2016-09-19 16:47:49,569:ERROR:STDERR:    rv = self.handle_user_exception(e)
> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1544, in handle_user_exception
> 2016-09-19 16:47:49,569:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1639, in full_dispatch_request
> 2016-09-19 16:47:49,569:ERROR:STDERR:    rv = self.dispatch_request()
> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1625, in dispatch_request
> 2016-09-19 16:47:49,569:ERROR:STDERR:    return
> self.view_functions[rule.endpoint](**req.view_args)
> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/views.py",
> line 84, in view
> 2016-09-19 16:47:49,569:ERROR:STDERR:    return
> self.dispatch_request(*args, **kwargs)
> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/utils.py", line 235, in
> dispatch_request
> 2016-09-19 16:47:49,569:ERROR:STDERR:    return method(*args, **kwargs)
> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_
> groups/servers/databases/__init__.py",
> line 364, in connect
> 2016-09-19 16:47:49,569:ERROR:STDERR:    conn =
> manager.connection(did=did, auto_reconnect=True)
> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
> "/Users/dpage/git/pgadmin4/web/pgadmin/utils/driver/psycopg2/__init__.py",
> line 1447, in connection
> 2016-09-19 16:47:49,569:ERROR:STDERR:    "Couldn't find the specified
> database."
> 2016-09-19 16:47:49,569:ERROR:STDERR:Exception: Couldn't find the
> specified database.
> 2016-09-19 16:47:49,569:ERROR:STDERR:==================================
> ====================================
> 2016-09-19 16:47:49,569:ERROR:STDERR:ERROR: runTest
> (pgadmin.browser.server_groups.servers.databases.tests.test_db_put.
> DatabasesUpdateTestCase)
> 2016-09-19 16:47:49,569:ERROR:STDERR:This function will update the
> comments field of database. (Check Databases Node)
> 2016-09-19 16:47:49,569:ERROR:STDERR:----------------------------------
> ------------------------------------
> 2016-09-19 16:47:49,570:ERROR:STDERR:Traceback (most recent call last):
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_
> groups/servers/databases/tests/test_db_put.py",
> line 37, in runTest
> 2016-09-19 16:47:49,570:ERROR:STDERR:    db_id)
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_
> groups/servers/databases/tests/utils.py",
> line 142, in verify_database
> 2016-09-19 16:47:49,570:ERROR:STDERR:    follow_redirects=True)
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/werkzeug/test.py",
> line 788, in post
> 2016-09-19 16:47:49,570:ERROR:STDERR:    return self.open(*args, **kw)
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/testing.py",
> line 113, in open
> 2016-09-19 16:47:49,570:ERROR:STDERR:    follow_redirects=follow_
> redirects)
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/werkzeug/test.py",
> line 751, in open
> 2016-09-19 16:47:49,570:ERROR:STDERR:    response =
> self.run_wsgi_app(environ, buffered=buffered)
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/werkzeug/test.py",
> line 668, in run_wsgi_app
> 2016-09-19 16:47:49,570:ERROR:STDERR:    rv =
> run_wsgi_app(self.application, environ, buffered=buffered)
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/werkzeug/test.py",
> line 871, in run_wsgi_app
> 2016-09-19 16:47:49,570:ERROR:STDERR:    app_rv = app(environ,
> start_response)
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 2000, in __call__
> 2016-09-19 16:47:49,570:ERROR:STDERR:    return self.wsgi_app(environ,
> start_response)
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1991, in wsgi_app
> 2016-09-19 16:47:49,570:ERROR:STDERR:    response =
> self.make_response(self.handle_exception(e))
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1567, in handle_exception
> 2016-09-19 16:47:49,570:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1988, in wsgi_app
> 2016-09-19 16:47:49,570:ERROR:STDERR:    response =
> self.full_dispatch_request()
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1641, in full_dispatch_request
> 2016-09-19 16:47:49,570:ERROR:STDERR:    rv = self.handle_user_exception(e)
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1544, in handle_user_exception
> 2016-09-19 16:47:49,570:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1639, in full_dispatch_request
> 2016-09-19 16:47:49,570:ERROR:STDERR:    rv = self.dispatch_request()
> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/app.py",
> line 1625, in dispatch_request
> 2016-09-19 16:47:49,571:ERROR:STDERR:    return
> self.view_functions[rule.endpoint](**req.view_args)
> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-
> packages/flask/views.py",
> line 84, in view
> 2016-09-19 16:47:49,571:ERROR:STDERR:    return
> self.dispatch_request(*args, **kwargs)
> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/utils.py", line 235, in
> dispatch_request
> 2016-09-19 16:47:49,571:ERROR:STDERR:    return method(*args, **kwargs)
> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_
> groups/servers/databases/__init__.py",
> line 364, in connect
> 2016-09-19 16:47:49,571:ERROR:STDERR:    conn =
> manager.connection(did=did, auto_reconnect=True)
> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
> "/Users/dpage/git/pgadmin4/web/pgadmin/utils/driver/psycopg2/__init__.py",
> line 1447, in connection
> 2016-09-19 16:47:49,571:ERROR:STDERR:    "Couldn't find the specified
> database."
> 2016-09-19 16:47:49,571:ERROR:STDERR:Exception: Couldn't find the
> specified database.
> 2016-09-19 16:47:49,571:ERROR:STDERR:==================================
> ====================================
> 2016-09-19 16:47:49,571:ERROR:STDERR:FAIL: runTest
> (pgadmin.browser.server_groups.servers.databases.tests.test_db_delete.
> DatabaseDeleteTestCase)
> 2016-09-19 16:47:49,571:ERROR:STDERR:This function will delete the
> database. (Check Databases Node URL)
> 2016-09-19 16:47:49,571:ERROR:STDERR:----------------------------------
> ------------------------------------
> 2016-09-19 16:47:49,571:ERROR:STDERR:Traceback (most recent call last):
> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_
> groups/servers/databases/tests/test_db_delete.py",
> line 38, in runTest
> 2016-09-19 16:47:49,571:ERROR:STDERR:
> self.assertEquals(response.status_code, 200)
> 2016-09-19 16:47:49,571:ERROR:STDERR:AssertionError: 410 != 200
> 2016-09-19 16:47:49,571:ERROR:STDERR:----------------------------------
> ------------------------------------
> 2016-09-19 16:47:49,571:ERROR:STDERR:Ran 25 tests in 12.664s
> 2016-09-19 16:47:49,571:ERROR:STDERR:FAILED
> 2016-09-19 16:47:49,571:ERROR:STDERR: (failures=1, errors=2)
> 2016-09-19 16:47:50,033:ERROR:STDERR:
> 2016-09-19 16:47:50,033:ERROR:STDERR:Test Result Summary
> 2016-09-19 16:47:50,033:ERROR:STDERR:============================
> 2016-09-19 16:47:50,033:ERROR:STDERR:Regression - EPAS 9.5: 22 tests
> passed, 3 tests failed :
> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabaseDeleteTestCase
> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesGetTestCase
> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesUpdateTestCase
> 2016-09-19 16:47:50,033:ERROR:STDERR:Regression - PG 9.5: 22 tests
> passed, 3 tests failed :
> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabaseDeleteTestCase
> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesGetTestCase
> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesUpdateTestCase
> 2016-09-19 16:47:50,034:ERROR:STDERR:Regression - PG 9.4: 25 tests
> passed, 0 tests failed
> 2016-09-19 16:47:50,034:ERROR:STDERR:============================
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>



-- 
Regards,
Navnath


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Regression errors - database node
  2016-09-19 15:52 Regression errors - database node Dave Page <[email protected]>
  2016-09-21 11:16 ` Re: Regression errors - database node Navnath Gadakh <[email protected]>
@ 2016-09-22 11:36   ` Navnath Gadakh <[email protected]>
  2016-09-22 12:00     ` Re: Regression errors - database node Dave Page <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Navnath Gadakh @ 2016-09-22 11:36 UTC (permalink / raw)
  To: Dave Page <[email protected]>; +Cc: pgadmin-hackers

Hi Dave,
       Please find the attached revised patch for regression errors which
we faced.
Firstly,  apply patch for RM#1720(Harshal worked on this) and then apply
this patch. There is some code change in test suite due to code
modification in dev side.

Note: Run test suite only for server or database node.

Thanks.




On Wed, Sep 21, 2016 at 4:46 PM, Navnath Gadakh <
[email protected]> wrote:

> Hi Dave,
>      After a long debugging of these errors with Harshal, we found the
> issue is in the handling pyscopg connection. Need to add some code in the
> pyscopg connection manager as per Harshal.
>
> For more details, Please refer RM #1720.
> <https://redmine.postgresql.org/issues/1720;
>
> @Harshal, thanks for the time invested.
>
> Thanks.
>
>
>
> On Mon, Sep 19, 2016 at 9:22 PM, Dave Page <[email protected]> wrote:
>
>> Hi Navnath
>>
>> I keep seeing the errors below when running tests. It seems to be
>> consistent on EPAS, but intermittent on PG. Any ideas what the issue
>> is? I'm fairly convinced it's a test issue not an actual problem.
>>
>> 2016-09-19 16:47:49,567:ERROR:STDERR:==================================
>> ====================================
>> 2016-09-19 16:47:49,568:ERROR:STDERR:ERROR: runTest
>> (pgadmin.browser.server_groups.servers.databases.tests.test_
>> db_get.DatabasesGetTestCase)
>> 2016-09-19 16:47:49,568:ERROR:STDERR:This function will fetch added
>> database. (Check Databases Node URL)
>> 2016-09-19 16:47:49,568:ERROR:STDERR:----------------------------------
>> ------------------------------------
>> 2016-09-19 16:47:49,568:ERROR:STDERR:Traceback (most recent call last):
>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups
>> /servers/databases/tests/test_db_get.py",
>> line 33, in runTest
>> 2016-09-19 16:47:49,568:ERROR:STDERR:    self.db_id)
>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups
>> /servers/databases/tests/utils.py",
>> line 142, in verify_database
>> 2016-09-19 16:47:49,568:ERROR:STDERR:    follow_redirects=True)
>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/werkzeug/test.py",
>> line 788, in post
>> 2016-09-19 16:47:49,568:ERROR:STDERR:    return self.open(*args, **kw)
>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/testing.py",
>> line 113, in open
>> 2016-09-19 16:47:49,568:ERROR:STDERR:    follow_redirects=follow_redire
>> cts)
>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/werkzeug/test.py",
>> line 751, in open
>> 2016-09-19 16:47:49,568:ERROR:STDERR:    response =
>> self.run_wsgi_app(environ, buffered=buffered)
>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/werkzeug/test.py",
>> line 668, in run_wsgi_app
>> 2016-09-19 16:47:49,568:ERROR:STDERR:    rv =
>> run_wsgi_app(self.application, environ, buffered=buffered)
>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/werkzeug/test.py",
>> line 871, in run_wsgi_app
>> 2016-09-19 16:47:49,568:ERROR:STDERR:    app_rv = app(environ,
>> start_response)
>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 2000, in __call__
>> 2016-09-19 16:47:49,568:ERROR:STDERR:    return self.wsgi_app(environ,
>> start_response)
>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1991, in wsgi_app
>> 2016-09-19 16:47:49,568:ERROR:STDERR:    response =
>> self.make_response(self.handle_exception(e))
>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1567, in handle_exception
>> 2016-09-19 16:47:49,568:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1988, in wsgi_app
>> 2016-09-19 16:47:49,569:ERROR:STDERR:    response =
>> self.full_dispatch_request()
>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1641, in full_dispatch_request
>> 2016-09-19 16:47:49,569:ERROR:STDERR:    rv =
>> self.handle_user_exception(e)
>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1544, in handle_user_exception
>> 2016-09-19 16:47:49,569:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1639, in full_dispatch_request
>> 2016-09-19 16:47:49,569:ERROR:STDERR:    rv = self.dispatch_request()
>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1625, in dispatch_request
>> 2016-09-19 16:47:49,569:ERROR:STDERR:    return
>> self.view_functions[rule.endpoint](**req.view_args)
>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/views.py",
>> line 84, in view
>> 2016-09-19 16:47:49,569:ERROR:STDERR:    return
>> self.dispatch_request(*args, **kwargs)
>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/utils.py", line 235, in
>> dispatch_request
>> 2016-09-19 16:47:49,569:ERROR:STDERR:    return method(*args, **kwargs)
>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups
>> /servers/databases/__init__.py",
>> line 364, in connect
>> 2016-09-19 16:47:49,569:ERROR:STDERR:    conn =
>> manager.connection(did=did, auto_reconnect=True)
>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>> "/Users/dpage/git/pgadmin4/web/pgadmin/utils/driver/psycopg2
>> /__init__.py",
>> line 1447, in connection
>> 2016-09-19 16:47:49,569:ERROR:STDERR:    "Couldn't find the specified
>> database."
>> 2016-09-19 16:47:49,569:ERROR:STDERR:Exception: Couldn't find the
>> specified database.
>> 2016-09-19 16:47:49,569:ERROR:STDERR:==================================
>> ====================================
>> 2016-09-19 16:47:49,569:ERROR:STDERR:ERROR: runTest
>> (pgadmin.browser.server_groups.servers.databases.tests.test_
>> db_put.DatabasesUpdateTestCase)
>> 2016-09-19 16:47:49,569:ERROR:STDERR:This function will update the
>> comments field of database. (Check Databases Node)
>> 2016-09-19 16:47:49,569:ERROR:STDERR:----------------------------------
>> ------------------------------------
>> 2016-09-19 16:47:49,570:ERROR:STDERR:Traceback (most recent call last):
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups
>> /servers/databases/tests/test_db_put.py",
>> line 37, in runTest
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    db_id)
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups
>> /servers/databases/tests/utils.py",
>> line 142, in verify_database
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    follow_redirects=True)
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/werkzeug/test.py",
>> line 788, in post
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    return self.open(*args, **kw)
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/testing.py",
>> line 113, in open
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    follow_redirects=follow_redire
>> cts)
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/werkzeug/test.py",
>> line 751, in open
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    response =
>> self.run_wsgi_app(environ, buffered=buffered)
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/werkzeug/test.py",
>> line 668, in run_wsgi_app
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    rv =
>> run_wsgi_app(self.application, environ, buffered=buffered)
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/werkzeug/test.py",
>> line 871, in run_wsgi_app
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    app_rv = app(environ,
>> start_response)
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 2000, in __call__
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    return self.wsgi_app(environ,
>> start_response)
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1991, in wsgi_app
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    response =
>> self.make_response(self.handle_exception(e))
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1567, in handle_exception
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1988, in wsgi_app
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    response =
>> self.full_dispatch_request()
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1641, in full_dispatch_request
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    rv =
>> self.handle_user_exception(e)
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1544, in handle_user_exception
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1639, in full_dispatch_request
>> 2016-09-19 16:47:49,570:ERROR:STDERR:    rv = self.dispatch_request()
>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/app.py",
>> line 1625, in dispatch_request
>> 2016-09-19 16:47:49,571:ERROR:STDERR:    return
>> self.view_functions[rule.endpoint](**req.view_args)
>> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packa
>> ges/flask/views.py",
>> line 84, in view
>> 2016-09-19 16:47:49,571:ERROR:STDERR:    return
>> self.dispatch_request(*args, **kwargs)
>> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/utils.py", line 235, in
>> dispatch_request
>> 2016-09-19 16:47:49,571:ERROR:STDERR:    return method(*args, **kwargs)
>> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups
>> /servers/databases/__init__.py",
>> line 364, in connect
>> 2016-09-19 16:47:49,571:ERROR:STDERR:    conn =
>> manager.connection(did=did, auto_reconnect=True)
>> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
>> "/Users/dpage/git/pgadmin4/web/pgadmin/utils/driver/psycopg2
>> /__init__.py",
>> line 1447, in connection
>> 2016-09-19 16:47:49,571:ERROR:STDERR:    "Couldn't find the specified
>> database."
>> 2016-09-19 16:47:49,571:ERROR:STDERR:Exception: Couldn't find the
>> specified database.
>> 2016-09-19 16:47:49,571:ERROR:STDERR:==================================
>> ====================================
>> 2016-09-19 16:47:49,571:ERROR:STDERR:FAIL: runTest
>> (pgadmin.browser.server_groups.servers.databases.tests.test_
>> db_delete.DatabaseDeleteTestCase)
>> 2016-09-19 16:47:49,571:ERROR:STDERR:This function will delete the
>> database. (Check Databases Node URL)
>> 2016-09-19 16:47:49,571:ERROR:STDERR:----------------------------------
>> ------------------------------------
>> 2016-09-19 16:47:49,571:ERROR:STDERR:Traceback (most recent call last):
>> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups
>> /servers/databases/tests/test_db_delete.py",
>> line 38, in runTest
>> 2016-09-19 16:47:49,571:ERROR:STDERR:
>> self.assertEquals(response.status_code, 200)
>> 2016-09-19 16:47:49,571:ERROR:STDERR:AssertionError: 410 != 200
>> 2016-09-19 16:47:49,571:ERROR:STDERR:----------------------------------
>> ------------------------------------
>> 2016-09-19 16:47:49,571:ERROR:STDERR:Ran 25 tests in 12.664s
>> 2016-09-19 16:47:49,571:ERROR:STDERR:FAILED
>> 2016-09-19 16:47:49,571:ERROR:STDERR: (failures=1, errors=2)
>> 2016-09-19 16:47:50,033:ERROR:STDERR:
>> 2016-09-19 16:47:50,033:ERROR:STDERR:Test Result Summary
>> 2016-09-19 16:47:50,033:ERROR:STDERR:============================
>> 2016-09-19 16:47:50,033:ERROR:STDERR:Regression - EPAS 9.5: 22 tests
>> passed, 3 tests failed :
>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabaseDeleteTestCase
>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesGetTestCase
>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesUpdateTestCase
>> 2016-09-19 16:47:50,033:ERROR:STDERR:Regression - PG 9.5: 22 tests
>> passed, 3 tests failed :
>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabaseDeleteTestCase
>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesGetTestCase
>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesUpdateTestCase
>> 2016-09-19 16:47:50,034:ERROR:STDERR:Regression - PG 9.4: 25 tests
>> passed, 0 tests failed
>> 2016-09-19 16:47:50,034:ERROR:STDERR:============================
>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
>
> --
> Regards,
> Navnath
>
>
>


-- 
Regards,
Navnath


-- 
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Attachments:

  [application/octet-stream] regression_errors.patch (26.7K, 3-regression_errors.patch)
  download | inline diff:
diff --git a/web/pgadmin/browser/server_groups/servers/databases/tests/test_db_add.py b/web/pgadmin/browser/server_groups/servers/databases/tests/test_db_add.py
index 41d6da6..1d13c02 100644
--- a/web/pgadmin/browser/server_groups/servers/databases/tests/test_db_add.py
+++ b/web/pgadmin/browser/server_groups/servers/databases/tests/test_db_add.py
@@ -30,21 +30,21 @@ class DatabaseAddTestCase(BaseTestGenerator):
     def runTest(self):
         """ This function will add database under 1st server of tree node. """
         self.db_name = ''
-        server_id = test_server_dict["server"][0]["server_id"]
-        server_response = server_utils.connect_server(self, server_id)
+        self.server_id = test_server_dict["server"][0]["server_id"]
+        server_response = server_utils.connect_server(self, self.server_id)
         if server_response["info"] == "Server connected.":
             db_owner = server_response['data']['user']['name']
             self.data = database_utils.get_db_data(db_owner)
             self.db_name = self.data['name']
             response = self.tester.post(self.url + str(utils.SERVER_GROUP) +
-                                        "/" + str(server_id) + "/",
+                                        "/" + str(self.server_id) + "/",
                                         data=json.dumps(self.data),
                                         content_type='html/json')
             self.assertEquals(response.status_code, 200)
             response_data = json.loads(response.data.decode('utf-8'))
             db_id = response_data['node']['_id']
             db_dict = {"db_id": db_id, "db_name": self.db_name}
-            utils.write_node_info(int(server_id), "did", db_dict)
+            utils.write_node_info(int(self.server_id), "did", db_dict)
         else:
             raise Exception("Error while connecting server to add the"
                             " database.")
@@ -59,3 +59,4 @@ class DatabaseAddTestCase(BaseTestGenerator):
                                              self.server['host'],
                                              self.server['port'])
         utils.drop_database(connection, self.db_name)
+
diff --git a/web/pgadmin/browser/server_groups/servers/databases/tests/utils.py b/web/pgadmin/browser/server_groups/servers/databases/tests/utils.py
index 7900863..6b26863 100644
--- a/web/pgadmin/browser/server_groups/servers/databases/tests/utils.py
+++ b/web/pgadmin/browser/server_groups/servers/databases/tests/utils.py
@@ -10,13 +10,12 @@
 import json
 import uuid
 
-from regression.test_setup import advanced_config_data
 from pgadmin.browser.server_groups.servers.tests import utils as server_utils
 from regression import test_utils as utils
 
 
 DATABASE_URL = '/browser/database/obj/'
-DATABASE_CONNECT_URL = 'browser/database/connect/'
+DATABASE_CONNECT_URL = '/browser/database/connect/'
 
 
 def get_db_data(db_owner):
diff --git a/web/pgadmin/browser/server_groups/servers/tests/test_server_add.py b/web/pgadmin/browser/server_groups/servers/tests/test_server_add.py
index 6ad9cf7..6433888 100644
--- a/web/pgadmin/browser/server_groups/servers/tests/test_server_add.py
+++ b/web/pgadmin/browser/server_groups/servers/tests/test_server_add.py
@@ -36,4 +36,4 @@ class ServersAddTestCase(BaseTestGenerator):
 
     def tearDown(self):
         """This function delete the server from SQLite """
-        utils.delete_server(self.server_id)
+        utils.delete_server(self.tester, self.server_id)
diff --git a/web/pgadmin/browser/server_groups/servers/tests/test_server_delete.py b/web/pgadmin/browser/server_groups/servers/tests/test_server_delete.py
index 6f57e55..4f9e82d 100644
--- a/web/pgadmin/browser/server_groups/servers/tests/test_server_delete.py
+++ b/web/pgadmin/browser/server_groups/servers/tests/test_server_delete.py
@@ -33,4 +33,4 @@ class ServerDeleteTestCase(BaseTestGenerator):
 
     def tearDown(self):
         """This function delete the server from SQLite """
-        utils.delete_server(self.server_id)
+        utils.delete_server(self.tester, self.server_id)
diff --git a/web/pgadmin/browser/server_groups/servers/tests/test_server_put.py b/web/pgadmin/browser/server_groups/servers/tests/test_server_put.py
index 92134d2..3db8c33 100644
--- a/web/pgadmin/browser/server_groups/servers/tests/test_server_put.py
+++ b/web/pgadmin/browser/server_groups/servers/tests/test_server_put.py
@@ -37,4 +37,4 @@ class ServerUpdateTestCase(BaseTestGenerator):
 
     def tearDown(self):
         """This function delete the server from SQLite"""
-        utils.delete_server(self.server_id)
+        utils.delete_server(self.tester, self.server_id)
diff --git a/web/pgadmin/browser/server_groups/servers/tests/utils.py b/web/pgadmin/browser/server_groups/servers/tests/utils.py
index c1b5259..de32d46 100644
--- a/web/pgadmin/browser/server_groups/servers/tests/utils.py
+++ b/web/pgadmin/browser/server_groups/servers/tests/utils.py
@@ -9,14 +9,9 @@
 
 from __future__ import print_function
 
-import sys
 import json
-import sqlite3
-import config
 
-from regression import node_info_dict
 from regression import test_utils as utils
-from regression.test_setup import config_data
 
 SERVER_URL = '/browser/server/obj/'
 SERVER_CONNECT_URL = '/browser/server/connect/'
diff --git a/web/regression/runtests.py b/web/regression/runtests.py
index 83760e9..678adc8 100644
--- a/web/regression/runtests.py
+++ b/web/regression/runtests.py
@@ -19,6 +19,9 @@ import atexit
 import unittest
 import logging
 
+logger = logging.getLogger(__name__)
+file_name = os.path.basename(__file__)
+
 from testscenarios.scenarios import generate_scenarios
 
 CURRENT_PATH = os.path.dirname(os.path.realpath(__file__))
@@ -33,34 +36,30 @@ if sys.path[0] != root:
 from pgadmin import create_app
 import config
 import test_setup
-import regression
 
-# Execute setup.py if test SQLite database doesn't exist.
+# Delete SQLite db file if exists
 if os.path.isfile(config.TEST_SQLITE_PATH):
-    print("The configuration database already existed at '%s'. "
-          "Please remove the database and again run the test suite." %
-          config.TEST_SQLITE_PATH)
-    sys.exit(1)
-else:
-    config.TESTING_MODE = True
-    pgadmin_credentials = test_setup.config_data
-
-    # Set environment variables for email and password
-    os.environ['PGADMIN_SETUP_EMAIL'] = ''
-    os.environ['PGADMIN_SETUP_PASSWORD'] = ''
-    if pgadmin_credentials:
-        if 'pgAdmin4_login_credentials' in pgadmin_credentials:
-            if all(item in pgadmin_credentials['pgAdmin4_login_credentials']
-                   for item in ['login_username', 'login_password']):
-                pgadmin_credentials = pgadmin_credentials[
-                    'pgAdmin4_login_credentials']
-                os.environ['PGADMIN_SETUP_EMAIL'] = pgadmin_credentials[
-                    'login_username']
-                os.environ['PGADMIN_SETUP_PASSWORD'] = pgadmin_credentials[
-                    'login_password']
-
-    # Execute the setup file
-    exec (open("setup.py").read())
+    os.remove(config.TEST_SQLITE_PATH)
+
+config.TESTING_MODE = True
+pgadmin_credentials = test_setup.config_data
+
+# Set environment variables for email and password
+os.environ['PGADMIN_SETUP_EMAIL'] = ''
+os.environ['PGADMIN_SETUP_PASSWORD'] = ''
+if pgadmin_credentials:
+    if 'pgAdmin4_login_credentials' in pgadmin_credentials:
+        if all(item in pgadmin_credentials['pgAdmin4_login_credentials']
+               for item in ['login_username', 'login_password']):
+            pgadmin_credentials = pgadmin_credentials[
+                'pgAdmin4_login_credentials']
+            os.environ['PGADMIN_SETUP_EMAIL'] = pgadmin_credentials[
+                'login_username']
+            os.environ['PGADMIN_SETUP_PASSWORD'] = pgadmin_credentials[
+                'login_password']
+
+# Execute the setup file
+exec (open("setup.py").read())
 
 # Get the config database schema version. We store this in pgadmin.model
 # as it turns out that putting it in the config files isn't a great idea
@@ -80,40 +79,25 @@ config.CONSOLE_LOG_LEVEL = WARNING
 app = create_app()
 app.config['WTF_CSRF_ENABLED'] = False
 test_client = app.test_client()
+drop_objects = test_utils.get_cleanup_handler(test_client)
 
 
-def get_suite(arguments, server, test_app_client):
+def get_suite(module_list, test_server, test_app_client):
     """
-     This function loads the all modules in the tests directory into testing
-     environment.
-
-    :param arguments: this is command line arguments for module name to
-    which test suite will run
-    :type arguments: str
-    :param server: server details
-    :type server: dict
+     This function add the tests to test suite and return modified test suite
+      variable.
+    :param module_list: test module list
+    :type module_list: list
+    :param test_server: server details
+    :type test_server: dict
     :param test_app_client: test client
     :type test_app_client: pgadmin app object
     :return pgadmin_suite: test suite with test cases
     :rtype: TestSuite
     """
-
-    from pgadmin.utils.route import TestsGeneratorRegistry
-
     modules = []
     pgadmin_suite = unittest.TestSuite()
 
-    # Load the test modules which are in given package(i.e. in arguments.pkg)
-    if arguments['pkg'] is None or arguments['pkg'] == "all":
-        TestsGeneratorRegistry.load_generators('pgadmin')
-    else:
-        TestsGeneratorRegistry.load_generators('pgadmin.%s.tests' %
-                                               arguments['pkg'])
-
-    # Sort module list so that test suite executes the test cases sequentially
-    module_list = TestsGeneratorRegistry.registry.items()
-    module_list = sorted(module_list, key=lambda module_tuple: module_tuple[0])
-
     # Get the each test module and add into list
     for key, klass in module_list:
         gen = klass
@@ -124,13 +108,41 @@ def get_suite(arguments, server, test_app_client):
         obj = module()
         obj.setApp(app)
         obj.setTestClient(test_app_client)
-        obj.setTestServer(server)
+        obj.setTestServer(test_server)
         scenario = generate_scenarios(obj)
         pgadmin_suite.addTests(scenario)
 
     return pgadmin_suite
 
 
+def get_test_modules(arguments):
+    """
+     This function loads the all modules in the tests directory into testing
+     environment.
+
+    :param arguments: this is command line arguments for module name to
+    which test suite will run
+    :type arguments: str
+    :return module list: test module list
+    :rtype: list
+    """
+
+    from pgadmin.utils.route import TestsGeneratorRegistry
+
+    # Load the test modules which are in given package(i.e. in arguments.pkg)
+    if arguments['pkg'] is None or arguments['pkg'] == "all":
+        TestsGeneratorRegistry.load_generators('pgadmin')
+    else:
+        TestsGeneratorRegistry.load_generators('pgadmin.%s.tests' %
+                                               arguments['pkg'])
+
+    # Sort module list so that test suite executes the test cases sequentially
+    module_list = TestsGeneratorRegistry.registry.items()
+    module_list = sorted(module_list, key=lambda module_tuple: module_tuple[0])
+
+    return module_list
+
+
 def add_arguments():
     """
     This function parse the command line arguments(project's package name
@@ -149,27 +161,41 @@ def add_arguments():
 
 
 def sig_handler(signo, frame):
-    test_utils.drop_objects()
+    drop_objects()
 
 
-def get_tests_result(tests):
+def get_tests_result(test_suite):
     """This function returns the total ran and total failed test cases count"""
-    total_ran = tests.testsRun
-    failed_cases_result = []
-    if total_ran:
-        if tests.failures:
-            for failed_case in tests.failures:
-                class_name = str(failed_case[0]).split('.')[-1].split()[0].\
-                    strip(')')
-                failed_cases_result.append(class_name)
-        if tests.errors:
-            for error_case in tests.errors:
-                class_name = str(error_case[0]).split('.')[-1].split()[0].\
-                    strip(')')
-                if class_name not in failed_cases_result:
+    try:
+        total_ran = test_suite.testsRun
+        failed_cases_result = []
+        skipped_cases_result = []
+        if total_ran:
+            if test_suite.failures:
+                for failed_case in test_suite.failures:
+                    class_name = str(
+                        failed_case[0]).split('.')[-1].split()[0].strip(')')
                     failed_cases_result.append(class_name)
-
-    return total_ran, failed_cases_result
+            if test_suite.errors:
+                for error_case in test_suite.errors:
+                    class_name = str(
+                        error_case[0]).split('.')[-1].split()[0].strip(')')
+                    if class_name not in failed_cases_result:
+                        failed_cases_result.append(class_name)
+                        # TODO: Code remaining to count the skipped test cases
+                        # if test_suite.skipped:
+                        #     for skip_test in test_suite.skipped:
+                        #         class_name = str(
+                        #           skip_test[0]).split('.')[-1].split()[0].strip(')')
+                        #         if class_name not in failed_cases_result:
+                        #             skipped_cases_result.append(class_name)
+                        #         print(class_name)
+        return total_ran, failed_cases_result, skipped_cases_result
+    except Exception as exception:
+        exception = "Exception: %s: line:%s %s" % (
+            file_name, sys.exc_traceback.tb_lineno, exception)
+        print(exception)
+        logger.exception(exception)
 
 
 class StreamToLogger(object):
@@ -199,7 +225,7 @@ class StreamToLogger(object):
 if __name__ == '__main__':
     test_result = dict()
     # Register cleanup function to cleanup on exit
-    atexit.register(test_utils.drop_objects)
+    atexit.register(drop_objects)
     # Set signal handler for cleanup
     signal.signal(signal.SIGTERM, sig_handler)
     signal.signal(signal.SIGABRT, sig_handler)
@@ -217,46 +243,48 @@ if __name__ == '__main__':
     # Create logger to write log in the logger file as well as on console
     stderr_logger = logging.getLogger('STDERR')
     sys.stderr = StreamToLogger(stderr_logger, logging.ERROR)
-
     args = vars(add_arguments())
+    # Get test module list
+    test_module_list = get_test_modules(args)
+    # Login the test client
+    test_utils.login_tester_account(test_client)
 
     servers_info = test_utils.get_config_data()
     try:
         for server in servers_info:
             print("\n=============Running the test cases for '%s'============="
                   % server['name'], file=sys.stderr)
-
+            # Create test server
             test_utils.create_test_server(server)
 
-            # Login the test client
-            test_utils.login_tester_account(test_client)
-
-            suite = get_suite(args, server, test_client)
+            suite = get_suite(test_module_list, server, test_client)
             tests = unittest.TextTestRunner(stream=sys.stderr,
                                             descriptions=True,
                                             verbosity=2).run(suite)
 
-            ran_tests, failed_cases = get_tests_result(tests)
-            test_result[server['name']] = [ran_tests, failed_cases]
-
-            # Logout the test client
-            test_utils.logout_tester_account(test_client)
-
-            test_utils.delete_test_server()
+            ran_tests, failed_cases, skipped_cases = \
+                get_tests_result(tests)
+            test_result[server['name']] = [ran_tests, failed_cases,
+                                           skipped_cases]
+            # Delete test server
+            test_utils.delete_test_server(test_client)
     except SystemExit:
-        test_utils.drop_objects()
+        drop_objects()
 
     print("\nTest Result Summary", file=sys.stderr)
     print("============================", file=sys.stderr)
     for server_res in test_result:
         failed_cases = "\n\t".join(test_result[server_res][1])
         total_failed = len(test_result[server_res][1])
+        # TODO : code remaining to handle '-1' condition
         total_passed = int(test_result[server_res][0]) - total_failed
 
         print("%s: %s test%s passed, %s test%s failed %s%s" %
               (server_res, total_passed, (total_passed != 1 and "s" or ""),
                total_failed, (total_failed != 1 and "s" or ""),
-               (total_failed != 0 and ":\n\t" or ""), failed_cases), file=sys.stderr)
+               (total_failed != 0 and ":\n\t" or ""), failed_cases),
+              file=sys.stderr)
+
     print("============================", file=sys.stderr)
 
     print("\nPlease check output in file: %s/regression.log " % CURRENT_PATH)
diff --git a/web/regression/test_setup.py b/web/regression/test_setup.py
index 6e8caaf..6064abf 100644
--- a/web/regression/test_setup.py
+++ b/web/regression/test_setup.py
@@ -13,17 +13,9 @@ import os
 
 CURRENT_PATH = os.path.dirname(os.path.realpath(__file__))
 
-
 try:
     with open(CURRENT_PATH + '/test_config.json') as data_file:
         config_data = json.load(data_file)
-except:
+except Exception as exception:
     with open(CURRENT_PATH + '/test_config.json.in') as data_file:
         config_data = json.load(data_file)
-
-try:
-    with open(CURRENT_PATH + '/test_advanced_config.json') as data_file:
-        advanced_config_data = json.load(data_file)
-except:
-    with open(CURRENT_PATH + '/test_advanced_config.json.in') as data_file:
-        advanced_config_data = json.load(data_file)
diff --git a/web/regression/test_utils.py b/web/regression/test_utils.py
index c8372cf..73c45a6 100644
--- a/web/regression/test_utils.py
+++ b/web/regression/test_utils.py
@@ -14,15 +14,12 @@ import uuid
 import psycopg2
 import sqlite3
 
-import logging
-
 import config
-
 import test_setup
 import regression
+from functools import partial
 
 SERVER_GROUP = test_setup.config_data['server_group']
-logger = logging.getLogger(__name__)
 file_name = os.path.basename(__file__)
 
 
@@ -36,10 +33,6 @@ def get_db_connection(db, username, password, host, port):
     return connection
 
 
-def get_node_info_dict():
-    return regression.node_info_dict
-
-
 def login_tester_account(tester):
     """
     This function login the test client using env variables email and password
@@ -47,8 +40,8 @@ def login_tester_account(tester):
     :type tester: flask test client object
     :return: None
     """
-    if os.environ['PGADMIN_SETUP_EMAIL'] and os.environ[
-        'PGADMIN_SETUP_PASSWORD']:
+    if os.environ['PGADMIN_SETUP_EMAIL'] and\
+            os.environ['PGADMIN_SETUP_PASSWORD']:
         email = os.environ['PGADMIN_SETUP_EMAIL']
         password = os.environ['PGADMIN_SETUP_PASSWORD']
         tester.post('/login', data=dict(email=email, password=password),
@@ -56,7 +49,7 @@ def login_tester_account(tester):
     else:
         print("Unable to login test client, email and password not found.",
               file=sys.stderr)
-        drop_objects()
+        _drop_objects(tester)
         sys.exit(1)
 
 
@@ -151,19 +144,25 @@ def create_database(server, db_name):
 def drop_database(connection, database_name):
     """This function used to drop the database"""
 
-    pg_cursor = connection.cursor()
-    pg_cursor.execute("SELECT * FROM pg_database db WHERE db.datname='%s'"
-                      % database_name)
-    if pg_cursor.fetchall():
-        # Release pid if any process using database
-        pg_cursor.execute("select pg_terminate_backend(pid) from"
-                          " pg_stat_activity where datname='%s'" %
-                          database_name)
-        old_isolation_level = connection.isolation_level
-        connection.set_isolation_level(0)
-        pg_cursor.execute('''DROP DATABASE "%s"''' % database_name)
-        connection.set_isolation_level(old_isolation_level)
-        connection.commit()
+    try:
+        pg_cursor = connection.cursor()
+        pg_cursor.execute("SELECT * FROM pg_database db WHERE db.datname='%s'"
+                          % database_name)
+        if pg_cursor.fetchall():
+            # Release pid if any process using database
+            pg_cursor.execute("select pg_terminate_backend(pid) from"
+                              " pg_stat_activity where datname='%s'" %
+                              database_name)
+            old_isolation_level = connection.isolation_level
+            connection.set_isolation_level(0)
+            pg_cursor.execute('''DROP DATABASE "%s"''' % database_name)
+            connection.set_isolation_level(old_isolation_level)
+            connection.commit()
+            connection.close()
+    except Exception as exception:
+        exception = "%s: line:%s %s" % (
+            file_name, sys.exc_traceback.tb_lineno, exception)
+        print(exception, file=sys.stderr)
 
 
 def create_server(server):
@@ -185,19 +184,37 @@ def create_server(server):
         raise Exception("Error while creating server. %s" % exception)
 
 
-def delete_server(sid):
+def delete_server(tester, sid):
     """This function used to delete server from SQLite"""
     try:
-        conn = sqlite3.connect(config.SQLITE_PATH)
-        cur = conn.cursor()
+        url = '/browser/server/obj/' + str(SERVER_GROUP) + "/"
+        # Call API to delete the server
+        response = tester.delete(url + str(sid))
+    except Exception as exception:
+        exception = "%s: line:%s %s" % (
+            file_name, sys.exc_traceback.tb_lineno, exception)
+        print(exception, file=sys.stderr)
+
+
+def delete_server_from_sqlite(sid):
+    """This function used to delete server from SQLite"""
+    try:
+        con = sqlite3.connect(config.SQLITE_PATH)
+        cur = con.cursor()
         server_objects = cur.execute('SELECT * FROM server WHERE id=%s' % sid)
-        servers_count = len(server_objects.fetchall())
+        ss = server_objects.fetchall()
+        # for i in ss:
+        #     print(">>>>>>>>>>>", i)
+        servers_count = len(ss)
+        # print(">>>>>>>", sid)
         if servers_count:
             cur.execute('DELETE FROM server WHERE id=%s' % sid)
-            conn.commit()
-        conn.close()
-    except Exception as err:
-        raise Exception("Error while deleting server %s" % err)
+            con.commit()
+        con.close()
+    except Exception as exception:
+        exception = "%s: line:%s %s" % (
+            file_name, sys.exc_traceback.tb_lineno, exception)
+        print(exception, file=sys.stderr)
 
 
 def create_tablespace(server, test_tablespace_name):
@@ -246,7 +263,6 @@ def delete_tablespace(connection, test_tablespace_name):
         exception = "%s: line:%s %s" % (
             file_name, sys.exc_traceback.tb_lineno, exception)
         print(exception, file=sys.stderr)
-        raise Exception(exception)
 
 
 def create_test_server(server_info):
@@ -277,7 +293,7 @@ def create_test_server(server_info):
                                                     "db_name": test_db_name})
 
 
-def delete_test_server():
+def delete_test_server(tester):
     test_server_dict = regression.test_server_dict
     test_servers = test_server_dict["server"]
     test_databases = test_server_dict["database"]
@@ -295,14 +311,12 @@ def delete_test_server():
                 database_name = database["db_name"]
                 # Drop database
                 drop_database(connection, database_name)
-
             # Delete server
-            delete_server(srv_id)
+            delete_server(tester, srv_id)
     except Exception as exception:
         exception = "Exception: %s: line:%s %s" % (
             file_name, sys.exc_traceback.tb_lineno, exception)
-        print(exception)
-        logger.exception(exception)
+        print(exception, file=sys.stderr)
 
     # Clear test_server_dict
     for item in regression.test_server_dict:
@@ -310,11 +324,12 @@ def delete_test_server():
 
 
 def remove_db_file():
+    """This function use to remove SQLite DB file"""
     if os.path.isfile(config.SQLITE_PATH):
         os.remove(config.SQLITE_PATH)
 
 
-def drop_objects():
+def _drop_objects(tester):
     """This function use to cleanup the created the objects(servers, databases,
      schemas etc) during the test suite run"""
     try:
@@ -329,7 +344,6 @@ def drop_objects():
                 host = server_info[1]
                 db_port = server_info[2]
 
-                server_id = server_info[5]
                 config_servers = test_setup.config_data['server_credentials']
                 db_password = ''
                 # Get the db password from config file for appropriate server
@@ -350,11 +364,15 @@ def drop_objects():
                     databases = pg_cursor.fetchall()
                     if databases:
                         for db in databases:
+                            connection = get_db_connection(server_info[3],
+                                                           server_info[4],
+                                                           db_password,
+                                                           server_info[1],
+                                                           server_info[2])
                             # Do not drop the default databases
                             if db[0] not in ["postgres", "template1",
                                              "template0"]:
                                 drop_database(connection, db[0])
-                    connection.close()
 
                     # Delete tablespace
                     connection = get_db_connection(server_info[3],
@@ -374,14 +392,30 @@ def drop_objects():
                                 # Delete tablespace
                                 delete_tablespace(connection, tablespace_name)
 
+            for server_info in all_servers:
+                server_id = server_info[5]
                 # Delete server
-                delete_server(server_id)
+                try:
+                    delete_server(tester, server_id)
+                except Exception as exception:
+                    exception = "Exception while deleting server: %s:" \
+                                " line:%s %s" %\
+                                (file_name, sys.exc_traceback.tb_lineno,
+                                 exception)
+                    print(exception, file=sys.stderr)
+                    continue
         conn.close()
-        # Remove SQLite db file
-        remove_db_file()
     except Exception as exception:
-        remove_db_file()
         exception = "Exception: %s: line:%s %s" % (
             file_name, sys.exc_traceback.tb_lineno, exception)
-        print(exception)
-        logger.exception(exception)
+        print(exception, file=sys.stderr)
+    finally:
+        # Logout the test client
+        logout_tester_account(tester)
+        # Remove SQLite db file
+        remove_db_file()
+
+
+def get_cleanup_handler(tester):
+    """This function use to bind variable to drop_objects function"""
+    return partial(_drop_objects, tester)


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Regression errors - database node
  2016-09-19 15:52 Regression errors - database node Dave Page <[email protected]>
  2016-09-21 11:16 ` Re: Regression errors - database node Navnath Gadakh <[email protected]>
  2016-09-22 11:36   ` Re: Regression errors - database node Navnath Gadakh <[email protected]>
@ 2016-09-22 12:00     ` Dave Page <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: Dave Page @ 2016-09-22 12:00 UTC (permalink / raw)
  To: Navnath Gadakh <[email protected]>; +Cc: pgadmin-hackers

Thanks, applied.

On Thu, Sep 22, 2016 at 12:36 PM, Navnath Gadakh
<[email protected]> wrote:
> Hi Dave,
>        Please find the attached revised patch for regression errors which we
> faced.
> Firstly,  apply patch for RM#1720(Harshal worked on this) and then apply
> this patch. There is some code change in test suite due to code modification
> in dev side.
>
> Note: Run test suite only for server or database node.
>
> Thanks.
>
>
>
>
> On Wed, Sep 21, 2016 at 4:46 PM, Navnath Gadakh
> <[email protected]> wrote:
>>
>> Hi Dave,
>>      After a long debugging of these errors with Harshal, we found the
>> issue is in the handling pyscopg connection. Need to add some code in the
>> pyscopg connection manager as per Harshal.
>>
>> For more details, Please refer RM #1720.
>>
>> @Harshal, thanks for the time invested.
>>
>> Thanks.
>>
>>
>>
>> On Mon, Sep 19, 2016 at 9:22 PM, Dave Page <[email protected]> wrote:
>>>
>>> Hi Navnath
>>>
>>> I keep seeing the errors below when running tests. It seems to be
>>> consistent on EPAS, but intermittent on PG. Any ideas what the issue
>>> is? I'm fairly convinced it's a test issue not an actual problem.
>>>
>>> 2016-09-19
>>> 16:47:49,567:ERROR:STDERR:======================================================================
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:ERROR: runTest
>>>
>>> (pgadmin.browser.server_groups.servers.databases.tests.test_db_get.DatabasesGetTestCase)
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:This function will fetch added
>>> database. (Check Databases Node URL)
>>> 2016-09-19
>>> 16:47:49,568:ERROR:STDERR:----------------------------------------------------------------------
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:Traceback (most recent call last):
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/test_db_get.py",
>>> line 33, in runTest
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:    self.db_id)
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/utils.py",
>>> line 142, in verify_database
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:    follow_redirects=True)
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
>>> line 788, in post
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:    return self.open(*args, **kw)
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/testing.py",
>>> line 113, in open
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:
>>> follow_redirects=follow_redirects)
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
>>> line 751, in open
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:    response =
>>> self.run_wsgi_app(environ, buffered=buffered)
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
>>> line 668, in run_wsgi_app
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:    rv =
>>> run_wsgi_app(self.application, environ, buffered=buffered)
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
>>> line 871, in run_wsgi_app
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:    app_rv = app(environ,
>>> start_response)
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 2000, in __call__
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:    return self.wsgi_app(environ,
>>> start_response)
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1991, in wsgi_app
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:    response =
>>> self.make_response(self.handle_exception(e))
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1567, in handle_exception
>>> 2016-09-19 16:47:49,568:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1988, in wsgi_app
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:    response =
>>> self.full_dispatch_request()
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1641, in full_dispatch_request
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:    rv =
>>> self.handle_user_exception(e)
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1544, in handle_user_exception
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1639, in full_dispatch_request
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:    rv = self.dispatch_request()
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1625, in dispatch_request
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:    return
>>> self.view_functions[rule.endpoint](**req.view_args)
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/views.py",
>>> line 84, in view
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:    return
>>> self.dispatch_request(*args, **kwargs)
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/utils.py", line 235, in
>>> dispatch_request
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:    return method(*args, **kwargs)
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/__init__.py",
>>> line 364, in connect
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:    conn =
>>> manager.connection(did=did, auto_reconnect=True)
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/git/pgadmin4/web/pgadmin/utils/driver/psycopg2/__init__.py",
>>> line 1447, in connection
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:    "Couldn't find the specified
>>> database."
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:Exception: Couldn't find the
>>> specified database.
>>> 2016-09-19
>>> 16:47:49,569:ERROR:STDERR:======================================================================
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:ERROR: runTest
>>>
>>> (pgadmin.browser.server_groups.servers.databases.tests.test_db_put.DatabasesUpdateTestCase)
>>> 2016-09-19 16:47:49,569:ERROR:STDERR:This function will update the
>>> comments field of database. (Check Databases Node)
>>> 2016-09-19
>>> 16:47:49,569:ERROR:STDERR:----------------------------------------------------------------------
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:Traceback (most recent call last):
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/test_db_put.py",
>>> line 37, in runTest
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    db_id)
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/utils.py",
>>> line 142, in verify_database
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    follow_redirects=True)
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
>>> line 788, in post
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    return self.open(*args, **kw)
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/testing.py",
>>> line 113, in open
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:
>>> follow_redirects=follow_redirects)
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
>>> line 751, in open
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    response =
>>> self.run_wsgi_app(environ, buffered=buffered)
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
>>> line 668, in run_wsgi_app
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    rv =
>>> run_wsgi_app(self.application, environ, buffered=buffered)
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
>>> line 871, in run_wsgi_app
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    app_rv = app(environ,
>>> start_response)
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 2000, in __call__
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    return self.wsgi_app(environ,
>>> start_response)
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1991, in wsgi_app
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    response =
>>> self.make_response(self.handle_exception(e))
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1567, in handle_exception
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1988, in wsgi_app
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    response =
>>> self.full_dispatch_request()
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1641, in full_dispatch_request
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    rv =
>>> self.handle_user_exception(e)
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1544, in handle_user_exception
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    reraise(exc_type, exc_value, tb)
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1639, in full_dispatch_request
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:    rv = self.dispatch_request()
>>> 2016-09-19 16:47:49,570:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
>>> line 1625, in dispatch_request
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:    return
>>> self.view_functions[rule.endpoint](**req.view_args)
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/views.py",
>>> line 84, in view
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:    return
>>> self.dispatch_request(*args, **kwargs)
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
>>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/utils.py", line 235, in
>>> dispatch_request
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:    return method(*args, **kwargs)
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/__init__.py",
>>> line 364, in connect
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:    conn =
>>> manager.connection(did=did, auto_reconnect=True)
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/git/pgadmin4/web/pgadmin/utils/driver/psycopg2/__init__.py",
>>> line 1447, in connection
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:    "Couldn't find the specified
>>> database."
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:Exception: Couldn't find the
>>> specified database.
>>> 2016-09-19
>>> 16:47:49,571:ERROR:STDERR:======================================================================
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:FAIL: runTest
>>>
>>> (pgadmin.browser.server_groups.servers.databases.tests.test_db_delete.DatabaseDeleteTestCase)
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:This function will delete the
>>> database. (Check Databases Node URL)
>>> 2016-09-19
>>> 16:47:49,571:ERROR:STDERR:----------------------------------------------------------------------
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:Traceback (most recent call last):
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:  File
>>>
>>> "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/test_db_delete.py",
>>> line 38, in runTest
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:
>>> self.assertEquals(response.status_code, 200)
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:AssertionError: 410 != 200
>>> 2016-09-19
>>> 16:47:49,571:ERROR:STDERR:----------------------------------------------------------------------
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:Ran 25 tests in 12.664s
>>> 2016-09-19 16:47:49,571:ERROR:STDERR:FAILED
>>> 2016-09-19 16:47:49,571:ERROR:STDERR: (failures=1, errors=2)
>>> 2016-09-19 16:47:50,033:ERROR:STDERR:
>>> 2016-09-19 16:47:50,033:ERROR:STDERR:Test Result Summary
>>> 2016-09-19 16:47:50,033:ERROR:STDERR:============================
>>> 2016-09-19 16:47:50,033:ERROR:STDERR:Regression - EPAS 9.5: 22 tests
>>> passed, 3 tests failed :
>>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabaseDeleteTestCase
>>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesGetTestCase
>>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesUpdateTestCase
>>> 2016-09-19 16:47:50,033:ERROR:STDERR:Regression - PG 9.5: 22 tests
>>> passed, 3 tests failed :
>>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabaseDeleteTestCase
>>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesGetTestCase
>>> 2016-09-19 16:47:50,033:ERROR:STDERR:  DatabasesUpdateTestCase
>>> 2016-09-19 16:47:50,034:ERROR:STDERR:Regression - PG 9.4: 25 tests
>>> passed, 0 tests failed
>>> 2016-09-19 16:47:50,034:ERROR:STDERR:============================
>>>
>>>
>>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>
>>
>>
>>
>> --
>> Regards,
>> Navnath
>>
>>
>
>
>
> --
> Regards,
> Navnath
>
>



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2016-09-22 12:00 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-09-19 15:52 Regression errors - database node Dave Page <[email protected]>
2016-09-21 11:16 ` Navnath Gadakh <[email protected]>
2016-09-22 11:36   ` Navnath Gadakh <[email protected]>
2016-09-22 12:00     ` Dave Page <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox