Build failed in Jenkins: pgadmin4-master-python27-feature #14

See <https://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/14/display/redirect?page=changes>

Changes:

[Dave Page] Rewrite the runtime as a tray-based server which can launch a web

[Dave Page] Bump the version to 3.0, per discussion on the mailing lists

[Dave Page] Fix quoting of function names in RE-SQL. Fixes #3060

[Dave Page] Update JS packages:

[Dave Page] Support EXPLAIN on Greenplum. Fixes #3097

[Dave Page] Add configurable shortcut keys for various common options in the main

[Dave Page] Configurable shortcuts in the Debugger. Fixes #2901

[Dave Page] Fix PEP-8 issues in feature_tests, dashboard, about and misc module's

[Dave Page] Fix tests for Python 3.x

[Dave Page] Fix target name

[Dave Page] Fix Python 2.6 support.

[Dave Page] Fix creation of tables and columns in GPDB. Fixes #3099

[Dave Page] Un-vendorise React, now that it contains bug fixes we need.

[Dave Page] Show button shortcut keys in the debugger on tooltips.

[Dave Page] Fix PEP8 issues in various modules. Fixes #3121

[Dave Page] Add a marker (/*pga4dash*/) to the dashboard queries to allow them to be

[Dave Page] Ensure we can properly update rows with upper-case primary key columns.

[Dave Page] Add missing reverse-engineered SQL header and drop statement for

[Dave Page] Python 3 fix for the runtime.

[Dave Page] Fix stupid thinko

[Dave Page] Attempt to ensure the runtime is built with the correct Python version.

[Dave Page] Fix silly typo

[Dave Page] Ensure column names on indexes on views are properly quoted in RE-SQL.

[Dave Page] Fix alignment issues in keyboard shortcut options. Fixes #3080

[Dave Page] Fix intermittent specified_version_number ValueError issue on restart.

[Dave Page] Clarify which shortcut is being tested in the shortcut test.

[Dave Page] Hide tablespace node on GPDB. Fixes #3107

[Dave Page] Don't depend on standards_conforming_strings being enabled. Fixes #3077

[Dave Page] Fix validation of sequence parameters. Fixes #3014

[Dave Page] Fix tablespace tests for Python 3.x. Fixes #3138

[Dave Page] PEP8 cleanups for the sequences module.

[Dave Page] Don't use the webpack cache with production builds.

[Dave Page] PEP8 fixes for the tools module.

[Dave Page] Add a test for sequence validation.

[Dave Page] Allow dashboard tables and charts to be enabled/disabled. Fixes #2951

[Dave Page] Fix table statistics for Greenplum. Fixes #3059

[Dave Page] PEP8 fixes.

[Dave Page] Ensure we pick up the messages from the current query and not a previous

[Dave Page] Update dashboard display options screenshots.

[Dave Page] PEP8 fixes.

[Dave Page] Revert "Ensure we pick up the messages from the current query and not a

[Dave Page] PEP8 fixes for the pgAgent and Tables nodes (and subnodes). Fixes #3148

[Dave Page] Case sensitive paths are confusing git...

[Dave Page] Fix function reserve SQL for GPDB. Fixes #3150

[Dave Page] Support tab navigation in dialogs. Fixes #2898

[Dave Page] PEP8 fixes for the server and server group modules.

[Dave Page] Add keyboard shortcuts for the Query Tool. Fixes #2900

[Dave Page] Fix block indent/outdent with configurable width. Fixes #3002

[Dave Page] PEP8 fixes. Fixes #3156

[Dave Page] PEP8 fixes.

[Dave Page] Ensure the pgAgent job start/end time grid fields synchronise with the

[Dave Page] Fix handling of tie/datetime array types when adding columns to a table.

[Dave Page] PEP8 fixes for the Casts, Event triggers, Extensions and Languages

[Dave Page] Add a makefile target for running PEP8 checks.

[Dave Page] Stupid Makefile syntax

[Dave Page] Handle opening of non-UTF8 compatible files. Fixes #3129

[Dave Page] Undo previous thinko - there's already a check-pep8 target. D'oh.

[Dave Page] Allow text selection/copying from disabled CodeMirror instances. Fixes

[Dave Page] Allow copying of SQL from the dashboard tables. Fixes #3137

[Dave Page] PEP8 changes for the FDW modules.

[Dave Page] Fix typo/thinko in access key definition.

[Dave Page] Ensure we can edit grid values in the debugger using keyboard shortcuts.

[Dave Page] Support for external tables in GPDB. Fixes #3168

[Dave Page] PEP8 fixes. Fixes #3175

[Dave Page] Disable function statistics on Greenplum. Fixes #3176

[Dave Page] Ensure all messages are retrieved from the server in the Query Tool.

[Dave Page] Update Jasmine to v3. Fixes #3182

[Dave Page] Insert rows correctly when a table has OIDs and a Primary Key in

[Dave Page] Allow admins to disable the use of Gravatar if they choose. Fixes #3037

[Dave Page] Make the poll query test a little more robust.

[Dave Page] More hardening of the query tool tests.

[Dave Page] Final PEP-8 fixes

[Dave Page] Always run PEP-8 checks!

[Dave Page] Fix test case for Python 2.

[Dave Page] Minor formatting fix

[Dave Page] Use test methods with @patch rather than directly.

------------------------------------------
[...truncated 82.69 KB...]
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 ... ERROR
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.view_data_dml_queries.CheckForViewDataTest)
Validate Insert, Update operations in View/Edit data with given test data
----------------------------------------------------------------------
Traceback (most recent call last):
  File
"<https://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/web/pgadmin/feature_tests/view_data_dml_queries.py",>
line125, in runTest
 
    self._verify_row_data(True)
  File
"<https://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/web/pgadmin/feature_tests/view_data_dml_queries.py",>
line325, in _verify_row_data
 
    self.assertEquals(cells[idx], config_data[str(idx)][1])
IndexError: list index out of range

======================================================================
FAIL: runTest (pgadmin.feature_tests.query_tool_journey_test.QueryToolJourneyTest)
Tests the path through the query tool
----------------------------------------------------------------------
Traceback (most recent call last):
  File
"<https://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/web/pgadmin/feature_tests/query_tool_journey_test.py",>
line51, in runTest
 
    self._test_history_tab()
  File
"<https://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/web/pgadmin/feature_tests/query_tool_journey_test.py",>
line104, in _test_history_tab
 
    selected_history_entry.text)
AssertionError: 'SELECT * FROM test_table ORDER BY value' not found in u'SELECT * FROM
table_that_doesnt_exist\n15:59:04'

----------------------------------------------------------------------
Ran 10 tests in 257.966s

FAILED (failures=1, errors=1)

=============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.keyboard_shortcut_test.KeyboardShortcutFeatureTest)
Test for keyboard shortcut ... Executing shortcut: File main menu...OK
Executing shortcut: Object main menu...OK
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 ... ERROR
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.view_data_dml_queries.CheckForViewDataTest)
Validate Insert, Update operations in View/Edit data with given test data
----------------------------------------------------------------------
Traceback (most recent call last):
  File
"<https://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/web/pgadmin/feature_tests/view_data_dml_queries.py",>
line125, in runTest
 
    self._verify_row_data(True)
  File
"<https://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/web/pgadmin/feature_tests/view_data_dml_queries.py",>
line325, in _verify_row_data
 
    self.assertEquals(cells[idx], config_data[str(idx)][1])
IndexError: list index out of range

----------------------------------------------------------------------
Ran 10 tests in 284.870s

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.keyboard_shortcut_test.KeyboardShortcutFeatureTest)
Test for keyboard shortcut ... Executing shortcut: File main menu...OK
Executing shortcut: Object main menu...OK
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 ... ERROR
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.view_data_dml_queries.CheckForViewDataTest)
Validate Insert, Update operations in View/Edit data with given test data
----------------------------------------------------------------------
Traceback (most recent call last):
  File
"<https://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/web/pgadmin/feature_tests/view_data_dml_queries.py",>
line125, in runTest
 
    self._verify_row_data(True)
  File
"<https://jenkins.pgadmin.org/job/pgadmin4-master-python27-feature/ws/web/pgadmin/feature_tests/view_data_dml_queries.py",>
line325, in _verify_row_data
 
    self.assertEquals(cells[idx], config_data[str(idx)][1])
IndexError: list index out of range

----------------------------------------------------------------------
Ran 10 tests in 284.819s

FAILED (errors=1)

======================================================================
Test Result Summary
======================================================================

PostgreSQL 9.6:

    9 tests passed
    1 test failed:
        CheckForViewDataTest (Validate Insert, Update operations in View/Edit data with given test data)
    0 tests skipped

PostgreSQL 9.5:

    9 tests passed
    1 test failed:
        CheckForViewDataTest (Validate Insert, Update operations in View/Edit data with given test data)
    0 tests skipped

PostgreSQL 9.4:

    9 tests passed
    1 test failed:
        CheckForViewDataTest (Validate Insert, Update operations in View/Edit data with given test data)
    0 tests skipped

PostgreSQL 9.3:

    9 tests passed
    1 test failed:
        CheckForViewDataTest (Validate Insert, Update operations in View/Edit data with given test data)
    0 tests skipped

PostgreSQL 9.2:

    8 tests passed
    2 tests failed:
        CheckForViewDataTest (Validate Insert, Update operations in View/Edit data with given test data)
        CopySelectedQueryResultsFeatureTest (Copy rows, column using button and keyboard shortcut)
    0 tests skipped

PostgreSQL 10:

    9 tests passed
    1 test failed:
        CheckForViewDataTest (Validate Insert, Update operations in View/Edit data with given test data)
    0 tests skipped

EDB Postgres AS 9.4:

    8 tests passed
    2 tests failed:
        CheckForViewDataTest (Validate Insert, Update operations in View/Edit data with given test data)
        QueryToolJourneyTest (Tests the path through the query tool)
    0 tests skipped

EDB Postgres AS 9.5:

    9 tests passed
    1 test failed:
        CheckForViewDataTest (Validate Insert, Update operations in View/Edit data with given test data)
    0 tests skipped

EDB Postgres AS 9.6:

    9 tests passed
    1 test failed:
        CheckForViewDataTest (Validate Insert, Update operations in View/Edit data with given test data)
    0 tests skipped

EDB Postgres AS 9.2:

    8 tests passed
    2 tests failed:
        CheckDebuggerForXssFeatureTest (Tests to check if Debugger is vulnerable to XSS)
        CheckForViewDataTest (Validate Insert, Update operations in View/Edit data with given test data)
    0 tests skipped

EDB Postgres AS 9.3:

    8 tests passed
    2 tests failed:
        CheckForViewDataTest (Validate Insert, Update operations in View/Edit data with given test data)
        QueryToolJourneyTest (Tests the path through the query tool)
    0 tests skipped

======================================================================

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

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-leaked-file-descriptors for
moreinformation 
Build step 'Execute shell' marked build as failure
Not sending mail to unregistered user akshay.joshi@enterprisedb.com