Skip to content

Instantly share code, notes, and snippets.

@Kulgar
Last active August 1, 2016 16:22
Show Gist options
  • Select an option

  • Save Kulgar/37f4e441555072d2ed54fee9f3c5bb04 to your computer and use it in GitHub Desktop.

Select an option

Save Kulgar/37f4e441555072d2ed54fee9f3c5bb04 to your computer and use it in GitHub Desktop.
Stacktrace of "PG:Unable to send" error
/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
Copy Markdown
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
Copy Markdown
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