I think I've figured out what I did wrong. I pushed up the new version of the app to Heroku servers before I migrated the db back to version 28. When I tried that, the migration files that the server was using to roll back were not the it needed to successfully bring the db to the earlier state.
Confusing and obviously not the right way to do this (which I'm learning the hard way). Anyway, I'll try this new approach tomorrow and see if I can report this problem as solved. On Sunday, April 19, 2020 at 3:02:35 PM UTC-7, Nick Appelmans wrote: > > Hello Sequel-talk: > I am not sure how to trouble shoot this error. I have a Sinatra app that I > made some changes to on my development box by 1) rolling the migrations > back to a specific migration, making the changes to the subsequent > migrations and then running the migrations forward to the most recent. On > Heroku however, I cannot run heroku run rake db:migrate -a w7lt without > getting the Migrator::Error: More than 1 row in migrator table. > Also, trying the same sequence of steps 1) first running rake > db:migrate[28] on that server gives me the same error trace (shown below). > There's little to no info on the web concerning this error. I don't know if > I'd have to walk back my git versions until I can get something working > again or what the approach should be. > > I'm not sure what additional info you guys need to help. I've included my > gemfile below the trace. > Thanks a whole lot for any help/insight you can provide. > Nick > > > $ heroku run rake db:migrate[28] -a myHerokuApp > Running rake db:migrate[28] on ⬢ myHerokuApp... up, run.4420 (Free) > Migrating to version 28 > rake aborted! > Sequel::Migrator::Error: More than 1 row in migrator table > /app/vendor/bundle/ruby/2.4.0/gems/sequel-5.5.0/lib/sequel/extensions/migration.rb:625:in > > `schema_dataset' > /app/vendor/bundle/ruby/2.4.0/gems/sequel-5.5.0/lib/sequel/extensions/migration.rb:450:in > > `initialize' > /app/vendor/bundle/ruby/2.4.0/gems/sequel-5.5.0/lib/sequel/extensions/migration.rb:517:in > > `initialize' > /app/vendor/bundle/ruby/2.4.0/gems/sequel-5.5.0/lib/sequel/extensions/migration.rb:398:in > > `new' > /app/vendor/bundle/ruby/2.4.0/gems/sequel-5.5.0/lib/sequel/extensions/migration.rb:398:in > > `run' > /app/Rakefile:9:in `block (2 levels) in <top (required)>' > /app/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/exe/rake:27:in `<top > (required)>' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:74:in > > `load' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:74:in > > `kernel_load' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:28:in > > `run' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/lib/bundler/cli.rb:465:in > `exec' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/command.rb:27:in > > `run' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in > > `invoke_command' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor.rb:387:in > > `dispatch' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/lib/bundler/cli.rb:27:in > `dispatch' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/base.rb:466:in > > `start' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/lib/bundler/cli.rb:18:in > `start' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/exe/bundle:30:in `block > in <top (required)>' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/lib/bundler/friendly_errors.rb:124:in > > `with_friendly_errors' > /app/vendor/bundle/ruby/2.4.0/gems/bundler-2.0.2/exe/bundle:22:in `<top > (required)>' > /app/vendor/bundle/bin/bundle:104:in `load' > /app/vendor/bundle/bin/bundle:104:in `<main>' > Tasks: TOP => db:migrate > > GemFile > ruby '2.4.1' > gem 'puma', '3.11.2' > gem 'rake', '12.3.0' > gem 'rspec', '3.7.0' > gem 'coderay', '1.1.2' > gem 'rack-test', '0.8.2' > gem 'sinatra', '2.0.2' > gem 'sequel', '5.5.0' > #gem 'sqlite3', '1.3.13' > gem 'pg', '1.0.0' > gem 'bcrypt', '3.1.11' > gem "rspec_sequel_matchers", '0.4.0', group: :test > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/1d3bcc5f-e4f8-4ef9-96e2-74ab18758f95%40googlegroups.com.
