Rails migration does not change schema.rb

Question

I have a rails migration that is not being applied to my schema.rb. The migration should create a table:

class CreateUserGraphs < ActiveRecord::Migration
  def change
    create_table :user_graphs do |t|
      t.string :name
      t.string :content
      t.integer :user_id
      t.string :type_id
      t.integer :upload_id

      t.timestamps
    end

    add_index :user_graphs, [:user_id, :created_at]
  end
end

I did db:reset. Then I tried rake db:migrate:up VERSION=123123123(this is the migration #). I am in my "dev" environment.

Why is the migration not affecting schema.rb?

Did you try to drop the database first? `rake db:drop db:create db:migrate` — Vucko, Dec 09 '13 at 07:04
Interesting that worked. How does `rake db:drop db:create` differ from `rake db:reset`? — Don P, Dec 09 '13 at 07:06
`rake db:reset` runs `db:create db:schema:load db:seed` without the migrations. I think that `db:migrate:reset` will suit your needs. — Vucko, Dec 09 '13 at 07:17
@Vucko, please add this suggestion as a valid answer to the question ;) — marzapower, Dec 09 '13 at 08:50

score 63 · Accepted Answer · answered Dec 09 '13 at 09:00

From the documentation:

The rake db:reset task will drop the database, recreate it and load the current schema into it.

This is not the same as running all the migrations. It will only use the contents of the current schema.rb file. If a migration can't be rolled back, 'rake db:reset' may not help you. To find out more about dumping the schema see 'schema dumping and you.'

So rake db:reset => db:drop db:create db:schema:load db:seed

To run all the migrations, use : rake db:drop db:create db:migrate

Or db:migrate:reset=> rake db:drop db:create db:migrate

Reference

score 3 · Answer 2 · answered Jun 08 '18 at 07:53

I had the same issue. I am working in development environment (with Passenger and Apache). Production and development environments use the same database.

When I run rake db:migrate, the db was changed, but the schema was not updated. Then I run rake db:migrate RAILS_ENV=development, and now the schema was updated.

Seems that rails/rake are confused about my environment. Passenger sets a development environment for this site, but rake aboutsays "Environment production".

score 1 · Answer 3 · answered Dec 09 '13 at 09:03

'Versions' of migrations are done via timestamps. Rails checks which migrations it needs to run by comparing the timestamp of the last run migration and seeing if there are any newer.

If the version of your new migration is 123123123, it will not be run as that number is not greater than the current timestamp (eg. 20131209170300).

score 1 · Answer 4 · answered Feb 07 '18 at 23:35

I had the same issue... it turns out it was because I edited the name of my migration file to look neater. Make sure you don't delete the time stamp in the migration file title like I did.

I deleted the migration file, the model, the controller, and associated tests and re-generated the controller and model which fixed the problem.

score 1 · Answer 5 · answered Jun 09 '18 at 11:46

First you try to down you migration

rake db:migrate:down VERSION=20180605141404 # "VERSION=20180605141404 your migration version"

And again up your migration

rake db:migrate:up VERSION=20180605141404 #"VERSION=20180605141404 your migration version"

score 0 · Answer 6 · answered Jan 28 '16 at 07:45

Found a way to obtain an error description. ran rake db:migrate:reset and received

`SQLite3::SQLException: Cannot add a NOT NULL column with default value NULL: ALTER TABLE "rooms" ADD "priority" integer NOT NULL/usr/local/rvm/gems/ruby-2.2.1/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:91:in `initialize`'

score 0 · Answer 7 · answered Jul 28 '22 at 13:34

0

Try stop Spring before run your migration. It works for me

bin/spring stop

answered Jul 28 '22 at 13:34

Jr.online

1
2

score 0 · Answer 8 · answered Dec 15 '22 at 12:03

0

In my case it was a config setting in config/application.rb:

config.active_record.dump_schema_after_migration = false

Changing it to true solved the problem.

answered Dec 15 '22 at 12:03

Alexander

1,072
1
5
9

Rails migration does not change schema.rb

8 Answers8

Linked