ruby on rails - Heroku "connection limit exceeded for non-superusers" -

-

i using free heroku plan shared database. cedar stack, rails 3.1.0.rc4.

when launching application error, breaks process , disappears after random push:

2011-07-21t08:36:17+00:00 heroku[web.1]: starting process command: bundle exec rails server -p 11382 thin 2011-07-21t08:36:23+00:00 app[web.1]: => booting thin 2011-07-21t08:36:23+00:00 app[web.1]: => rails 3.1.0.rc4 application starting in production on http://0.0.0.0:11382 2011-07-21t08:36:23+00:00 app[web.1]: => call -d detach 2011-07-21t08:36:23+00:00 app[web.1]: => ctrl-c shutdown server 2011-07-21t08:36:23+00:00 app[web.1]: exiting 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:987:in initialize': fatal: connection limit exceeded non-superusers (pgerror) 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:987:in new' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:987:in connect' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:260:in initialize' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:27:in new' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:27:in postgresql_connection' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in new_connection' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/connection_pool.rb:302:in checkout_new_connection' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/connection_pool.rb:254:in block (2 levels) in checkout' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/connection_pool.rb:250:in loop' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/connection_pool.rb:250:in block in checkout' 2011-07-21t08:36:23+00:00 app[web.1]: /usr/local/lib/ruby/1.9.1/monitor.rb:201:inmon_synchronize' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/connection_pool.rb:249:in checkout' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/connection_pool.rb:151:in con

2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/connection_pool.rb:388:in retrieve_connection' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/connection_specification.rb:107:in retrieve_connection' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/connection_specification.rb:89:in connection' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/base.rb:704:in table_exists?' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/base.rb:789:in attribute_names' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/actionpack-3.1.0.rc4/lib/action_controller/metal/params_wrapper.rb:169:in _set_wrapper_defaults' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/actionpack-3.1.0.rc4/lib/action_controller/metal/params_wrapper.rb:129:in inherited' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/actionpack-3.1.0.rc4/lib/abstract_controller/railties/routes_helpers.rb:7:in block (2 levels) in with' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/actionpack-3.1.0.rc4/lib/action_controller/railties/paths.rb:7:in block (2 levels) in with' 2011-07-21t08:36:23+00:00 app[web.1]: /app/app/controllers/customers_controller.rb:1:in' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/dependencies.rb:237:in require' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/dependencies.rb:237:in block in require' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/dependencies.rb:225:in load_dependency' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/dependencies.rb:237:in require' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/dependencies.rb:344:in require_or_load' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/dependencies.rb:298:in depend_on' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/dependencies.rb:214:in require_dependency' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/engine.rb:399:in block (2 levels) in eager_load!' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/engine.rb:398:in each' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/engine.rb:398:in block in eager_load!' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/engine.rb:396:in each' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/engine.rb:396:in eager_load!' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/application.rb:83:in eager_load!' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/application/finisher.rb:51:in block in ' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/initializable.rb:25:in instance_exec' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/initializable.rb:25:in run' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/initializable.rb:50:in block in run_initializers' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/initializable.rb:49:in each' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/initializable.rb:49:in run_initializers' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/application.rb:96:in initialize!' 2011-07-21t08:36:23+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/railtie/configurable.rb:30:in method_missing' 2011-07-21t08:36:23+00:00 app[web.1]: /app/config/environment.rb:5:in' 2011-07-21t08:36:23+00:00 app[web.1]: /app/config.ru:4:in `block in ' 2011-07-21t08:36:23+00:00 heroku[web.1]: process exited 2011-07-21t08:36:24+00:00 heroku[web.1]: state changed starting crashed 2011-07-21t08:36:24+00:00 heroku[router]: error h10 (app crashed) -> dyno= queue= wait= service= status=503 bytes= 2011-07-21t08:36:25+00:00 heroku[router]: error h10

i don't see piece of own code in message.

that's postgresql error messsage when have more connections specified in max_connections setting in postgresql.conf. unless can change yourself, you'll have contact heroku support.


Comments

Post a Comment

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

-
my group , running server based upon django , uses mod_wsgi run apache server. not working on project after over, attempting set cronjob similar functionality check if apache server has shut down(system restart or power failure), , if has, restart server me. i've found documentation on how check if apache server down , restart server if is, our server uses https , our start command pretty verbose. can use functionality provided in these examples: https://askubuntu.com/questions/277389/cron-job-to-restart-apache https://www.digitalocean.com/community/tutorials/how-to-use-a-simple-bash-script-to-restart-server-programs or need more complicated process make happen? the command use start server is python manage.py runmodwsgi --host 0.0.0.0 --port 8001 --https-port 8000 --ssl-certificate (certificate location) --server-name (domain name) i'm pretty new linux , using both mod-wsgi apache appreciated. you better off using --setup-only option mod_wsgi-expres
Read more

actionscript 3 - TweenLite does not work with object -

-
i got following problem: i have object called tempscore game. this object blitted canvas renderer via copypixels method. object not display object. it's score-object (self made). score-object extends object called basicblitarrayobject. basicblitarrayobject extends eventdispatcher (therefore no display object). i tried apply several different tweenlite-plugins tempscore-object (i.e. transformaroundcenter, colormatrixfilter, etc.). nothing happens. absolutely nothing. sometimes error messages (when plugin requires display object , object not display object). far good. according greensock (maker of tweenlite) engine can tween numeric property of object. when plugin transformaroundcenter requires display object tweening have modify plugin working non-display object (tempscore). can't because it's way hard me. my game rests upon code: http://www.8bitrocket.com/book/ch11_blastermines.zip try apply tweenlite object called tempmine inside game class blastermines.
Read more

jQuery Ajax Render Fragments OR Whole Page -

-
i'm in throes of building application wraps mess of legacy code. page working on, need substitute fragment divs constructed on back-end -- or else need replace entire page altogether. idea there dynamically controlled flow needs satisfied before can forward legacy product. substituting fragments works fine, seen in below my_body_content swap. trouble comes when i'm trying render not fragment, whole page, in "body" swap. @ point page goes blank. i want similar errors returned server. want nice rest 404 error messages displayed on screen, legacy-product 404s show in legacy-product 404 page. yes, requirements project weird. that's not problem can fix. here's jquery invocation, names changed protect guilty: $.ajax({ url: "places/things", type: "post", data: json.stringify(somebadassobject), datatype: "text", accepts: "text/html", contenttype: "application/json; charset=
Read more