Skip to content

Instantly share code, notes, and snippets.

@Kulgar
Last active August 1, 2016 16:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Kulgar/37f4e441555072d2ed54fee9f3c5bb04 to your computer and use it in GitHub Desktop.
Save Kulgar/37f4e441555072d2ed54fee9f3c5bb04 to your computer and use it in GitHub Desktop.
Stacktrace of "PG:Unable to send" error
# From production app:
[- 6354c4d2-3927-411a-af09-5f2cc99ef8e0] CacheStore: read "_account_lookup4/1" 0.0000
[- 6354c4d2-3927-411a-af09-5f2cc99ef8e0] ^[[1m^[[35mAccount Load (0.8ms)^[[0m SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = 1 LIMIT 1 [["id", 1]] [production:1 master]
[- 6354c4d2-3927-411a-af09-5f2cc99ef8e0] CacheStore: generate "_account_lookup4/1" 0.0030
[- 6354c4d2-3927-411a-af09-5f2cc99ef8e0]
ActiveRecord::StatementInvalid (PG::UnableToSend: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
: SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = 1 LIMIT 1):
app/models/account.rb:1118:in `block (2 levels) in find_cached'
app/models/account.rb:1116:in `block in find_cached'
app/models/account.rb:1115:in `find_cached'
app/models/account.rb:1134:in `block in get_special_account'
app/models/account.rb:1129:in `get_special_account'
app/models/account.rb:1095:in `default'
app/middleware/load_account.rb:15:in `default_domain_root_account'
app/middleware/load_account.rb:8:in `call'
app/middleware/request_context_generator.rb:49:in `call'
app/middleware/prevent_non_multipart_parse.rb:32:in `call'
[- 6354c4d2-3927-411a-af09-5f2cc99ef8e0] Processing by ApplicationController#rescue_action_dispatch_exception as */*
[- 6354c4d2-3927-411a-af09-5f2cc99ef8e0] CacheStore: read "_account_lookup4/1" 0.0000
[- 6354c4d2-3927-411a-af09-5f2cc99ef8e0] ^[[1m^[[36mAccount Load (0.4ms)^[[0m ^[[1mSELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = 1 LIMIT 1^[[0m [["id", 1]] [production:1 master]
[- 6354c4d2-3927-411a-af09-5f2cc99ef8e0] CacheStore: generate "_account_lookup4/1" 0.0020
[- 6354c4d2-3927-411a-af09-5f2cc99ef8e0]
PG::UnableToSend (no connection to the server
):
/usr/local/rvm/gems/ruby-2.1.6/gems/rack-mini-profiler-0.9.2/lib/patches/sql_patches.rb:160:in `exec'
/usr/local/rvm/gems/ruby-2.1.6/gems/rack-mini-profiler-0.9.2/lib/patches/sql_patches.rb:160:in `async_exec'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.6/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `block in exec_no_cache'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract_adapter.rb:472:in `block in log'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/lib/switchman/sharded_instrumenter.rb:20:in `instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract_adapter.rb:466:in `log'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/lib/switchman/active_record/abstract_adapter.rb:33:in `log'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.6/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `exec_no_cache'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.6/lib/active_record/connection_adapters/postgresql_adapter.rb:584:in `execute_and_clear'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in `exec_query'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract/database_statements.rb:356:in `select'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/lib/switchman/active_record/query_cache.rb:63:in `select_all'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.6/lib/active_record/querying.rb:39:in `find_by_sql'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/lib/switchman/active_record/statement_cache.rb:22:in `block in execute'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/app/models/switchman/shard_internal.rb:553:in `block in activate'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/app/models/switchman/shard_internal.rb:79:in `activate'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/app/models/switchman/shard_internal.rb:552:in `activate'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/lib/switchman/active_record/statement_cache.rb:21:in `execute'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.6/lib/active_record/core.rb:153:in `find'
/home/deploy/canvas-lms/app/models/account.rb:1118:in `block (2 levels) in find_cached'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/cache.rb:299:in `block in fetch'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/cache.rb:585:in `block in save_block_result_to_cache'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/cache.rb:547:in `block in instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/notifications.rb:164:in `block in instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/notifications.rb:164:in `instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/cache.rb:547:in `instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/cache.rb:584:in `save_block_result_to_cache'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/cache.rb:299:in `fetch'
/home/deploy/canvas-lms/app/models/account.rb:1116:in `block in find_cached'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/app/models/switchman/shard_internal.rb:553:in `block in activate'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/app/models/switchman/shard_internal.rb:79:in `activate'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/app/models/switchman/shard_internal.rb:552:in `activate'
/home/deploy/canvas-lms/app/models/account.rb:1115:in `find_cached'
/home/deploy/canvas-lms/app/models/account.rb:1134:in `block in get_special_account'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/app/models/switchman/shard_internal.rb:553:in `block in activate'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/app/models/switchman/shard_internal.rb:79:in `activate'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.3/app/models/switchman/shard_internal.rb:552:in `activate'
/home/deploy/canvas-lms/app/models/account.rb:1129:in `get_special_account'
/home/deploy/canvas-lms/app/models/account.rb:1095:in `default'
/home/deploy/canvas-lms/app/middleware/load_account.rb:15:in `default_domain_root_account'
/home/deploy/canvas-lms/app/controllers/application_controller.rb:360:in `load_account'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:432:in `block in make_lambda'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:164:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:164:in `block in halting'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:504:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:504:in `block in call'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:504:in `each'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:504:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:92:in `__run_callbacks__'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:778:in `_run_process_action_callbacks'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/callbacks.rb:81:in `run_callbacks'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/abstract_controller/callbacks.rb:19:in `process_action'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/action_controller/metal/rescue.rb:29:in `process_action'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/action_controller/metal/instrumentation.rb:32:in `block in process_action'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/notifications.rb:164:in `block in instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.2.6/lib/active_support/notifications.rb:164:in `instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/action_controller/metal/instrumentation.rb:30:in `process_action'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/action_controller/metal/params_wrapper.rb:250:in `process_action'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.6/lib/active_record/railties/controller_runtime.rb:18:in `process_action'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/abstract_controller/base.rb:137:in `process'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionview-4.2.6/lib/action_view/rendering.rb:30:in `process'
/usr/local/rvm/gems/ruby-2.1.6/gems/rack-mini-profiler-0.9.2/lib/mini_profiler/profiling_methods.rb:79:in `block in profile_method'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/action_controller/metal.rb:196:in `dispatch'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/action_controller/metal/rack_delegation.rb:13:in `dispatch'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/action_controller/metal.rb:237:in `block in action'
/home/deploy/canvas-lms/config/application.rb:239:in `call'
/home/deploy/canvas-lms/config/application.rb:239:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/action_dispatch/middleware/show_exceptions.rb:47:in `render_exception'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/action_dispatch/middleware/show_exceptions.rb:35:in `rescue in call'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/action_dispatch/middleware/show_exceptions.rb:30:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/railties-4.2.6/lib/rails/rack/logger.rb:38:in `call_app'
/usr/local/rvm/gems/ruby-2.1.6/gems/railties-4.2.6/lib/rails/rack/logger.rb:22:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/request_store-1.3.1/lib/request_store/middleware.rb:9:in `call'
/home/deploy/canvas-lms/app/middleware/request_context_generator.rb:49:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/rack-1.6.4/lib/rack/methodoverride.rb:22:in `call'
/home/deploy/canvas-lms/app/middleware/prevent_non_multipart_parse.rb:32:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/rack-1.6.4/lib/rack/runtime.rb:18:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/actionpack-4.2.6/lib/action_dispatch/middleware/static.rb:120:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/rack-1.6.4/lib/rack/sendfile.rb:113:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/rack-mini-profiler-0.9.2/lib/mini_profiler/profiler.rb:193:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/railties-4.2.6/lib/rails/engine.rb:518:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/railties-4.2.6/lib/rails/application.rb:165:in `call'
/usr/local/rvm/gems/ruby-2.1.6/gems/railties-4.2.6/lib/rails/railtie.rb:194:in `public_send'
/usr/local/rvm/gems/ruby-2.1.6/gems/railties-4.2.6/lib/rails/railtie.rb:194:in `method_missing'
/usr/share/ruby/vendor_ruby/phusion_passenger/rack/thread_handler_extension.rb:97:in `process_request'
/usr/share/ruby/vendor_ruby/phusion_passenger/request_handler/thread_handler.rb:152:in `accept_and_process_next_request'
/usr/share/ruby/vendor_ruby/phusion_passenger/request_handler/thread_handler.rb:113:in `main_loop'
/usr/share/ruby/vendor_ruby/phusion_passenger/request_handler.rb:416:in `block (3 levels) in start_threads'
/usr/share/ruby/vendor_ruby/phusion_passenger/utils.rb:113:in `block in create_thread_and_abort_on_exception'
# From the console:
/usr/local/rvm/gems/ruby-2.1.6/gems/rack-mini-profiler-0.9.2/lib/patches/sql_patches.rb:160:in `exec'
/usr/local/rvm/gems/ruby-2.1.6/gems/rack-mini-profiler-0.9.2/lib/patches/sql_patches.rb:160:in `async_exec'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/connection_adapters/postgresql_adapter.rb:813:in `exec_no_cache'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/connection_adapters/postgresql/database_statements.rb:138:in `block in exec_query'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/connection_adapters/abstract_adapter.rb:442:in `block in log'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.0.13/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.13/lib/switchman/sharded_instrumenter.rb:20:in `instrument'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/connection_adapters/abstract_adapter.rb:437:in `log'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.13/lib/switchman/active_record/abstract_adapter.rb:37:in `log'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/connection_adapters/postgresql/database_statements.rb:137:in `exec_query'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/connection_adapters/postgresql_adapter.rb:930:in `select'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/connection_adapters/abstract/database_statements.rb:25:in `select_all'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.13/lib/switchman/active_record/query_cache.rb:63:in `select_all'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/querying.rb:36:in `find_by_sql'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/relation.rb:587:in `exec_queries'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.13/lib/switchman/shackles/relation.rb:11:in `exec_queries'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/relation.rb:471:in `load'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/relation.rb:220:in `to_a'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.13/lib/switchman/active_record/relation.rb:53:in `to_a'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.13/lib/switchman/active_record/relation.rb:55:in `block in to_a'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.13/lib/switchman/active_record/relation.rb:83:in `activate'
/usr/local/rvm/gems/ruby-2.1.6/gems/switchman-1.5.13/lib/switchman/active_record/relation.rb:55:in `to_a'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/relation/finder_methods.rb:326:in `find_first'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/relation/finder_methods.rb:91:in `first'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-deprecated_finders-1.0.4/lib/active_record/deprecated_finders/relation.rb:129:in `first'
/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.0.13/lib/active_record/querying.rb:3:in `first'
(irb):7:in `irb_binding'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb/workspace.rb:86:in `eval'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb/workspace.rb:86:in `evaluate'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb/context.rb:380:in `evaluate'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb.rb:492:in `block (2 levels) in eval_input'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb.rb:624:in `signal_status'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb.rb:489:in `block in eval_input'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb/ruby-lex.rb:247:in `block (2 levels) in each_top_level_statement'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb/ruby-lex.rb:233:in `loop'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb/ruby-lex.rb:233:in `block in each_top_level_statement'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb/ruby-lex.rb:232:in `catch'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb/ruby-lex.rb:232:in `each_top_level_statement'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb.rb:488:in `eval_input'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb.rb:397:in `block in start'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb.rb:396:in `catch'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/2.1.0/irb.rb:396:in `start'
/usr/local/rvm/gems/ruby-2.1.6/gems/railties-4.0.13/lib/rails/commands/console.rb:90:in `start'
/usr/local/rvm/gems/ruby-2.1.6/gems/railties-4.0.13/lib/rails/commands/console.rb:9:in `start'
/usr/local/rvm/gems/ruby-2.1.6/gems/railties-4.0.13/lib/rails/commands.rb:62:in `<top (required)>'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.0.13/lib/active_support/dependencies.rb:229:in `require'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.0.13/lib/active_support/dependencies.rb:229:in `block in require'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.0.13/lib/active_support/dependencies.rb:214:in `load_dependency'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.0.13/lib/active_support/dependencies.rb:229:in `require'
/root/canvas/bin/rails:9:in `<top (required)>'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.0.13/lib/active_support/dependencies.rb:223:in `load'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.0.13/lib/active_support/dependencies.rb:223:in `block in load'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.0.13/lib/active_support/dependencies.rb:214:in `load_dependency'
/usr/local/rvm/gems/ruby-2.1.6/gems/activesupport-4.0.13/lib/active_support/dependencies.rb:223:in `load'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/site_ruby/2.1.0/rubygems/core_ext/kernel_require.rb:54:in `require'
/usr/local/rvm/rubies/ruby-2.1.6/lib/ruby/site_ruby/2.1.0/rubygems/core_ext/kernel_require.rb:54:in `require'
@Kulgar
Copy link
Author

Kulgar commented Aug 1, 2016

Here is the error:

[- -] User Load (0.9ms) 1mSELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT 1 [development:1 master]
[- -] PG::UnableToSend: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
: SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT 1
[- -] extra logging: PG::UnableToSend: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
: SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT 1:

@Kulgar
Copy link
Author

Kulgar commented Aug 1, 2016

In dev environment:

ActiveRecord::StatementInvalid
PG::UnableToSend: no connection to the server : SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = '"accounts"'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum

Extracted source (around line #151):

  def self.columns_with_remove_dropped_columns
    @columns_with_dropped ||= self.columns_without_remove_dropped_columns.reject { |c|
      (DROPPED_COLUMNS[self.table_name] || []).include?(c.name)
    }
  end

Rails.root: /root/canvas

Application Trace | Framework Trace | Full Trace
rack-mini-profiler (0.9.2) lib/patches/sql_patches.rb:160:in `exec'
rack-mini-profiler (0.9.2) lib/patches/sql_patches.rb:160:in `async_exec'
activerecord (4.0.13) lib/active_record/connection_adapters/postgresql_adapter.rb:798:in `exec_no_cache'
activerecord (4.0.13) lib/active_record/connection_adapters/postgresql/database_statements.rb:138:in `block in exec_query'
activerecord (4.0.13) lib/active_record/connection_adapters/abstract_adapter.rb:442:in `block in log'
activesupport (4.0.13) lib/active_support/notifications/instrumenter.rb:20:in `instrument'
switchman (1.5.13) lib/switchman/sharded_instrumenter.rb:20:in `instrument'
activerecord (4.0.13) lib/active_record/connection_adapters/abstract_adapter.rb:437:in `log'
switchman (1.5.13) lib/switchman/active_record/abstract_adapter.rb:37:in `log'
activerecord (4.0.13) lib/active_record/connection_adapters/postgresql/database_statements.rb:137:in `exec_query'
activerecord (4.0.13) lib/active_record/connection_adapters/postgresql_adapter.rb:937:in `column_definitions'
activerecord (4.0.13) lib/active_record/connection_adapters/postgresql/schema_statements.rb:187:in `columns'
activerecord (4.0.13) lib/active_record/connection_adapters/schema_cache.rb:114:in `block in prepare_default_proc'
activerecord (4.0.13) lib/active_record/connection_adapters/schema_cache.rb:56:in `yield'
activerecord (4.0.13) lib/active_record/connection_adapters/schema_cache.rb:56:in `columns'
activerecord (4.0.13) lib/active_record/model_schema.rb:208:in `columns'
config/initializers/dropped_columns.rb:151:in `columns_with_remove_dropped_columns'
activerecord (4.0.13) lib/active_record/model_schema.rb:249:in `column_defaults'
activerecord (4.0.13) lib/active_record/locking/optimistic.rb:169:in `column_defaults'
activerecord (4.0.13) lib/active_record/core.rb:171:in `initialize'
aroi (0.0.3) lib/aroi/instrumentation/active_record.rb:34:in `block in initialize'
activesupport (4.0.13) lib/active_support/notifications.rb:159:in `block in instrument'
activesupport (4.0.13) lib/active_support/notifications/instrumenter.rb:20:in `instrument'
activesupport (4.0.13) lib/active_support/notifications.rb:159:in `instrument'
aroi (0.0.3) lib/aroi/instrumentation/active_record.rb:33:in `initialize'
activerecord (4.0.13) lib/active_record/inheritance.rb:30:in `new'
activerecord (4.0.13) lib/active_record/inheritance.rb:30:in `new'
app/models/account.rb:1154:in `block in get_special_account'
switchman (1.5.13) app/models/switchman/shard_internal.rb:554:in `block in activate'
switchman (1.5.13) app/models/switchman/shard_internal.rb:79:in `activate'
switchman (1.5.13) app/models/switchman/shard_internal.rb:553:in `activate'
app/models/account.rb:1133:in `get_special_account'
app/models/account.rb:1099:in `default'
app/middleware/load_account.rb:15:in `default_domain_root_account'
app/middleware/load_account.rb:8:in `call'
actionpack (4.0.13) lib/action_dispatch/middleware/cookies.rb:486:in `call'
activerecord (4.0.13) lib/active_record/query_cache.rb:36:in `call'
activerecord (4.0.13) lib/active_record/connection_adapters/abstract/connection_pool.rb:612:in `call'
actionpack (4.0.13) lib/action_dispatch/middleware/callbacks.rb:29:in `block in call'
activesupport (4.0.13) lib/active_support/callbacks.rb:373:in `_run__1937221426873439155__call__callbacks'
activesupport (4.0.13) lib/active_support/callbacks.rb:80:in `run_callbacks'
actionpack (4.0.13) lib/action_dispatch/middleware/callbacks.rb:27:in `call'
actionpack (4.0.13) lib/action_dispatch/middleware/reloader.rb:64:in `call'
actionpack (4.0.13) lib/action_dispatch/middleware/remote_ip.rb:76:in `call'
actionpack (4.0.13) lib/action_dispatch/middleware/debug_exceptions.rb:17:in `call'
actionpack (4.0.13) lib/action_dispatch/middleware/show_exceptions.rb:30:in `call'
railties (4.0.13) lib/rails/rack/logger.rb:38:in `call_app'
railties (4.0.13) lib/rails/rack/logger.rb:22:in `call'
request_store (1.3.1) lib/request_store/middleware.rb:9:in `call'
app/middleware/request_context_generator.rb:49:in `call'
rack (1.5.4) lib/rack/methodoverride.rb:21:in `call'
app/middleware/prevent_non_multipart_parse.rb:32:in `call'
rack (1.5.4) lib/rack/runtime.rb:17:in `call'
rack (1.5.4) lib/rack/lock.rb:17:in `call'
actionpack (4.0.13) lib/action_dispatch/middleware/static.rb:84:in `call'
rack (1.5.4) lib/rack/sendfile.rb:112:in `call'
rack-mini-profiler (0.9.2) lib/mini_profiler/profiler.rb:193:in `call'
railties (4.0.13) lib/rails/engine.rb:511:in `call'
railties (4.0.13) lib/rails/application.rb:97:in `call'
rack (1.5.4) lib/rack/content_length.rb:14:in `call'
thin (1.6.3) lib/thin/connection.rb:86:in `block in pre_process'
thin (1.6.3) lib/thin/connection.rb:84:in `catch'
thin (1.6.3) lib/thin/connection.rb:84:in `pre_process'
thin (1.6.3) lib/thin/connection.rb:53:in `process'
thin (1.6.3) lib/thin/connection.rb:39:in `receive_data'
eventmachine (1.0.4) lib/eventmachine.rb:187:in `run_machine'
eventmachine (1.0.4) lib/eventmachine.rb:187:in `run'
thin (1.6.3) lib/thin/backends/base.rb:73:in `start'
thin (1.6.3) lib/thin/server.rb:162:in `start'
rack (1.5.4) lib/rack/handler/thin.rb:16:in `run'
rack (1.5.4) lib/rack/server.rb:264:in `start'
railties (4.0.13) lib/rails/commands/server.rb:84:in `start'
railties (4.0.13) lib/rails/commands.rb:76:in `block in <top (required)>'
railties (4.0.13) lib/rails/commands.rb:71:in `tap'
railties (4.0.13) lib/rails/commands.rb:71:in `<top (required)>'
bin/rails:9:in `require'
bin/rails:9:in `<top (required)>'
spring (1.7.2) lib/spring/client/rails.rb:28:in `load'
spring (1.7.2) lib/spring/client/rails.rb:28:in `call'
spring (1.7.2) lib/spring/client/command.rb:7:in `call'
spring (1.7.2) lib/spring/client.rb:30:in `run'
spring (1.7.2) bin/spring:49:in `<top (required)>'
spring (1.7.2) lib/spring/binstub.rb:11:in `load'
spring (1.7.2) lib/spring/binstub.rb:11:in `<top (required)>'
bin/spring:16:in `require'
bin/spring:16:in `<top (required)>'
bin/rails:3:in `load'
bin/rails:3:in `<main>'
Request

Parameters:

None
Toggle session dump
Toggle env dump
GATEWAY_INTERFACE: "CGI/1.2"
HTTP_ACCEPT: "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8"
HTTP_ACCEPT_ENCODING: "gzip, deflate, sdch"
HTTP_ACCEPT_LANGUAGE: "fr,fr-FR;q=0.8,en;q=0.6,en-US;q=0.4"
HTTP_CACHE_CONTROL: "max-age=0"
REMOTE_ADDR: "82.127.5.100"
SERVER_NAME: "163.172.157.215"
SERVER_PROTOCOL: "HTTP/1.1"
Response

Headers:

None

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment