See <https://jenkins.pgadmin.org/job/pgadmin4-master-python26/483/display/redirect?page=changes>
Changes: [Dave Page] Ensure auto-indent honours the spaces/tabs config setting. Fixes #2780 [Dave Page] Fix name of 'check-constraints' to follow the usual singular convention. [Dave Page] Fix check constraint regression tests. [Dave Page] Update yarn lock file. [Dave Page] Show how the config/storage directory can be mounted on the host under ------------------------------------------ [...truncated 160.36 KB...] runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.check_constraint.tests.test_check_constraint_add.CheckConstraintAddTestCase) Add check constraint to table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.check_constraint.tests.test_check_constraint_delete.CheckConstraintDeleteTestCase) Delete check constraint to table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.check_constraint.tests.test_check_constraint_get.CheckConstraintGetTestCase) Fetch check constraint to table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.check_constraint.tests.test_check_constraint_put.CheckConstraintPutTestCase) Update check constraint to table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.foreign_key.tests.test_foreign_key_add.ForeignKeyAddTestCase) Add foreign Key constraint to table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.foreign_key.tests.test_foreign_key_delete.ForeignKeyDeleteTestCase) Delete foreign Key constraint. ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.foreign_key.tests.test_foreign_key_get.ForeignGetDeleteTestCase) Fetch foreign Key constraint. ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.foreign_key.tests.test_foreign_key_put.ForeignPutDeleteTestCase) Fetch foreign Key constraint. ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.index_constraint.tests.test_index_constraint_add.IndexConstraintAddTestCase) Add primary Key constraint to table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.index_constraint.tests.test_index_constraint_add.IndexConstraintAddTestCase) Add unique Key constraint to table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.index_constraint.tests.test_index_constraint_delete.IndexConstraintDeleteTestCase) Delete primary Key constraint of table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.index_constraint.tests.test_index_constraint_delete.IndexConstraintDeleteTestCase) Delete unique Key constraint of table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.index_constraint.tests.test_index_constraint_get.IndexConstraintGetTestCase) Fetch primary Key constraint of table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.index_constraint.tests.test_index_constraint_get.IndexConstraintGetTestCase) Fetch unique Key constraint of table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.index_constraint.tests.test_index_constraint_put.IndexConstraintUpdateTestCase) Update primary Key constraint of table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.index_constraint.tests.test_index_constraint_put.IndexConstraintUpdateTestCase) Update unique Key constraint of table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.indexes.tests.test_indexes_add.IndexesAddTestCase) Add index Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.indexes.tests.test_indexes_delete.IndexesDeleteTestCase) Delete index Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.indexes.tests.test_indexes_get.IndexesGetTestCase) Fetch index Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.indexes.tests.test_indexes_put.IndexesUpdateTestCase) Put index Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.rules.tests.test_rules_add.RulesAddTestCase) Add rule Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.rules.tests.test_rules_delete.RulesDeleteTestCase) Delete rule Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.rules.tests.test_rules_get.RulesGetTestCase) Fetch rule Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.rules.tests.test_rules_put.RulesUpdateTestCase) Put rule Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_column_acl_sql.TestColumnAclSql) Test Column ACL SQL file ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_column_properties_sql.TestColumnPropertiesSql) Test Column Properties SQL file ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_add.TableAddTestCase) Create Table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_add.TableAddTestCase) Create Range partitioned table with 2 partitions ... skipped 'Partitioned table are not supported by PPAS/PG 10.0 and below.' runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_add.TableAddTestCase) Create List partitioned table with 2 partitions ... skipped 'Partitioned table are not supported by PPAS/PG 10.0 and below.' runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_delete.TableDeleteTestCase) Delete Table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_get.TableGetTestCase) Fetch table Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_put.TableUpdateTestCase) Update Table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_put.TableUpdateTestCase) Create partitions of existing range partitioned table ... skipped 'Partitioned table are not supported by PPAS/PG 10.0 and below.' runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_put.TableUpdateTestCase) Create partitions of existing list partitioned table ... skipped 'Partitioned table are not supported by PPAS/PG 10.0 and below.' runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_put.TableUpdateTestCase) Detach partition from existing range partitioned table ... skipped 'Partitioned table are not supported by PPAS/PG 10.0 and below.' runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_put.TableUpdateTestCase) Detach partition from existing list partitioned table ... skipped 'Partitioned table are not supported by PPAS/PG 10.0 and below.' runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_put.TableUpdateTestCase) Attach partition to existing range partitioned table ... skipped 'Partitioned table are not supported by PPAS/PG 10.0 and below.' runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_table_put.TableUpdateTestCase) Attach partition to existing list partitioned table ... skipped 'Partitioned table are not supported by PPAS/PG 10.0 and below.' runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_tables_acl_sql.TestTablesAclSql) Test query returns the permissions when there are permissions set up on the table ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_tables_node_sql.TestTablesNodeSql) This scenario tests that all applicable sql template versions can fetch table names ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_tables_properties_sql.TestTablesPropertiesSql) This scenario tests that all applicable sql template versions can fetch some ddl ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_trigger_get_oid_sql.TestTriggerGetOidSql) Test Trigger to retrieve OID SQL file ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.tests.test_trigger_nodes_sql.TestTriggerNodesSql) Test Trigger Nodes SQL file ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.triggers.tests.test_triggers_add.TriggersAddTestCase) Add trigger Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.triggers.tests.test_triggers_delete.TriggersDeleteTestCase) Delete trigger Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.triggers.tests.test_triggers_get.TriggersGetTestCase) Fetch trigger Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tables.triggers.tests.test_triggers_put.TriggersUpdateTestCase) Put trigger Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tests.test_schema_add.SchemaAddTestCase) Check Schema Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tests.test_schema_delete.SchemaDeleteTestCase) Check Schema Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tests.test_schema_get.SchemaGetTestCase) Check Schema Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.tests.test_schema_put.SchemaPutTestCase) Check Schema Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.types.tests.test_types_add.TypesAddTestCase) Add type under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.types.tests.test_types_delete.TypesDeleteTestCase) Delete type under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.types.tests.test_types_get.TypesGetTestCase) Get type under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.types.tests.test_types_put.TypesUpdateTestCase) Update type under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.views.tests.test_views_add.ViewsAddTestCase) Add view under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.views.tests.test_views_add.ViewsAddTestCase) Add materialized view under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.views.tests.test_views_delete.ViewsDeleteTestCase) Delete view under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.views.tests.test_views_delete.ViewsDeleteTestCase) Delete materialized view under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.views.tests.test_views_get.ViewsGetTestCase) Get view under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.views.tests.test_views_get.ViewsGetTestCase) Get materialized view under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.views.tests.test_views_put.ViewsUpdateTestCase) Update view under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.schemas.views.tests.test_views_put.ViewsUpdateTestCase) Update materialized view under schema node ... ok runTest (pgadmin.browser.server_groups.servers.databases.tests.test_db_add.DatabaseAddTestCase) Check Databases Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.tests.test_db_delete.DatabaseDeleteTestCase) Check Databases Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.tests.test_db_get.DatabasesGetTestCase) Check Databases Node URL ... ok runTest (pgadmin.browser.server_groups.servers.databases.tests.test_db_put.DatabasesUpdateTestCase) Check Databases Node ... ok runTest (pgadmin.browser.server_groups.servers.resource_groups.tests.test_resource_groups_add.ResourceGroupsAddTestCase) Add resource groups ... skipped 'Resource groups are not supported by PG.' runTest (pgadmin.browser.server_groups.servers.resource_groups.tests.test_resource_groups_delete.ResourceGroupsDeleteTestCase) Delete resource groups ... skipped 'Resource groups are not supported by PG.' runTest (pgadmin.browser.server_groups.servers.resource_groups.tests.test_resource_groups_put.ResourceGroupsPutTestCase) Put resource groups ... skipped 'Resource groups are not supported by PG.' runTest (pgadmin.browser.server_groups.servers.resource_groups.tests.tests_resource_groups_get.ResourceGroupsGetTestCase) Get resource groups ... skipped 'Resource groups are not supported by PG.' runTest (pgadmin.browser.server_groups.servers.roles.tests.test_role_add.LoginRoleAddTestCase) Check Role Node ... ok runTest (pgadmin.browser.server_groups.servers.roles.tests.test_role_delete.LoginRoleDeleteTestCase) Check Role Node ... ok runTest (pgadmin.browser.server_groups.servers.roles.tests.test_role_get.LoginRoleGetTestCase) Check Role Node ... ok runTest (pgadmin.browser.server_groups.servers.roles.tests.test_role_put.LoginRolePutTestCase) Check Role Node ... ok runTest (pgadmin.browser.server_groups.servers.tablespaces.tests.test_tbspc_add.TableSpaceAddTestCase) Check Tablespace Node ... ok runTest (pgadmin.browser.server_groups.servers.tablespaces.tests.test_tbspc_delete.TableSpaceDeleteTestCase) Check Tablespace Node ... ok runTest (pgadmin.browser.server_groups.servers.tablespaces.tests.test_tbspc_get.TablespaceGetTestCase) Check Tablespace Node ... ok runTest (pgadmin.browser.server_groups.servers.tablespaces.tests.test_tbspc_put.TableSpaceUpdateTestCase) Check Tablespace Node ... ok runTest (pgadmin.browser.server_groups.servers.tests.test_check_recovery.TestCheckRecovery) Test for check recovery ... ok runTest (pgadmin.browser.server_groups.servers.tests.test_check_ssl_connection.TestSSLConnection) Test for SSL connection ... skipped "Cannot run SSL connection check test with 'prefer' sslmode" runTest (pgadmin.browser.server_groups.servers.tests.test_dependencies_sql.TestDependenciesSql) Test dependencies SQL file ... ok runTest (pgadmin.browser.server_groups.servers.tests.test_dependents_sql.TestDependentsSql) Test dependencies SQL file ... ok runTest (pgadmin.browser.server_groups.servers.tests.test_role_dependencies_sql.TestRoleDependenciesSql) Test Role Dependencies SQL file ... ok runTest (pgadmin.browser.server_groups.servers.tests.test_server_add.ServersAddTestCase) Default Server Node url ... ok runTest (pgadmin.browser.server_groups.servers.tests.test_server_delete.ServerDeleteTestCase) Default Server Node url ... ok runTest (pgadmin.browser.server_groups.servers.tests.test_server_get.ServersGetTestCase) Default Server Node url ... ok runTest (pgadmin.browser.server_groups.servers.tests.test_server_put.ServerUpdateTestCase) Default Server Node url ... ok runTest (pgadmin.browser.server_groups.tests.test_sg_get.SgNodeTestCase) Check Server Group Node ... ok runTest (pgadmin.utils.javascript.tests.test_javascript_bundler.JavascriptBundlerTestCase) scenario name: JavascriptBundlerTestCase ... ok runTest (pgadmin.utils.tests.test_versioned_template_loader.TestVersionedTemplateLoader) Render a template when called ... ok runTest (pgadmin.utils.tests.test_versioned_template_loader.TestVersionedTemplateLoader) Render a version 9.1 template when it is present ... ok runTest (pgadmin.utils.tests.test_versioned_template_loader.TestVersionedTemplateLoader) Render a version 9.2 template when request for a higher version ... ok runTest (pgadmin.utils.tests.test_versioned_template_loader.TestVersionedTemplateLoader) Render default version when version 9.0 was requested and only 9.1 and 9.2 are present ... ok runTest (pgadmin.utils.tests.test_versioned_template_loader.TestVersionedTemplateLoader) Raise error when version is smaller than available templates ... ok runTest (pgadmin.utils.tests.test_versioned_template_loader.TestVersionedTemplateLoader) Render a version GPDB 5.0 template when it is present ... ok runTest (pgadmin.utils.tests.test_versioned_template_loader.TestVersionedTemplateLoader) Render a version GPDB 5.0 template when it is in default ... ok runTest (pgadmin.utils.tests.test_versioned_template_loader.TestVersionedTemplateLoader) Raise error when version is gpdb but template does not exist ... ok runTest (regression.python_test_utils.sql_template_test_base.SQLTemplateTestBase) parent test class ... ok ---------------------------------------------------------------------- Ran 175 tests in 21.162s OK (skipped=21) =============Running the test cases for 'PostgreSQL 10'============= Traceback (most recent call last): File "<https://jenkins.pgadmin.org/job/pgadmin4-master-python26/ws/web/regression/python_test_utils/test_utils.py";,> line 123, in create_database server['sslmode']) File "<https://jenkins.pgadmin.org/job/pgadmin4-master-python26/ws/web/regression/python_test_utils/test_utils.py";,> line 36, in get_db_connection sslmode=sslmode File "<https://jenkins.pgadmin.org/job/pgadmin4-master-python26/ws/pgadmin-venv/lib/python2.6/site-packages/psycopg2/__init__.py";,> line 130, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) OperationalError: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp//.s.PGSQL.5437"? NOTE: Configuring authentication for DESKTOP mode. pgAdmin 4 - Application Initialisation ====================================== Traceback (most recent call last): File "<https://jenkins.pgadmin.org/job/pgadmin4-master-python26/ws/web/regression/runtests.py";,> line 336, in <module> test_utils.create_parent_server_node(server) File "<https://jenkins.pgadmin.org/job/pgadmin4-master-python26/ws/web/regression/python_test_utils/test_utils.py";,> line 453, in create_parent_server_node server_info['sslmode']) File "<https://jenkins.pgadmin.org/job/pgadmin4-master-python26/ws/web/regression/python_test_utils/test_utils.py";,> line 36, in get_db_connection sslmode=sslmode File "<https://jenkins.pgadmin.org/job/pgadmin4-master-python26/ws/pgadmin-venv/lib/python2.6/site-packages/psycopg2/__init__.py";,> line 130, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp//.s.PGSQL.5437"? Traceback (most recent call last): File "<https://jenkins.pgadmin.org/job/pgadmin4-master-python26/ws/web/regression/python_test_utils/test_utils.py";,> line 572, in _cleanup connection = get_db_server(database["server_id"]) File "<https://jenkins.pgadmin.org/job/pgadmin4-master-python26/ws/web/regression/python_test_utils/test_utils.py";,> line 547, in get_db_server ssl_mode) File "<https://jenkins.pgadmin.org/job/pgadmin4-master-python26/ws/web/regression/python_test_utils/test_utils.py";,> line 36, in get_db_connection sslmode=sslmode File "<https://jenkins.pgadmin.org/job/pgadmin4-master-python26/ws/pgadmin-venv/lib/python2.6/site-packages/psycopg2/__init__.py";,> line 130, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) OperationalError: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp//.s.PGSQL.5437"? ERROR: Error detected when running the Python tests. ERROR: Error detected when running the Python tests. Build step 'Execute shell' marked build as failure
