2019-12-11 17:11:17,161: ERROR	STDERR:	
2019-12-11 17:11:17,162: ERROR	STDERR:	=============Running the test cases for 'PostgreSQL 9.4'=============
2019-12-11 17:11:21,415: ERROR	STDERR:	runTest (pgadmin.browser.server_groups.servers.databases.extensions.tests.test_extension_add.ExtensionsAddTestCase)
2019-12-11 17:11:21,416: ERROR	STDERR:	Check Extension Node
2019-12-11 17:11:21,416: ERROR	STDERR:	 ...
2019-12-11 17:11:21,423: INFO	flask.app:	Connection Request for server#2
2019-12-11 17:11:21,436: INFO	flask.app:	Connection Established for server:                 2 - PostgreSQL 9.4
2019-12-11 17:11:21,439: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 1654263):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2019-12-11 17:11:21,446: INFO	flask.app:	Connection Request for server#2
2019-12-11 17:11:21,451: INFO	flask.app:	Connection Established for server:                 2 - PostgreSQL 9.4
2019-12-11 17:11:21,451: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 7388287):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2019-12-11 17:11:21,459: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 4011244):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_encoding_to_char(db.encoding) AS serverencoding,
    has_database_privilege(db.oid, 'CREATE') as cancreate, datlastsysoid
FROM
    pg_database db
WHERE db.oid = 24606
2019-12-11 17:11:21,465: INFO	flask.app:	Connection Established for Database Id:                 24606
2019-12-11 17:11:21,478: SQL	flask.app:	Execute (dict) for server #2 - DB:test_db_0c23a (Query-id: 2911315):
CREATE EXTENSION cube
    SCHEMA test_schema_51b4d
2019-12-11 17:11:21,479: ERROR	flask.app:	Failed to execute query (execute_dict) for the server #2- DB:test_db_0c23a (Query-id: 2911315):
Error Message:ERROR:  could not open extension control file "/usr/local/pgsql/share/extension/cube.control": No such file or directory

2019-12-11 17:11:21,492: ERROR	STDERR:	FAIL
2019-12-11 17:11:21,492: ERROR	STDERR:	runTest (pgadmin.browser.server_groups.servers.databases.extensions.tests.test_extension_delete.ExtensionsDeleteTestCase)
2019-12-11 17:11:21,492: ERROR	STDERR:	Check Extension Node
2019-12-11 17:11:21,492: ERROR	STDERR:	 ...
2019-12-11 17:11:21,496: INFO	flask.app:	Connection Request for server#2
2019-12-11 17:11:21,503: INFO	flask.app:	Connection Established for server:                 2 - PostgreSQL 9.4
2019-12-11 17:11:21,503: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 6121767):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2019-12-11 17:11:21,508: ERROR	STDERR:	Traceback (most recent call last):
2019-12-11 17:11:21,508: ERROR	STDERR:	  File "/home/karan/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/utils.py", line 53, in create_extension
2019-12-11 17:11:21,508: ERROR	STDERR:	    schema_name))
2019-12-11 17:11:21,508: ERROR	STDERR:	psycopg2.errors.UndefinedFile: could not open extension control file "/usr/local/pgsql/share/extension/cube.control": No such file or directory
2019-12-11 17:11:21,512: INFO	flask.app:	Connection Request for server#2
2019-12-11 17:11:21,518: INFO	flask.app:	Connection Established for server:                 2 - PostgreSQL 9.4
2019-12-11 17:11:21,518: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 3682222):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2019-12-11 17:11:21,526: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 7905093):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_encoding_to_char(db.encoding) AS serverencoding,
    has_database_privilege(db.oid, 'CREATE') as cancreate, datlastsysoid
FROM
    pg_database db
WHERE db.oid = 24606
2019-12-11 17:11:21,532: INFO	flask.app:	Connection Established for Database Id:                 24606
2019-12-11 17:11:21,547: ERROR	STDERR:	ERROR
2019-12-11 17:11:21,547: ERROR	STDERR:	runTest (pgadmin.browser.server_groups.servers.databases.extensions.tests.test_extension_delete_multiple.ExtensionsDeleteMultipleTestCase)
2019-12-11 17:11:21,547: ERROR	STDERR:	Check Extension Node
2019-12-11 17:11:21,547: ERROR	STDERR:	 ...
2019-12-11 17:11:21,553: INFO	flask.app:	Connection Request for server#2
2019-12-11 17:11:21,558: INFO	flask.app:	Connection Established for server:                 2 - PostgreSQL 9.4
2019-12-11 17:11:21,558: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 3689145):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2019-12-11 17:11:21,562: ERROR	STDERR:	Traceback (most recent call last):
2019-12-11 17:11:21,562: ERROR	STDERR:	  File "/home/karan/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/utils.py", line 53, in create_extension
2019-12-11 17:11:21,562: ERROR	STDERR:	    schema_name))
2019-12-11 17:11:21,562: ERROR	STDERR:	psycopg2.errors.UndefinedFile: could not open extension control file "/usr/local/pgsql/share/extension/dblink.control": No such file or directory
2019-12-11 17:11:21,565: ERROR	STDERR:	Traceback (most recent call last):
2019-12-11 17:11:21,565: ERROR	STDERR:	  File "/home/karan/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/utils.py", line 53, in create_extension
2019-12-11 17:11:21,565: ERROR	STDERR:	    schema_name))
2019-12-11 17:11:21,565: ERROR	STDERR:	psycopg2.errors.UndefinedFile: could not open extension control file "/usr/local/pgsql/share/extension/hstore.control": No such file or directory
2019-12-11 17:11:21,569: INFO	flask.app:	Connection Request for server#2
2019-12-11 17:11:21,574: INFO	flask.app:	Connection Established for server:                 2 - PostgreSQL 9.4
2019-12-11 17:11:21,575: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 6440306):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2019-12-11 17:11:21,583: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 2989925):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_encoding_to_char(db.encoding) AS serverencoding,
    has_database_privilege(db.oid, 'CREATE') as cancreate, datlastsysoid
FROM
    pg_database db
WHERE db.oid = 24606
2019-12-11 17:11:21,588: INFO	flask.app:	Connection Established for Database Id:                 24606
2019-12-11 17:11:21,603: ERROR	STDERR:	ERROR
2019-12-11 17:11:21,604: ERROR	STDERR:	runTest (pgadmin.browser.server_groups.servers.databases.extensions.tests.test_extension_get.ExtensionsGetTestCase)
2019-12-11 17:11:21,604: ERROR	STDERR:	Check Extension Node
2019-12-11 17:11:21,604: ERROR	STDERR:	 ...
2019-12-11 17:11:21,608: INFO	flask.app:	Connection Request for server#2
2019-12-11 17:11:21,613: INFO	flask.app:	Connection Established for server:                 2 - PostgreSQL 9.4
2019-12-11 17:11:21,613: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 3369218):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2019-12-11 17:11:21,617: ERROR	STDERR:	Traceback (most recent call last):
2019-12-11 17:11:21,617: ERROR	STDERR:	  File "/home/karan/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/utils.py", line 53, in create_extension
2019-12-11 17:11:21,617: ERROR	STDERR:	    schema_name))
2019-12-11 17:11:21,617: ERROR	STDERR:	psycopg2.errors.UndefinedFile: could not open extension control file "/usr/local/pgsql/share/extension/cube.control": No such file or directory
2019-12-11 17:11:21,621: INFO	flask.app:	Connection Request for server#2
2019-12-11 17:11:21,626: INFO	flask.app:	Connection Established for server:                 2 - PostgreSQL 9.4
2019-12-11 17:11:21,626: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 8463607):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2019-12-11 17:11:21,634: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 9189113):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_encoding_to_char(db.encoding) AS serverencoding,
    has_database_privilege(db.oid, 'CREATE') as cancreate, datlastsysoid
FROM
    pg_database db
WHERE db.oid = 24606
2019-12-11 17:11:21,640: INFO	flask.app:	Connection Established for Database Id:                 24606
2019-12-11 17:11:21,648: ERROR	flask.app:	404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
Traceback (most recent call last):
  File "/home/karan/altpg/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request
    rv = self.dispatch_request()
  File "/home/karan/altpg/lib/python3.6/site-packages/flask/app.py", line 1791, in dispatch_request
    self.raise_routing_exception(req)
  File "/home/karan/altpg/lib/python3.6/site-packages/flask/app.py", line 1774, in raise_routing_exception
    raise request.routing_exception
  File "/home/karan/altpg/lib/python3.6/site-packages/flask/ctx.py", line 336, in match_request
    self.url_adapter.match(return_rule=True)
  File "/home/karan/altpg/lib/python3.6/site-packages/werkzeug/routing.py", line 1799, in match
    raise NotFound()
werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
2019-12-11 17:11:21,663: ERROR	STDERR:	FAIL
2019-12-11 17:11:21,663: ERROR	STDERR:	runTest (pgadmin.browser.server_groups.servers.databases.extensions.tests.test_extension_put.ExtensionsPutTestCase)
2019-12-11 17:11:21,663: ERROR	STDERR:	Check Extension Node
2019-12-11 17:11:21,663: ERROR	STDERR:	 ...
2019-12-11 17:11:21,668: INFO	flask.app:	Connection Request for server#2
2019-12-11 17:11:21,673: INFO	flask.app:	Connection Established for server:                 2 - PostgreSQL 9.4
2019-12-11 17:11:21,673: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 7671887):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2019-12-11 17:11:21,677: ERROR	STDERR:	Traceback (most recent call last):
2019-12-11 17:11:21,677: ERROR	STDERR:	  File "/home/karan/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/utils.py", line 53, in create_extension
2019-12-11 17:11:21,678: ERROR	STDERR:	    schema_name))
2019-12-11 17:11:21,678: ERROR	STDERR:	psycopg2.errors.UndefinedFile: could not open extension control file "/usr/local/pgsql/share/extension/cube.control": No such file or directory
2019-12-11 17:11:21,683: INFO	flask.app:	Connection Request for server#2
2019-12-11 17:11:21,688: INFO	flask.app:	Connection Established for server:                 2 - PostgreSQL 9.4
2019-12-11 17:11:21,688: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 4962219):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2019-12-11 17:11:21,698: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 2280705):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_encoding_to_char(db.encoding) AS serverencoding,
    has_database_privilege(db.oid, 'CREATE') as cancreate, datlastsysoid
FROM
    pg_database db
WHERE db.oid = 24606
2019-12-11 17:11:21,704: INFO	flask.app:	Connection Established for Database Id:                 24606
2019-12-11 17:11:21,722: ERROR	STDERR:	ERROR
2019-12-11 17:11:21,722: ERROR	STDERR:	runTest (regression.re_sql.tests.test_resql.ReverseEngineeredSQLTestCases)
2019-12-11 17:11:21,722: ERROR	STDERR:	Reverse Engineered SQL Test Cases
2019-12-11 17:11:21,722: ERROR	STDERR:	 ...
2019-12-11 17:11:21,727: INFO	flask.app:	Connection Request for server#2
2019-12-11 17:11:21,732: INFO	flask.app:	Connection Established for server:                 2 - PostgreSQL 9.4
2019-12-11 17:11:21,732: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 9178306):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2019-12-11 17:11:21,741: SQL	flask.app:	Execute (dict) for server #2 - DB:postgres (Query-id: 2349296):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_encoding_to_char(db.encoding) AS serverencoding,
    has_database_privilege(db.oid, 'CREATE') as cancreate, datlastsysoid
FROM
    pg_database db
WHERE db.oid = 24606
2019-12-11 17:11:21,747: INFO	flask.app:	Connection Established for Database Id:                 24606
2019-12-11 17:11:21,764: ERROR	STDERR:	ok
2019-12-11 17:11:21,765: ERROR	STDERR:	======================================================================
2019-12-11 17:11:21,765: ERROR	STDERR:	ERROR: runTest (pgadmin.browser.server_groups.servers.databases.extensions.tests.test_extension_delete.ExtensionsDeleteTestCase)
2019-12-11 17:11:21,765: ERROR	STDERR:	Check Extension Node
2019-12-11 17:11:21,765: ERROR	STDERR:	----------------------------------------------------------------------
2019-12-11 17:11:21,765: ERROR	STDERR:	Traceback (most recent call last):
2019-12-11 17:11:21,765: ERROR	STDERR:	  File "/home/karan/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/test_extension_delete.py", line 50, in runTest
2019-12-11 17:11:21,765: ERROR	STDERR:	    raise Exception("Could not find extension.")
2019-12-11 17:11:21,765: ERROR	STDERR:	Exception: Could not find extension.
2019-12-11 17:11:21,765: ERROR	STDERR:	======================================================================
2019-12-11 17:11:21,765: ERROR	STDERR:	ERROR: runTest (pgadmin.browser.server_groups.servers.databases.extensions.tests.test_extension_delete_multiple.ExtensionsDeleteMultipleTestCase)
2019-12-11 17:11:21,765: ERROR	STDERR:	Check Extension Node
2019-12-11 17:11:21,765: ERROR	STDERR:	----------------------------------------------------------------------
2019-12-11 17:11:21,765: ERROR	STDERR:	Traceback (most recent call last):
2019-12-11 17:11:21,765: ERROR	STDERR:	  File "/home/karan/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/test_extension_delete_multiple.py", line 57, in runTest
2019-12-11 17:11:21,765: ERROR	STDERR:	    raise Exception("Could not find extension.")
2019-12-11 17:11:21,765: ERROR	STDERR:	Exception: Could not find extension.
2019-12-11 17:11:21,765: ERROR	STDERR:	======================================================================
2019-12-11 17:11:21,765: ERROR	STDERR:	ERROR: runTest (pgadmin.browser.server_groups.servers.databases.extensions.tests.test_extension_put.ExtensionsPutTestCase)
2019-12-11 17:11:21,765: ERROR	STDERR:	Check Extension Node
2019-12-11 17:11:21,765: ERROR	STDERR:	----------------------------------------------------------------------
2019-12-11 17:11:21,765: ERROR	STDERR:	Traceback (most recent call last):
2019-12-11 17:11:21,766: ERROR	STDERR:	  File "/home/karan/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/test_extension_put.py", line 52, in runTest
2019-12-11 17:11:21,766: ERROR	STDERR:	    raise Exception("Could not find extension.")
2019-12-11 17:11:21,766: ERROR	STDERR:	Exception: Could not find extension.
2019-12-11 17:11:21,766: ERROR	STDERR:	======================================================================
2019-12-11 17:11:21,766: ERROR	STDERR:	FAIL: runTest (pgadmin.browser.server_groups.servers.databases.extensions.tests.test_extension_add.ExtensionsAddTestCase)
2019-12-11 17:11:21,766: ERROR	STDERR:	Check Extension Node
2019-12-11 17:11:21,766: ERROR	STDERR:	----------------------------------------------------------------------
2019-12-11 17:11:21,766: ERROR	STDERR:	Traceback (most recent call last):
2019-12-11 17:11:21,766: ERROR	STDERR:	  File "/home/karan/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/test_extension_add.py", line 50, in runTest
2019-12-11 17:11:21,766: ERROR	STDERR:	    self.assertEquals(response.status_code, 200)
2019-12-11 17:11:21,766: ERROR	STDERR:	AssertionError: 500 != 200
2019-12-11 17:11:21,766: ERROR	STDERR:	======================================================================
2019-12-11 17:11:21,766: ERROR	STDERR:	FAIL: runTest (pgadmin.browser.server_groups.servers.databases.extensions.tests.test_extension_get.ExtensionsGetTestCase)
2019-12-11 17:11:21,766: ERROR	STDERR:	Check Extension Node
2019-12-11 17:11:21,766: ERROR	STDERR:	----------------------------------------------------------------------
2019-12-11 17:11:21,766: ERROR	STDERR:	Traceback (most recent call last):
2019-12-11 17:11:21,766: ERROR	STDERR:	  File "/home/karan/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/test_extension_get.py", line 52, in runTest
2019-12-11 17:11:21,767: ERROR	STDERR:	    self.assertEquals(response.status_code, 200)
2019-12-11 17:11:21,767: ERROR	STDERR:	AssertionError: 404 != 200
2019-12-11 17:11:21,767: ERROR	STDERR:	----------------------------------------------------------------------
2019-12-11 17:11:21,767: ERROR	STDERR:	Ran 6 tests in 0.349s
2019-12-11 17:11:21,767: ERROR	STDERR:	FAILED
2019-12-11 17:11:21,767: ERROR	STDERR:	 (failures=2, errors=3)
2019-12-11 17:11:23,196: ERROR	STDERR:	
2019-12-11 17:11:23,196: ERROR	STDERR:	======================================================================
2019-12-11 17:11:23,197: ERROR	STDERR:	Test Result Summary
2019-12-11 17:11:23,197: ERROR	STDERR:	======================================================================
2019-12-11 17:11:23,197: ERROR	STDERR:	PostgreSQL 9.4:
2019-12-11 17:11:23,198: ERROR	STDERR:	
2019-12-11 17:11:23,198: ERROR	STDERR:		1 test passed
2019-12-11 17:11:23,198: ERROR	STDERR:		5 tests failed:
2019-12-11 17:11:23,198: ERROR	STDERR:			ExtensionsAddTestCase (Check Extension Node)
2019-12-11 17:11:23,198: ERROR	STDERR:			ExtensionsGetTestCase (Check Extension Node)
2019-12-11 17:11:23,198: ERROR	STDERR:			ExtensionsDeleteTestCase (Check Extension Node)
2019-12-11 17:11:23,198: ERROR	STDERR:			ExtensionsDeleteMultipleTestCase (Check Extension Node)
2019-12-11 17:11:23,198: ERROR	STDERR:			ExtensionsPutTestCase (Check Extension Node)
2019-12-11 17:11:23,199: ERROR	STDERR:		0 tests skipped
2019-12-11 17:11:23,200: ERROR	STDERR:	======================================================================