Test failure: test_permission_for_files_anonymous_func #4727
Description
❌ test_permission_for_files_anonymous_func: AssertionError: assert 'sdk-2CBwOKgg-ra78c29e38' in {} (14m40.874s)
AssertionError: assert 'sdk-2CBwOKgg-ra78c29e38' in {}
+ where 'sdk-2CBwOKgg-ra78c29e38' = Group(display_name='sdk-2CBwOKgg-ra78c29e38', entitlements=[], external_id=None, groups=[], id='2124786401016569', mem...[], schemas=[<GroupSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_CORE_2_0_GROUP: 'urn:ietf:params:scim:schemas:core:2.0:Group'>]).display_name
[gw3] linux -- Python 3.10.19 /home/runner/work/ucx/ucx/.venv/bin/python
06:03 DEBUG [tests.integration.workspace_access.test_tacl] old=sdk-2CBwOKgg-ra78c29e38, new=sdk-RztCwjcC-ra78c29e38
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.grants] fetching grants inventory
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] Inventory table not found
Traceback (most recent call last):
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/framework/crawlers.py", line 152, in _snapshot
cached_results = list(fetcher())
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/grants.py", line 239, in _try_fetch
for row in self._fetch(f"SELECT * FROM {escape_sql_identifier(self.full_name)}"):
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 344, in fetch_all
execute_response = self.execute(
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 268, in execute
self._raise_if_needed(status)
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 478, in _raise_if_needed
raise NotFound(error_message)
databricks.sdk.errors.platform.NotFound: [TABLE_OR_VIEW_NOT_FOUND] The table or view `hive_metastore`.`dummy_sjefdoj3n`.`grants` cannot be found. Verify the spelling and correctness of the schema and catalog.
If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog.
To tolerate the error on drop use DROP VIEW IF EXISTS or DROP TABLE IF EXISTS. SQLSTATE: 42P01; line 1 pos 14
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.grants] crawling new set of snapshot data for grants
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.tables] fetching tables inventory
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] Inventory table not found
Traceback (most recent call last):
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/framework/crawlers.py", line 152, in _snapshot
cached_results = list(fetcher())
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/tables.py", line 458, in _try_fetch
for row in self._fetch(f"SELECT * FROM {escape_sql_identifier(self.full_name)}"):
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 344, in fetch_all
execute_response = self.execute(
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 268, in execute
self._raise_if_needed(status)
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 478, in _raise_if_needed
raise NotFound(error_message)
databricks.sdk.errors.platform.NotFound: [TABLE_OR_VIEW_NOT_FOUND] The table or view `hive_metastore`.`dummy_sjefdoj3n`.`tables` cannot be found. Verify the spelling and correctness of the schema and catalog.
If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog.
To tolerate the error on drop use DROP VIEW IF EXISTS or DROP TABLE IF EXISTS. SQLSTATE: 42P01; line 1 pos 14
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.tables] crawling new set of snapshot data for tables
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] Skipping UCX inventory schema: dummy_sjefdoj3n
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_s0chd55et] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdh33rsar] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdruekgx4] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sfw9annwt] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sg6ncx8fg] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_srcgkwu5r] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_srhltnur0] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssnlpx934] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_suds6lkyg] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.hiveserde_in_place_vryxr] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.CLOUD_ENV_service_principals] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.clusters] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.code_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.directfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.directfs_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.directfs_in_queries] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.external_locations] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.global_init_scripts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.grant_detail] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.groups] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.inferred_grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.jobs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.lakeview_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.logs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.migration_status] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.misc_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.mounts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.permissions] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.pipelines] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.policies] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.query_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.recon_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.reconciliation_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.redash_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.submit_runs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.table_estimates] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.table_failures] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.table_size] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.udfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.used_tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.used_tables_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.used_tables_in_queries] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.workflow_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.workspace_objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sg6ncx8fg.grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sg6ncx8fg.migration_status] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sg6ncx8fg.tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sg6ncx8fg.udfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_srcgkwu5r.dummy_tp40lmoap] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.CLOUD_ENV_service_principals] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.clusters] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.code_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.directfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.directfs_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.directfs_in_queries] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.external_locations] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.global_init_scripts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.grant_detail] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.groups] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.inferred_grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.jobs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.lakeview_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.logs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.migration_status] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.misc_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.mounts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.permissions] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.pipelines] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.policies] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.query_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.recon_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.reconciliation_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.redash_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.submit_runs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.table_estimates] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.table_failures] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.table_size] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.udfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.used_tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.used_tables_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.used_tables_in_queries] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.workflow_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.workspace_objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_srhltnur0.dummy_tmynawu63] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_srhltnur0.dummy_ty0hod3nb] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdruekgx4.dummy_tjsakqsmp] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdruekgx4.dummy_tlt4b6kx0] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdruekgx4.dummy_tz0ypsjbt] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdruekgx4.view3] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssnlpx934.dummy_thcavc8ep] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdh33rsar.grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdh33rsar.tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdh33rsar.udfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.CLOUD_ENV_service_principals] fetching table metadata
06:03 WARNING [databricks.labs.ucx.hive_metastore.tables] Schema hive_metastore.dummy_srhltnur0 no longer existed
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.clusters] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.code_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.directfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.directfs_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.directfs_in_queries] fetching table metadata
06:03 WARNING [databricks.labs.ucx.hive_metastore.tables] Schema hive_metastore.dummy_srhltnur0 no longer existed
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.external_locations] fetching table metadata
06:03 WARNING [databricks.labs.ucx.hive_metastore.tables] Schema hive_metastore.dummy_ssnlpx934 no longer existed
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.global_init_scripts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.grant_detail] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.groups] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.inferred_grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.jobs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.lakeview_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.logs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.migration_status] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.misc_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.mounts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.permissions] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.pipelines] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.policies] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.query_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.recon_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.reconciliation_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.redash_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.submit_runs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.table_estimates] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.table_failures] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.table_size] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.udfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.used_tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.used_tables_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.used_tables_in_queries] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.workflow_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.workspace_objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.hiveserde_in_place_vryxr.avro_serde_vryxr] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.hiveserde_in_place_vryxr.orc_serde_vryxr] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.hiveserde_in_place_vryxr.parquet_serde_vryxr] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.aggregate_details] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.aggregate_metrics] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.aggregate_rules] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.analyzer_table] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.dqx_demo_simple_pk] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.main] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.morpheus_tsql_failures] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_s0chd55et.dummy_tzt00njha] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.tables] found 134 new records for tables
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.udfs] fetching udfs inventory
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] Inventory table not found
Traceback (most recent call last):
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/framework/crawlers.py", line 152, in _snapshot
cached_results = list(fetcher())
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/udfs.py", line 63, in _try_fetch
for row in self._fetch(f"SELECT * FROM {escape_sql_identifier(self.full_name)}"):
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 344, in fetch_all
execute_response = self.execute(
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 268, in execute
self._raise_if_needed(status)
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 478, in _raise_if_needed
raise NotFound(error_message)
databricks.sdk.errors.platform.NotFound: [TABLE_OR_VIEW_NOT_FOUND] The table or view `hive_metastore`.`dummy_sjefdoj3n`.`udfs` cannot be found. Verify the spelling and correctness of the schema and catalog.
If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog.
To tolerate the error on drop use DROP VIEW IF EXISTS or DROP TABLE IF EXISTS. SQLSTATE: 42P01; line 1 pos 14
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.udfs] crawling new set of snapshot data for udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.TEST_SCHEMA] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_s0chd55et] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_sdruekgx4] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_sfw9annwt] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_sg6ncx8fg] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_sjefdoj3n] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_sqarrnijl] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_srcgkwu5r] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_ss55xzbbk] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_ssmxashad] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.hiveserde_in_place_vryxr] listing udfs
06:04 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.udfs] found 0 new records for udfs
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_sdh33rsar no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_srhltnur0 no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_ssnlpx934 no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_suds6lkyg no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_sdh33rsar no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_sdh33rsar no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_sdh33rsar no longer existed
06:06 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.grants] found 147 new records for grants
06:18 ERROR [databricks.labs.ucx.hive_metastore.grants] Couldn't fetch grants for object ANY FILE : TEMPORARILY_UNAVAILABLE: The service at /api/2.0/sql-acl/get-permissions is taking too long to process your request. Please try again later or try a faster operation. [TraceId: 00-8505404863804277eefa31c7bdb2b08c-3626957e510ab2e5-00]
06:03 DEBUG [tests.integration.workspace_access.test_tacl] old=sdk-2CBwOKgg-ra78c29e38, new=sdk-RztCwjcC-ra78c29e38
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.grants] fetching grants inventory
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] Inventory table not found
Traceback (most recent call last):
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/framework/crawlers.py", line 152, in _snapshot
cached_results = list(fetcher())
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/grants.py", line 239, in _try_fetch
for row in self._fetch(f"SELECT * FROM {escape_sql_identifier(self.full_name)}"):
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 344, in fetch_all
execute_response = self.execute(
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 268, in execute
self._raise_if_needed(status)
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 478, in _raise_if_needed
raise NotFound(error_message)
databricks.sdk.errors.platform.NotFound: [TABLE_OR_VIEW_NOT_FOUND] The table or view `hive_metastore`.`dummy_sjefdoj3n`.`grants` cannot be found. Verify the spelling and correctness of the schema and catalog.
If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog.
To tolerate the error on drop use DROP VIEW IF EXISTS or DROP TABLE IF EXISTS. SQLSTATE: 42P01; line 1 pos 14
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.grants] crawling new set of snapshot data for grants
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.tables] fetching tables inventory
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] Inventory table not found
Traceback (most recent call last):
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/framework/crawlers.py", line 152, in _snapshot
cached_results = list(fetcher())
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/tables.py", line 458, in _try_fetch
for row in self._fetch(f"SELECT * FROM {escape_sql_identifier(self.full_name)}"):
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 344, in fetch_all
execute_response = self.execute(
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 268, in execute
self._raise_if_needed(status)
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 478, in _raise_if_needed
raise NotFound(error_message)
databricks.sdk.errors.platform.NotFound: [TABLE_OR_VIEW_NOT_FOUND] The table or view `hive_metastore`.`dummy_sjefdoj3n`.`tables` cannot be found. Verify the spelling and correctness of the schema and catalog.
If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog.
To tolerate the error on drop use DROP VIEW IF EXISTS or DROP TABLE IF EXISTS. SQLSTATE: 42P01; line 1 pos 14
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.tables] crawling new set of snapshot data for tables
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] Skipping UCX inventory schema: dummy_sjefdoj3n
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_s0chd55et] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdh33rsar] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdruekgx4] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sfw9annwt] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sg6ncx8fg] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_srcgkwu5r] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_srhltnur0] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssnlpx934] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_suds6lkyg] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.hiveserde_in_place_vryxr] listing tables and views
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.CLOUD_ENV_service_principals] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.clusters] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.code_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.directfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.directfs_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.directfs_in_queries] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.external_locations] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.global_init_scripts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.grant_detail] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.groups] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.inferred_grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.jobs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.lakeview_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.logs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.migration_status] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.misc_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.mounts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.permissions] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.pipelines] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.policies] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.query_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.recon_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.reconciliation_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.redash_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.submit_runs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.table_estimates] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.table_failures] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.table_size] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.udfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.used_tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.used_tables_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.used_tables_in_queries] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.workflow_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ss55xzbbk.workspace_objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sg6ncx8fg.grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sg6ncx8fg.migration_status] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sg6ncx8fg.tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sg6ncx8fg.udfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_srcgkwu5r.dummy_tp40lmoap] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.CLOUD_ENV_service_principals] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.clusters] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.code_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.directfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.directfs_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.directfs_in_queries] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.external_locations] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.global_init_scripts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.grant_detail] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.groups] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.inferred_grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.jobs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.lakeview_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.logs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.migration_status] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.misc_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.mounts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.permissions] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.pipelines] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.policies] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.query_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.recon_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.reconciliation_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.redash_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.submit_runs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.table_estimates] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.table_failures] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.table_size] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.udfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.used_tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.used_tables_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.used_tables_in_queries] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.workflow_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sqarrnijl.workspace_objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_srhltnur0.dummy_tmynawu63] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_srhltnur0.dummy_ty0hod3nb] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdruekgx4.dummy_tjsakqsmp] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdruekgx4.dummy_tlt4b6kx0] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdruekgx4.dummy_tz0ypsjbt] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdruekgx4.view3] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssnlpx934.dummy_thcavc8ep] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdh33rsar.grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdh33rsar.tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_sdh33rsar.udfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.CLOUD_ENV_service_principals] fetching table metadata
06:03 WARNING [databricks.labs.ucx.hive_metastore.tables] Schema hive_metastore.dummy_srhltnur0 no longer existed
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.clusters] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.code_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.directfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.directfs_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.directfs_in_queries] fetching table metadata
06:03 WARNING [databricks.labs.ucx.hive_metastore.tables] Schema hive_metastore.dummy_srhltnur0 no longer existed
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.external_locations] fetching table metadata
06:03 WARNING [databricks.labs.ucx.hive_metastore.tables] Schema hive_metastore.dummy_ssnlpx934 no longer existed
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.global_init_scripts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.grant_detail] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.groups] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.inferred_grants] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.jobs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.lakeview_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.logs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.migration_status] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.misc_patterns] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.mounts] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.permissions] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.pipelines] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.policies] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.query_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.recon_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.reconciliation_results] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.redash_dashboards] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.submit_runs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.table_estimates] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.table_failures] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.table_size] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.udfs] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.used_tables] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.used_tables_in_paths] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.used_tables_in_queries] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.workflow_problems] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_ssmxashad.workspace_objects] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.hiveserde_in_place_vryxr.avro_serde_vryxr] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.hiveserde_in_place_vryxr.orc_serde_vryxr] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.hiveserde_in_place_vryxr.parquet_serde_vryxr] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.aggregate_details] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.aggregate_metrics] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.aggregate_rules] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.analyzer_table] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.dqx_demo_simple_pk] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.main] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.TEST_SCHEMA.morpheus_tsql_failures] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.dummy_s0chd55et.dummy_tzt00njha] fetching table metadata
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.tables] found 134 new records for tables
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.udfs] fetching udfs inventory
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] Inventory table not found
Traceback (most recent call last):
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/framework/crawlers.py", line 152, in _snapshot
cached_results = list(fetcher())
File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/udfs.py", line 63, in _try_fetch
for row in self._fetch(f"SELECT * FROM {escape_sql_identifier(self.full_name)}"):
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 344, in fetch_all
execute_response = self.execute(
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 268, in execute
self._raise_if_needed(status)
File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 478, in _raise_if_needed
raise NotFound(error_message)
databricks.sdk.errors.platform.NotFound: [TABLE_OR_VIEW_NOT_FOUND] The table or view `hive_metastore`.`dummy_sjefdoj3n`.`udfs` cannot be found. Verify the spelling and correctness of the schema and catalog.
If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog.
To tolerate the error on drop use DROP VIEW IF EXISTS or DROP TABLE IF EXISTS. SQLSTATE: 42P01; line 1 pos 14
06:03 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.udfs] crawling new set of snapshot data for udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.TEST_SCHEMA] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_s0chd55et] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_sdruekgx4] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_sfw9annwt] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_sg6ncx8fg] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_sjefdoj3n] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_sqarrnijl] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_srcgkwu5r] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_ss55xzbbk] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.dummy_ssmxashad] listing udfs
06:04 DEBUG [databricks.labs.ucx.hive_metastore.udfs] [hive_metastore.hiveserde_in_place_vryxr] listing udfs
06:04 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.udfs] found 0 new records for udfs
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_sdh33rsar no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_srhltnur0 no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_ssnlpx934 no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_suds6lkyg no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_sdh33rsar no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_sdh33rsar no longer existed
06:04 WARNING [databricks.labs.ucx.hive_metastore.grants] Schema hive_metastore.dummy_sdh33rsar no longer existed
06:06 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.dummy_sjefdoj3n.grants] found 147 new records for grants
06:18 ERROR [databricks.labs.ucx.hive_metastore.grants] Couldn't fetch grants for object ANY FILE : TEMPORARILY_UNAVAILABLE: The service at /api/2.0/sql-acl/get-permissions is taking too long to process your request. Please try again later or try a faster operation. [TraceId: 00-8505404863804277eefa31c7bdb2b08c-3626957e510ab2e5-00]
[gw3] linux -- Python 3.10.19 /home/runner/work/ucx/ucx/.venv/bin/python
Running from nightly #774