Merge branch 'toon-replication-cleanup-queue-again-again' into 'master'

datastore: Clean completed & dead replication jobs

Closes #3665

See merge request gitlab-org/gitaly!4353

1 files changed, 17 insertions, 0 deletions

diff --git a/internal/praefect/datastore/migrations/20220215160117_replication_queue_cleanup_again.go b/internal/praefect/datastore/migrations/20220215160117_replication_queue_cleanup_again.go
new file mode 100644
index 000000000..b7fa8f885
--- /dev/null
+++ b/internal/praefect/datastore/migrations/20220215160117_replication_queue_cleanup_again.go
@@ -0,0 +1,17 @@
+package migrations
+
+import migrate "github.com/rubenv/sql-migrate"
+
+func init() {
+	m := &migrate.Migration{
+		Id: "20220215160117_replication_queue_cleanup_again",
+		Up: []string{
+			`DELETE FROM replication_queue WHERE state = ANY (ARRAY['dead'::REPLICATION_JOB_STATE, 'completed'::REPLICATION_JOB_STATE])`,
+		},
+		Down: []string{
+			// there is no way to restore deleted data
+		},
+	}
+
+	allMigrations = append(allMigrations, m)
+}