After upgrade Migration fails

[saleheenkhan]

Hello,
Currently using Pay 2. & trying to upgrade to pay3 following this upgrade guide

Created the migrations

Trying to ran the migration

& getting the following error

ubuntu@ip-x-x-x-x:~/project$ rails db:migrate
Warning: the running version of Bundler (2.2.23) is older than the version that created the lockfile (2.2.25). We suggest you to upgrade to the version that created the lockfile by running `gem install bundler:2.2.25`.
== 20211011003831 CreatePayV3Models: migrating ================================
-- create_table(:pay_customers)
   -> 0.1173s
-- add_index(:pay_customers, [:owner_type, :owner_id, :deleted_at], {:name=>:customer_owner_processor_index})
   -> 0.0068s
-- add_index(:pay_customers, [:processor, :processor_id])
   -> 0.0038s
-- create_table(:pay_merchants)
   -> 0.0178s
-- add_index(:pay_merchants, [:owner_type, :owner_id, :processor])
   -> 0.0050s
-- create_table(:pay_payment_methods)
   -> 0.0243s
-- add_index(:pay_payment_methods, [:customer_id, :processor_id], {:unique=>true})
   -> 0.0058s
-- create_table(:pay_webhooks)
   -> 0.0117s
-- rename_column(:pay_charges, :pay_subscription_id, :subscription_id)
rails aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::UndefinedColumn: ERROR:  column "pay_subscription_id" does not exist
/home/ubuntu/visioun-dev/db/migrate/20211011003831_create_pay_v3_models.rb:49:in `change'
/home/ubuntu/visioun-dev/bin/rails:5:in `<top (required)>'
/home/ubuntu/visioun-dev/bin/spring:10:in `block in <top (required)>'
/home/ubuntu/visioun-dev/bin/spring:7:in `<top (required)>'

Caused by:
ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR:  column "pay_subscription_id" does not exist
/home/ubuntu/visioun-dev/db/migrate/20211011003831_create_pay_v3_models.rb:49:in `change'
/home/ubuntu/visioun-dev/bin/rails:5:in `<top (required)>'
/home/ubuntu/visioun-dev/bin/spring:10:in `block in <top (required)>'
/home/ubuntu/visioun-dev/bin/spring:7:in `<top (required)>'

Caused by:
PG::UndefinedColumn: ERROR:  column "pay_subscription_id" does not exist
/home/ubuntu/visioun-dev/db/migrate/20211011003831_create_pay_v3_models.rb:49:in `change'
/home/ubuntu/visioun-dev/bin/rails:5:in `<top (required)>'
/home/ubuntu/visioun-dev/bin/spring:10:in `block in <top (required)>'
/home/ubuntu/visioun-dev/bin/spring:7:in `<top (required)>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

Can anyone help me with this?

Thanks,
Saleheen

[excid3]

@saleheenkhan Looks like you may have missed a migration from v2 that creates the pay_subscription_id column. You can just modify the migration to fix it.

[saleheenkhan]

Thank you Chris for the hint.