用户卡加载失败

selase · 2025 年5 月 19 日 14:44

我没有完整的跟踪信息，但我认为错误发生在用户卡片的 gamification_score 序列化过程中。

考虑到这些物化视图的瞬态性质，分数查找不应导致系统范围的错误，当视图不存在时，它应该回退到“默认分数”。

物化视图存在性检查中存在一个错误。它报告视图存在，但实际上并不存在（至少不在当前的 public schema 中），这导致在查找不存在的视图时出错。

我认为发生这种情况的原因是，在恢复过程中创建的 backup schema 中存在物化视图，但在 public schema 中不存在。backup schema 在恢复后会保留一段时间。

github.com/discourse/discourse-gamification

plugin.rb

213af96ac


      
                  .includes(:flair_upload)
                  .all
                  .map { |group| BasicGroupSerializer.new(group, root: false, scope: self.scope).as_json },
              gamification_leaderboards:
                DiscourseGamification::GamificationLeaderboard.all.map do |leaderboard|
                  LeaderboardSerializer.new(leaderboard, root: false).as_json
                end,
            }
          end
          
          add_to_serializer(:user_card, :gamification_score) { object.gamification_score }
          add_to_serializer(:site, :default_gamification_leaderboard_id) do
            DiscourseGamification::GamificationLeaderboard.first&.id
          end
          
          SeedFu.fixture_paths << Rails
            .root
            .join("plugins", "discourse-gamification", "db", "fixtures")
            .to_s
          
          on(:site_setting_changed) do |name|

github.com/discourse/discourse-gamification

lib/discourse_gamification/user_extension.rb

213af96ac


      
              DEFAULT_SCORE = 0
          
              def gamification_score
                return DEFAULT_SCORE if !default_leaderboard
          
                DiscourseGamification::GamificationLeaderboard.find_position_by(
                  leaderboard_id: default_leaderboard.id,
                  period: "all_time",
                  for_user_id: self.id,
                )&.total_score || DEFAULT_SCORE
              rescue DiscourseGamification::LeaderboardCachedView::NotReadyError
                Jobs.enqueue(Jobs::GenerateLeaderboardPositions, leaderboard_id: default_leaderboard.id)
          
                DEFAULT_SCORE
              end
          
              def default_leaderboard
                @default_leaderboard ||= DiscourseGamification::GamificationLeaderboard.select(:id).first
              end
            end
          end

github.com/discourse/discourse-gamification

lib/discourse_gamification/leaderboard_cached_view.rb

213af96ac


      
          def scores(period: "all_time", page: 0, for_user_id: false, limit: nil, offset: nil)
            user_filter_condition = for_user_id ? ["users.id = ?", for_user_id] : [nil]
          
            if mview_exists?(period)
              User
                .where(*user_filter_condition)
                .joins("INNER JOIN #{mview_name(period)} p ON  p.user_id = users.id")
                .select(
                  "users.id, users.name, users.username, users.uploaded_avatar_id, p.total_score, p.position",
                )
                .limit(limit)
                .offset(offset)
                .order(position: :asc, id: :asc)
                .load
            else
              raise NotReadyError.new(I18n.t("errors.leaderboard_positions_not_ready"))
            end
          end

我已经准备了一个包含修复程序的 PR。

github.com/discourse/discourse-gamification

FIX: Scope materialized view existence check to current schema

main ← fix/materialized-view-presence-check

opened 02:16PM - 19 May 25 UTC

s3lase

+21 -1

Currently, `mview_exists?` returns true if the materialized view existed anywher…e in the database, regardless of the schema. This caused issues after backup restores, where the views may exist in the `backup` schema created during the restore but not in the current public schema. This change ensures the check is scoped to the current schema.

话题		回复	浏览量
Usercard Redesign Experiment Feature completed , user-card	130	6886	2025 年12 月 3 日
User Card Directory Theme component official , user-card-directory	131	17742	2025 年11 月 26 日
New user cards and user profile page design deployed Feature	63	8437	2015 年7 月 3 日
Since 2.8.0beta2 update some users can't get to preferences (etc) Support	8	665	2021 年7 月 16 日
User Card Directory component not working Support user-card-directory	5	72	2025 年11 月 24 日

用户卡加载失败

相关话题