テーブルが作成されません

Question

rails db:migrate実行後

フォロー機能作成の為、rails db:migrateをコマンド入力をしたのですが、テーブルが作成されずエラーが発生してしまいました。
エラーの原因が調べてもよく分からず困っています。
見て頂けないでしょうか？

エラー

Running via Spring preloader in process 4973
== 20220928013253 CreateRelationships: migrating ==============================
-- create_table(:relationships)
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

Column `user_id` on table `relationships` does not match column `id` on `users`, which has type `bigint(20)`. To resolve this issue, change the type of the `user_id` column on `relationships` to be :bigint. (For example `t.bigint :user_id`).
Original message: Mysql2::Error: Cannot add foreign key constraint
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:148:in `_query'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:148:in `block in query'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:147:in `handle_interrupt'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:147:in `query'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:206:in `block (2 levels) in execute'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:205:in `block in execute'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_adapter.rb:696:in `block (2 levels) in log'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_adapter.rb:695:in `block in log'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_adapter.rb:687:in `log'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:204:in `execute'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/mysql/database_statements.rb:52:in `execute'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract/schema_statements.rb:322:in `create_table'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/mysql/schema_statements.rb:81:in `create_table'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:929:in `block in method_missing'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:897:in `block in say_with_time'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:897:in `say_with_time'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:918:in `method_missing'
/home/ubuntu/environment/tsunageru/db/migrate/20220928013253_create_relationships.rb:3:in `change'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:867:in `exec_migration'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:851:in `block (2 levels) in migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:850:in `block in migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:462:in `with_connection'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:849:in `migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1037:in `migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1329:in `block in execute_migration_in_transaction'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1382:in `ddl_transaction'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1328:in `execute_migration_in_transaction'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1302:in `each'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1302:in `migrate_without_lock'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1251:in `block in migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1401:in `block in with_advisory_lock'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1416:in `block in with_advisory_lock_connection'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:462:in `with_connection'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1416:in `with_advisory_lock_connection'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1397:in `with_advisory_lock'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1251:in `migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1086:in `up'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1061:in `migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/tasks/database_tasks.rb:237:in `migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/railties/databases.rake:92:in `block (3 levels) in <main>'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/railties/databases.rake:90:in `each'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/railties/databases.rake:90:in `block (2 levels) in <main>'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:10:in `block in fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:10:in `block in fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:8:in `fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:8:in `fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:27:in `fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:8:in `fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:27:in `fork'
<internal:/home/ubuntu/.rvm/rubies/ruby-3.0.0/lib/ruby/3.0.0/rubygems/core_ext/kernel_require.rb>:85:in `require'
<internal:/home/ubuntu/.rvm/rubies/ruby-3.0.0/lib/ruby/3.0.0/rubygems/core_ext/kernel_require.rb>:85:in `require'
-e:1:in `<main>'

Caused by:
ActiveRecord::MismatchedForeignKey: Column `user_id` on table `relationships` does not match column `id` on `users`, which has type `bigint(20)`. To resolve this issue, change the type of the `user_id` column on `relationships` to be :bigint. (For example `t.bigint :user_id`).
Original message: Mysql2::Error: Cannot add foreign key constraint
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:148:in `_query'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:148:in `block in query'
　　　　　　　　　　・
　　　　　　　　　　・
　　　　　　　　　　・

Caused by:
Mysql2::Error: Cannot add foreign key constraint
　　　　　・
　　　　　・
　　　　　・
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

マイグレーションファイル

class CreateRelationships < ActiveRecord::Migration[6.1]
  def change
    create_table :relationships do |t|
      t.references :user, null: false, foreign_key: true
      t.references :follow, null: false, foreign_key: true

      t.timestamps
      
      t.index [:user_id, :follow_id], unique: true
    end
  end
end

文字数制限で質問ができなかったため、重要だと思われる個所だけを残しました。
必要とされる個所は、追記したいと思います。

!追記
恐らく、user_idに関することだと思うのですが、カラムのデータ型に関して言っているのでしょうか？
0
!追記
＞マイグレーションファイルの作成順は、参照されるテーブルが先になっていますか？

参照されるテーブルというのはrelationshipsのことですか？

Comments

[退会済みユーザー]

エラー全文

Running via Spring preloader in process 4973
== 20220928013253 CreateRelationships: migrating ==============================
-- create_table(:relationships)
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

Column `user_id` on table `relationships` does not match column `id` on `users`, which has type `bigint(20)`. To resolve this issue, change the type of the `user_id` column on `relationships` to be :bigint. (For example `t.bigint :user_id`).
Original message: Mysql2::Error: Cannot add foreign key constraint
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:148:in `_query'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:148:in `block in query'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:147:in `handle_interrupt'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:147:in `query'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:206:in `block (2 levels) in execute'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:205:in `block in execute'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_adapter.rb:696:in `block (2 levels) in log'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_adapter.rb:695:in `block in log'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_adapter.rb:687:in `log'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:204:in `execute'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/mysql/database_statements.rb:52:in `execute'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract/schema_statements.rb:322:in `create_table'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/mysql/schema_statements.rb:81:in `create_table'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:929:in `block in method_missing'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:897:in `block in say_with_time'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:897:in `say_with_time'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:918:in `method_missing'
/home/ubuntu/environment/tsunageru/db/migrate/20220928013253_create_relationships.rb:3:in `change'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:867:in `exec_migration'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:851:in `block (2 levels) in migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:850:in `block in migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:462:in `with_connection'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:849:in `migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1037:in `migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1329:in `block in execute_migration_in_transaction'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1382:in `ddl_transaction'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1328:in `execute_migration_in_transaction'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1302:in `each'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1302:in `migrate_without_lock'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1251:in `block in migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1401:in `block in with_advisory_lock'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1416:in `block in with_advisory_lock_connection'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:462:in `with_connection'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1416:in `with_advisory_lock_connection'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1397:in `with_advisory_lock'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1251:in `migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1086:in `up'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/migration.rb:1061:in `migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/tasks/database_tasks.rb:237:in `migrate'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/railties/databases.rake:92:in `block (3 levels) in <main>'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/railties/databases.rake:90:in `each'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/railties/databases.rake:90:in `block (2 levels) in <main>'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:10:in `block in fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:10:in `block in fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:8:in `fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:8:in `fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:27:in `fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:8:in `fork'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/fork_tracker.rb:27:in `fork'
<internal:/home/ubuntu/.rvm/rubies/ruby-3.0.0/lib/ruby/3.0.0/rubygems/core_ext/kernel_require.rb>:85:in `require'
<internal:/home/ubuntu/.rvm/rubies/ruby-3.0.0/lib/ruby/3.0.0/rubygems/core_ext/kernel_require.rb>:85:in `require'
-e:1:in `<main>'

Caused by:
ActiveRecord::MismatchedForeignKey: Column `user_id` on table `relationships` does not match column `id` on `users`, which has type `bigint(20)`. To resolve this issue, change the type of the `user_id` column on `relationships` to be :bigint. (For example `t.bigint :user_id`).
Original message: Mysql2::Error: Cannot add foreign key constraint
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:148:in `_query'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:148:in `block in query'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:147:in `handle_interrupt'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:147:in `query'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:206:in `block (2 levels) in execute'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:205:in `block in execute'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/abstract_adapter.rb:696:in `block (2 levels) in log'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/home/ubuntu/.rvm/gems/ruby-3.0.0/gems/activesupport-6.1.7/lib/active_support/concurrency/loa

Answer 1

エラーが出たら、まずは翻訳、次に検索、そして質問する癖をつけたほうが良い気がします。

Column user_id on table relationships does not match column id on users, which has type bigint(20).

の検索結果の1位はこちらでした。
マイグレーションファイルの作成順は、参照されるテーブルが先になっていますか？
https://qiita.com/ken_sasaki2/items/84c257fc1a8ae964ddb9

Comments

[退会済みユーザー]

下記の状態なのですが、作成日時を修正後に一度、 down 20220928013253 Create relationships
を削除する必要がありますかそれとも、上書きできますか？
Status Migration ID Migration Name
--------------------------------------------------
up 20220926035148 Devise create users
up 20220927063833 Rename self inroduction column to users
up 20220927150407 Create plans
down 20220928013253 Create relationships

[no1knows]

> 対処法はマイグレーションファイルの作成日時を修正してあげれば解決できます。
> 添付画像の数字部分を、参照される側のテーブルよりも外部キーを使用するテーブルの数字を大きくすれば解決します。
記事をよく読んでみてください

[退会済みユーザー]

relationshipsマイグレーションファイルの作成日時を20220928013253→20220928313253に変更してrails db:migrateを実行したのですが、同じエラーが発生してしまいました。

Answer 2

Column `user_id` on table `relationships` does not match column `id` on `users`, which has type `bigint(20)`. 
To resolve this issue, change the type of the `user_id` column on `relationships` to be :bigint.
(For example `t.bigint :user_id`).

とあるように、定義を変えてください。
relationships が期待する 型 と実際の User.id の型が異なっているのが原因です

Comments

[退会済みユーザー]

t.bigint :user_idにマイグレーションファイルの記述を
変えてほしいと言っているのでしょうか？
調べるとuserはintegerの形が多いのですが、integerでもテーブルは作成されますでしょうか？

[退会済みユーザー]

下記のサイトのように type:でタイプ指定してもテーブル作成は可能ですか？
https://qiita.com/Jwataru/items/7b840be38d4279224245

[winterboum]

DB により、id につかう型が変わるようです。。。
詳しいことはわかりません。

type指定で行けるかもしれません、試していただければ。