Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[production][unknown] PG::ConnectionBad: FATAL: remaining connection slots are reserved for non-replication superuser ... #202

Open
dwilkie opened this issue Jul 11, 2015 · 1 comment
Open

[production][unknown] PG::ConnectionBad: FATAL: remaining connection slots are reserved for non-replication superuser ... #202

dwilkie opened this issue Jul 11, 2015 · 1 comment

Comments

@dwilkie
Copy link
Owner

dwilkie commented Jul 11, 2015

See this exception on Errbit

PG::ConnectionBad: FATAL: remaining connection slots are reserved for non-replication superuser connections

Summary

URL

https://www.chibitxt.me/sidekiq/busy"

Where

unknown

Occured

Jul 11 12:30pm

Similar

0

Params

{
}

Session

{
}

Backtrace

655:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb -> **initialize**
655:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb -> **new**
655:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb -> **connect**
242:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb -> **initialize**
44:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb -> **new**
44:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb -> **postgresql_connection**
438:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb -> **new_connection**
448:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb -> **checkout_new_connection**
422:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb -> **acquire_connection**
349:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb -> **block in checkout**
211:  /opt/rubies/ruby-2.2.2/lib/ruby/2.2.0/monitor.rb -> **mon_synchronize**
348:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb -> **checkout**
263:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb -> **block in connection**
211:  /opt/rubies/ruby-2.2.2/lib/ruby/2.2.0/monitor.rb -> **mon_synchronize**
262:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb -> **connection**
571:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb -> **retrieve_connection**
113:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_handling.rb -> **retrieve_connection**
87:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_handling.rb -> **connection**
51:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/query_cache.rb -> **restore_query_cache_settings**
43:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/query_cache.rb -> **rescue in call**
31:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/query_cache.rb -> **call**
653:  [GEM_ROOT]/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb -> **call**
29:  [GEM_ROOT]/gems/actionpack-4.2.3/lib/action_dispatch/middleware/callbacks.rb -> **block in call**
84:  [GEM_ROOT]/gems/activesupport-4.2.3/lib/active_support/callbacks.rb -> **run_callbacks**
27:  [GEM_ROOT]/gems/actionpack-4.2.3/lib/action_dispatch/middleware/callbacks.rb -> **call**
78:  [GEM_ROOT]/gems/actionpack-4.2.3/lib/action_dispatch/middleware/remote_ip.rb -> **call**
17:  [GEM_ROOT]/gems/actionpack-4.2.3/lib/action_dispatch/middleware/debug_exceptions.rb -> **call**
30:  [GEM_ROOT]/gems/actionpack-4.2.3/lib/action_dispatch/middleware/show_exceptions.rb -> **call**
38:  [GEM_ROOT]/gems/railties-4.2.3/lib/rails/rack/logger.rb -> **call_app**
20:  [GEM_ROOT]/gems/railties-4.2.3/lib/rails/rack/logger.rb -> **block in call**
68:  [GEM_ROOT]/gems/activesupport-4.2.3/lib/active_support/tagged_logging.rb -> **block in tagged**
26:  [GEM_ROOT]/gems/activesupport-4.2.3/lib/active_support/tagged_logging.rb -> **tagged**
68:  [GEM_ROOT]/gems/activesupport-4.2.3/lib/active_support/tagged_logging.rb -> **tagged**
20:  [GEM_ROOT]/gems/railties-4.2.3/lib/rails/rack/logger.rb -> **call**
21:  [GEM_ROOT]/gems/actionpack-4.2.3/lib/action_dispatch/middleware/request_id.rb -> **call**
22:  [GEM_ROOT]/gems/rack-1.6.4/lib/rack/methodoverride.rb -> **call**
18:  [GEM_ROOT]/gems/rack-1.6.4/lib/rack/runtime.rb -> **call**
28:  [GEM_ROOT]/gems/activesupport-4.2.3/lib/active_support/cache/strategy/local_cache_middleware.rb -> **call**
116:  [GEM_ROOT]/gems/actionpack-4.2.3/lib/action_dispatch/middleware/static.rb -> **call**
113:  [GEM_ROOT]/gems/rack-1.6.4/lib/rack/sendfile.rb -> **call**
24:  [GEM_ROOT]/gems/actionpack-4.2.3/lib/action_dispatch/middleware/ssl.rb -> **call**
518:  [GEM_ROOT]/gems/railties-4.2.3/lib/rails/engine.rb -> **call**
165:  [GEM_ROOT]/gems/railties-4.2.3/lib/rails/application.rb -> **call**
51:  [GEM_ROOT]/gems/puma-2.11.3/lib/puma/configuration.rb -> **call**
507:  [GEM_ROOT]/gems/puma-2.11.3/lib/puma/server.rb -> **handle_request**
375:  [GEM_ROOT]/gems/puma-2.11.3/lib/puma/server.rb -> **process_client**
262:  [GEM_ROOT]/gems/puma-2.11.3/lib/puma/server.rb -> **block in run**
104:  [GEM_ROOT]/gems/puma-2.11.3/lib/puma/thread_pool.rb -> **call**
104:  [GEM_ROOT]/gems/puma-2.11.3/lib/puma/thread_pool.rb -> **block in spawn_thread**

Environment

rack_version: ["1", "3"]
rack_multithread: true
rack_multiprocess: false
rack_run_once: false
SCRIPT_NAME:
CONTENT_TYPE: text/plain
QUERY_STRING:
SERVER_PROTOCOL: HTTP/1.1
SERVER_SOFTWARE: 2.11.3
GATEWAY_INTERFACE: CGI/1.2
REMOTE_ADDR: 127.0.0.1
REQUEST_METHOD: GET
REQUEST_PATH: /sidekiq/busy
REQUEST_URI: /sidekiq/busy
HTTP_VERSION: HTTP/1.0
HTTP_HOST: www.chibitxt.me
HTTP_X_FORWARDED_FOR: 115.178.26.244, 10.0.0.89
HTTP_CONNECTION: close
HTTP_ACCEPT: text/html, */*; q=0.01
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.8,km;q=0.6
HTTP_DNT: 1
HTTP_IF_NONE_MATCH: W/"f957442a94e7dfde3b997c6f1f1c2386"
HTTP_REFERER: https://www.chibitxt.me/sidekiq/busy?poll=true
HTTP_USER_AGENT: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/43.0.2357.81 Chrome/43.0.2357.81 Safari/537.36
HTTP_X_REQUESTED_WITH: XMLHttpRequest
HTTP_X_FORWARDED_PORT: 443
HTTP_X_FORWARDED_PROTO: https
SERVER_NAME: www.chibitxt.me
SERVER_PORT: 443
PATH_INFO: /sidekiq/busy
puma_socket: #
rack_hijack?: true
rack_hijack: #
rack_url_scheme: http
rack_after_reply: []
puma_config: #
ORIGINAL_FULLPATH: /sidekiq/busy
ORIGINAL_SCRIPT_NAME:
action_dispatch_parameter_filter: ["password"]
action_dispatch_redirect_filter: []
action_dispatch_show_exceptions: true
action_dispatch_show_detailed_exceptions: false
action_dispatch_cookies_serializer: json
action_dispatch_cookies_digest:
ROUTES_70311391045720_SCRIPT_NAME:
action_dispatch_request_id: f5606ffc-e720-42db-88c7-835b6edd0b33
action_dispatch_remote_ip: 115.178.26.244
rack_request_query_string:
rack_request_query_hash:
@dwilkie
Copy link
Owner Author

dwilkie commented Jul 11, 2015

http://stackoverflow.com/questions/13640871/heroku-psql-fatal-remaining-connection-slots-are-reserved-for-non-replication

Check max connections

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@dwilkie