search

databrickslabs / ucx

Your best companion for upgrading to Unity Catalog. UCX will guide you, the Databricks customer, through the process of upgrading your account, groups, workspaces, jobs etc. to Unity Catalog.
Other
193 stars 69 forks source link

whitelist omegaconf #1992

Closed ericvergnaud closed 2 days ago

ericvergnaud commented 2 days ago

Changes

whitelist omegaconf

Linked issues

Progresses #1901

Functionality

None

Tests

github-actions[bot] commented 2 days ago

❌ 77/79 passed, 2 failed, 18 skipped, 5h27m46s total

❌ test_spn_migration[True]: assert [] (1m29.505s) ``` assert [] 15:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_s8z7d: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s8z7d 15:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_s8z7d', metastore_id=None, name='ucx_s8z7d', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw6] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 15:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_s8z7d: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s8z7d 15:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_s8z7d', metastore_id=None, name='ucx_s8z7d', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 15:48 INFO [databricks.labs.ucx.CLOUD_ENV.credentials] Found 0 distinct service principals already used in UC storage credentials listed in include_names 15:48 INFO [databricks.labs.ucx.CLOUD_ENV.credentials] Service Principal name: testinfra_storageaccess_gtqayo, application_id: 9cbd8a1a-8169-4ff8-a929-f1e9572c090c, privilege READ_FILES on location TEST_MOUNT_CONTAINER/avoid_ext_loc_overlap 15:48 WARNING [databricks.labs.ucx.CLOUD_ENV.credentials] At least one Azure Service Principal accesses a storage account with non-Allow TEST_SCHEMA network configuration, which might cause connectivity issues. We recommend using Databricks Access Connectors instead 15:48 WARNING [databricks.labs.ucx.CLOUD_ENV.credentials] Service principal 'testinfra_storageaccess_gtqayo' accesses storage account 'TEST_MOUNT_CONTAINER/avoid_ext_loc_overlap' with non-Allow network configuration 15:48 INFO [databricks.labs.ucx.CLOUD_ENV.credentials] Completed migration from Azure Service Principal to UC Storage credentials and creation of UC Storage credentials for storage access with Databricks Access Connectors. Please check ~/mock/CLOUD_ENV_service_principal_migration_result.csv for validation results 15:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_s8z7d: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s8z7d 15:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_s8z7d', metastore_id=None, name='ucx_s8z7d', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 15:48 INFO [databricks.labs.ucx.CLOUD_ENV.credentials] Found 0 distinct service principals already used in UC storage credentials listed in include_names 15:48 INFO [databricks.labs.ucx.CLOUD_ENV.credentials] Service Principal name: testinfra_storageaccess_gtqayo, application_id: 9cbd8a1a-8169-4ff8-a929-f1e9572c090c, privilege READ_FILES on location TEST_MOUNT_CONTAINER/avoid_ext_loc_overlap 15:48 WARNING [databricks.labs.ucx.CLOUD_ENV.credentials] At least one Azure Service Principal accesses a storage account with non-Allow TEST_SCHEMA network configuration, which might cause connectivity issues. We recommend using Databricks Access Connectors instead 15:48 WARNING [databricks.labs.ucx.CLOUD_ENV.credentials] Service principal 'testinfra_storageaccess_gtqayo' accesses storage account 'TEST_MOUNT_CONTAINER/avoid_ext_loc_overlap' with non-Allow network configuration 15:48 INFO [databricks.labs.ucx.CLOUD_ENV.credentials] Completed migration from Azure Service Principal to UC Storage credentials and creation of UC Storage credentials for storage access with Databricks Access Connectors. Please check ~/mock/CLOUD_ENV_service_principal_migration_result.csv for validation results 15:48 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 schema fixtures 15:48 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_s8z7d', metastore_id=None, name='ucx_s8z7d', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw6] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python ```
❌ test_table_migration_job_refreshes_migration_status[hiveserde-migrate-external-tables-ctas]: TimeoutError: Timed out after 0:05:00 (21m10.055s) ``` TimeoutError: Timed out after 0:05:00 15:57 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/AK19 15:57 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt 15:57 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.hiveserde_in_place_6lpxt', metastore_id=None, name='hiveserde_in_place_6lpxt', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 15:57 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt 15:58 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_6lpxt.parquet_serde_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt/parquet_serde_6lpxt 15:58 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.parquet_serde_6lpxt', metastore_id=None, name='parquet_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/parquet_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 15:58 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_6lpxt.orc_serde_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt/orc_serde_6lpxt 15:58 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.orc_serde_6lpxt', metastore_id=None, name='orc_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/orc_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 15:59 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_6lpxt.avro_serde_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt/avro_serde_6lpxt 15:59 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.avro_serde_6lpxt', metastore_id=None, name='avro_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/avro_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 15:59 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719935979576, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coudz', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_coudz', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1719935979576, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 15:59 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_coudz.hiveserde_in_place_6lpxt: https://DATABRICKS_HOST/explore/data/ucx_coudz/hiveserde_in_place_6lpxt 15:59 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_coudz', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coudz.hiveserde_in_place_6lpxt', metastore_id=None, name='hiveserde_in_place_6lpxt', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:01 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_soqbu: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_soqbu 16:01 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_soqbu', metastore_id=None, name='ucx_soqbu', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw0] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 15:57 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/AK19 15:57 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt 15:57 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.hiveserde_in_place_6lpxt', metastore_id=None, name='hiveserde_in_place_6lpxt', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 15:57 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt 15:58 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_6lpxt.parquet_serde_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt/parquet_serde_6lpxt 15:58 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.parquet_serde_6lpxt', metastore_id=None, name='parquet_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/parquet_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 15:58 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_6lpxt.orc_serde_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt/orc_serde_6lpxt 15:58 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.orc_serde_6lpxt', metastore_id=None, name='orc_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/orc_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 15:59 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_6lpxt.avro_serde_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt/avro_serde_6lpxt 15:59 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.avro_serde_6lpxt', metastore_id=None, name='avro_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/avro_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 15:59 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719935979576, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coudz', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_coudz', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1719935979576, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 15:59 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_coudz.hiveserde_in_place_6lpxt: https://DATABRICKS_HOST/explore/data/ucx_coudz/hiveserde_in_place_6lpxt 15:59 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_coudz', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coudz.hiveserde_in_place_6lpxt', metastore_id=None, name='hiveserde_in_place_6lpxt', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:01 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_soqbu: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_soqbu 16:01 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_soqbu', metastore_id=None, name='ucx_soqbu', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:05 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.TYHD/config.yml) doesn't exist. 16:05 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 16:05 INFO [databricks.labs.ucx.installer.hms_lineage] HMS Lineage feature creates one system table named system.hms_to_uc_migration.table_access and helps in your migration process from HMS to UC by allowing you to programmatically query HMS lineage data. 16:05 INFO [databricks.labs.ucx.install] Fetching installations... 16:05 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.TYHD is corrupted. Skipping... 16:05 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 16:05 DEBUG [tests.integration.conftest] Waiting for clusters to start... 16:05 DEBUG [tests.integration.conftest] Waiting for clusters to start... 16:05 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+2820240702160546 16:05 INFO [databricks.labs.ucx.install] Creating ucx schemas... 16:09 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 16:09 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 16:09 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 16:10 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.TYHD/README for the next steps. 16:10 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-tables-ctas job: https://DATABRICKS_HOST#job/343549839206802 15:57 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/AK19 15:57 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt 15:57 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.hiveserde_in_place_6lpxt', metastore_id=None, name='hiveserde_in_place_6lpxt', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 15:57 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt 15:58 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_6lpxt.parquet_serde_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt/parquet_serde_6lpxt 15:58 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.parquet_serde_6lpxt', metastore_id=None, name='parquet_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/parquet_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 15:58 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_6lpxt.orc_serde_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt/orc_serde_6lpxt 15:58 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.orc_serde_6lpxt', metastore_id=None, name='orc_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/orc_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 15:59 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_6lpxt.avro_serde_6lpxt: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_6lpxt/avro_serde_6lpxt 15:59 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.avro_serde_6lpxt', metastore_id=None, name='avro_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/avro_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 15:59 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719935979576, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coudz', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_coudz', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1719935979576, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 15:59 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_coudz.hiveserde_in_place_6lpxt: https://DATABRICKS_HOST/explore/data/ucx_coudz/hiveserde_in_place_6lpxt 15:59 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_coudz', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coudz.hiveserde_in_place_6lpxt', metastore_id=None, name='hiveserde_in_place_6lpxt', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:01 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_soqbu: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_soqbu 16:01 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_soqbu', metastore_id=None, name='ucx_soqbu', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:05 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.TYHD/config.yml) doesn't exist. 16:05 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 16:05 INFO [databricks.labs.ucx.installer.hms_lineage] HMS Lineage feature creates one system table named system.hms_to_uc_migration.table_access and helps in your migration process from HMS to UC by allowing you to programmatically query HMS lineage data. 16:05 INFO [databricks.labs.ucx.install] Fetching installations... 16:05 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.TYHD is corrupted. Skipping... 16:05 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 16:05 DEBUG [tests.integration.conftest] Waiting for clusters to start... 16:05 DEBUG [tests.integration.conftest] Waiting for clusters to start... 16:05 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+2820240702160546 16:05 INFO [databricks.labs.ucx.install] Creating ucx schemas... 16:09 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 16:09 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 16:09 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 16:10 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 16:10 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.TYHD/README for the next steps. 16:10 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-tables-ctas job: https://DATABRICKS_HOST#job/343549839206802 16:14 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_storage_dir fixtures 16:14 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt 16:14 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures 16:14 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/AK19 16:14 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 cluster fixtures 16:14 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures 16:14 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719935979576, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coudz', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_coudz', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1719935979576, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 16:14 INFO [databricks.labs.ucx.install] Deleting UCX v0.27.2+2820240702160546 from https://DATABRICKS_HOST 16:14 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_soqbu 16:15 INFO [databricks.labs.ucx.install] Deleting jobs 16:15 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=318235280661675. 16:15 INFO [databricks.labs.ucx.install] Deleting migrate-external-hiveserde-tables-in-place-experimental job_id=376972014448835. 16:15 INFO [databricks.labs.ucx.install] Deleting migrate-tables-in-mounts-experimental job_id=256008054968256. 16:15 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=965123822716275. 16:15 INFO [databricks.labs.ucx.install] Deleting scan-tables-in-mounts-experimental job_id=826720948160964. 16:15 INFO [databricks.labs.ucx.install] Deleting migrate-data-reconciliation job_id=742512629074540. 16:15 INFO [databricks.labs.ucx.install] Deleting experimental-workflow-linter job_id=235724695472429. 16:15 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=1107187084040006. 16:15 INFO [databricks.labs.ucx.install] Deleting failing job_id=272884212711265. 16:15 INFO [databricks.labs.ucx.install] Deleting migrate-external-tables-ctas job_id=343549839206802. 16:15 INFO [databricks.labs.ucx.install] Deleting assessment job_id=921499933248688. 16:15 INFO [databricks.labs.ucx.install] Deleting migrate-groups-experimental job_id=685691262241984. 16:15 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=502563789395066. 16:15 INFO [databricks.labs.ucx.install] Deleting cluster policy 16:15 INFO [databricks.labs.ucx.install] Deleting secret scope 16:15 INFO [databricks.labs.ucx.install] UnInstalling UCX complete 16:15 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace user fixtures 16:15 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 account group fixtures 16:15 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures 16:15 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 16:15 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 table fixtures 16:15 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.parquet_serde_6lpxt', metastore_id=None, name='parquet_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/parquet_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:16 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.orc_serde_6lpxt', metastore_id=None, name='orc_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/orc_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:16 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_6lpxt.avro_serde_6lpxt', metastore_id=None, name='avro_serde_6lpxt', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070217'}, row_filter=None, schema_name='hiveserde_in_place_6lpxt', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_6lpxt/avro_serde_6lpxt', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:17 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures 16:17 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.hiveserde_in_place_6lpxt', metastore_id=None, name='hiveserde_in_place_6lpxt', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:17 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_coudz', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coudz.hiveserde_in_place_6lpxt', metastore_id=None, name='hiveserde_in_place_6lpxt', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:18 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_soqbu', metastore_id=None, name='ucx_soqbu', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw0] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python ```

Running from acceptance #4147