PG15 마이그레이션 후 Sidekiq 작업(Calculate Scores)이 계속 실패합니다

지원
1

안녕하세요. PSQL15로 마이그레이션한 후 갑자기 ‘Calculate Scores’ 작업이 계속 실패하고 있습니다:

Job exception: ERROR: could not open file "base/16384/544114.1" (target block 655360): previous segment is only 20325 blocks
Job exception: ERROR: could not open file "base/16384/544113.1" (target block 134235414): previous segment is only 41880 blocks
(no such files present in psql data folder)

Backtrace:
rack-mini-profiler-3.3.1/lib/patches/db/pg.rb:110:in `exec' 
rack-mini-profiler-3.3.1/lib/patches/db/pg.rb:110:in `async_exec' 
mini_sql-1.6.0/lib/mini_sql/postgres/connection.rb:217:in `run' 
mini_sql-1.6.0/lib/mini_sql/active_record_postgres/connection.rb:38:in `block in run' 
mini_sql-1.6.0/lib/mini_sql/active_record_postgres/connection.rb:34:in `block in with_lock' 
activesupport-7.2.2.1/lib/active_support/concurrency/null_lock.rb:9:in `synchronize' 
mini_sql-1.6.0/lib/mini_sql/active_record_postgres/connection.rb:34:in `with_lock' 
mini_sql-1.6.0/lib/mini_sql/active_record_postgres/connection.rb:38:in `run' 
/var/www/discourse/lib/mini_sql_multisite_connection.rb:109:in `run' 
mini_sql-1.6.0/lib/mini_sql/postgres/connection.rb:196:in `exec' 
(eval at /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/mini_sql-1.6.0/lib/mini_sql/builder.rb:62):2:in `exec'
/var/www/discourse/lib/score_calculator.rb:73:in `update_posts_rank' 
/var/www/discourse/lib/score_calculator.rb:15:in `calculate' 
/var/www/discourse/app/jobs/scheduled/calculate_scores.rb:8:in `execute' 
/var/www/discourse/app/jobs/base.rb:316:in `block (2 levels) in perform' 
rails_multisite-6.1.0/lib/rails_multisite/connection_management/null_instance.rb:49:in `with_connection'
rails_multisite-6.1.0/lib/rails_multisite/connection_management.rb:21:in `with_connection'
/var/www/discourse/app/jobs/base.rb:303:in `block in perform' 
/var/www/discourse/app/jobs/base.rb:299:in `each' 
/var/www/discourse/app/jobs/base.rb:299:in `perform' 
/var/www/discourse/app/jobs/base.rb:379:in `perform' 
mini_scheduler-0.18.0/lib/mini_scheduler/manager.rb:137:in `process_queue' 
mini_scheduler-0.18.0/lib/mini_scheduler/manager.rb:77:in `worker_loop' 
mini_scheduler-0.18.0/lib/mini_scheduler/manager.rb:63:in `block (2 levels) in ensure_worker_threads'

또한, 프로필에 문제가 없음에도 불구하고 두 명의 사용자가 공개 프로필에 액세스할 때 500 오류를 보고하고 있습니다:

/u/username/summary.json

이 상황을 해결하는 방법에 대해 조언을 주실 수 있을까요?

2

데이터베이스 파일에 문제가 있는 것 같습니다. 먼저 해당 파일들을 조사해 보시는 것이 좋습니다.