ci(windows): parallel pytest-xdist workers race on duck_conn.install_extension("ducklake") in test_duckdb.py #6182
Description
Description
In cicd-tests-windows (make fast-test running pytest -n auto), three tests in tests/core/engine_adapter/test_duckdb.py call duck_conn.install_extension("ducklake"):
test_ducklake_partitioning(test_duckdb.py:132)test_drop_table_ducklake_no_cascade(test_duckdb.py:164, added in fix(duckdb): do not cascade table/view drops in DuckLake catalogs #6034)test_drop_table_ducklake_no_cascade_mixed_case_alias(test_duckdb.py:195, added in fix(duckdb): do not cascade table/view drops in DuckLake catalogs #6034)
When pytest-xdist schedules these tests concurrently across workers (gw0 / gw1) on Windows, both workers download and move ducklake.duckdb_extension into the shared ~/.duckdb/extensions/ directory simultaneously, causing a Windows file-move lock error:
_duckdb.IOException: IO Error: Could not move file: Access is denied.
Example CI Failures
main(chore(db2): bump db2-sqlglot-dialect minimum to 1.1.0 #6170): https://github.com/SQLMesh/sqlmesh/actions/runs/41349768739/job/124977697623- PR Feat: Add Apache Doris engine adapter with OLAP and multi-catalog lakehouse support #6154: https://github.com/SQLMesh/sqlmesh/actions/runs/41350012195/job/124981396365
- PR Metrics: an aggregate nested in another expression (e.g. APPROX_QUANTILES(x, 2)[OFFSET(1)]) loses its alias in the rewrite #6169: https://github.com/SQLMesh/sqlmesh/actions/runs/41330108586/job/124918421447
Suggested Fix
Either mark the ducklake tests with @pytest.mark.isolated, group them onto a single xdist worker, or configure SET extension_directory = '<tmp_path>' / pre-install ducklake once before worker fan-out.
Activity