Praefect migration to drop gitaly_ tables

As there was a rename of the tables in migrations after
migrations were applied all tables with old names are
still present on the envs.
New migration removes old tables with 'gitaly_' prefix
if they are still exist.

Closes: https://gitlab.com/gitlab-org/gitaly/-/issues/2796

1 files changed, 17 insertions, 0 deletions

diff --git a/internal/praefect/datastore/migrations/20200527103816_drop_old_gitaly_tables.go b/internal/praefect/datastore/migrations/20200527103816_drop_old_gitaly_tables.go
new file mode 100644
index 000000000..cc425087f
--- /dev/null
+++ b/internal/praefect/datastore/migrations/20200527103816_drop_old_gitaly_tables.go
@@ -0,0 +1,17 @@
+package migrations
+
+import migrate "github.com/rubenv/sql-migrate"
+
+func init() {
+	m := &migrate.Migration{
+		Id: "20200527103816_drop_old_gitaly_tables",
+		Up: []string{
+			`DROP TABLE IF EXISTS gitaly_replication_queue_job_lock CASCADE`,
+			`DROP TABLE IF EXISTS gitaly_replication_queue CASCADE`,
+			`DROP TABLE IF EXISTS gitaly_replication_queue_lock CASCADE`,
+		},
+		Down: []string{},
+	}
+
+	allMigrations = append(allMigrations, m)
+}