DB migrate from scratch is broken in test env

dzaporozhets:~/Projects/gitlab-development-kit/gitlab master 
→ be rake db:migrate:reset RAILS_ENV=test

....

== 20130218141258 ConvertClosedToStateInIssue: migrating ======================
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::UndefinedColumn: ERROR:  column issues.deleted_at does not exist
LINE 1: ..."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."...
                                                             ^
: UPDATE "issues" SET "state" = 'closed' WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."deleted_at" IS NULL AND "issues"."closed" = $1  ORDER BY "issues

Not sure if a case for dev env but still unacceptable

cc @rspeicher @DouweM

Title changed from Migration path is broken to DB migrate from scratch is broken in test env

The migration's from 2013, probably before we had rules about not using Rails models in migrations (for this exact reason).

mentioned in commit 47a539df

mentioned in merge request !3429 (merged)

Reassigned to @rspeicher

Status changed to closed by merge request !3429 (merged)

mentioned in commit 54957d69

This seems not only to happen in test env. I just tried to install GitLab via the .deb package from scratch and run into the same(?) issue. At least I get the same error message when the db migrations runs. Any pointers on how to solve the issue?

Update: Maybe ignore my comment, after I tried to reinstall GitLab after deleting the postgresql schema I do not get the error any more.

mentioned in issue #15113 (closed)

mentioned in issue #15210 (closed)

mentioned in issue omnibus-gitlab#1763 (closed)