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
196 stars 70 forks source link

whitelist pyod #2061

Closed ericvergnaud closed 1 week ago

ericvergnaud commented 1 week ago

Changes

whitelist pyod

Linked issues

Progresses #1901

Functionality

None

Tests

github-actions[bot] commented 1 week ago

❌ 83/85 passed, 2 failed, 21 skipped, 4h45m0s total

❌ test_group: TimeoutError: Timed out after 0:00:30 (34.022s) ``` TimeoutError: Timed out after 0:00:30 [gw5] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 11:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-jp37dtmt@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-jp37dtmt@example.com')], entitlements=[], external_id=None, groups=[], id='2242058123467495', name=Name(family_name=None, given_name='sdk-jp37dtmt@example.com'), roles=[], schemas=[, ], user_name='sdk-jp37dtmt@example.com') 11:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-jp37dtmt@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-jp37dtmt@example.com')], entitlements=[], external_id=None, groups=[], id='2242058123467495', name=Name(family_name=None, given_name='sdk-jp37dtmt@example.com'), roles=[], schemas=[, ], user_name='sdk-jp37dtmt@example.com') 11:36 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 workspace user fixtures 11:36 DEBUG [databricks.labs.ucx.mixins.fixtures] removing workspace user fixture: User(active=True, display_name='sdk-jp37dtmt@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-jp37dtmt@example.com')], entitlements=[], external_id=None, groups=[], id='2242058123467495', name=Name(family_name=None, given_name='sdk-jp37dtmt@example.com'), roles=[], schemas=[, ], user_name='sdk-jp37dtmt@example.com') 11:36 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures [gw5] 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 (13m9.533s) ``` TimeoutError: Timed out after 0:05:00 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/ba3P 11:46 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p 11:46 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_qjp5p', metastore_id=None, name='hiveserde_in_place_qjp5p', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p 11:46 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_qjp5p.parquet_serde_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p/parquet_serde_qjp5p 11:46 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_qjp5p.parquet_serde_qjp5p', metastore_id=None, name='parquet_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/parquet_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_qjp5p.orc_serde_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p/orc_serde_qjp5p 11:47 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_qjp5p.orc_serde_qjp5p', metastore_id=None, name='orc_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/orc_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_qjp5p.avro_serde_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p/avro_serde_qjp5p 11:47 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_qjp5p.avro_serde_qjp5p', metastore_id=None, name='avro_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/avro_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720007270999, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coo4w', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_coo4w', 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=1720007270999, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_coo4w.hiveserde_in_place_qjp5p: https://DATABRICKS_HOST/explore/data/ucx_coo4w/hiveserde_in_place_qjp5p 11:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_coo4w', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coo4w.hiveserde_in_place_qjp5p', metastore_id=None, name='hiveserde_in_place_qjp5p', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sr1v6: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sr1v6 11:48 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_sr1v6', metastore_id=None, name='ucx_sr1v6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw1] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/ba3P 11:46 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p 11:46 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_qjp5p', metastore_id=None, name='hiveserde_in_place_qjp5p', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p 11:46 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_qjp5p.parquet_serde_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p/parquet_serde_qjp5p 11:46 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_qjp5p.parquet_serde_qjp5p', metastore_id=None, name='parquet_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/parquet_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_qjp5p.orc_serde_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p/orc_serde_qjp5p 11:47 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_qjp5p.orc_serde_qjp5p', metastore_id=None, name='orc_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/orc_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_qjp5p.avro_serde_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p/avro_serde_qjp5p 11:47 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_qjp5p.avro_serde_qjp5p', metastore_id=None, name='avro_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/avro_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720007270999, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coo4w', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_coo4w', 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=1720007270999, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_coo4w.hiveserde_in_place_qjp5p: https://DATABRICKS_HOST/explore/data/ucx_coo4w/hiveserde_in_place_qjp5p 11:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_coo4w', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coo4w.hiveserde_in_place_qjp5p', metastore_id=None, name='hiveserde_in_place_qjp5p', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sr1v6: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sr1v6 11:48 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_sr1v6', metastore_id=None, name='ucx_sr1v6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:50 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.8Kep/config.yml) doesn't exist. 11:50 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 11:50 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. 11:50 INFO [databricks.labs.ucx.install] Fetching installations... 11:50 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.8Kep is corrupted. Skipping... 11:50 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 11:50 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:50 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:50 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+7020240703115057 11:50 INFO [databricks.labs.ucx.install] Creating ucx schemas... 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 11:53 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.8Kep/README for the next steps. 11:53 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-tables-ctas job: https://DATABRICKS_HOST#job/678644330001435 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/ba3P 11:46 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p 11:46 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_qjp5p', metastore_id=None, name='hiveserde_in_place_qjp5p', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p 11:46 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_qjp5p.parquet_serde_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p/parquet_serde_qjp5p 11:46 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_qjp5p.parquet_serde_qjp5p', metastore_id=None, name='parquet_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/parquet_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_qjp5p.orc_serde_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p/orc_serde_qjp5p 11:47 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_qjp5p.orc_serde_qjp5p', metastore_id=None, name='orc_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/orc_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_qjp5p.avro_serde_qjp5p: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_qjp5p/avro_serde_qjp5p 11:47 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_qjp5p.avro_serde_qjp5p', metastore_id=None, name='avro_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/avro_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720007270999, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coo4w', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_coo4w', 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=1720007270999, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_coo4w.hiveserde_in_place_qjp5p: https://DATABRICKS_HOST/explore/data/ucx_coo4w/hiveserde_in_place_qjp5p 11:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_coo4w', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coo4w.hiveserde_in_place_qjp5p', metastore_id=None, name='hiveserde_in_place_qjp5p', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sr1v6: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sr1v6 11:48 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_sr1v6', metastore_id=None, name='ucx_sr1v6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:50 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.8Kep/config.yml) doesn't exist. 11:50 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 11:50 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. 11:50 INFO [databricks.labs.ucx.install] Fetching installations... 11:50 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.8Kep is corrupted. Skipping... 11:50 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 11:50 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:50 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:50 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+7020240703115057 11:50 INFO [databricks.labs.ucx.install] Creating ucx schemas... 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 11:53 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.8Kep/README for the next steps. 11:53 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-tables-ctas job: https://DATABRICKS_HOST#job/678644330001435 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_storage_dir fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/ba3P 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 cluster fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720007270999, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coo4w', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_coo4w', 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=1720007270999, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:57 INFO [databricks.labs.ucx.install] Deleting UCX v0.27.2+7020240703115057 from https://DATABRICKS_HOST 11:57 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_sr1v6 11:58 INFO [databricks.labs.ucx.install] Deleting jobs 11:58 INFO [databricks.labs.ucx.install] Deleting migrate-groups-experimental job_id=639314032314365. 11:58 INFO [databricks.labs.ucx.install] Deleting scan-tables-in-mounts-experimental job_id=600739259752221. 11:58 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=1049130842439977. 11:58 INFO [databricks.labs.ucx.install] Deleting experimental-workflow-linter job_id=648539580913470. 11:58 INFO [databricks.labs.ucx.install] Deleting migrate-external-hiveserde-tables-in-place-experimental job_id=1095996580847909. 11:58 INFO [databricks.labs.ucx.install] Deleting failing job_id=502570861201709. 11:58 INFO [databricks.labs.ucx.install] Deleting migrate-tables-in-mounts-experimental job_id=609193892667437. 11:58 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=897721909232467. 11:58 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=547997815802627. 11:58 INFO [databricks.labs.ucx.install] Deleting migrate-external-tables-ctas job_id=678644330001435. 11:58 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=822125816886606. 11:58 INFO [databricks.labs.ucx.install] Deleting assessment job_id=475134299384656. 11:58 INFO [databricks.labs.ucx.install] Deleting migrate-data-reconciliation job_id=683730436540588. 11:58 INFO [databricks.labs.ucx.install] Deleting cluster policy 11:58 INFO [databricks.labs.ucx.install] Deleting secret scope 11:58 INFO [databricks.labs.ucx.install] UnInstalling UCX complete 11:58 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace user fixtures 11:58 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 account group fixtures 11:58 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures 11:58 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 11:58 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 table fixtures 11:58 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_qjp5p.parquet_serde_qjp5p', metastore_id=None, name='parquet_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/parquet_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:58 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_qjp5p.orc_serde_qjp5p', metastore_id=None, name='orc_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/orc_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:58 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_qjp5p.avro_serde_qjp5p', metastore_id=None, name='avro_serde_qjp5p', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070313'}, row_filter=None, schema_name='hiveserde_in_place_qjp5p', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_qjp5p/avro_serde_qjp5p', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:58 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures 11:58 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_qjp5p', metastore_id=None, name='hiveserde_in_place_qjp5p', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:58 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_coo4w', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_coo4w.hiveserde_in_place_qjp5p', metastore_id=None, name='hiveserde_in_place_qjp5p', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:59 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_sr1v6', metastore_id=None, name='ucx_sr1v6', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw1] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python ```

Running from acceptance #4285