Add view and procedure to handle missing dimension slices

timescale / timescaledb-extras

Helper functions and procedures for timescale

Other

44 stars 16 forks source link

Add view and procedure to handle missing dimension slices #8

Closed mkindahl closed 3 years ago

mkindahl commented 3 years ago

Due to a bug in versions prior to 1.7.5, dimension slices could be removed when running insert and drop_chunks concurrently. This commit contain a script to re-construct such missing dimension slices as well as a view to show any missing slices and what hypertables and chunks they affect.

See timescale/timescaledb#1986

davidkohn88 commented 3 years ago

Chatted with @mkindahl and we decided that this didn't belong in this repo, we'd prefer that people perform the upgrade via the database and if they need it otherwise we can direct them to the commit in the DB project.