Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DBR 16 and later support #3481

Open
wants to merge 5 commits into
base: main
Choose a base branch
from
Open

DBR 16 and later support #3481

wants to merge 5 commits into from

Conversation

asnare
Copy link
Contributor

@asnare asnare commented Jan 6, 2025

Changes

This PR adds DBR16 compatibility for the code that (optionally) converts HMS tables to external tables within the migrate-tables workflow.

Linked issues

Follows #3459
Resolves #3460

Functionality

  • modified existing workflow: migrate-tables

Tests

  • manually tested (for DBR16)
  • existing integration tests (for DBR15)
  • verified on staging environment (see screenshot below)

image

asnare added 2 commits January 6, 2025 15:39
Update the run/wait pattern in the rest of our tests so that we can set a breakpoint on the wait and watch the workflow run.
@asnare asnare added the tech debt chores and design flaws label Jan 6, 2025
@asnare asnare self-assigned this Jan 6, 2025
@asnare asnare requested a review from a team as a code owner January 6, 2025 15:25
Copy link
Member

@JCZuurmond JCZuurmond left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks for finding the source of this issue! If you can test it better, then that is appreciated

@JCZuurmond JCZuurmond changed the title Dbr16 support DBR 16 and later support Jan 6, 2025
@asnare asnare added the bug Something isn't working label Jan 6, 2025
Copy link

github-actions bot commented Jan 6, 2025

❌ 50/56 passed, 2 flaky, 6 failed, 4 skipped, 4h30m48s total

❌ test_table_migration_job_refreshes_migration_status[hiveserde-migrate-external-tables-ctas]: AssertionError: Workflow failed: assessment (21m27.286s)
... (skipped 3156 bytes)
cks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
14:50 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.XS7k/README for the next steps.
14:50 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
14:50 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/1083868987528137
14:50 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/1083868987528137/runs/1119521855033781
14:50 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/1083868987528137
14:50 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
14:50 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.XS7k/config.yml) doesn't exist.
14:50 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
14: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.
14:50 INFO [databricks.labs.ucx.install] Fetching installations...
14:50 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.XS7k is corrupted. Skipping...
14:50 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
14:50 DEBUG [tests.integration.conftest] Waiting for clusters to start...
14:50 DEBUG [tests.integration.conftest] Waiting for clusters to start...
14:50 INFO [databricks.labs.ucx.install] Installing UCX v0.53.2+1020250107145024
14:50 INFO [databricks.labs.ucx.install] Creating ucx schemas...
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-legacy
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migration-progress-experimental
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental
14:50 INFO [databricks.labs.ucx.install] Creating dashboards...
14:50 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
14:50 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
14:50 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
14:50 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.XS7k/README for the next steps.
14:50 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
14:50 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/1083868987528137
14:50 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/1083868987528137/runs/1119521855033781
14:50 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/1083868987528137
14:50 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:10 INFO [databricks.labs.ucx.install] Deleting UCX v0.53.2+1020250107145024 from https://DATABRICKS_HOST
15:10 INFO [databricks.labs.ucx.install] Deleting inventory database dummy_sfepz
15:10 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=39667884774024, as it is no longer needed
15:10 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=961590965971445, as it is no longer needed
15:10 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=22138439020199, as it is no longer needed
15:10 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=300590352090318, as it is no longer needed
15:10 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=457872162382869, as it is no longer needed
15:10 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=1064023958032036, as it is no longer needed
15:10 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=1083868987528137, as it is no longer needed
15:10 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=14672870075526, as it is no longer needed
15:10 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=830074551325763, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=165096298233422, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=114911844077899, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=254526023017374, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=175607459233050, as it is no longer needed
15:11 INFO [databricks.labs.ucx.install] Deleting cluster policy
15:11 INFO [databricks.labs.ucx.install] Deleting secret scope
15:11 INFO [databricks.labs.ucx.install] UnInstalling UCX complete
[gw7] linux -- Python 3.10.15 /home/runner/work/ucx/ucx/.venv/bin/python
❌ test_table_migration_job_refreshes_migration_status[regular-migrate-tables]: AssertionError: Workflow failed: assessment (21m33.62s)
... (skipped 3149 bytes)
databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
14:50 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.fRGU/README for the next steps.
14:50 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
14:50 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/144789328384904
14:50 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/144789328384904/runs/43179210368233
14:50 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/144789328384904
14:50 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
14:50 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.fRGU/config.yml) doesn't exist.
14:50 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
14: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.
14:50 INFO [databricks.labs.ucx.install] Fetching installations...
14:50 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.fRGU is corrupted. Skipping...
14:50 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
14:50 DEBUG [tests.integration.conftest] Waiting for clusters to start...
14:50 DEBUG [tests.integration.conftest] Waiting for clusters to start...
14:50 INFO [databricks.labs.ucx.install] Installing UCX v0.53.2+1020250107145036
14:50 INFO [databricks.labs.ucx.install] Creating ucx schemas...
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migration-progress-experimental
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-legacy
14:50 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
14:50 INFO [databricks.labs.ucx.install] Creating dashboards...
14:50 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
14:50 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
14:50 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
14:50 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
14:50 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:50 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.fRGU/README for the next steps.
14:50 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
14:50 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/144789328384904
14:50 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/144789328384904/runs/43179210368233
14:50 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/144789328384904
14:50 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:11 INFO [databricks.labs.ucx.install] Deleting UCX v0.53.2+1020250107145036 from https://DATABRICKS_HOST
15:11 INFO [databricks.labs.ucx.install] Deleting inventory database dummy_suniu
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=220652554145965, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=1019592536646165, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=560054011428026, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=144789328384904, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=121428304280911, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=973404245901305, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=327280470510160, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=733655079442564, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=360427268299506, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=1031494662934465, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=316435086232232, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=655774159598387, as it is no longer needed
15:11 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=495910634330428, as it is no longer needed
15:11 INFO [databricks.labs.ucx.install] Deleting cluster policy
15:11 INFO [databricks.labs.ucx.install] Deleting secret scope
15:11 INFO [databricks.labs.ucx.install] UnInstalling UCX complete
[gw8] linux -- Python 3.10.15 /home/runner/work/ucx/ucx/.venv/bin/python
❌ test_hiveserde_table_in_place_migration_job[migrate-external-tables-ctas]: AssertionError: Workflow failed: assessment (21m34.186s)
... (skipped 3522 bytes)
tabricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
14:51 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.3WQn/README for the next steps.
14:51 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
14:51 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/670102142505046
14:51 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/670102142505046/runs/795627605294009
14:51 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/670102142505046
14:51 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
14:51 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.3WQn/config.yml) doesn't exist.
14:51 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
14:51 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.
14:51 INFO [databricks.labs.ucx.install] Fetching installations...
14:51 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.3WQn is corrupted. Skipping...
14:51 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
14:51 DEBUG [tests.integration.conftest] Waiting for clusters to start...
14:51 DEBUG [tests.integration.conftest] Waiting for clusters to start...
14:51 INFO [databricks.labs.ucx.install] Installing UCX v0.53.2+1020250107145128
14:51 INFO [databricks.labs.ucx.install] Creating ucx schemas...
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migration-progress-experimental
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-legacy
14:51 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental
14:51 INFO [databricks.labs.ucx.install] Creating dashboards...
14:51 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
14:51 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
14:51 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
14:51 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
14:51 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:51 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.3WQn/README for the next steps.
14:51 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
14:51 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/670102142505046
14:51 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/670102142505046/runs/795627605294009
14:51 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/670102142505046
14:51 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:11 INFO [databricks.labs.ucx.install] Deleting UCX v0.53.2+1020250107145128 from https://DATABRICKS_HOST
15:11 INFO [databricks.labs.ucx.install] Deleting inventory database dummy_su02v
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=967061852582358, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=545053611549080, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=336867669029016, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=864117160266653, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=670102142505046, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=295656030763423, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=271535178801179, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=551745113209133, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=274795170062055, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=610633297762916, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=1116853805272475, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=146013185288881, as it is no longer needed
15:12 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=1071512605365177, as it is no longer needed
15:12 INFO [databricks.labs.ucx.install] Deleting cluster policy
15:12 INFO [databricks.labs.ucx.install] Deleting secret scope
15:12 INFO [databricks.labs.ucx.install] UnInstalling UCX complete
[gw1] linux -- Python 3.10.15 /home/runner/work/ucx/ucx/.venv/bin/python
❌ test_table_migration_job_publishes_remaining_tables: AssertionError: Workflow failed: assessment (23m35.99s)
... (skipped 3523 bytes)
abricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
14:58 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Uqjw/README for the next steps.
14:58 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
14:58 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/151215413485727
14:58 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/151215413485727/runs/284079982591760
14:58 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/151215413485727
14:58 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
14:56 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Uqjw/config.yml) doesn't exist.
14:56 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
14:57 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.
14:57 INFO [databricks.labs.ucx.install] Fetching installations...
14:58 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Uqjw is corrupted. Skipping...
14:58 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
14:58 DEBUG [tests.integration.conftest] Waiting for clusters to start...
14:58 DEBUG [tests.integration.conftest] Waiting for clusters to start...
14:58 INFO [databricks.labs.ucx.install] Installing UCX v0.53.2+1020250107145803
14:58 INFO [databricks.labs.ucx.install] Creating ucx schemas...
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-legacy
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migration-progress-experimental
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas
14:58 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental
14:58 INFO [databricks.labs.ucx.install] Creating dashboards...
14:58 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
14:58 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
14:58 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
14:58 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
14:58 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
14:58 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Uqjw/README for the next steps.
14:58 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
14:58 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/151215413485727
14:58 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/151215413485727/runs/284079982591760
14:58 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/151215413485727
14:58 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:18 INFO [databricks.labs.ucx.install] Deleting UCX v0.53.2+1020250107145803 from https://DATABRICKS_HOST
15:18 INFO [databricks.labs.ucx.install] Deleting inventory database dummy_sskry
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=151215413485727, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=846527783265925, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=261116264558948, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=1103775355343481, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=1115352994576838, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=602822743130099, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=720360596072322, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=886888523375129, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=726869664499848, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=1096900175790005, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=489418579502842, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=851640381805731, as it is no longer needed
15:18 INFO [databricks.labs.ucx.installer.workflows] Removing job_id=499027268945942, as it is no longer needed
15:18 INFO [databricks.labs.ucx.install] Deleting cluster policy
15:18 INFO [databricks.labs.ucx.install] Deleting secret scope
15:18 INFO [databricks.labs.ucx.install] UnInstalling UCX complete
[gw3] linux -- Python 3.10.15 /home/runner/work/ucx/ucx/.venv/bin/python
❌ test_hiveserde_table_in_place_migration_job[migrate-external-hiveserde-tables-in-place-experimental]: AssertionError: Workflow failed: migrate-external-hiveserde-tables-in-place-experimental (24m36.528s)
... (skipped 3274 bytes)
2 INFO [databricks.labs.ucx.install] Creating dashboards...
15:12 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
15:12 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
15:12 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
15:12 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Xrpa/README for the next steps.
15:12 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
15:12 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/1121934601341599
15:12 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/1121934601341599/runs/568637429462628
15:12 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/1121934601341599
15:12 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:31 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-hiveserde-tables-in-place-experimental job: https://DATABRICKS_HOST#job/220498450411715
15:31 INFO [databricks.labs.ucx.installer.workflows] Started migrate-external-hiveserde-tables-in-place-experimental job: https://DATABRICKS_HOST#job/220498450411715/runs/837336879844561
15:31 DEBUG [databricks.labs.ucx.installer.workflows] Validating migrate-external-hiveserde-tables-in-place-experimental workflow: https://DATABRICKS_HOST#job/220498450411715
15:31 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:11 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Xrpa/config.yml) doesn't exist.
15:11 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
15:11 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.
15:11 INFO [databricks.labs.ucx.install] Fetching installations...
15:11 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Xrpa is corrupted. Skipping...
15:11 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
15:11 DEBUG [tests.integration.conftest] Waiting for clusters to start...
15:11 DEBUG [tests.integration.conftest] Waiting for clusters to start...
15:11 INFO [databricks.labs.ucx.install] Installing UCX v0.53.2+1020250107151157
15:11 INFO [databricks.labs.ucx.install] Creating ucx schemas...
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-legacy
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migration-progress-experimental
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental
15:12 INFO [databricks.labs.ucx.install] Creating dashboards...
15:12 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
15:12 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
15:12 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
15:12 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
15:12 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:12 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Xrpa/README for the next steps.
15:12 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
15:12 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/1121934601341599
15:12 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/1121934601341599/runs/568637429462628
15:12 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/1121934601341599
15:12 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:31 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-hiveserde-tables-in-place-experimental job: https://DATABRICKS_HOST#job/220498450411715
15:31 INFO [databricks.labs.ucx.installer.workflows] Started migrate-external-hiveserde-tables-in-place-experimental job: https://DATABRICKS_HOST#job/220498450411715/runs/837336879844561
15:31 DEBUG [databricks.labs.ucx.installer.workflows] Validating migrate-external-hiveserde-tables-in-place-experimental workflow: https://DATABRICKS_HOST#job/220498450411715
15:31 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:35 INFO [databricks.labs.ucx.install] Deleting UCX v0.53.2+1020250107151157 from https://DATABRICKS_HOST
15:35 ERROR [databricks.labs.ucx.install] Check if /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Xrpa is present
[gw7] linux -- Python 3.10.15 /home/runner/work/ucx/ucx/.venv/bin/python
❌ test_table_migration_convert_manged_to_external: AssertionError: assert False (24m40.489s)
... (skipped 2908 bytes)
al
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-legacy
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
15:13 INFO [databricks.labs.ucx.install] Creating dashboards...
15:13 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
15:13 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
15:13 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
15:13 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.xWzS/README for the next steps.
15:13 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
15:13 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/681587910698677
15:13 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/681587910698677/runs/342992669631551
15:13 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/681587910698677
15:13 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:31 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-tables job: https://DATABRICKS_HOST#job/458689307290674
15:31 INFO [databricks.labs.ucx.installer.workflows] Started migrate-tables job: https://DATABRICKS_HOST#job/458689307290674/runs/622751668843786
15:31 DEBUG [databricks.labs.ucx.installer.workflows] Validating migrate-tables workflow: https://DATABRICKS_HOST#job/458689307290674
15:31 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:12 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.xWzS/config.yml) doesn't exist.
15:12 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
15:12 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.
15:12 INFO [databricks.labs.ucx.install] Fetching installations...
15:12 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.xWzS is corrupted. Skipping...
15:12 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
15:12 DEBUG [tests.integration.conftest] Waiting for clusters to start...
15:12 DEBUG [tests.integration.conftest] Waiting for clusters to start...
15:12 INFO [databricks.labs.ucx.install] Installing UCX v0.53.2+1020250107151245
15:12 INFO [databricks.labs.ucx.install] Creating ucx schemas...
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migration-progress-experimental
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-legacy
15:12 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
15:13 INFO [databricks.labs.ucx.install] Creating dashboards...
15:13 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
15:13 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
15:13 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration...
15:13 DEBUG [databricks.labs.ucx.install] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/groups...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/migration/main...
15:13 INFO [databricks.labs.ucx.install] Creating dashboard in /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/progress/main...
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
15:13 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.xWzS/README for the next steps.
15:13 INFO [databricks.labs.ucx.progress.install] Installation completed successfully!
15:13 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/681587910698677
15:13 INFO [databricks.labs.ucx.installer.workflows] Started assessment job: https://DATABRICKS_HOST#job/681587910698677/runs/342992669631551
15:13 DEBUG [databricks.labs.ucx.installer.workflows] Validating assessment workflow: https://DATABRICKS_HOST#job/681587910698677
15:13 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:31 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-tables job: https://DATABRICKS_HOST#job/458689307290674
15:31 INFO [databricks.labs.ucx.installer.workflows] Started migrate-tables job: https://DATABRICKS_HOST#job/458689307290674/runs/622751668843786
15:31 DEBUG [databricks.labs.ucx.installer.workflows] Validating migrate-tables workflow: https://DATABRICKS_HOST#job/458689307290674
15:31 INFO [databricks.labs.ucx.installer.workflows] Identified a run in progress waiting for run completion
15:35 INFO [databricks.labs.ucx.install] Deleting UCX v0.53.2+1020250107151245 from https://DATABRICKS_HOST
15:35 ERROR [databricks.labs.ucx.install] Check if /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.xWzS is present
[gw8] linux -- Python 3.10.15 /home/runner/work/ucx/ucx/.venv/bin/python

Flaky tests:

  • 🤪 test_hiveserde_table_ctas_migration_job (21m18.604s)
  • 🤪 test_table_migration_job_refreshes_migration_status[hiveserde-migrate-external-hiveserde-tables-in-place-experimental] (21m24.89s)

Running from acceptance #7887

@asnare asnare requested a review from FastLee January 7, 2025 08:37
@@ -327,6 +323,8 @@ def _convert_hms_table_to_external(self, src_table: Table) -> bool:
old_table.schemaPreservesCase(),
old_table.ignoredProperties(),
old_table.viewOriginalText(),
# From DBR 16, there's a new table property: entityStorageLocations (Seq[EntityStorageLocation])
*([old_table.entityStorageLocations()] if hasattr(old_table, 'entityStorageLocations') else []),
Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@FastLee: I assume that this (new) property should be copied from the old table when doing this migration?

@asnare asnare requested a deployment to account-admin January 8, 2025 09:07 — with GitHub Actions In progress
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working tech debt chores and design flaws
Projects
Status: Ready for Review
Development

Successfully merging this pull request may close these issues.

[BUG]: CONVERT_TO_EXTERNAL table migration strategy does not work for Databricks runtime 16.0
2 participants