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 azure #2016

Closed ericvergnaud closed 2 days ago

ericvergnaud commented 2 days ago

Changes

whitelist azure

Linked issues

Progresses #1901

Functionality

None

Tests

github-actions[bot] commented 2 days ago

❌ 78/81 passed, 3 failed, 18 skipped, 4h57m56s total

❌ test_table_migration_job_refreshes_migration_status[hiveserde-migrate-external-tables-ctas]: TimeoutError: Timed out after 0:05:00 (18m11.779s) ``` TimeoutError: Timed out after 0:05:00 16:52 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/z6tv 16:53 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6 16:53 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_ycet6', metastore_id=None, name='hiveserde_in_place_ycet6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:53 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6 16:53 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ycet6.parquet_serde_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6/parquet_serde_ycet6 16:53 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_ycet6.parquet_serde_ycet6', metastore_id=None, name='parquet_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/parquet_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:53 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ycet6.orc_serde_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6/orc_serde_ycet6 16:53 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_ycet6.orc_serde_ycet6', metastore_id=None, name='orc_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/orc_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:54 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ycet6.avro_serde_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6/avro_serde_ycet6 16:54 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_ycet6.avro_serde_ycet6', metastore_id=None, name='avro_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/avro_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:54 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719939268247, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqtxs', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cqtxs', 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=1719939268247, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 16:54 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cqtxs.hiveserde_in_place_ycet6: https://DATABRICKS_HOST/explore/data/ucx_cqtxs/hiveserde_in_place_ycet6 16:54 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cqtxs', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqtxs.hiveserde_in_place_ycet6', metastore_id=None, name='hiveserde_in_place_ycet6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:55 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_seysv: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_seysv 16:55 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_seysv', metastore_id=None, name='ucx_seysv', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw3] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 16:52 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/z6tv 16:53 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6 16:53 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_ycet6', metastore_id=None, name='hiveserde_in_place_ycet6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:53 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6 16:53 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ycet6.parquet_serde_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6/parquet_serde_ycet6 16:53 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_ycet6.parquet_serde_ycet6', metastore_id=None, name='parquet_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/parquet_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:53 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ycet6.orc_serde_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6/orc_serde_ycet6 16:53 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_ycet6.orc_serde_ycet6', metastore_id=None, name='orc_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/orc_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:54 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ycet6.avro_serde_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6/avro_serde_ycet6 16:54 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_ycet6.avro_serde_ycet6', metastore_id=None, name='avro_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/avro_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:54 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719939268247, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqtxs', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cqtxs', 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=1719939268247, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 16:54 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cqtxs.hiveserde_in_place_ycet6: https://DATABRICKS_HOST/explore/data/ucx_cqtxs/hiveserde_in_place_ycet6 16:54 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cqtxs', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqtxs.hiveserde_in_place_ycet6', metastore_id=None, name='hiveserde_in_place_ycet6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:55 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_seysv: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_seysv 16:55 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_seysv', metastore_id=None, name='ucx_seysv', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:58 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.e4Ad/config.yml) doesn't exist. 16:58 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 16:58 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:58 INFO [databricks.labs.ucx.install] Fetching installations... 16:59 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.e4Ad is corrupted. Skipping... 16:59 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 16:59 DEBUG [tests.integration.conftest] Waiting for clusters to start... 16:59 DEBUG [tests.integration.conftest] Waiting for clusters to start... 16:59 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+5720240702165911 16:59 INFO [databricks.labs.ucx.install] Creating ucx schemas... 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 17:03 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.e4Ad/README for the next steps. 17:03 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-tables-ctas job: https://DATABRICKS_HOST#job/766197198144681 16:52 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/z6tv 16:53 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6 16:53 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_ycet6', metastore_id=None, name='hiveserde_in_place_ycet6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:53 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6 16:53 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ycet6.parquet_serde_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6/parquet_serde_ycet6 16:53 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_ycet6.parquet_serde_ycet6', metastore_id=None, name='parquet_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/parquet_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:53 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ycet6.orc_serde_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6/orc_serde_ycet6 16:53 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_ycet6.orc_serde_ycet6', metastore_id=None, name='orc_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/orc_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:54 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ycet6.avro_serde_ycet6: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ycet6/avro_serde_ycet6 16:54 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_ycet6.avro_serde_ycet6', metastore_id=None, name='avro_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/avro_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 16:54 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719939268247, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqtxs', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cqtxs', 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=1719939268247, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 16:54 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cqtxs.hiveserde_in_place_ycet6: https://DATABRICKS_HOST/explore/data/ucx_cqtxs/hiveserde_in_place_ycet6 16:54 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cqtxs', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqtxs.hiveserde_in_place_ycet6', metastore_id=None, name='hiveserde_in_place_ycet6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:55 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_seysv: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_seysv 16:55 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_seysv', metastore_id=None, name='ucx_seysv', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 16:58 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.e4Ad/config.yml) doesn't exist. 16:58 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 16:58 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:58 INFO [databricks.labs.ucx.install] Fetching installations... 16:59 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.e4Ad is corrupted. Skipping... 16:59 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 16:59 DEBUG [tests.integration.conftest] Waiting for clusters to start... 16:59 DEBUG [tests.integration.conftest] Waiting for clusters to start... 16:59 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+5720240702165911 16:59 INFO [databricks.labs.ucx.install] Creating ucx schemas... 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 17:03 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 17:03 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.e4Ad/README for the next steps. 17:03 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-tables-ctas job: https://DATABRICKS_HOST#job/766197198144681 17:07 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_storage_dir fixtures 17:07 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6 17:07 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures 17:07 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/z6tv 17:07 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 cluster fixtures 17:07 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures 17:07 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719939268247, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqtxs', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cqtxs', 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=1719939268247, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 17:07 INFO [databricks.labs.ucx.install] Deleting UCX v0.27.2+5720240702165911 from https://DATABRICKS_HOST 17:07 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_seysv 17:08 INFO [databricks.labs.ucx.install] Deleting jobs 17:08 INFO [databricks.labs.ucx.install] Deleting assessment job_id=219977777443355. 17:08 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=849468392523838. 17:08 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=661883846861871. 17:08 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=49526929863342. 17:08 INFO [databricks.labs.ucx.install] Deleting migrate-tables-in-mounts-experimental job_id=314124836700435. 17:08 INFO [databricks.labs.ucx.install] Deleting failing job_id=792091640900855. 17:08 INFO [databricks.labs.ucx.install] Deleting experimental-workflow-linter job_id=489539873820000. 17:08 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=663157709680504. 17:08 INFO [databricks.labs.ucx.install] Deleting migrate-groups-experimental job_id=886261606819152. 17:08 INFO [databricks.labs.ucx.install] Deleting migrate-data-reconciliation job_id=1016139932849094. 17:08 INFO [databricks.labs.ucx.install] Deleting migrate-external-hiveserde-tables-in-place-experimental job_id=488709367760659. 17:08 INFO [databricks.labs.ucx.install] Deleting scan-tables-in-mounts-experimental job_id=1145352842919. 17:08 INFO [databricks.labs.ucx.install] Deleting migrate-external-tables-ctas job_id=766197198144681. 17:08 INFO [databricks.labs.ucx.install] Deleting cluster policy 17:08 INFO [databricks.labs.ucx.install] Deleting secret scope 17:08 INFO [databricks.labs.ucx.install] UnInstalling UCX complete 17:08 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace user fixtures 17:08 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 account group fixtures 17:08 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures 17:08 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 17:08 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 table fixtures 17:08 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_ycet6.parquet_serde_ycet6', metastore_id=None, name='parquet_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/parquet_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:08 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_ycet6.orc_serde_ycet6', metastore_id=None, name='orc_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/orc_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:09 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_ycet6.avro_serde_ycet6', metastore_id=None, name='avro_serde_ycet6', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='hiveserde_in_place_ycet6', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ycet6/avro_serde_ycet6', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:09 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures 17:09 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_ycet6', metastore_id=None, name='hiveserde_in_place_ycet6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:10 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cqtxs', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqtxs.hiveserde_in_place_ycet6', metastore_id=None, name='hiveserde_in_place_ycet6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:10 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_seysv', metastore_id=None, name='ucx_seysv', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw3] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python ```
❌ test_running_real_workflow_linter_job: TimeoutError: Timed out after 0:02:00 (9m26.238s) ``` TimeoutError: Timed out after 0:02:00 [gw0] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 17:14 DEBUG [databricks.labs.ucx.mixins.fixtures] added directory fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ruUR 17:14 DEBUG [databricks.labs.ucx.mixins.fixtures] added notebook fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ruUR/notebook.ipynb 17:14 INFO [databricks.labs.ucx.mixins.fixtures] Job: https://DATABRICKS_HOST#job/1022528928124355 17:14 DEBUG [databricks.labs.ucx.mixins.fixtures] added job fixture: CreateResponse(job_id=1022528928124355) 17:14 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_ssu0g: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_ssu0g 17:14 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_ssu0g', metastore_id=None, name='ucx_ssu0g', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:15 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.TxFN/config.yml) doesn't exist. 17:15 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 17:15 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. 17:15 INFO [databricks.labs.ucx.install] Fetching installations... 17:16 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 17:16 DEBUG [tests.integration.conftest] Waiting for clusters to start... 17:16 DEBUG [tests.integration.conftest] Waiting for clusters to start... 17:16 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+5720240702171608 17:16 INFO [databricks.labs.ucx.install] Creating ucx schemas... 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 17:18 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.TxFN/README for the next steps. 17:18 DEBUG [databricks.labs.ucx.installer.workflows] starting experimental-workflow-linter job: https://DATABRICKS_HOST#job/531934020903776 17:23 DEBUG [databricks.labs.ucx.installer.workflows] Validating experimental-workflow-linter workflow: https://DATABRICKS_HOST#job/531934020903776 17:14 DEBUG [databricks.labs.ucx.mixins.fixtures] added directory fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ruUR 17:14 DEBUG [databricks.labs.ucx.mixins.fixtures] added notebook fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ruUR/notebook.ipynb 17:14 INFO [databricks.labs.ucx.mixins.fixtures] Job: https://DATABRICKS_HOST#job/1022528928124355 17:14 DEBUG [databricks.labs.ucx.mixins.fixtures] added job fixture: CreateResponse(job_id=1022528928124355) 17:14 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_ssu0g: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_ssu0g 17:14 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_ssu0g', metastore_id=None, name='ucx_ssu0g', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:15 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.TxFN/config.yml) doesn't exist. 17:15 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 17:15 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. 17:15 INFO [databricks.labs.ucx.install] Fetching installations... 17:16 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 17:16 DEBUG [tests.integration.conftest] Waiting for clusters to start... 17:16 DEBUG [tests.integration.conftest] Waiting for clusters to start... 17:16 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+5720240702171608 17:16 INFO [databricks.labs.ucx.install] Creating ucx schemas... 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 17:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 17:18 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.TxFN/README for the next steps. 17:18 DEBUG [databricks.labs.ucx.installer.workflows] starting experimental-workflow-linter job: https://DATABRICKS_HOST#job/531934020903776 17:23 DEBUG [databricks.labs.ucx.installer.workflows] Validating experimental-workflow-linter workflow: https://DATABRICKS_HOST#job/531934020903776 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 job fixtures 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] removing job fixture: CreateResponse(job_id=1022528928124355) 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 directory fixtures 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] removing directory fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ruUR 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 notebook fixtures 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] removing notebook fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ruUR/notebook.ipynb 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while notebook /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ruUR/notebook.ipynb teardown: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ruUR/notebook.ipynb) doesn't exist. 17:23 INFO [databricks.labs.ucx.install] Deleting UCX v0.27.2+5720240702171608 from https://DATABRICKS_HOST 17:23 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_ssu0g 17:23 INFO [databricks.labs.ucx.install] Deleting jobs 17:23 INFO [databricks.labs.ucx.install] Deleting scan-tables-in-mounts-experimental job_id=946868918733142. 17:23 INFO [databricks.labs.ucx.install] Deleting migrate-data-reconciliation job_id=148299542033298. 17:23 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=328594073008796. 17:23 INFO [databricks.labs.ucx.install] Deleting migrate-tables-in-mounts-experimental job_id=849076170391310. 17:23 INFO [databricks.labs.ucx.install] Deleting assessment job_id=399676627324160. 17:23 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=454422387164976. 17:23 INFO [databricks.labs.ucx.install] Deleting migrate-external-hiveserde-tables-in-place-experimental job_id=139929658780786. 17:23 INFO [databricks.labs.ucx.install] Deleting experimental-workflow-linter job_id=531934020903776. 17:23 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=317082616137249. 17:23 INFO [databricks.labs.ucx.install] Deleting failing job_id=786295571236199. 17:23 INFO [databricks.labs.ucx.install] Deleting migrate-external-tables-ctas job_id=304708733526066. 17:23 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=766654394471933. 17:23 INFO [databricks.labs.ucx.install] Deleting migrate-groups-experimental job_id=364668179730663. 17:23 INFO [databricks.labs.ucx.install] Deleting cluster policy 17:23 INFO [databricks.labs.ucx.install] Deleting secret scope 17:23 INFO [databricks.labs.ucx.install] UnInstalling UCX complete 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace user fixtures 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 account group fixtures 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 17:23 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 schema fixtures 17:23 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_ssu0g', metastore_id=None, name='ucx_ssu0g', 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 ```
❌ test_table_migration_job_refreshes_migration_status[regular-migrate-tables]: TimeoutError: Timed out after 0:05:00 (12m8.718s) ``` TimeoutError: Timed out after 0:05:00 17:13 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/QJNg 17:13 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.migrate_2g1ii: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii 17:13 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.migrate_2g1ii', metastore_id=None, name='migrate_2g1ii', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:13 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tuztp: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tuztp 17:13 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tuztp', metastore_id=None, name='ucx_tuztp', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/migrate_2g1ii/ucx_tuztp', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:14 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tbo3g: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tbo3g 17:14 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tbo3g', metastore_id=None, name='ucx_tbo3g', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/tmp/ucx_test_bg4P', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:14 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tbgvj: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tbgvj 17:14 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tbgvj', metastore_id=None, name='ucx_tbgvj', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/QJNg', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:15 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_t6six: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_t6six 17:15 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.migrate_2g1ii.ucx_t6six', metastore_id=None, name='ucx_t6six', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.migrate_2g1ii.ucx_tuztp', view_dependencies=None) 17:15 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tn3wm: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tn3wm 17:15 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.migrate_2g1ii.ucx_tn3wm', metastore_id=None, name='ucx_tn3wm', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.migrate_2g1ii.ucx_t6six', view_dependencies=None) 17:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719940538933, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cfbg1', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cfbg1', 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=1719940538933, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 17:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cfbg1.migrate_2g1ii: https://DATABRICKS_HOST/explore/data/ucx_cfbg1/migrate_2g1ii 17:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cfbg1', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cfbg1.migrate_2g1ii', metastore_id=None, name='migrate_2g1ii', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:16 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sxaml: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sxaml 17:16 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_sxaml', metastore_id=None, name='ucx_sxaml', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw7] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 17:13 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/QJNg 17:13 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.migrate_2g1ii: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii 17:13 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.migrate_2g1ii', metastore_id=None, name='migrate_2g1ii', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:13 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tuztp: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tuztp 17:13 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tuztp', metastore_id=None, name='ucx_tuztp', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/migrate_2g1ii/ucx_tuztp', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:14 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tbo3g: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tbo3g 17:14 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tbo3g', metastore_id=None, name='ucx_tbo3g', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/tmp/ucx_test_bg4P', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:14 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tbgvj: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tbgvj 17:14 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tbgvj', metastore_id=None, name='ucx_tbgvj', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/QJNg', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:15 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_t6six: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_t6six 17:15 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.migrate_2g1ii.ucx_t6six', metastore_id=None, name='ucx_t6six', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.migrate_2g1ii.ucx_tuztp', view_dependencies=None) 17:15 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tn3wm: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tn3wm 17:15 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.migrate_2g1ii.ucx_tn3wm', metastore_id=None, name='ucx_tn3wm', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.migrate_2g1ii.ucx_t6six', view_dependencies=None) 17:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719940538933, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cfbg1', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cfbg1', 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=1719940538933, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 17:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cfbg1.migrate_2g1ii: https://DATABRICKS_HOST/explore/data/ucx_cfbg1/migrate_2g1ii 17:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cfbg1', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cfbg1.migrate_2g1ii', metastore_id=None, name='migrate_2g1ii', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:16 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sxaml: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sxaml 17:16 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_sxaml', metastore_id=None, name='ucx_sxaml', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:17 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.uaGL/config.yml) doesn't exist. 17:17 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 17:17 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. 17:17 INFO [databricks.labs.ucx.install] Fetching installations... 17:18 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.uaGL is corrupted. Skipping... 17:18 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 17:18 DEBUG [tests.integration.conftest] Waiting for clusters to start... 17:18 DEBUG [tests.integration.conftest] Waiting for clusters to start... 17:18 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+5720240702171833 17:18 INFO [databricks.labs.ucx.install] Creating ucx schemas... 17:19 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 17:20 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.uaGL/README for the next steps. 17:20 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-tables job: https://DATABRICKS_HOST#job/149182247783398 17:13 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/QJNg 17:13 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.migrate_2g1ii: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii 17:13 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.migrate_2g1ii', metastore_id=None, name='migrate_2g1ii', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:13 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tuztp: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tuztp 17:13 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tuztp', metastore_id=None, name='ucx_tuztp', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/migrate_2g1ii/ucx_tuztp', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:14 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tbo3g: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tbo3g 17:14 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tbo3g', metastore_id=None, name='ucx_tbo3g', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/tmp/ucx_test_bg4P', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:14 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tbgvj: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tbgvj 17:14 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tbgvj', metastore_id=None, name='ucx_tbgvj', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/QJNg', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:15 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_t6six: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_t6six 17:15 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.migrate_2g1ii.ucx_t6six', metastore_id=None, name='ucx_t6six', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.migrate_2g1ii.ucx_tuztp', view_dependencies=None) 17:15 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.migrate_2g1ii.ucx_tn3wm: https://DATABRICKS_HOST/explore/data/hive_metastore/migrate_2g1ii/ucx_tn3wm 17:15 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.migrate_2g1ii.ucx_tn3wm', metastore_id=None, name='ucx_tn3wm', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.migrate_2g1ii.ucx_t6six', view_dependencies=None) 17:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719940538933, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cfbg1', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cfbg1', 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=1719940538933, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 17:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cfbg1.migrate_2g1ii: https://DATABRICKS_HOST/explore/data/ucx_cfbg1/migrate_2g1ii 17:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cfbg1', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cfbg1.migrate_2g1ii', metastore_id=None, name='migrate_2g1ii', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:16 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sxaml: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sxaml 17:16 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_sxaml', metastore_id=None, name='ucx_sxaml', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:17 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.uaGL/config.yml) doesn't exist. 17:17 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 17:17 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. 17:17 INFO [databricks.labs.ucx.install] Fetching installations... 17:18 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.uaGL is corrupted. Skipping... 17:18 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 17:18 DEBUG [tests.integration.conftest] Waiting for clusters to start... 17:18 DEBUG [tests.integration.conftest] Waiting for clusters to start... 17:18 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+5720240702171833 17:18 INFO [databricks.labs.ucx.install] Creating ucx schemas... 17:19 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 17:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 17:20 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.uaGL/README for the next steps. 17:20 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-tables job: https://DATABRICKS_HOST#job/149182247783398 17:24 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 make_storage_dir fixtures 17:24 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures 17:24 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/QJNg 17:24 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 cluster fixtures 17:24 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures 17:24 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1719940538933, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cfbg1', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cfbg1', 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=1719940538933, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 17:24 INFO [databricks.labs.ucx.install] Deleting UCX v0.27.2+5720240702171833 from https://DATABRICKS_HOST 17:24 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_sxaml 17:24 INFO [databricks.labs.ucx.install] Deleting jobs 17:24 INFO [databricks.labs.ucx.install] Deleting migrate-groups-experimental job_id=1020780298110147. 17:24 INFO [databricks.labs.ucx.install] Deleting migrate-data-reconciliation job_id=568899153621786. 17:24 INFO [databricks.labs.ucx.install] Deleting scan-tables-in-mounts-experimental job_id=114739525218718. 17:24 INFO [databricks.labs.ucx.install] Deleting migrate-tables-in-mounts-experimental job_id=1011925886782145. 17:24 INFO [databricks.labs.ucx.install] Deleting assessment job_id=649475527370636. 17:24 INFO [databricks.labs.ucx.install] Deleting failing job_id=854045804989952. 17:24 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=604985868494189. 17:24 INFO [databricks.labs.ucx.install] Deleting migrate-external-hiveserde-tables-in-place-experimental job_id=654460553212051. 17:24 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=886987396366972. 17:24 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=825296434800404. 17:24 INFO [databricks.labs.ucx.install] Deleting experimental-workflow-linter job_id=742112851702990. 17:24 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=149182247783398. 17:24 INFO [databricks.labs.ucx.install] Deleting migrate-external-tables-ctas job_id=616103617719341. 17:24 INFO [databricks.labs.ucx.install] Deleting cluster policy 17:24 INFO [databricks.labs.ucx.install] Deleting secret scope 17:24 INFO [databricks.labs.ucx.install] UnInstalling UCX complete 17:24 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace user fixtures 17:24 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 account group fixtures 17:24 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures 17:24 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 17:24 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 5 table fixtures 17:24 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tuztp', metastore_id=None, name='ucx_tuztp', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/migrate_2g1ii/ucx_tuztp', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:24 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tbo3g', metastore_id=None, name='ucx_tbo3g', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/tmp/ucx_test_bg4P', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:24 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=, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.migrate_2g1ii.ucx_tbgvj', metastore_id=None, name='ucx_tbgvj', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/QJNg', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 17:24 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.migrate_2g1ii.ucx_t6six', metastore_id=None, name='ucx_t6six', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.migrate_2g1ii.ucx_tuztp', view_dependencies=None) 17:25 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.migrate_2g1ii.ucx_t6six', metastore_id=None, name='ucx_t6six', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.migrate_2g1ii.ucx_tuztp', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.migrate_2g1ii.ucx_t6six is a VIEW. Use DROP VIEW instead. SQLSTATE: 42809 17:25 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.migrate_2g1ii.ucx_tn3wm', metastore_id=None, name='ucx_tn3wm', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.migrate_2g1ii.ucx_t6six', view_dependencies=None) 17:25 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.migrate_2g1ii.ucx_tn3wm', metastore_id=None, name='ucx_tn3wm', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070218'}, row_filter=None, schema_name='migrate_2g1ii', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.migrate_2g1ii.ucx_t6six', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.migrate_2g1ii.ucx_tn3wm is a VIEW. Use DROP VIEW instead. SQLSTATE: 42809 17:25 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures 17:25 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.migrate_2g1ii', metastore_id=None, name='migrate_2g1ii', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:25 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cfbg1', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cfbg1.migrate_2g1ii', metastore_id=None, name='migrate_2g1ii', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 17:25 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_sxaml', metastore_id=None, name='ucx_sxaml', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw7] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python ```

Running from acceptance #4200