Skip to content

Instantly share code, notes, and snippets.

@richdownie

richdownie/gist:351760

Created April 1, 2010 12:49
Show Gist options
  • Save richdownie/351760 to your computer and use it in GitHub Desktop.
Save richdownie/351760 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Apr 01 12:49:03 --
Processing IssuesController#dashboard (for 74.220.158.207 at 2010-04-01 12:49:03) [GET]
Apr 01 12:49:03 -- Person Load (0.3ms) SELECT * FROM "people" WHERE ("people"."id" = 1) ORDER BY id asc LIMIT 1
Apr 01 12:49:03 -- IssueType Load (0.2ms) SELECT * FROM "issue_types" WHERE ("issue_types"."id" = 23) ORDER BY name LIMIT 1
Apr 01 12:49:03 -- CommunityMembership Load (0.3ms) SELECT * FROM "memberships" WHERE ("memberships"."person_id" = 1 AND "memberships"."community_id" = 1 AND "memberships"."role_id" = 9) AND ( ("memberships"."type" = 'CommunityMembership' ) )
Apr 01 12:49:03 -- Rendering template within layouts/cs_skin
Apr 01 12:49:03 -- Rendering issues/dashboard
Apr 01 12:49:03 -- SQL (0.3ms) SELECT count(*) AS count_all FROM "memberships" WHERE ("memberships".person_id = 1) AND ( ("memberships"."type" = 'WorkspaceMembership' ) )
Apr 01 12:49:03 -- IssueType Load (0.2ms) SELECT * FROM "issue_types" ORDER BY name
Apr 01 12:49:03 -- UploadedFile Load (0.3ms) SELECT * FROM "uploaded_files" WHERE ("uploaded_files"."id" = 1)
Apr 01 12:49:03 -- CommunityFooterPref Load (0.3ms) SELECT * FROM "community_footer_prefs" WHERE ("community_footer_prefs".community_id = 1) ORDER BY id
Apr 01 12:49:03 -- Completed in 84ms (View: 73, DB: 6) | 200 OK [https://qaauto.rollstream.com/issues_dashboard]
Apr 01 12:49:03 --
Processing CommunitiesController#logo (for 74.220.158.207 at 2010-04-01 12:49:03) [GET]
Apr 01 12:49:03 -- Parameters: {"1264610190"=>nil}
Apr 01 12:49:04 -- Person Load (0.3ms) SELECT * FROM "people" WHERE ("people"."id" = 1) ORDER BY id asc LIMIT 1
Apr 01 12:49:04 -- UploadedFile Load (0.2ms) SELECT * FROM "uploaded_files" WHERE ("uploaded_files"."id" = 1)
Apr 01 12:49:04 -- DbFile Load (113.5ms) SELECT * FROM "db_files" WHERE ("db_files"."id" = 1)
Apr 01 12:49:04 -- Completed in 284ms (View: 1, DB: 115) | 200 OK [https://qaauto.rollstream.com/communities/logo?1264610190]
Apr 01 12:49:04 --
Processing IssuesController#dashboard_li_count (for 74.220.158.207 at 2010-04-01 12:49:04) [GET]
Apr 01 12:49:04 -- Parameters: {"issue_type_id"=>"23", "start_range"=>"Wed Apr 01 12:49:03 +0000 2009", "end_range"=>"Thu Apr 01 12:49:03 +0000 2010"}
Apr 01 12:49:04 -- Person Load (0.3ms) SELECT * FROM "people" WHERE ("people"."id" = 1) ORDER BY id asc LIMIT 1
Apr 01 12:49:04 -- IssueType Load (0.3ms) SELECT * FROM "issue_types" WHERE ("issue_types"."id" = 23) ORDER BY name LIMIT 1
Apr 01 12:49:04 -- CommunityMembership Load (0.4ms) SELECT * FROM "memberships" WHERE ("memberships"."person_id" = 1 AND "memberships"."community_id" = 1 AND "memberships"."role_id" = 9) AND ( ("memberships"."type" = 'CommunityMembership' ) )
Apr 01 12:49:04 -- LineItem Load (0.0ms) PGError: ERROR: syntax error at or near "total_items"
LINE 1: ...created_at) as year, count(line_items.created_at) total_item...
^
: SELECT DATE_PART('month', line_items.created_at) as month, DATE_PART('year', line_items.created_at) as year, count(line_items.created_at) total_items FROM "line_items" LEFT OUTER JOIN "issues" ON "issues".id = "line_items".issue_id WHERE (("line_items"."created_at" BETWEEN '2009-04-01 00:00:00.000000' AND '2010-04-01 23:59:59.999999' AND "issues"."issue_type_id" = 23)) group by year, month order by year DESC, month DESC;
Apr 01 12:49:04 --
ActiveRecord::StatementInvalid (PGError: ERROR: syntax error at or near "total_items"
LINE 1: ...created_at) as year, count(line_items.created_at) total_item...
^
: SELECT DATE_PART('month', line_items.created_at) as month, DATE_PART('year', line_items.created_at) as year, count(line_items.created_at) total_items FROM "line_items" LEFT OUTER JOIN "issues" ON "issues".id = "line_items".issue_id WHERE (("line_items"."created_at" BETWEEN '2009-04-01 00:00:00.000000' AND '2010-04-01 23:59:59.999999' AND "issues"."issue_type_id" = 23)) group by year, month order by year DESC, month DESC;):
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/instrumentation/active_record_instrumentation.rb:52:in `log'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:62:in `trace_method_execution_with_scope'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/instrumentation/active_record_instrumentation.rb:50:in `log'
config/initializers/query_caching.rb:12:in `cache_sql'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:161:in `find_by_sql'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:62:in `trace_method_execution_with_scope'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:160:in `find_by_sql'
app/models/line_item.rb:256:in `get_counts_by_issue_type_and_status_and_range'
lib/chartable_issues.rb:141:in `data_line_for_status_and_range'
lib/chartable_issues.rb:84:in `aggregate_data_lines_for_status_and_range'
lib/chartable_issues.rb:83:in `each'
lib/chartable_issues.rb:83:in `aggregate_data_lines_for_status_and_range'
app/controllers/issues_controller.rb:145:in `dashboard_li_count'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:138:in `perform_action'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:62:in `trace_method_execution_with_scope'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:122:in `perform_action'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:38:in `trace_method_execution_no_scope'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:117:in `perform_action'
haml (2.2.1) lib/sass/plugin/rails.rb:19:in `process'
passenger (2.2.9) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request'
passenger (2.2.9) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
passenger (2.2.9) lib/phusion_passenger/railz/application_spawner.rb:400:in `start_request_handler'
passenger (2.2.9) lib/phusion_passenger/railz/application_spawner.rb:351:in `handle_spawn_application'
passenger (2.2.9) lib/phusion_passenger/utils.rb:184:in `safe_fork'
passenger (2.2.9) lib/phusion_passenger/railz/application_spawner.rb:349:in `handle_spawn_application'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:163:in `start'
passenger (2.2.9) lib/phusion_passenger/railz/application_spawner.rb:209:in `start'
passenger (2.2.9) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
passenger (2.2.9) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
passenger (2.2.9) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
passenger (2.2.9) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
passenger (2.2.9) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
passenger (2.2.9) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
passenger (2.2.9) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
passenger (2.2.9) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
Apr 01 12:49:04 -- Rendered rescues/_trace (38.9ms)
Apr 01 12:49:04 -- Rendered rescues/_request_and_response (0.4ms)
Apr 01 12:49:04 -- Rendering rescues/layout (internal_server_error)
Apr 01 12:49:04 --
Processing IssuesController#dashboard_resolution_count (for 74.220.158.207 at 2010-04-01 12:49:04) [GET]
Apr 01 12:49:04 -- Parameters: {"issue_type_id"=>"23", "start_range"=>"Wed Apr 01 12:49:03 +0000 2009", "end_range"=>"Thu Apr 01 12:49:03 +0000 2010"}
Apr 01 12:49:04 -- Person Load (0.4ms) SELECT * FROM "people" WHERE ("people"."id" = 1) ORDER BY id asc LIMIT 1
Apr 01 12:49:04 -- IssueType Load (0.2ms) SELECT * FROM "issue_types" WHERE ("issue_types"."id" = 23) ORDER BY name LIMIT 1
Apr 01 12:49:04 -- CommunityMembership Load (0.3ms) SELECT * FROM "memberships" WHERE ("memberships"."person_id" = 1 AND "memberships"."community_id" = 1 AND "memberships"."role_id" = 9) AND ( ("memberships"."type" = 'CommunityMembership' ) )
Apr 01 12:49:04 -- LineItem Load (0.0ms) PGError: ERROR: syntax error at or near "total_items"
LINE 1: ...created_at) as year, count(line_items.created_at) total_item...
^
: SELECT DATE_PART('month', line_items.created_at) as month, DATE_PART('year', line_items.created_at) as year, count(line_items.created_at) total_items FROM "line_items" LEFT OUTER JOIN "issues" ON "issues".id = "line_items".issue_id WHERE (("line_items"."created_at" BETWEEN '2009-04-01 00:00:00.000000' AND '2010-04-01 23:59:59.999999' AND "issues"."issue_type_id" = 23)) group by year, month order by year DESC, month DESC;
Apr 01 12:49:04 --
ActiveRecord::StatementInvalid (PGError: ERROR: syntax error at or near "total_items"
LINE 1: ...created_at) as year, count(line_items.created_at) total_item...
^
: SELECT DATE_PART('month', line_items.created_at) as month, DATE_PART('year', line_items.created_at) as year, count(line_items.created_at) total_items FROM "line_items" LEFT OUTER JOIN "issues" ON "issues".id = "line_items".issue_id WHERE (("line_items"."created_at" BETWEEN '2009-04-01 00:00:00.000000' AND '2010-04-01 23:59:59.999999' AND "issues"."issue_type_id" = 23)) group by year, month order by year DESC, month DESC;):
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/instrumentation/active_record_instrumentation.rb:52:in `log'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:62:in `trace_method_execution_with_scope'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/instrumentation/active_record_instrumentation.rb:50:in `log'
config/initializers/query_caching.rb:12:in `cache_sql'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:161:in `find_by_sql'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:62:in `trace_method_execution_with_scope'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:160:in `find_by_sql'
app/models/line_item.rb:272:in `get_totals_by_issue_type_and_range'
lib/chartable_issues.rb:102:in `data_line_for_total_items'
app/controllers/issues_controller.rb:162:in `dashboard_resolution_count'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:138:in `perform_action'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:62:in `trace_method_execution_with_scope'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:122:in `perform_action'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/method_tracer.rb:38:in `trace_method_execution_no_scope'
/opt/ree/lib/ruby/gems/1.8/gems/newrelic_rpm-2.9.5/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:117:in `perform_action'
haml (2.2.1) lib/sass/plugin/rails.rb:19:in `process'
passenger (2.2.9) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request'
passenger (2.2.9) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
passenger (2.2.9) lib/phusion_passenger/railz/application_spawner.rb:400:in `start_request_handler'
passenger (2.2.9) lib/phusion_passenger/railz/application_spawner.rb:351:in `handle_spawn_application'
passenger (2.2.9) lib/phusion_passenger/utils.rb:184:in `safe_fork'
passenger (2.2.9) lib/phusion_passenger/railz/application_spawner.rb:349:in `handle_spawn_application'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:163:in `start'
passenger (2.2.9) lib/phusion_passenger/railz/application_spawner.rb:209:in `start'
passenger (2.2.9) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
passenger (2.2.9) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
passenger (2.2.9) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
passenger (2.2.9) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
passenger (2.2.9) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
passenger (2.2.9) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
passenger (2.2.9) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
passenger (2.2.9) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
passenger (2.2.9) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
Apr 01 12:49:04 -- Rendered rescues/_trace (35.4ms)
Apr 01 12:49:04 -- Rendered rescues/_request_and_response (0.4ms)
Apr 01 12:49:04 -- Rendering rescues/layout (internal_server_error)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment