AWSでデプロイすると「Tasks: TOP => db:migrate」のところでエラーが発生して、デプロイできない。

エラーコード

途中からのエラーを載せています。

terminal
1** DEPLOY FAILED
2** Refer to log/capistrano.log for details. Here are the last 20 lines:
3
4
5/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:771:in `migrate'
6
7/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:951:in `migrate'
8
9/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:1232:in `block in execute_migration_in_transaction'
10
11/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:1302:in `ddl_transaction'
12
13/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:1231:in `execute_migration_in_transaction'
14
15/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:1203:in `block in migrate_without_lock'
16
17/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:1202:in `each'
18
19/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:1202:in `migrate_without_lock'
20
21/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:1150:in `block in migrate'
22
23/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:1319:in `with_advisory_lock'
24
25/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:1150:in `migrate'
26
27/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:1006:in `up'
28
29/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/migration.rb:984:in `migrate'
30
31/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/tasks/database_tasks.rb:163:in `migrate'
32
33/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/activerecord-5.0.7.2/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
34
35/var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/rake-13.0.1/exe/rake:27:in `<top (required)>'
36
37/home/ec2-user/.rbenv/versions/2.5.1/bin/bundle:23:in `load'
38
39/home/ec2-user/.rbenv/versions/2.5.1/bin/bundle:23:in `<main>'
40
41 DEBUG [240c78b7]       Tasks: TOP => db:migrate
42
43 DEBUG [240c78b7]       (See full trace by running task with --trace)

デプロイのエラーが出たときの解決方法やエラー文でどこを読めばいいのかが、いまいち分かっていません。。
教えていただけると嬉しいです。

maisumakun

2020/06/24 01:09

log/capistrano.logの中身は確認してみましたか？

NakayaKousuke

2020/06/24 03:51

maisumakunさん、回答ありがとうございます！ log/capistrano.logの中身を、「Refer to log/capistrano.log for details. Here are the last 20 lines:」のエラー分で見てみました。下記のように書いてあり、itemsテーブルが存在していると書いてあります。 -------------------------------------------------------------------------- DEBUG [240c78b7] Caused by: DEBUG [240c78b7] Mysql2::Error: Table 'items' already exists DEBUG [240c78b7] /var/www/fleamarket_sample_72a/shared/bundle/ruby/2.5.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `_query' -------------------------------------------------------------------------- 仮説としては、私が以前、間違えてmasterブランチで「itemsテーブル」と「imagesテーブル」を作成して、そのあとに、ローカルブランチで「itemsテーブル」と「imagesテーブル」を一度削除して、また作り直して、 masterブランチにマージしてしまったことが原因じゃないかな？と思いました。。。この場合は、どのようにしたら良いのでしょうか？