Link: https://github.com/SQLMesh/sqlmesh/actions/runs/32076174970/job/95529820539
AI Notes
Failing test
tests/core/engine_adapter/integration/test_integration_postgres.py::test_grants_plan_clone_environment
What’s Wrong
The test uses a shared fixed Postgres user (test_reader). With parallel workers, another grants test can drop that user (DROP OWNED BY / DROP USER) mid-run. Grants on the physical table disappear ({}), or GRANT fails with role "test_reader" does not exist. Flaky test isolation, not a clone-grants product bug.
Possible Fix
In create_users in test_integration_postgres.py: give each run a unique username (e.g. test_reader_{random_id}) instead of a fixed test_reader.
Link: https://github.com/SQLMesh/sqlmesh/actions/runs/32076174970/job/95529820539
AI Notes
Failing test
tests/core/engine_adapter/integration/test_integration_postgres.py::test_grants_plan_clone_environmentWhat’s Wrong
The test uses a shared fixed Postgres user (test_reader). With parallel workers, another grants test can drop that user (DROP OWNED BY / DROP USER) mid-run. Grants on the physical table disappear ({}), or GRANT fails with role "test_reader" does not exist. Flaky test isolation, not a clone-grants product bug.
Possible Fix
In create_users in test_integration_postgres.py: give each run a unique username (e.g. test_reader_{random_id}) instead of a fixed test_reader.