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

iphone - Using nested NSDictionary with Picker -

-
newbie here, i have single component picker set plist, each item being array, multiple strings in each array app uses. currently plist structure this: nsdictionary -> nsarray -> nsstring | | items in picker data each item but now, want: nsdictionary -> nsdictionary -> nsarray -> nsstring | | | different picker data sets items in picker data each item so there multiple sets of picker components show using segmented control etc... i'm not sure if possible, , hoping save me making many different separate picker controllers. what has me stumped getting ingested properly this have now, builds crashes (debug info below): nsbundle *bundle = [nsbundle mainbundle]; nsstring *plistpath = [bundle pathforresource:@"camerasdatabase" oftype:@"plist"]; nsdictionary *dictionary = [[nsdictionary alloc] initwithcontentsoffi...
Read more

php - accessing mysql using different server to which db connection data is located -

-
i'm trying include file db connection info (hostname password username). this have far: include ('http://site.com/config35sdf322e54353452d/wp2154654315634652132513546541564.php'); mysql_connect($hostname,$username,$password); @mysql_select_db($dbname) or die( "unable select database"); include ('../refference.php'); $select = mysql_query("select my_field $usertable ". "gdi_username = '$sponsor_gdi_id' , unique_id = '$sponsor_refference'"); while($check = mysql_fetch_array($select)) { $sponsor_email = $check["email"]; $sponsor = $check["gdi_username"]; $sponsor_first_nme = $check["first_name"]; $sponsor_second_nme = $check["last_name"]; $sponsor_domain = $check["gdi_domain"]; $unq_id = $check["unique_id"]; } $sponsor_name = "$sponsor_first_nme $sponsor_second_nme"; echo "$sponsor $hostname" ?> i err...
Read more

javascript - Iterate over array and calculate average values of array-parts -

-
i have array this: ["2011-06-16 16:37:20",23.2], ["2011-06-21 16:37:20",35.6], ["2011-06-26 16:37:20",41.8], ["2011-07-01 16:37:20",25], ["2011-07-06 16:37:20",22.8], ["2011-07-11 16:37:20",36.4], ["2011-07-16 16:37:20",34], ["2011-07-21 16:37:20",20] [...] format: [$date,count] now need add 3rd 4th value every array element, average of n counts before or after. example if n=3 the 3rd value should average of 3 count-values before , 4th value should average of 3 count-values after current array element. result that: ["2011-06-16 16:37:20",23.2, null, 34.13], ["2011-06-21 16:37:20",35.6, null, 29.86], ["2011-06-26 16:37:20",41.8, null, 28.06], ["2011-07-01 16:37:20",25, 33.53, 31.06], ["2011-07-06 16:37:20",22.8, 34.13, 30.13], ["2011-07-11 16:37:20",36.4, 29.86, null], ["2011-07-16 16:37:20",34, 28.06, null], ["2...
Read more