timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
16.82k stars 852 forks source link

Reduce drop_extension test flakiness #7022

Closed fabriziomello closed 3 weeks ago

fabriziomello commented 3 weeks ago

In this regression test we check the DROP SCHEMA public CASCADE; for removing the extension objects stored in that schema. The problem is if at the same moment we're running a background job it will lead to a deadlock because the scheduler maintain information about each execution in the metadata tables that should be part of the cascade schema removal.

Forced stop the background jobs and also terminate any running job.

https://github.com/timescale/timescaledb/actions/runs/9424506293/job/25964852620

Disable-check: force-changelog-file

codecov[bot] commented 3 weeks ago

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 81.75%. Comparing base (59f50f2) to head (31d7c7a). Report is 208 commits behind head on main.

Additional details and impacted files ```diff @@ Coverage Diff @@ ## main #7022 +/- ## ========================================== + Coverage 80.06% 81.75% +1.69% ========================================== Files 190 199 +9 Lines 37181 37019 -162 Branches 9450 9675 +225 ========================================== + Hits 29770 30266 +496 + Misses 2997 2860 -137 + Partials 4414 3893 -521 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.