Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dpECF-0001NR-Gu for pgadmin-hackers@arkaria.postgresql.org; Tue, 05 Sep 2017 13:47:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dpECE-0000tg-UT for pgadmin-hackers@arkaria.postgresql.org; Tue, 05 Sep 2017 13:47:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dpECE-0000rW-Lj for pgadmin-hackers@lists.postgresql.org; Tue, 05 Sep 2017 13:47:18 +0000 Received: from mail-yw0-x229.google.com ([2607:f8b0:4002:c05::229]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dpEC1-0002jF-CI for pgadmin-hackers@postgresql.org; Tue, 05 Sep 2017 13:47:18 +0000 Received: by mail-yw0-x229.google.com with SMTP id k78so13101152ywe.1 for ; Tue, 05 Sep 2017 06:47:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:cc; bh=tn7/h+2YtyCt3yupGf/TImgpvQKduLEJ6N+AORuiSCk=; b=ziw9/SHG/ODWFlCPdbEXiaPBcgmUc2nNe6B7FS9wSkEMCI+IklFyvVsaGc0578Tns/ TaJBHSRs1/qLgZfRqzcgXFAuFI7sDXd/R8lxf72eHSvQqb+hP7QFGOJcD9dYsUnA5cHj 8HAX9IcwfoHZydMIO9dBVDYrQJmlJZOiarWyS0Hl7cP8nP2477U243E4qsbTnHLVozkH 9IiOJ6imXLf+pcUPSTKe6KMQZn/V3GZ7tT/ItdKmfcV21OcU3p/ffIrYgUfsYn7JfIDS gcjLuRK6702Li6AvPYfidSPAh1BbJqCrpi39VFAVsPCmrv4Ge1C4iefyDWJjJbrDDCPx teXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:cc; bh=tn7/h+2YtyCt3yupGf/TImgpvQKduLEJ6N+AORuiSCk=; b=Qb0vc3mqsiuscwVjFFass1eYIb94FcUjByduKrPLbhBY8Kmeteh8unyvtq5bM4Ezro hu0J87lqfgwrGQrG/BcUOebJH9iuc+VPdchcA0ajzNQ9gsExl/ypw4EWXEUW96f7Ofic Or/kEQhpCPRHLXdyUi5o3fNk2QF7ByWcA5VHtyLTDr1viQbe2TuuViChmuE8ESepJowO QxAiZt87iGVHI25I83Pz19Z95vzlJpNUCtb9IU6RhjZAyXMd1T+HwqRu1C+yOz8+5wZL Vg8YAN+lqZ/jjGwZ2eav/W6GrvxxmVN/GaW0X5Q4CHBgS9r6vtKKwJQHmlLY9SfEeGXd 1bvA== X-Gm-Message-State: AHPjjUgr9jNawyt8e2YtnQiO1Kjv8fcuq20rXh0RXewJUZ2C6FMLa1m8 Hn+vV0BZ1Pe+VrrmlYMDtg5lqSG02SmO72g= X-Received: by 10.129.169.193 with SMTP id g184mt3181977ywh.118.1504619222716; Tue, 05 Sep 2017 06:47:02 -0700 (PDT) MIME-Version: 1.0 Received: by 10.129.70.3 with HTTP; Tue, 5 Sep 2017 06:47:01 -0700 (PDT) In-Reply-To: <837579483.65.1504539130276.JavaMail.jenkins@jenkins.pgadmin.org> References: <1386163588.62.1503672067159.JavaMail.jenkins@jenkins.pgadmin.org> <837579483.65.1504539130276.JavaMail.jenkins@jenkins.pgadmin.org> From: Harshal Dhumal Date: Tue, 5 Sep 2017 19:17:01 +0530 Message-ID: Subject: Re: Build failed in Jenkins: pgadmin4-master-python27-feature #11 Cc: pgadmin-hackers , Ashesh Vashi , Dave Page Content-Type: multipart/mixed; boundary="94eb2c13cde04b88860558717693" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Unsubscribe: , List-Archive: Precedence: bulk --94eb2c13cde04b88860558717693 Content-Type: multipart/alternative; boundary="94eb2c13cde04b88830558717691" --94eb2c13cde04b88830558717691 Content-Type: text/plain; charset="UTF-8" Hi Dave, Please attached patch to fixed Querytool feature test cases (RM2681 ). -- *Harshal Dhumal* *Sr. Software Engineer* EnterpriseDB India: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Mon, Sep 4, 2017 at 9:02 PM, pgAdmin 4 Jenkins wrote: > See feature/11/display/redirect?page=changes> > > Changes: > > [Dave Page] Allow queries to be cancelled from the dashboard, and display > additional > > [Ashesh Vashi] Define the utility path lable, and help message for the > Greenplum > > [Ashesh Vashi] Using the proper python syntax to fetch the default binary > path for > > [akshay.joshi] Fixed issue where 'backend_type' column is exist for > database server > > [Dave Page] Cleanup feature tests. Fixes #2586 > > [Dave Page] Allow pgAdmin to run with config database versions from the > future. > > [Dave Page] Rename the debugger XSS test function to 'a_test_function' to > ensure it > > [Dave Page] GPDB compatibility fixes: > > [Dave Page] Fix RE-SQL for triggers with a single arg. Fixes #2668 > > [Dave Page] Improve datamodel validations for default Validator if user > (developer) > > [Dave Page] Fix display of types in GPDB. > > [Ashesh Vashi] Define the proper NODE_ENV environment during running the > webpack. Using > > [akshay.joshi] 1) Fixed error in alertify.pgNotifier when server > connection is lost. 2) > > [Dave Page] Fix Copy so it still works after query results have been > copied. Fixes > > ------------------------------------------ > [...truncated 79.49 KB...] > File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/ > selenium/webdriver/remote/errorhandler.py",> line 193, in check_response > raise exception_class(message, screen, stacktrace) > NoSuchElementException: Message: no such element: Unable to locate > element: {"method":"xpath","selector":"//*[contains(string(),'Total > Cost')]"} > (Session info: chrome=59.0.3071.115) > (Driver info: chromedriver=2.29.461571 (8a88bbe0775e2a23afda0ceaf2ef7ee74e822cc5),platform=Linux > 3.10.0-514.16.1.el7.x86_64 x86_64) > > > ---------------------------------------------------------------------- > Ran 9 tests in 154.798s > > FAILED (errors=1) > > =============Running the test cases for 'EDB Postgres AS 9.4'============= > runTest (pgadmin.feature_tests.copy_selected_query_results_feature_test. > CopySelectedQueryResultsFeatureTest) > Copy rows, column using button and keyboard shortcut ... ok > runTest (pgadmin.feature_tests.pg_datatype_validation_test. > PGDataypeFeatureTest) > Test checks for PG data-types output ... ok > runTest (pgadmin.feature_tests.query_tool_journey_test. > QueryToolJourneyTest) > Tests the path through the query tool ... ok > runTest (pgadmin.feature_tests.query_tool_tests.QueryToolFeatureTest) > Query tool feature test ... > On demand query result... > On demand result set on scrolling... OK. > On demand result set on grid select all... OK. > On demand result set on column select all... OK. > Explain query with verbose and cost... OK. > Explain analyze query with buffers and timing... OK. > Auto commit disabled... OK. > Auto commit enabled... OK. > Auto rollback enabled... OK. > Cancel query... OK. > ok > runTest (pgadmin.feature_tests.table_ddl_feature_test.TableDdlFeatureTest) > Test table DDL generation ... ok > runTest (pgadmin.feature_tests.view_data_dml_queries.CheckForViewDataTest) > Validate Insert, Update operations in View/Edit data with given test data > ... ok > runTest (pgadmin.feature_tests.xss_checks_panels_and_query_tool_ > test.CheckForXssFeatureTest) > Test XSS check for panels and query tool ... ok > runTest (pgadmin.feature_tests.xss_checks_pgadmin_debugger_test. > CheckDebuggerForXssFeatureTest) > Tests to check if Debugger is vulnerable to XSS ... ok > runTest (pgadmin.feature_tests.xss_checks_roles_control_test. > CheckRoleMembershipControlFeatureTest) > Tests to check if Role membership control is vulnerable to XSS ... ok > > ---------------------------------------------------------------------- > Ran 9 tests in 225.902s > > OK > > =============Running the test cases for 'EDB Postgres AS 9.5'============= > runTest (pgadmin.feature_tests.copy_selected_query_results_feature_test. > CopySelectedQueryResultsFeatureTest) > Copy rows, column using button and keyboard shortcut ... ok > runTest (pgadmin.feature_tests.pg_datatype_validation_test. > PGDataypeFeatureTest) > Test checks for PG data-types output ... ok > runTest (pgadmin.feature_tests.query_tool_journey_test. > QueryToolJourneyTest) > Tests the path through the query tool ... ok > runTest (pgadmin.feature_tests.query_tool_tests.QueryToolFeatureTest) > Query tool feature test ... > On demand query result... > On demand result set on scrolling... OK. > On demand result set on grid select all... OK. > On demand result set on column select all... OK. > Explain query with verbose and cost... ERROR > runTest (pgadmin.feature_tests.table_ddl_feature_test.TableDdlFeatureTest) > Test table DDL generation ... ok > runTest (pgadmin.feature_tests.view_data_dml_queries.CheckForViewDataTest) > Validate Insert, Update operations in View/Edit data with given test data > ... ok > runTest (pgadmin.feature_tests.xss_checks_panels_and_query_tool_ > test.CheckForXssFeatureTest) > Test XSS check for panels and query tool ... ok > runTest (pgadmin.feature_tests.xss_checks_pgadmin_debugger_test. > CheckDebuggerForXssFeatureTest) > Tests to check if Debugger is vulnerable to XSS ... ok > runTest (pgadmin.feature_tests.xss_checks_roles_control_test. > CheckRoleMembershipControlFeatureTest) > Tests to check if Role membership control is vulnerable to XSS ... ok > > ====================================================================== > ERROR: runTest (pgadmin.feature_tests.query_tool_tests. > QueryToolFeatureTest) > Query tool feature test > ---------------------------------------------------------------------- > Traceback (most recent call last): > File " feature/ws/web/pgadmin/feature_tests/query_tool_tests.py",> line 55, in > runTest > self._query_tool_explain_with_verbose_and_cost() > File " feature/ws/web/pgadmin/feature_tests/query_tool_tests.py",> line 235, in > _query_tool_explain_with_verbose_and_cost > canvas.find_element_by_xpath("//*[contains(string(),'Total Cost')]") > File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/ > selenium/webdriver/remote/webelement.py",> line 260, in > find_element_by_xpath > return self.find_element(by=By.XPATH, value=xpath) > File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/ > selenium/webdriver/remote/webelement.py",> line 510, in find_element > {"using": by, "value": value})['value'] > File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/ > selenium/webdriver/remote/webelement.py",> line 493, in _execute > return self._parent.execute(command, params) > File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/ > selenium/webdriver/remote/webdriver.py",> line 249, in execute > self.error_handler.check_response(response) > File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/ > selenium/webdriver/remote/errorhandler.py",> line 193, in check_response > raise exception_class(message, screen, stacktrace) > NoSuchElementException: Message: no such element: Unable to locate > element: {"method":"xpath","selector":"//*[contains(string(),'Total > Cost')]"} > (Session info: chrome=59.0.3071.115) > (Driver info: chromedriver=2.29.461571 (8a88bbe0775e2a23afda0ceaf2ef7ee74e822cc5),platform=Linux > 3.10.0-514.16.1.el7.x86_64 x86_64) > > > ---------------------------------------------------------------------- > Ran 9 tests in 155.286s > > FAILED (errors=1) > > =============Running the test cases for 'EDB Postgres AS 9.6'============= > runTest (pgadmin.feature_tests.copy_selected_query_results_feature_test. > CopySelectedQueryResultsFeatureTest) > Copy rows, column using button and keyboard shortcut ... ok > runTest (pgadmin.feature_tests.pg_datatype_validation_test. > PGDataypeFeatureTest) > Test checks for PG data-types output ... ok > runTest (pgadmin.feature_tests.query_tool_journey_test. > QueryToolJourneyTest) > Tests the path through the query tool ... ok > runTest (pgadmin.feature_tests.query_tool_tests.QueryToolFeatureTest) > Query tool feature test ... > On demand query result... > On demand result set on scrolling... OK. > On demand result set on grid select all... OK. > On demand result set on column select all... OK. > Explain query with verbose and cost... OK. > Explain analyze query with buffers and timing... ERROR > runTest (pgadmin.feature_tests.table_ddl_feature_test.TableDdlFeatureTest) > Test table DDL generation ... ok > runTest (pgadmin.feature_tests.view_data_dml_queries.CheckForViewDataTest) > Validate Insert, Update operations in View/Edit data with given test data > ... ok > runTest (pgadmin.feature_tests.xss_checks_panels_and_query_tool_ > test.CheckForXssFeatureTest) > Test XSS check for panels and query tool ... ok > runTest (pgadmin.feature_tests.xss_checks_pgadmin_debugger_test. > CheckDebuggerForXssFeatureTest) > Tests to check if Debugger is vulnerable to XSS ... ok > runTest (pgadmin.feature_tests.xss_checks_roles_control_test. > CheckRoleMembershipControlFeatureTest) > Tests to check if Role membership control is vulnerable to XSS ... ok > > ====================================================================== > ERROR: runTest (pgadmin.feature_tests.query_tool_tests. > QueryToolFeatureTest) > Query tool feature test > ---------------------------------------------------------------------- > Traceback (most recent call last): > File " feature/ws/web/pgadmin/feature_tests/query_tool_tests.py",> line 62, in > runTest > self._query_tool_explain_analyze_with_buffers_and_timing() > File " feature/ws/web/pgadmin/feature_tests/query_tool_tests.py",> line 267, in > _query_tool_explain_analyze_with_buffers_and_timing > "//*[contains(string(), 'Shared Read Blocks')]" > File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/ > selenium/webdriver/remote/webelement.py",> line 260, in > find_element_by_xpath > return self.find_element(by=By.XPATH, value=xpath) > File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/ > selenium/webdriver/remote/webelement.py",> line 510, in find_element > {"using": by, "value": value})['value'] > File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/ > selenium/webdriver/remote/webelement.py",> line 493, in _execute > return self._parent.execute(command, params) > File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/ > selenium/webdriver/remote/webdriver.py",> line 249, in execute > self.error_handler.check_response(response) > File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/ > selenium/webdriver/remote/errorhandler.py",> line 193, in check_response > raise exception_class(message, screen, stacktrace) > NoSuchElementException: Message: no such element: Unable to locate > element: {"method":"xpath","selector":"//*[contains(string(), 'Shared > Read Blocks')]"} > (Session info: chrome=59.0.3071.115) > (Driver info: chromedriver=2.29.461571 (8a88bbe0775e2a23afda0ceaf2ef7ee74e822cc5),platform=Linux > 3.10.0-514.16.1.el7.x86_64 x86_64) > > > ---------------------------------------------------------------------- > Ran 9 tests in 159.524s > > FAILED (errors=1) > > ====================================================================== > Test Result Summary > ====================================================================== > > PostgreSQL 9.6: > > 9 tests passed > 0 tests failed > 0 tests skipped > > PostgreSQL 9.5: > > 8 tests passed > 1 test failed: > QueryToolFeatureTest (Query tool feature test) > 0 tests skipped > > PostgreSQL 9.4: > > 8 tests passed > 1 test failed: > QueryToolFeatureTest (Query tool feature test) > 0 tests skipped > > PostgreSQL 9.3: > > 8 tests passed > 1 test failed: > QueryToolFeatureTest (Query tool feature test) > 0 tests skipped > > PostgreSQL 9.2: > > 9 tests passed > 0 tests failed > 0 tests skipped > > PostgreSQL 10: > > 7 tests passed > 1 test failed: > QueryToolFeatureTest (Query tool feature test) > 1 test skipped: > CheckDebuggerForXssFeatureTest (Tests to check if Debugger > is vulnerable to XSS) > > EDB Postgres AS 9.4: > > 9 tests passed > 0 tests failed > 0 tests skipped > > EDB Postgres AS 9.5: > > 8 tests passed > 1 test failed: > QueryToolFeatureTest (Query tool feature test) > 0 tests skipped > > EDB Postgres AS 9.6: > > 8 tests passed > 1 test failed: > QueryToolFeatureTest (Query tool feature test) > 0 tests skipped > > EDB Postgres AS 9.2: > > 7 tests passed > 2 tests failed: > QueryToolFeatureTest (Query tool feature test) > CheckDebuggerForXssFeatureTest (Tests to check if Debugger > is vulnerable to XSS) > 0 tests skipped > > EDB Postgres AS 9.3: > > 8 tests passed > 1 test failed: > QueryToolFeatureTest (Query tool feature test) > 0 tests skipped > > ====================================================================== > > NOTE: Configuring authentication for DESKTOP mode. > pgAdmin 4 - Application Initialisation > ====================================== > > Please check output in file: job/pgadmin4-master-python27-feature/ws/web/regression/regression.log> > > ERROR: Error detected when running the Feature tests. > Process leaked file descriptors. See https://jenkins.io/redirect/ > troubleshooting/process-leaked-file-descriptors for more information > Build step 'Execute shell' marked build as failure > Not sending mail to unregistered user akshay.joshi@enterprisedb.com > > --94eb2c13cde04b88830558717691 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Dave,

Please attached patch to fixed= Querytool feature test cases (RM2681).


--=C2=A0
Harshal Dhumal
S= r. Software Engineer

EnterpriseDB India:=C2=A0http://www.enterprisedb.com
The Enterprise PostgreSQL Company
<= /div>

On Mon, Sep 4, 2017 at 9:02 PM, pgAdmin 4 Je= nkins <jenkins@pgadmin.org> wrote:
See <https://jenkins.pgadmin.org/job/pgadmin4-master-p= ython27-feature/11/display/redirect?page=3Dchanges>

Changes:

[Dave Page] Allow queries to be cancelled from the dashboard, and display a= dditional

[Ashesh Vashi] Define the utility path lable, and help message for the Gree= nplum

[Ashesh Vashi] Using the proper python syntax to fetch the default binary p= ath for

[akshay.joshi] Fixed issue where 'backend_type' column is exist for= database server

[Dave Page] Cleanup feature tests. Fixes #2586

[Dave Page] Allow pgAdmin to run with config database versions from the fut= ure.

[Dave Page] Rename the debugger XSS test function to 'a_test_function&#= 39; to ensure it

[Dave Page] GPDB compatibility fixes:

[Dave Page] Fix RE-SQL for triggers with a single arg. Fixes #2668

[Dave Page] Improve datamodel validations for default Validator if user (de= veloper)

[Dave Page] Fix display of types in GPDB.

[Ashesh Vashi] Define the proper NODE_ENV environment during running the we= bpack. Using

[akshay.joshi] 1) Fixed error in alertify.pgNotifier when server connection= is lost. 2)

[Dave Page] Fix Copy so it still works after query results have been copied= . Fixes

------------------------------------------
[...truncated 79.49 KB...]
=C2=A0 File "<htt= ps://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/= pgadmin-venv/lib/python2.7/site-packages/selenium/webdriver/remot= e/errorhandler.py",> line 193, in check_response
=C2=A0 =C2=A0 raise exception_class(message, screen, stacktrace)
NoSuchElementException: Message: no such element: Unable to locate element:= {"method":"xpath","selector":"//*[= contains(string(),'Total Cost')]"}
=C2=A0 (Session info: chrome=3D59.0.3071.115)
=C2=A0 (Driver info: chromedriver=3D2.29.461571 (8a88bbe0775e2a23afda0= ceaf2ef7ee74e822cc5),platform=3DLinux 3.10.0-514.16.1.el7.x86_64 x86_6= 4)


-----------------------------------------------------------------= -----
Ran 9 tests in 154.798s

FAILED (errors=3D1)

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DRunning the test cases for 'EDB = Postgres AS 9.4'=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
runTest (pgadmin.feature_tests.copy_selected_query_results_featur= e_test.CopySelectedQueryResultsFeatureTest)
Copy rows, column using button and keyboard shortcut ... ok
runTest (pgadmin.feature_tests.pg_datatype_validation_test.PGData= ypeFeatureTest)
Test checks for PG data-types output ... ok
runTest (pgadmin.feature_tests.query_tool_journey_test.QueryToolJ= ourneyTest)
Tests the path through the query tool ... ok
runTest (pgadmin.feature_tests.query_tool_tests.QueryToolFeatureT= est)
Query tool feature test ...
On demand query result...
On demand result set on scrolling... OK.
On demand result set on grid select all... OK.
On demand result set on column select all... OK.
Explain query with verbose and cost... OK.
Explain analyze query with buffers and timing... OK.
Auto commit disabled... OK.
Auto commit enabled... OK.
Auto rollback enabled... OK.
Cancel query... OK.
ok
runTest (pgadmin.feature_tests.table_ddl_feature_test.TableDdlFea= tureTest)
Test table DDL generation ... ok
runTest (pgadmin.feature_tests.view_data_dml_queries.CheckForView= DataTest)
Validate Insert, Update operations in View/Edit data with given test data .= .. ok
runTest (pgadmin.feature_tests.xss_checks_panels_and_query_tool_t= est.CheckForXssFeatureTest)
Test XSS check for panels and query tool ... ok
runTest (pgadmin.feature_tests.xss_checks_pgadmin_debugger_test.C= heckDebuggerForXssFeatureTest)
Tests to check if Debugger is vulnerable to XSS ... ok
runTest (pgadmin.feature_tests.xss_checks_roles_control_test.Chec= kRoleMembershipControlFeatureTest)
Tests to check if Role membership control is vulnerable to XSS ... ok

-----------------------------------------------------------------= -----
Ran 9 tests in 225.902s

OK

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DRunning the test cases for 'EDB = Postgres AS 9.5'=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
runTest (pgadmin.feature_tests.copy_selected_query_results_featur= e_test.CopySelectedQueryResultsFeatureTest)
Copy rows, column using button and keyboard shortcut ... ok
runTest (pgadmin.feature_tests.pg_datatype_validation_test.PGData= ypeFeatureTest)
Test checks for PG data-types output ... ok
runTest (pgadmin.feature_tests.query_tool_journey_test.QueryToolJ= ourneyTest)
Tests the path through the query tool ... ok
runTest (pgadmin.feature_tests.query_tool_tests.QueryToolFeatureT= est)
Query tool feature test ...
On demand query result...
On demand result set on scrolling... OK.
On demand result set on grid select all... OK.
On demand result set on column select all... OK.
Explain query with verbose and cost... ERROR
runTest (pgadmin.feature_tests.table_ddl_feature_test.TableDdlFea= tureTest)
Test table DDL generation ... ok
runTest (pgadmin.feature_tests.view_data_dml_queries.CheckForView= DataTest)
Validate Insert, Update operations in View/Edit data with given test data .= .. ok
runTest (pgadmin.feature_tests.xss_checks_panels_and_query_tool_t= est.CheckForXssFeatureTest)
Test XSS check for panels and query tool ... ok
runTest (pgadmin.feature_tests.xss_checks_pgadmin_debugger_test.C= heckDebuggerForXssFeatureTest)
Tests to check if Debugger is vulnerable to XSS ... ok
runTest (pgadmin.feature_tests.xss_checks_roles_control_test.Chec= kRoleMembershipControlFeatureTest)
Tests to check if Role membership control is vulnerable to XSS ... ok

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
ERROR: runTest (pgadmin.feature_tests.query_tool_tests.QueryToolF= eatureTest)
Query tool feature test
-----------------------------------------------------------------= -----
Traceback (most recent call last):
=C2=A0 File "<https://jenkins.pgadmin.org/job/pga= dmin4-master-python27-feature/ws/web/pgadmin/feature_tests/query_= tool_tests.py",> line 55, in runTest
=C2=A0 =C2=A0 self._query_tool_explain_with_verbose_and_cost()
=C2=A0 File "<https://jenkins.pgadmin.org/job/pga= dmin4-master-python27-feature/ws/web/pgadmin/feature_tests/query_= tool_tests.py",> line 235, in _query_tool_explain_with_verbose_and_cost
=C2=A0 =C2=A0 canvas.find_element_by_xpath("//*[contains(string()= ,'Total Cost')]")
=C2=A0 File "<https= ://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/pg= admin-venv/lib/python2.7/site-packages/selenium/webdriver/remote/= webelement.py",> line 260, in find_element_by_xpath
=C2=A0 =C2=A0 return self.find_element(by=3DBy.XPATH, value=3Dxpath)
=C2=A0 File "<https= ://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/pg= admin-venv/lib/python2.7/site-packages/selenium/webdriver/remote/= webelement.py",> line 510, in find_element
=C2=A0 =C2=A0 {"using": by, "value": value})['value= ']
=C2=A0 File "<https= ://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/pg= admin-venv/lib/python2.7/site-packages/selenium/webdriver/remote/= webelement.py",> line 493, in _execute
=C2=A0 =C2=A0 return self._parent.execute(command, params)
=C2=A0 File "<https:= //jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/pga= dmin-venv/lib/python2.7/site-packages/selenium/webdriver/remote/<= wbr>webdriver.py",> line 249, in execute
=C2=A0 =C2=A0 self.error_handler.check_response(response)
=C2=A0 File "<htt= ps://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/= pgadmin-venv/lib/python2.7/site-packages/selenium/webdriver/remot= e/errorhandler.py",> line 193, in check_response
=C2=A0 =C2=A0 raise exception_class(message, screen, stacktrace)
NoSuchElementException: Message: no such element: Unable to locate element:= {"method":"xpath","selector":"//*[= contains(string(),'Total Cost')]"}
=C2=A0 (Session info: chrome=3D59.0.3071.115)
=C2=A0 (Driver info: chromedriver=3D2.29.461571 (8a88bbe0775e2a23afda0= ceaf2ef7ee74e822cc5),platform=3DLinux 3.10.0-514.16.1.el7.x86_64 x86_6= 4)


-----------------------------------------------------------------= -----
Ran 9 tests in 155.286s

FAILED (errors=3D1)

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DRunning the test cases for 'EDB = Postgres AS 9.6'=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
runTest (pgadmin.feature_tests.copy_selected_query_results_featur= e_test.CopySelectedQueryResultsFeatureTest)
Copy rows, column using button and keyboard shortcut ... ok
runTest (pgadmin.feature_tests.pg_datatype_validation_test.PGData= ypeFeatureTest)
Test checks for PG data-types output ... ok
runTest (pgadmin.feature_tests.query_tool_journey_test.QueryToolJ= ourneyTest)
Tests the path through the query tool ... ok
runTest (pgadmin.feature_tests.query_tool_tests.QueryToolFeatureT= est)
Query tool feature test ...
On demand query result...
On demand result set on scrolling... OK.
On demand result set on grid select all... OK.
On demand result set on column select all... OK.
Explain query with verbose and cost... OK.
Explain analyze query with buffers and timing... ERROR
runTest (pgadmin.feature_tests.table_ddl_feature_test.TableDdlFea= tureTest)
Test table DDL generation ... ok
runTest (pgadmin.feature_tests.view_data_dml_queries.CheckForView= DataTest)
Validate Insert, Update operations in View/Edit data with given test data .= .. ok
runTest (pgadmin.feature_tests.xss_checks_panels_and_query_tool_t= est.CheckForXssFeatureTest)
Test XSS check for panels and query tool ... ok
runTest (pgadmin.feature_tests.xss_checks_pgadmin_debugger_test.C= heckDebuggerForXssFeatureTest)
Tests to check if Debugger is vulnerable to XSS ... ok
runTest (pgadmin.feature_tests.xss_checks_roles_control_test.Chec= kRoleMembershipControlFeatureTest)
Tests to check if Role membership control is vulnerable to XSS ... ok

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
ERROR: runTest (pgadmin.feature_tests.query_tool_tests.QueryToolF= eatureTest)
Query tool feature test
-----------------------------------------------------------------= -----
Traceback (most recent call last):
=C2=A0 File "<https://jenkins.pgadmin.org/job/pga= dmin4-master-python27-feature/ws/web/pgadmin/feature_tests/query_= tool_tests.py",> line 62, in runTest
=C2=A0 =C2=A0 self._query_tool_explain_analyze_with_buffers_and_t= iming()
=C2=A0 File "<https://jenkins.pgadmin.org/job/pga= dmin4-master-python27-feature/ws/web/pgadmin/feature_tests/query_= tool_tests.py",> line 267, in _query_tool_explain_analyze_= with_buffers_and_timing
=C2=A0 =C2=A0 "//*[contains(string(), 'Shared Read Blocks')]&q= uot;
=C2=A0 File "<https= ://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/pg= admin-venv/lib/python2.7/site-packages/selenium/webdriver/remote/= webelement.py",> line 260, in find_element_by_xpath
=C2=A0 =C2=A0 return self.find_element(by=3DBy.XPATH, value=3Dxpath)
=C2=A0 File "<https= ://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/pg= admin-venv/lib/python2.7/site-packages/selenium/webdriver/remote/= webelement.py",> line 510, in find_element
=C2=A0 =C2=A0 {"using": by, "value": value})['value= ']
=C2=A0 File "<https= ://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/pg= admin-venv/lib/python2.7/site-packages/selenium/webdriver/remote/= webelement.py",> line 493, in _execute
=C2=A0 =C2=A0 return self._parent.execute(command, params)
=C2=A0 File "<https:= //jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/pga= dmin-venv/lib/python2.7/site-packages/selenium/webdriver/remote/<= wbr>webdriver.py",> line 249, in execute
=C2=A0 =C2=A0 self.error_handler.check_response(response)
=C2=A0 File "<htt= ps://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/= pgadmin-venv/lib/python2.7/site-packages/selenium/webdriver/remot= e/errorhandler.py",> line 193, in check_response
=C2=A0 =C2=A0 raise exception_class(message, screen, stacktrace)
NoSuchElementException: Message: no such element: Unable to locate element:= {"method":"xpath","selector":"//*[= contains(string(), 'Shared Read Blocks')]"}
=C2=A0 (Session info: chrome=3D59.0.3071.115)
=C2=A0 (Driver info: chromedriver=3D2.29.461571 (8a88bbe0775e2a23afda0= ceaf2ef7ee74e822cc5),platform=3DLinux 3.10.0-514.16.1.el7.x86_64 x86_6= 4)


-----------------------------------------------------------------= -----
Ran 9 tests in 159.524s

FAILED (errors=3D1)

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Test Result Summary
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

PostgreSQL 9.6:

=C2=A0 =C2=A0 =C2=A0 =C2=A0 9 tests passed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests failed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests skipped

PostgreSQL 9.5:

=C2=A0 =C2=A0 =C2=A0 =C2=A0 8 tests passed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 1 test failed:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 QueryToolFeatureTes= t (Query tool feature test)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests skipped

PostgreSQL 9.4:

=C2=A0 =C2=A0 =C2=A0 =C2=A0 8 tests passed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 1 test failed:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 QueryToolFeatureTes= t (Query tool feature test)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests skipped

PostgreSQL 9.3:

=C2=A0 =C2=A0 =C2=A0 =C2=A0 8 tests passed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 1 test failed:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 QueryToolFeatureTes= t (Query tool feature test)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests skipped

PostgreSQL 9.2:

=C2=A0 =C2=A0 =C2=A0 =C2=A0 9 tests passed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests failed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests skipped

PostgreSQL 10:

=C2=A0 =C2=A0 =C2=A0 =C2=A0 7 tests passed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 1 test failed:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 QueryToolFeatureTes= t (Query tool feature test)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 1 test skipped:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 CheckDebuggerForXss= FeatureTest (Tests to check if Debugger is vulnerable to XSS)

EDB Postgres AS 9.4:

=C2=A0 =C2=A0 =C2=A0 =C2=A0 9 tests passed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests failed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests skipped

EDB Postgres AS 9.5:

=C2=A0 =C2=A0 =C2=A0 =C2=A0 8 tests passed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 1 test failed:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 QueryToolFeatureTes= t (Query tool feature test)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests skipped

EDB Postgres AS 9.6:

=C2=A0 =C2=A0 =C2=A0 =C2=A0 8 tests passed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 1 test failed:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 QueryToolFeatureTes= t (Query tool feature test)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests skipped

EDB Postgres AS 9.2:

=C2=A0 =C2=A0 =C2=A0 =C2=A0 7 tests passed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 2 tests failed:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 QueryToolFeatureTes= t (Query tool feature test)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 CheckDebuggerForXss= FeatureTest (Tests to check if Debugger is vulnerable to XSS)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests skipped

EDB Postgres AS 9.3:

=C2=A0 =C2=A0 =C2=A0 =C2=A0 8 tests passed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 1 test failed:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 QueryToolFeatureTes= t (Query tool feature test)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 tests skipped

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

NOTE: Configuring authentication for DESKTOP mode.
pgAdmin 4 - Application Initialisation
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Please check output in file: <https://jenkins.pgadmin.org/job/pgadmin4= -master-python27-feature/ws/web/regression/regression.log>=

ERROR: Error detected when running the Feature tests.
Process leaked file descriptors. See https://jenkins.io/redirect/troubleshooting/process-l= eaked-file-descriptors for more information
Build step 'Execute shell' marked build as failure
Not sending mail to unregistered user akshay.joshi@enterprisedb.com


--94eb2c13cde04b88830558717691-- --94eb2c13cde04b88860558717693 Content-Type: text/x-patch; charset="US-ASCII"; name="RM2681.patch" Content-Disposition: attachment; filename="RM2681.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_j77nblvz0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2ZlYXR1cmVfdGVzdHMvcXVlcnlfdG9vbF90ZXN0cy5w eSBiL3dlYi9wZ2FkbWluL2ZlYXR1cmVfdGVzdHMvcXVlcnlfdG9vbF90ZXN0cy5weQppbmRleCBl MmFkYjZlLi5kOWRmN2FkIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9mZWF0dXJlX3Rlc3RzL3F1 ZXJ5X3Rvb2xfdGVzdHMucHkKKysrIGIvd2ViL3BnYWRtaW4vZmVhdHVyZV90ZXN0cy9xdWVyeV90 b29sX3Rlc3RzLnB5CkBAIC00MSw2ICs0MSw3IEBAIGNsYXNzIFF1ZXJ5VG9vbEZlYXR1cmVUZXN0 KEJhc2VGZWF0dXJlVGVzdCk6CiAgICAgICAgIHNlbGYucGFnZS5hZGRfc2VydmVyKHNlbGYuc2Vy dmVyKQogICAgICAgICBzZWxmLl9sb2NhdGVfZGF0YWJhc2VfdHJlZV9ub2RlKCkKICAgICAgICAg c2VsZi5wYWdlLm9wZW5fcXVlcnlfdG9vbCgpCisgICAgICAgIHNlbGYuX3Jlc2V0X29wdGlvbnMo KQogCiAgICAgZGVmIHJ1blRlc3Qoc2VsZik6CiAgICAgICAgICMgb24gZGVtYW5kIHJlc3VsdCBz ZXQgb24gc2Nyb2xsaW5nLgpAQCAtOTcsNiArOTgsMzMgQEAgY2xhc3MgUXVlcnlUb29sRmVhdHVy ZVRlc3QoQmFzZUZlYXR1cmVUZXN0KToKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgc2VsZi5zZXJ2ZXJbJ3NzbG1vZGUnXSkKICAgICAgICAgdGVzdF91 dGlscy5kcm9wX2RhdGFiYXNlKGNvbm5lY3Rpb24sICJhY2NlcHRhbmNlX3Rlc3RfZGIiKQogCisg ICAgZGVmIF9yZXNldF9vcHRpb25zKHNlbGYpOgorICAgICAgICAjIHRoaXMgd2lsbCBzZXQgZm9j dXMgdG8gY29ycmVjdCBpZnJhbWUuCisgICAgICAgIHNlbGYucGFnZS5maWxsX2NvZGVtaXJyb3Jf YXJlYV93aXRoKCcnKQorCisgICAgICAgIHF1ZXJ5X29wID0gc2VsZi5wYWdlLmZpbmRfYnlfaWQo ImJ0bi1xdWVyeS1kcm9wZG93biIpCisgICAgICAgIHF1ZXJ5X29wLmNsaWNrKCkKKyAgICAgICAg QWN0aW9uQ2hhaW5zKHNlbGYuZHJpdmVyKS5tb3ZlX3RvX2VsZW1lbnQoCisgICAgICAgICAgICBx dWVyeV9vcC5maW5kX2VsZW1lbnRfYnlfeHBhdGgoCisgICAgICAgICAgICAgICAgIi8vbGlbY29u dGFpbnMoLiwnRXhwbGFpbiBPcHRpb25zJyldIikpLnBlcmZvcm0oKQorCisgICAgICAgICMgZGlz YWJsZSBFeHBsYWluIG9wdGlvbnMgYW5kIGF1dG8gcm9sbGJhY2sgb25seSBpZiB0aGV5IGFyZSBl bmFibGVkLgorICAgICAgICBmb3Igb3AgaW4gKCdleHBsYWluLXZlcmJvc2UnLCAnZXhwbGFpbi1j b3N0cycsCisgICAgICAgICAgICAgICAgICAgJ2V4cGxhaW4tYnVmZmVycycsICdleHBsYWluLXRp bWluZycsICdhdXRvLXJvbGxiYWNrJyk6CisgICAgICAgICAgICBidG4gPSBzZWxmLnBhZ2UuZmlu ZF9ieV9pZCgiYnRuLXt9Ii5mb3JtYXQob3ApKQorICAgICAgICAgICAgY2hlY2sgPSBidG4uZmlu ZF9lbGVtZW50X2J5X3RhZ19uYW1lKCdpJykKKyAgICAgICAgICAgIGlmICd2aXNpYmlsaXR5LWhp ZGRlbicgbm90IGluIGNoZWNrLmdldF9hdHRyaWJ1dGUoJ2NsYXNzJyk6CisgICAgICAgICAgICAg ICAgYnRuLmNsaWNrKCkKKworICAgICAgICAjIGVuYWJsZSBhdXRvY29tbWl0IG9ubHkgaWYgaXQn cyBkaXNhYmxlZAorICAgICAgICBidG4gPSBzZWxmLnBhZ2UuZmluZF9ieV9pZCgiYnRuLWF1dG8t Y29tbWl0IikKKyAgICAgICAgY2hlY2sgPSBidG4uZmluZF9lbGVtZW50X2J5X3RhZ19uYW1lKCdp JykKKyAgICAgICAgaWYgJ3Zpc2liaWxpdHktaGlkZGVuJyBpbiBjaGVjay5nZXRfYXR0cmlidXRl KCdjbGFzcycpOgorICAgICAgICAgICAgYnRuLmNsaWNrKCkKKworICAgICAgICAjIGNsb3NlIG1l bnUKKyAgICAgICAgcXVlcnlfb3AuY2xpY2soKQorCiAgICAgZGVmIF9sb2NhdGVfZGF0YWJhc2Vf dHJlZV9ub2RlKHNlbGYpOgogICAgICAgICBzZWxmLnBhZ2UudG9nZ2xlX29wZW5fdHJlZV9pdGVt KHNlbGYuc2VydmVyWyduYW1lJ10pCiAgICAgICAgIHNlbGYucGFnZS50b2dnbGVfb3Blbl90cmVl X2l0ZW0oJ0RhdGFiYXNlcycpCg== --94eb2c13cde04b88860558717693--