Heroku中Rake任务无法识别命名空间模型问题求助

环境信息 #

• Rails版本：rails 6.1.4
• Ruby版本：ruby 3.1.1
• 代码结构：核心业务代码放在living_muay_thai/子目录下，使用LivingMuayThai::命名空间

问题现象 #

本地开发环境中，填充数据的Rake任务level_requirements_upload可正常运行；但部署到Heroku后执行该任务时触发错误：

$ heroku run rails level_requirements_upload
...
DEBUG -- :   LivingMuayThai::LevelRequirement Load (0.9ms)  SELECT "living_muay_thai_level_requirements".* FROM "living_muay_thai_level_requirements"
rails aborted!
ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR:  relation "living_muay_thai_level_requirements" does not exist
LINE 1: ...LECT "living_muay_thai_level_requirements".* FROM "living_mu...

错误指向Rake任务第4行的LivingMuayThai::LevelRequirement.destroy_all代码。

已排查的操作 #

1. 反复核对模型和Rake任务中的表名拼写，确认无错误
2. 检查Heroku数据库，误以为对应表为空（实际报错提示表不存在）
3. 尝试用单引号包裹类名，触发其他关联错误

相关代码 #

Level模型（app/models/living_muay_thai/level.rb） #

# Table name: living_muay_thai_levels
#
#  id         :bigint           not null, primary key
#  color      :string
#  level_name :string
#  sort_order :integer
#  created_at :datetime         not null
#  updated_at :datetime         not null
#
class LivingMuayThai::Level < ApplicationRecord
  has_many :living_muay_thai_level_requirements
  has_many :living_muay_thai_requirements, through: :living_muay_thai_level_requirements
end

Requirement模型（app/models/living_muay_thai/requirement.rb） #

# Table name: living_muay_thai_requirements
#
#  id               :bigint           not null, primary key
#  requirement_name :string
#  created_at       :datetime         not null
#  updated_at       :datetime         not null
#
class LivingMuayThai::Requirement < ApplicationRecord
  has_many :living_muay_thai_level_requirements
  has_many :living_muay_thai_levels, through: :living_muay_thai_level_requirements
end

LevelRequirement模型（app/models/living_muay_thai/level_requirement.rb） #

# Table name: living_muay_thai_level_requirements
#
#  id             :bigint           not null, primary key
#  created_at     :datetime         not null
#  updated_at     :datetime         not null
#  level_id       :integer          not null
#  requirement_id :integer          not null
#
# Indexes
#
#  level_req_index  (level_id)
#  req_level_index  (requirement_id)
#
class LivingMuayThai::LevelRequirement < ApplicationRecord
  belongs_to :living_muay_thai_level, class_name: 'LivingMuayThai::Level', foreign_key: :level_id
  belongs_to :living_mauy_thai_requirement, class_name: 'LivingMuayThai::Requirement', foreign_key: :requirement_id

  validates_uniqueness_of :level_id,  scope: :requirement_id 
end

Rake任务（lib/tasks/level_requirements_upload.rake） #

desc "create level requirements records"
task :level_requirements_upload => :environment do 
  LivingMuayThai::LevelRequirement.destroy_all
  LivingMuayThai::Requirement.destroy_all

  @reqs.each_line do |line|
    parts = line.split(",")
    parts[0].strip!
    parts[1].strip!

    puts "-------------------------"
    puts "part[0] => #{parts[0]} and parts[1] is #{parts[1]}"

    req=LivingMuayThai::Requirement.new(:requirement_name => parts[1])
    if req.save
      puts "Requirement #{parts[1]} entered"

      # we have levels in the db, so add the level requirement here
      level=LivingMuayThai::Level.where(:level_name => parts[0]).first
      if level.present?
        level_id = level.id
        lr=LivingMuayThai::LevelRequirement.new(:level_id => level_id, :requirement_id => req.id)
        if lr.save
          puts "Insert into level_requirements #{lr.level_id}, #{lr.requirement_id}"
        else
          puts "Error: #{lr.errors.full_messages}"
        end
      end 
    else
      puts "Error Requirement: #{req.errors.full_messages}"
    end
  end
end

@reqs = "Level 1, Class 1
...more lines..."

问题原因及解决方案 #

核心原因1：Heroku未执行数据库迁移 #

错误提示relation "living_muay_thai_level_requirements" does not exist说明该表在Heroku数据库中根本不存在，而非为空。大概率是部署后未运行数据库迁移命令。

解决步骤：

# 登录Heroku并执行迁移
heroku run rails db:migrate
# 若存在预发布环境，需同步执行
heroku run rails db:migrate --app your-app-staging

核心原因2：模型关联存在拼写错误 #

在LivingMuayThai::LevelRequirement模型中，belongs_to :living_mauy_thai_requirement存在拼写错误：mauy应为muay，这会导致后续关联操作失败，即使表创建成功也会触发其他错误。

修复代码：

# 修改LevelRequirement模型中的关联
belongs_to :living_muay_thai_requirement, class_name: 'LivingMuayThai::Requirement', foreign_key: :requirement_id

辅助优化：明确命名空间模型的关联配置 #

为避免Rails自动推断关联时出错，建议在命名空间模型的关联中显式指定class_name和foreign_key：

# 在LivingMuayThai::Level模型中补充关联配置
has_many :living_muay_thai_level_requirements, class_name: 'LivingMuayThai::LevelRequirement', foreign_key: :level_id
has_many :living_muay_thai_requirements, through: :living_muay_thai_level_requirements, source: :living_muay_thai_requirement

# 在LivingMuayThai::Requirement模型中补充关联配置
has_many :living_muay_thai_level_requirements, class_name: 'LivingMuayThai::LevelRequirement', foreign_key: :requirement_id
has_many :living_muay_thai_levels, through: :living_muay_thai_level_requirements, source: :living_muay_thai_level

内容的提问来源于stack exchange，提问作者John Cowan