Rails:Active_Adminが500エラーになる。

Question

前提・実現したいこと

ActiveAdminにページを追加しようとした所、５００エラーになり正常に動きません。
６時間ほど格闘していましたが、他のページは正常に動いているので何故だか分かりません。
なので知恵をお借りしたいです。
宜しくお願いいたします。

発生している問題・エラーメッセージ

Processing by Admin::ItemsController#index as HTML
  User Load (0.4ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 45 ORDER BY `users`.`id` ASC LIMIT 1
  竊ｳ app/controllers/application_controller.rb:21
  AdminUser Load (0.2ms)  SELECT  `admin_users`.* FROM `admin_users` WHERE `admin_users`.`id` = 1 ORDER BY `admin_users`.`id` ASC LIMIT 1
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  Rendering vendor/bundle/ruby/2.5.0/gems/activeadmin-2.7.0/app/views/active_admin/resource/index.html.arb
   (0.6ms)  SELECT COUNT(*) FROM (SELECT  1 AS one FROM `items` LIMIT 30 OFFSET 0) subquery_for_count
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE  (0.0ms)  SELECT COUNT(*) FROM (SELECT  1 AS one FROM `items` LIMIT 30 OFFSET 0) subquery_for_count
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
   (0.3ms)  SELECT COUNT(*) FROM `items`
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE  (0.0ms)  SELECT COUNT(*) FROM (SELECT  1 AS one FROM `items` LIMIT 30 OFFSET 0) subquery_for_count
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  Item Load (0.5ms)  SELECT  `items`.* FROM `items` ORDER BY `items`.`id` desc LIMIT 30 OFFSET 0
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  User Load (0.8ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  User Load (0.4ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 1 LIMIT 1
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 1 LIMIT 1  [["id", 1], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 1 LIMIT 1  [["id", 1], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 1 LIMIT 1  [["id", 1], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 1 LIMIT 1  [["id", 1], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  CACHE User Load (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1  [["id", 3], ["LIMIT", 1]]
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  User Load (0.7ms)  SELECT `users`.* FROM `users`
  竊ｳ vendor/bundle/ruby/2.5.0/bin/unicorn_rails:23
  Rendered vendor/bundle/ruby/2.5.0/gems/activeadmin-2.7.0/app/views/active_admin/resource/index.html.arb (228.4ms)
  Rendering errors/error_500.html within layouts/application
  Rendered errors/error_500.html within layouts/application (2.8ms)
  Rendered layouts/_header.html.slim (63.2ms)
  Rendered layouts/_footer.html.slim (11.0ms)
Completed 500 Internal Server Error in 354ms (Views: 94.4ms | ActiveRecord: 5.3ms)

該当のソースコードとコマンド

itemsモデルを作って以下のコマンドを実行。

rails generate active_admin:resource book

出来たソースコードと関係ありそうなソースコードは以下の通りです。

admin/items

ActiveAdmin.register Item do

  # See permitted parameters documentation:
  # https://github.com/activeadmin/activeadmin/blob/master/docs/2-resource-customization.md#setting-up-strong-parameters
  #
  # Uncomment all parameters which should be permitted for assignment
  #
  # permit_params :user_id, :name, :description, :price
  #
  # or
  #
  # permit_params do
  #   permitted = [:user_id, :name, :description, :price]
  #   permitted << :other if params[:action] == 'create' && current_user.admin?
  #   permitted
  # end
  
end

db/scheme.rb

create_table "items", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
    t.bigint "user_id", null: false
    t.string "name"
    t.string "description"
    t.integer "price"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.index ["user_id"], name: "index_items_on_user_id"
  end
....
add_foreign_key "items", "users"

itemテーブルは以下のようになっています。
|id|user_id|name|description|price|created_at|updated
|:--|:--:|--:|
|データ|データ|データ|データ|データ|データ|データ|

試したこと

1.ログをみると**SELECT users.* FROM users**が最後に発行されたSQLになっているのでターミナルで直接実行。
=>エラーは発生することなく正常にデータを取ることが出来ました。

2.rakeコマンドを通さずitemテーブルを少し弄ったのでscheme.rbと実際のテーブルを確認。
=>違ってるところは何も無し。

3.rake tmp:clear => 変わり無し。

4.ActiveRecord::Base.connection.query_cache.clearでアクティブレコードのキャッシュをクリア
=>変わり無し。

5.admin/items.rbでindexとcontrollerのオーバーライドをしてみるも、そもそもそこまで実行されない。

6.ルーティングが通ってないのかと思い bundle exec rails routes | grep product
=>/admin/items以下が全てある事を確認。

7.サーバごと再起動 => 変わり無し。

どなたか問題に心当たりある方いませんでしょうが。
宜しくお願いいたします。

Answer 1

モデルから作り直すことで解決しました。
根本的な解決にはなっていませんが...