Getting: “Migrations are pending; run 'bin/rak

问题:

I cloned my project. Bundled with "bundle install", then run "rake db:migrate". I am getting this error: (when I run the rails server and open my browser to localhost:3000) "Migrations are pending; run 'bin/rake db:migrate RAILS_ENV=development' to resolve this issue."

I checked all migrations one by one and all were executed without errors. Also no errors were shown after the execution of "rake db:migrate".

This is what I see when I execute "rake db:migrate:status"

I am on development environment. Please let me know if you need any other information.

I also tried "bundle exec rake db:migrate", and "bundle exec rake db:migrate:reset" as "burninggramma" suggested.

Any clues what causes the error?

回答1:

Interesting. Did you run rake db:create? Assuming you are using sqlite3, do this:

      rm -f db/*.sqlite3
      rake db:create
      RAILS_ENV=development rake db:migrate
      rails s -e development

Also, can you list the contents of your config/database.yml file?

Edit: Warning! Obviously, you will lose your existing data.

回答2:

After running the migrate command, I still had the same error.

What worked for me was to just stop the rails server and start it again.

回答3:

List your executed migrations with rake db:migrate:status and look if every migration was executed. You can try to cancel your migration with rake db:abort_if_pending_migrations and try to migrate again.

回答4:

1. Maybe its default in ruby2/rails4 but have you tried: bundle exec rake db:migrate?

2. Another option would be resetting the whole database - use with CAUTION! resets all the data as well - bundle exec rake db:migrate:reset

+) I would just make sure that you are executing everything in the same development env:

RAILS_ENV=development bundle exec rake db:migrate:reset
RAILS_ENV=development bundle exec rails s

回答5:

Running rake db:migrate RAILS_ENV=test did it for me

回答6:

I had the same error in the browser, but upon closely looking at the error message, I noticed some how I had an extra white space in the migrate comment and post files. Once I removed it, it worked perfectly.

回答7:

Open the database and click schema_migration table. The migrations will be listed as below.

Sort the version column and find the latest migration you want to go back. Delete or Insert a new one. Rails keeps all the migration history in this table, so you can adjust the migration history to you liking.

回答8:

Here's what worked for me: -gem install rails -v 4.1.0 Inside Gemfile: -gem 'rails', '4.1.0' (replace the newer/older with this) Do bundle install and update -bundle install -bundle update In your application.rb : Remove/Comment - config.active_record.raise_in_transactional_callbacks = true

run bundle rake: -bundle exec rake db:migrate Refresh your page and the error should be gone.

回答9:

Two reasons 'db:migrate:reset' did not work for me

1) loosing data 
2) we moved from php to rails, so we had an existing DB and the migrations were written on top of it not from the scratch

So What I tried is to update the 'scheema_migrations'(mysql) table with the list of migrations(just version values) that I was really sure were already run on my db(development), this can be lil time consuming process but it works. I would not attempt this on production though.

回答10:

I'm guessing the error is that you are creating a table that already exists, I had this problem before. Step 1 look into the error when you rake dv:migrate

Step 2 go to the model where this table is created

Step 3 add drop_table :[YOUR TABLE] right before the create_table :[YOUR TABLE]

Step 2 run rake db:migrate

Step 3 remove the drop_table once the your migration is done

回答11:

I had this problem and it was because I had my rails files inside a folder named "[rails]". It seems rake doesn't like the following symbols "[]" used in a folder name.

Hope this helps others with this issue.

回答12:

I got the same error working on the Learn Enough to Be Dangerous Rails tutorial. I'm using Git Bash terminals on a Windows 10 machine. The error showed up in the terminal where I'm running guard, after I tried to migrate my db using the command (in another terminal):

$ bundle exec rake db: migrate:

After trying the solution offered by @lewstherin, I still got the same error. I tried the command:

$ rails test And got the explicit and helpful warning:

Migrations are pending. To resolve this issue, run:

bin/rails db:migrate RAILS_ENV=test

I ran the command:

$ bin/rails db:migrate RAILS_ENV=test

and now I'm working again.

回答13:

I had the same problem in genieacs and this code helped:

rake db:drop rake db:create rake db:schema:load RAILS_ENV=development
rake db:migrate rails s -e development

回答14:

You can always run rake db:reset

回答15:

When I executed rake test and met bug :

"rake aborted! ActiveRecord::PendingMigrationError: Migrations are pending. To resolve this issue, run: bin/rake db:migrate RAILS_ENV=test"

I tried and succeeded with:

rm -f db/*.sqlite3

rake db:create

RAILS_ENV=development rake db:migrate

rails s -e development