Ok, I solved this and just adding info here for the record. For some reason my schema_info table had three identical version numbers. I just deleted all but one of these. Not sure how that happened as I looked through my command history and the error in question appeared after my first attempt to run $heroku run rake db:migrate. Anyway, an easy fix. N
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/eb2c4856-ce4b-40d8-b29a-bcbab6bf1c82%40googlegroups.com.
