What to do if you cannot roll back the migration (UnknownMigrationVersionError)
Introduction
When I tried to roll back the migration file with rails db: rollback, I was suffering from the error UnknownMigrationVersionError as below, so I will write about this solution.
Terminal
rails aborted!
ActiveRecord::UnknownMigrationVersionError:
No migration with version number 20201230115014.
Details of UnknownMigrationVersionError
When I checked the status of the migration file with rails db: migrate, there was some unfamiliar data written as NO FILE. This was because the migration file was deleted on the VS code with the status up, so the data remained on the DB. (Probably the file I created by forgetting skip-migration when I created the model with ActiveHash \ ...) In summary, the cause of the UnknownMigrationVersionError was that the migration data, which did not have a corresponding file, remained.
Solutions
1. Create a migration file on VS code
First, create a file on the VS code that corresponds to the data whose ID is 20201230115014, which was NO FILE. (This time, it is created with the file name "20201230115014.dummy.rb".)
2. Bring the status down
If you try to roll back with just the migration file created, the following error will occur. This is because the contents of the migration file created earlier are not described.
Terminal
rails aborted!
NameError: uninitialized constant Dummy
To solve this, write the class and change action in the migration file. After that, perform migration once.
ruby:20201230115014.dummy.rb
class Dummy < ActiveRecord::Migration[6.0]
def change
end
end
Terminal
rails db:migrate
In this state, if you roll back, the status will be down safely.
3. Delete the target file
At this point, all you have to do is delete the target file. After deleting the file "20201230115014.dummy.rb" with VS code, if you check with rails db: migrate: status, you can confirm that the target data can be deleted safely.
At the end
I casually thought that deleting the migration file without checking the status would be troublesome later. I hope it will be a hint for those who see something.
reference
https://qiita.com/ISSO33/items/33a935cb3255c269bef2