entryテーブルにplan_idをreferencesでカラム追加しようとしたらエラーで失敗し、おかしくなったので一度、entryテーブルを削除して、テーブルを再構築しようとしたのですがすでにありますと表示され、パニックになってしまい色々と検索した結果、schemaに残っているデータからテーブルをすべて再構築しなおしたら、entryテーブルも再構築されると思い実行したらすべてのテーブルがおかしくなったかもしれません。
完成に近づいていた中で、テーブルがめちゃくちゃになりとてもパニックです。
どうすればいいでしょうか?
mysqlで確認すると
+---------------------------------+ | ar_internal_metadata | | entries | | favorites | | messages | | plans | | relationships | | rooms | | schema_migrations | | users | +---------------------------------+ 9 rows in set (0.00 sec)
存在はするっぽいのですが、
リセットした際にエラーが発生しました。
```
Running via Spring preloader in process 9058
== 20220926035148 DeviseCreateUsers: migrating ================================
-- create_table(:users)
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: Table 'users' already exists
/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/20220926035148_devise_create_users.rb:5: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::StatementInvalid: Mysql2::Error: Table 'users' already exists
/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/li
質問は編集できます。
回答1件
あなたの回答
tips
プレビュー