Issue #4004 has been reported by Tudor Georgescu. ---------------------------------------- Bug #4004: Possbile bug in summation http://projects.puppetlabs.com/issues/4004
Author: Tudor Georgescu Status: Unreviewed Priority: High Assigned to: Category: Target version: 1.0 Keywords: Branch: Affected URL: Followed dashboard installation instructions as per: http://zcentric.com/2010/03/11/install-puppet-dashboard-on-redhatcentos-5/ When attempting to connect to http://host:3000 via FF i get: ActiveRecord::StatementInvalid in PagesController#home PGError: ERROR: function sum(boolean) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. : SELECT COUNT(*) - SUM(success) as failed, COUNT(*) as total, SUM(success) / COUNT(*) * 100 as percent, FROM_UNIXTIME(FLOOR(UNIX_TIMESTAMP(time) / 86400) * 86400) as start FROM reports GROUP BY FLOOR(UNIX_TIMESTAMP(time) / 86400) ORDER BY time DESC LIMIT 30 RAILS_ROOT: /opt/puppet-dashboard Application Trace | Framework Trace | Full Trace /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:550:in `execute' /opt/puppet-dashboard/app/models/status.rb:61:in `execute' /opt/puppet-dashboard/app/models/status.rb:51:in `by_interval' /opt/puppet-dashboard/app/controllers/pages_controller.rb:3:in `home' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:550:in `execute' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `send' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `perform_action_without_filters' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/filters.rb:617:in `call_filters' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue' /opt/puppet-dashboard/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms' /opt/puppet-dashboard/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:10:in `realtime' /opt/puppet-dashboard/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/rescue.rb:160:in `perform_action_without_flash' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/flash.rb:146:in `perform_action' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `send' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `process_without_filters' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `sass_old_process' /opt/puppet-dashboard/vendor/gems/haml-2.2.2/lib/sass/plugin/rails.rb:19:in `process' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:391:in `process' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:386:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/routing/route_set.rb:437:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:87:in `dispatch' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:121:in `_call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:130:in `build_middleware_stack' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/query_cache.rb:9:in `cache' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/query_cache.rb:28:in `call' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/head.rb:9:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/methodoverride.rb:24:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/params_parser.rb:15:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/session/cookie_store.rb:93:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/failsafe.rb:26:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call' /usr/lib/ruby/1.8/thread.rb:135:in `synchronize' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:114:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/reloader.rb:34:in `run' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:108:in `call' /opt/puppet-dashboard/vendor/rails/railties/lib/rails/rack/static.rb:31:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:46:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in `each' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in `call' /opt/puppet-dashboard/vendor/rails/railties/lib/rails/rack/log_tailer.rb:17:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/content_length.rb:13:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/handler/webrick.rb:50:in `service' /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' /usr/lib/ruby/1.8/webrick/server.rb:162:in `start' /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' /usr/lib/ruby/1.8/webrick/server.rb:95:in `start' /usr/lib/ruby/1.8/webrick/server.rb:92:in `each' /usr/lib/ruby/1.8/webrick/server.rb:92:in `start' /usr/lib/ruby/1.8/webrick/server.rb:23:in `start' /usr/lib/ruby/1.8/webrick/server.rb:82:in `start' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/handler/webrick.rb:14:in `run' /opt/puppet-dashboard/vendor/rails/railties/lib/commands/server.rb:111 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require' /opt/puppet-dashboard/script/server:3 /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:550:in `execute' /opt/puppet-dashboard/app/models/status.rb:61:in `execute' /opt/puppet-dashboard/app/models/status.rb:51:in `by_interval' /opt/puppet-dashboard/app/controllers/pages_controller.rb:3:in `home' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `send' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `perform_action_without_filters' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/filters.rb:617:in `call_filters' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue' /opt/puppet-dashboard/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms' /opt/puppet-dashboard/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:10:in `realtime' /opt/puppet-dashboard/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/rescue.rb:160:in `perform_action_without_flash' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/flash.rb:146:in `perform_action' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `send' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `process_without_filters' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `sass_old_process' /opt/puppet-dashboard/vendor/gems/haml-2.2.2/lib/sass/plugin/rails.rb:19:in `process' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:391:in `process' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/base.rb:386:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/routing/route_set.rb:437:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:87:in `dispatch' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:121:in `_call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:130:in `build_middleware_stack' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/query_cache.rb:9:in `cache' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/query_cache.rb:28:in `call' /opt/puppet-dashboard/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/head.rb:9:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/methodoverride.rb:24:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/params_parser.rb:15:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/session/cookie_store.rb:93:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/failsafe.rb:26:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call' /usr/lib/ruby/1.8/thread.rb:135:in `synchronize' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:114:in `call' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/reloader.rb:34:in `run' /opt/puppet-dashboard/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:108:in `call' /opt/puppet-dashboard/vendor/rails/railties/lib/rails/rack/static.rb:31:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:46:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in `each' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in `call' /opt/puppet-dashboard/vendor/rails/railties/lib/rails/rack/log_tailer.rb:17:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/content_length.rb:13:in `call' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/handler/webrick.rb:50:in `service' /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' /usr/lib/ruby/1.8/webrick/server.rb:162:in `start' /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' /usr/lib/ruby/1.8/webrick/server.rb:95:in `start' /usr/lib/ruby/1.8/webrick/server.rb:92:in `each' /usr/lib/ruby/1.8/webrick/server.rb:92:in `start' /usr/lib/ruby/1.8/webrick/server.rb:23:in `start' /usr/lib/ruby/1.8/webrick/server.rb:82:in `start' /opt/puppet-dashboard/vendor/gems/rack-1.0.1/lib/rack/handler/webrick.rb:14:in `run' /opt/puppet-dashboard/vendor/rails/railties/lib/commands/server.rb:111 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require' /opt/puppet-dashboard/script/server:3 Request Parameters: None Show session dump --- Response Headers: {"Content-Type"=>"", "Cache-Control"=>"no-cache"} -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://projects.puppetlabs.com/my/account -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/puppet-bugs?hl=en.
