ActiveRecord::StatementInvalid: PG::DiskFull: ERROR: could not write to hash-join temporary file: No space left on device : SELECT summoners.account_id, summoners.region FROM "summoner_performances" INNER JOIN "summoners" ON "summoners"."id" = "summoner
Closed this issue · 0 comments
danReynolds commented
View details in Rollbar: https://rollbar.com/danreynolds/SummonerExpert/items/153/
PG::DiskFull: ERROR: could not write to hash-join temporary file: No space left on device
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb", line 598, in async_exec
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb", line 598, in block in exec_no_cache
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_adapter.rb", line 566, in block in log
File "/usr/local/bundle/gems/activesupport-5.0.0.1/lib/active_support/notifications/instrumenter.rb", line 21, in instrument
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_adapter.rb", line 560, in log
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb", line 598, in exec_no_cache
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb", line 587, in execute_and_clear
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb", line 103, in exec_query
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb", line 373, in select
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb", line 41, in select_all
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/query_cache.rb", line 70, in select_all
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/querying.rb", line 39, in find_by_sql
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/relation.rb", line 699, in exec_queries
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/relation.rb", line 580, in load
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/relation.rb", line 260, in records
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/relation/delegation.rb", line 38, in map
File "/app/lib/tasks/scheduler.rake", line 157, in block (2 levels) in <top (required)>
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/task.rb", line 250, in block in execute
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/task.rb", line 250, in each
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/task.rb", line 250, in execute
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/task.rb", line 194, in block in invoke_with_call_chain
File "/usr/local/lib/ruby/2.3.0/monitor.rb", line 214, in mon_synchronize
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/task.rb", line 187, in invoke_with_call_chain
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/task.rb", line 216, in block in invoke_prerequisites
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/task.rb", line 214, in each
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/task.rb", line 214, in invoke_prerequisites
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/task.rb", line 193, in block in invoke_with_call_chain
File "/usr/local/lib/ruby/2.3.0/monitor.rb", line 214, in mon_synchronize
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/task.rb", line 187, in invoke_with_call_chain
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/task.rb", line 180, in invoke
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/application.rb", line 152, in invoke_task
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/application.rb", line 108, in block (2 levels) in top_level
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/application.rb", line 108, in each
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/application.rb", line 108, in block in top_level
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/application.rb", line 117, in run_with_threads
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/application.rb", line 102, in top_level
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/application.rb", line 80, in block in run
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/application.rb", line 178, in standard_exception_handling
File "/usr/local/bundle/gems/rake-12.0.0/lib/rake/application.rb", line 77, in run
File "/usr/local/bundle/gems/rake-12.0.0/exe/rake", line 27, in <top (required)>
File "/usr/local/bundle/bin/rake", line 29, in load
File "/usr/local/bundle/bin/rake", line 29, in <top (required)>
File "/usr/local/bundle/gems/bundler-1.16.1/lib/bundler/cli/exec.rb", line 75, in load
File "/usr/local/bundle/gems/bundler-1.16.1/lib/bundler/cli/exec.rb", line 75, in kernel_load
File "/usr/local/bundle/gems/bundler-1.16.1/lib/bundler/cli/exec.rb", line 28, in run
File "/usr/local/bundle/gems/bundler-1.16.1/lib/bundler/cli.rb", line 424, in exec
File "/usr/local/bundle/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/command.rb", line 27, in run
File "/usr/local/bundle/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/invocation.rb", line 126, in invoke_command
File "/usr/local/bundle/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor.rb", line 387, in dispatch
File "/usr/local/bundle/gems/bundler-1.16.1/lib/bundler/cli.rb", line 27, in dispatch
File "/usr/local/bundle/gems/bundler-1.16.1/lib/bundler/vendor/thor/lib/thor/base.rb", line 466, in start
File "/usr/local/bundle/gems/bundler-1.16.1/lib/bundler/cli.rb", line 18, in start
File "/usr/local/bundle/gems/bundler-1.16.1/exe/bundle", line 30, in block in <top (required)>
File "/usr/local/bundle/gems/bundler-1.16.1/lib/bundler/friendly_errors.rb", line 122, in with_friendly_errors
File "/usr/local/bundle/gems/bundler-1.16.1/exe/bundle", line 22, in <top (required)>
File "/usr/local/bin/bundle", line 23, in load
File "/usr/local/bin/bundle", line 23, in <main>
ActiveRecord::StatementInvalid: PG::DiskFull: ERROR: could not write to hash-join temporary file: No space left on device
: SELECT summoners.account_id, summoners.region FROM "summoner_performances" INNER JOIN "summoners" ON "summoners"."id" = "summoner_performances"."summoner_id" ORDER BY summoner_performances.created_at DESC LIMIT $1
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb", line 598, in async_exec
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb", line 598, in block in exec_no_cache
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_adapter.rb", line 566, in block in log
File "/usr/local/bundle/gems/activesupport-5.0.0.1/lib/active_support/notifications/instrumenter.rb", line 21, in instrument
File "/usr/local/bundle/gems/activerecord-5.0.0.1/lib/acti