Issue #4004 has been updated by Tudor Georgescu.
Thought I'd re-format the SQL.
<pre><code class="sql">
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
</code></pre>
----------------------------------------
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.
