search

fjordllc / bootcamp

プログラマー向けEラーニングシステム
https://bootcamp.fjord.jp
MIT License
281 stars 74 forks source link

ActionView::Template::Error: PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. #7909

Closed komagata closed 4 days ago

komagata commented 4 days ago

View details in Rollbar: https://app.rollbar.com/a/komagata/fix/item/Bootcamp/1696



PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.

  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb", line 687, in exec_prepared
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb", line 687, in block (2 levels) in exec_cache
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/dependencies/interlock.rb", line 48, in block in permit_concurrent_loads
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/concurrency/share_lock.rb", line 187, in yield_shares
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/dependencies/interlock.rb", line 47, in permit_concurrent_loads
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb", line 686, in block in exec_cache
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/abstract_adapter.rb", line 696, in block (2 levels) in log
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb", line 26, in block (2 levels) in synchronize
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb", line 25, in handle_interrupt
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb", line 25, in block in synchronize
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb", line 21, in handle_interrupt
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb", line 21, in synchronize
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/abstract_adapter.rb", line 695, in block in log
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/notifications/instrumenter.rb", line 24, in instrument
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/abstract_adapter.rb", line 687, in log
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb", line 685, in exec_cache
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb", line 651, in execute_and_clear
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/postgresql/database_statements.rb", line 53, in exec_query
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/abstract/database_statements.rb", line 536, in select_prepared
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/abstract/database_statements.rb", line 67, in select_all
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/abstract/query_cache.rb", line 101, in block in select_all
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/abstract/query_cache.rb", line 118, in block in cache_sql
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb", line 26, in block (2 levels) in synchronize
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb", line 25, in handle_interrupt
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb", line 25, in block in synchronize
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb", line 21, in handle_interrupt
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb", line 21, in synchronize
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/abstract/query_cache.rb", line 109, in cache_sql
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/abstract/query_cache.rb", line 101, in select_all
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation/calculations.rb", line 200, in block in pluck
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation.rb", line 861, in skip_query_cache_if_necessary
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation/calculations.rb", line 196, in pluck
  File "/app/app/models/product.rb", line 37, in block in <class:Product>
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation.rb", line 411, in instance_exec
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation.rb", line 411, in block in _exec_scope
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation.rb", line 804, in _scoping
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation.rb", line 411, in _exec_scope
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/scoping/named.rb", line 176, in block in scope
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation/delegation.rb", line 67, in block in unchecked
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation.rb", line 406, in block in scoping
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation.rb", line 804, in _scoping
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation.rb", line 406, in scoping
  File "/usr/local/bundle/gems/activerecord-6.1.4.7/lib/active_record/relation/delegation.rb", line 67, in unchecked
  File "/app/app/models/cache.rb", line 27, in block in unassigned_product_count
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/cache.rb", line 752, in block in save_block_result_to_cache
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/cache.rb", line 726, in block in instrument
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/notifications.rb", line 205, in instrument
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/cache.rb", line 726, in instrument
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/cache.rb", line 751, in save_block_result_to_cache
  File "/usr/local/bundle/gems/activesupport-6.1.4.7/lib/active_support/cache.rb", line 343, in fetch
  File "/app/app/models/cache.rb", line 26, in unassigned_product_count
  File "/app/app/views/application/_global_nav.slim", l