Bug #2634: Eventful reports - route error - Foreman

Actions

Copy link

Bug #2634

closed

Eventful reports - route error

Added by Lex Rivera almost 11 years ago. Updated almost 7 years ago.

Status:

Resolved

Priority:

Normal

Assignee:

Category:

Reporting

Target version:

Difficulty:

Triaged:

Bugzilla link:

Pull request:

Fixed in Releases:

Found in Releases:

Red Hat JIRA:

Description

On 1.2-RC1 tag, trying to open eventful reports (just clicking on "reports"):
ActionController::RoutingError
No route matches {:host_id=>nil, :controller=>"reports"}
app/views/reports/_list.html.erb:18:in `_app_views_reports__list_html_erb___130845487__633955468'
app/views/reports/_list.html.erb:15:in `_app_views_reports__list_html_erb___130845487__633955468'
app/views/reports/index.html.erb:3:in `_app_views_reports_index_html_erb__916748500__633902068'
lib/foreman/thread_session.rb:31:in `clear_thread'

Actions

Copy link

Updated by Joseph Magen almost 11 years ago

Status changed from New to Assigned
Assignee set to Joseph Magen

Actions

Copy link

Updated by Joseph Magen almost 11 years ago

Status changed from Assigned to Need more information

I can't duplicate this bug. Can yo provide more information how/when it happens?

Actions

Copy link

Updated by Lex Rivera almost 11 years ago

I updated 1.1 to 1.2.0-RC1 tag and after that i see that error.

Actions

Copy link

Updated by Joseph Magen almost 11 years ago

Lex, I still don't get the error when I checkout the 1.2.0-RC1 tag
Checkout the 1.2.0-RC2 tag and see if the error still exists.

The only thing that I can think of is that there is some invalid data in your database causing this. I'm kind of stumped.

Actions

Copy link

Updated by Lex Rivera almost 11 years ago

Seems like this was something in my database causing this. Cleaned it, updated to 1.2.0-RC2 and everything works now. Thanks.

Actions

Copy link

Updated by Joseph Magen almost 11 years ago

Status changed from Need more information to Closed

Great. Thanks for the update. I'm closing this ticket.

Actions

Copy link

Updated by David Blank-Edelman almost 11 years ago

I'm sorry to ask for a re-opening of this issue, but I'm seeing the same thing with an upgrade from 1.1.1 to 1.2 via the Ubuntu packages on a Postgres backed install. Here's the error I'm seeing:

ActionController::RoutingError
No route matches {:controller=>"reports", :host_id=>nil}
app/views/reports/_list.html.erb:18:in `_app_views_reports__list_html_erb__1229755230_70302029736140'
app/views/reports/_list.html.erb:15:in `_app_views_reports__list_html_erb__1229755230_70302029736140'
app/views/reports/index.html.erb:3:in `_app_views_reports_index_html_erb__409991220_70302029747820'
lib/foreman/thread_session.rb:31:in `clear_thread'

and in the logs:

Started GET "/reports?search=eventful+%3D+true" for XX.XXX.XX.XXX at Tue Jul 02 23:42:08 -0400 2013
Processing by ReportsController#index as HTML
  Parameters: {"search"=>"eventful = true"}
  Rendered reports/_list.html.erb (271.3ms)
  Rendered reports/index.html.erb within layouts/application (271.8ms)
Operation FAILED: No route matches {:controller=>"reports", :host_id=>nil}
  Rendered common/500.html.erb within layouts/application (2.9ms)
Completed 500 Internal Server Error in 284ms (Views: 5.2ms | ActiveRecord: 39.6ms)

I'm more than willing to believe it is something in the db (and I'm willing to provide a dump if that helps), but I'm afraid I don't know what Lex means by "Cleaned it" (would prefer not to drop all of the data if I can).

Any ideas on how to go about debugging this? Thanks!

Actions

Copy link

Updated by Joseph Magen almost 11 years ago

Status changed from Closed to Assigned

I still can't reproduce the error. I thought it may be if there is an orphaned foreign key, where there is a report with host_id that doesn't exist.

Here is my log.

Started GET "/reports?search=eventful+%3D+true" for 127.0.0.1 at 2013-07-03 09:54:27 +0300
Processing by ReportsController#index as HTML
  Parameters: {"search"=>"eventful = true"}
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
   (0.3ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization')
Setting current organization thread-local variable to none
   (0.2ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location')
  Location Load (0.2ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."id" = $1 ORDER BY type, name LIMIT 1  [["id", 3]]
Setting current location thread-local variable to TLV
   (0.2ms)  SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
   (0.1ms)  SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') LIMIT 1
  Report Load (0.2ms)  SELECT "reports".* FROM "reports" LIMIT 1
   (0.3ms)  SELECT "hosts"."id" FROM "hosts" WHERE "hosts"."location_id" IN (3) AND "hosts"."type" IN ('Host::Managed')
  Report Load (10.5ms)  SELECT "reports".* FROM "reports" WHERE "reports"."host_id" IN (179, 183, 194, 197, 199, 541, 661, 846, 847, 853, 858, 860, 866, 873, 878, 879, 880, 906, 914, 916, 917, 918, 871, 857, 182, 920, 921, 444, 394) AND (((("reports"."status" >> 0 & 16777215) > 0))) ORDER BY "reports"."reported_at" DESC NULLS LAST LIMIT 20 OFFSET 0
  Host::Managed Load (0.4ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."location_id" IN (3) AND "hosts"."type" IN ('Host::Managed') AND "hosts"."id" IN (194, 197, 394)
   (9.2ms)  SELECT COUNT(*) FROM "reports" WHERE "reports"."host_id" IN (179, 183, 194, 197, 199, 541, 661, 846, 847, 853, 858, 860, 866, 873, 878, 879, 880, 906, 914, 916, 917, 918, 871, 857, 182, 920, 921, 444, 394) AND (((("reports"."status" >> 0 & 16777215) > 0)))
  Rendered reports/_list.html.erb (54.2ms)
  Rendered reports/index.html.erb within layouts/application (54.7ms)
  Rendered home/_user_dropdown.html.erb (1.0ms)
  CACHE (0.0ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization')
  Organization Load (0.7ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') ORDER BY type, name
  Rendered home/_organization_dropdown.html.erb (3.3ms)
  CACHE (0.0ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location')
  Location Load (0.3ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') ORDER BY type, name

Did you cut out some lines in your log?

Actions

Copy link

Updated by Joseph Magen almost 11 years ago

Target version changed from 1.2.0 to 1.2.1

Actions

Copy link

#10

Updated by David Blank-Edelman almost 11 years ago

Thanks for looking into this. The log lines are exactly as I pasted them.

I see no SQL statements reported in them, though it is entirely possible my logging is not sufficiently cranked up. If you tell me what SQL to run to check for the foreign key condition and/or what to set to bring it to the same debugging level, I'm happy to do both and provide the info.

Actions

Copy link

#11

Updated by Dominic Cleal almost 11 years ago

David, check this page for info on enabling full debug logs:
http://projects.theforeman.org/wiki/foreman/Troubleshooting#How-do-I-enable-debugging

It should then log SQL queries too.

Actions

Copy link

#12

Updated by David Blank-Edelman almost 11 years ago

Thanks for the debug pointer.

(slept for some hours)...made the config change...bounced nginx...and....

no sign of the bug. Change back to info level, restart nginx, and still no sign.

I couldn't tell you what made this heisenbug go away. My first guess is overnight the right host checked in and inserted data that made the condition go away.

At least now I know how to throw things into debugging mode should I see this return. I guess we can go back to leaving this bug closed, sigh. Thanks again!

Actions

Copy link

#13

Updated by Dominic Cleal almost 11 years ago

Category set to Reporting
Status changed from Assigned to Closed
Target version deleted (~~1.2.1~~)

Thanks for confirming David. If it happens again, let us know!

Actions

Copy link

#14

Updated by Joseph Magen almost 11 years ago

David, I created an orphaned foreign key and there was no error, so it must be something else.

Actions

Copy link

#15

Updated by Peter Gustafsson almost 11 years ago

Hi,

I'm having the same issue using foreman 1.2 stable and postgreSQL.

Here is my log:

Started GET "/" for 10.77.12.65 at 2013-07-05 10:13:54 +0200
Processing by DashboardController#index as HTML
  User Load (0.6ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
   (0.7ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization')
Setting current organization thread-local variable to none
   (0.6ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location')
Setting current location thread-local variable to none
   (0.6ms)  SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
   (0.6ms)  SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') LIMIT 1
  Host::Managed Load (1.1ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') LIMIT 1
   (0.7ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed')
   (0.8ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (last_report > '2013-07-05 07:38:54.883906') AND ((puppet_status > 0) and
 ( ((puppet_status >> 12 & 63) != 0) or
 ((puppet_status >> 18 & 63) != 0) ))
   (0.8ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (last_report > '2013-07-05 07:38:54.887775') AND ((puppet_status > 0) and
 ( ((puppet_status >> 12 & 63) != 0) or
 ((puppet_status >> 18 & 63) != 0) )) AND (enabled = 't')
   (0.8ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (last_report > '2013-07-05 07:38:54.891636') AND ((puppet_status > 0) and
 ( ((puppet_status >> 0 & 63) != 0) or
 ((puppet_status >> 6 & 63) != 0) ))
   (0.9ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (last_report > '2013-07-05 07:38:54.895193') AND ((puppet_status > 0) and
 ( ((puppet_status >> 0 & 63) != 0) or
 ((puppet_status >> 6 & 63) != 0) )) AND (((puppet_status >> 12 & 63) = 0) and
 ((puppet_status >> 18 & 63) = 0))
   (0.9ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (last_report > '2013-07-05 07:38:54.898864') AND ((puppet_status > 0) and
 ( ((puppet_status >> 0 & 63) != 0) or
 ((puppet_status >> 6 & 63) != 0) )) AND (((puppet_status >> 12 & 63) = 0) and
 ((puppet_status >> 18 & 63) = 0)) AND (enabled = 't')
   (4.8ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (last_report > '2013-07-05 07:38:54.902927') AND (((puppet_status >> 0 & 63) = 0) and
 ((puppet_status >> 6 & 63) = 0)) AND (((puppet_status >> 12 & 63) = 0) and
 ((puppet_status >> 18 & 63) = 0)) AND (((puppet_status >> 30 & 63) = 0))
   (1.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (last_report > '2013-07-05 07:38:54.911715') AND (((puppet_status >> 0 & 63) = 0) and
 ((puppet_status >> 6 & 63) = 0)) AND (((puppet_status >> 12 & 63) = 0) and
 ((puppet_status >> 18 & 63) = 0)) AND (((puppet_status >> 30 & 63) = 0)) AND (enabled = 't')
   (0.8ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (last_report < '2013-07-05 07:38:54.916890' and enabled != 'f')
   (0.8ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (last_report < '2013-07-05 07:38:54.919950' and enabled != 'f') AND (enabled = 't')
   (0.9ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (enabled = 'f')
   (0.8ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (last_report > '2013-07-05 07:38:54.925919') AND ((puppet_status > 0) and ((puppet_status >> 30 & 63) != 0))
   (0.8ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (last_report > '2013-07-05 07:38:54.929606') AND ((puppet_status > 0) and ((puppet_status >> 30 & 63) != 0)) AND (enabled = 't')
   (0.7ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (((NOT COALESCE("hosts"."last_report" IS NOT NULL, false)) AND (("hosts"."enabled" <> 'f'))))
  Rendered dashboard/_status_table.html.erb (6.6ms)
   (0.8ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "reports" WHERE (status != 0) AND (("reports"."reported_at" >= '2013-06-29')) LIMIT 6) subquery_for_count 
  Report Load (1.1ms)  SELECT "reports".* FROM "reports" WHERE (status != 0) AND (("reports"."reported_at" >= '2013-06-29')) ORDER BY "reports"."reported_at" DESC NULLS LAST LIMIT 6
  Host::Managed Load (0.9ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 18 LIMIT 1
  Host::Managed Load (1.0ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 14 LIMIT 1
  CACHE (0.0ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 18 LIMIT 1
  CACHE (0.0ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 18 LIMIT 1
  Host::Managed Load (0.9ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 33 LIMIT 1
  Rendered dashboard/index.html.erb within layouts/application (37.5ms)
Operation FAILED: No route matches {:controller=>"reports", :host_id=>nil}
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:532:in `raise_routing_error'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:528:in `rescue in generate'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:520:in `generate'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:561:in `generate'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:586:in `url_for'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/url_for.rb:148:in `url_for'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/helpers/url_helper.rb:107:in `url_for'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:213:in `host_reports_path'
/usr/share/foreman/app/views/dashboard/index.html.erb:27:in `block in _app_views_dashboard_index_html_erb___2341707709798967778_55020820'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/relation/delegation.rb:6:in `each'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/relation/delegation.rb:6:in `each'
/usr/share/foreman/app/views/dashboard/index.html.erb:25:in `_app_views_dashboard_index_html_erb___2341707709798967778_55020820'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/template.rb:145:in `block in render'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications.rb:125:in `instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/template.rb:143:in `render'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/renderer/template_renderer.rb:47:in `block (2 levels) in render_template'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/renderer/abstract_renderer.rb:38:in `block in instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications.rb:123:in `block in instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications.rb:123:in `instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/renderer/abstract_renderer.rb:38:in `instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/renderer/template_renderer.rb:46:in `block in render_template'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/renderer/template_renderer.rb:54:in `render_with_layout'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/renderer/template_renderer.rb:45:in `render_template'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/renderer/template_renderer.rb:18:in `render'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/renderer/renderer.rb:36:in `render_template'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_view/renderer/renderer.rb:17:in `render'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/rendering.rb:110:in `_render_template'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/streaming.rb:225:in `_render_template'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/rendering.rb:103:in `render_to_body'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/renderers.rb:28:in `render_to_body'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/compatibility.rb:50:in `render_to_body'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/rendering.rb:88:in `render'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/rendering.rb:16:in `render'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/instrumentation.rb:40:in `block (2 levels) in render'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/core_ext/benchmark.rb:5:in `block in ms'
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:295:in `realtime'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/core_ext/benchmark.rb:5:in `ms'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/instrumentation.rb:40:in `block in render'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/instrumentation.rb:83:in `cleanup_view_runtime'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/controller_runtime.rb:24:in `cleanup_view_runtime'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/instrumentation.rb:39:in `render'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/implicit_render.rb:10:in `default_render'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/mime_responds.rb:196:in `respond_to'
/usr/share/foreman/app/controllers/dashboard_controller.rb:6:in `index'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/base.rb:167:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/rendering.rb:10:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/callbacks.rb:18:in `block in process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:549:in `block (3 levels) in _run__1252528313113801285__process_action__118373899845998496__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_4539'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:326:in `around'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:310:in `_callback_around_917'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_4539'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:537:in `block (2 levels) in _run__1252528313113801285__process_action__118373899845998496__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_4538'
/usr/share/foreman/lib/foreman/thread_session.rb:31:in `clear_thread'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_4538'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:415:in `block in _run__1252528313113801285__process_action__118373899845998496__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_4537'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:326:in `around'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:310:in `_callback_around_13'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_4537'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:414:in `_run__1252528313113801285__process_action__118373899845998496__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:405:in `__run_callback'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:81:in `run_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/callbacks.rb:17:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/rescue.rb:29:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/instrumentation.rb:30:in `block in process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications.rb:123:in `block in instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications.rb:123:in `instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/instrumentation.rb:29:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/params_wrapper.rb:207:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/controller_runtime.rb:18:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/base.rb:121:in `process'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/rendering.rb:45:in `process'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal.rb:203:in `dispatch'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal.rb:246:in `block in action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:73:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:73:in `dispatch'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:36:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/journey-1.0.4/lib/journey/router.rb:68:in `block in call'
/opt/rh/ruby193/root/usr/share/gems/gems/journey-1.0.4/lib/journey/router.rb:56:in `each'
/opt/rh/ruby193/root/usr/share/gems/gems/journey-1.0.4/lib/journey/router.rb:56:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:600:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/apipie-rails-0.0.18/lib/apipie/static_dispatcher.rb:56:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/etag.rb:23:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/conditionalget.rb:25:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/head.rb:14:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/params_parser.rb:21:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/flash.rb:242:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/session/abstract/id.rb:205:in `context'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/session/abstract/id.rb:200:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/cookies.rb:339:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/query_cache.rb:64:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:473:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/callbacks.rb:28:in `block in call'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:405:in `_run__3117997350554980598__call__4525438644838438571__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:405:in `__run_callback'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:385:in `_run_call_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:81:in `run_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/callbacks.rb:27:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/rack/logger.rb:26:in `call_app'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/rack/logger.rb:16:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/request_id.rb:22:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/methodoverride.rb:21:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/runtime.rb:17:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/cache/strategy/local_cache.rb:72:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/lock.rb:15:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/static.rb:62:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:136:in `forward'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:245:in `fetch'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:185:in `lookup'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:66:in `call!'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:51:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/engine.rb:479:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/application.rb:223:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/railtie/configurable.rb:30:in `method_missing'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/builder.rb:134:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/urlmap.rb:64:in `block in call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/urlmap.rb:49:in `each'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/urlmap.rb:49:in `call'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.5/lib/phusion_passenger/rack/thread_handler_extension.rb:77:in `process_request'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.5/lib/phusion_passenger/request_handler/thread_handler.rb:140:in `accept_and_process_next_request'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.5/lib/phusion_passenger/request_handler/thread_handler.rb:108:in `main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.5/lib/phusion_passenger/request_handler.rb:441:in `block (3 levels) in start_threads'
  Rendered common/500.html.erb within layouts/application (6.0ms)
Completed 500 Internal Server Error in 126ms (Views: 10.6ms | ActiveRecord: 4.8ms)

Actions

Copy link

#16

Updated by Dominic Cleal almost 11 years ago

Status changed from Closed to Assigned

Actions

Copy link

#17

Updated by Dominic Cleal almost 11 years ago

I've looked at Peter's database and there are reports referencing a host_id that's non-existent, after the hosts were deleted via the web UI. It appears the reports aren't getting deleted for some reason when the host is destroyed. I can't replicate this behaviour at the moment, only the resulting error.

Actions

Copy link

#18

Updated by Dominic Cleal almost 11 years ago

It looks like the host delete initially failed as the VM was powered on (maybe #2704), and then was deleted a second time. There aren't debug logs for this period though so I'm not sure what happened to the DB.

This SQL query should work to delete orphaned reports and get rid of the error:

delete from reports where host_id not in (select id from hosts);

(for PostgreSQL, run sudo -u foreman psql to get a shell)

Actions

Copy link

#19

Updated by Joseph Magen almost 11 years ago

Description updated (diff)
Status changed from Assigned to Feedback
Assignee deleted (~~Joseph Magen~~)

Actions

Copy link

#20

Updated by Benjamin Papillon about 10 years ago

Hello,

Can you provide feedback regarding this issue?
It has been open for a while now and we are not aware if it solved the issue for you.

Regards,

Actions

Copy link

#21

Updated by Anonymous almost 7 years ago

Status changed from Feedback to Resolved

no reaction, closing.

Actions

Copy link

Also available in: Atom PDF

Project

General

Profile

Custom queries

Bug #2634

Eventful reports - route error

Updated by Joseph Magen almost 11 years ago

Updated by Joseph Magen almost 11 years ago

Updated by Lex Rivera almost 11 years ago

Updated by Joseph Magen almost 11 years ago

Updated by Lex Rivera almost 11 years ago

Updated by Joseph Magen almost 11 years ago

Updated by David Blank-Edelman almost 11 years ago

Updated by Joseph Magen almost 11 years ago

Updated by Joseph Magen almost 11 years ago

Updated by David Blank-Edelman almost 11 years ago

Updated by Dominic Cleal almost 11 years ago

Updated by David Blank-Edelman almost 11 years ago

Updated by Dominic Cleal almost 11 years ago

Updated by Joseph Magen almost 11 years ago

Updated by Peter Gustafsson almost 11 years ago

Updated by Dominic Cleal almost 11 years ago

Updated by Dominic Cleal almost 11 years ago

Updated by Dominic Cleal almost 11 years ago

Updated by Joseph Magen almost 11 years ago

Updated by Benjamin Papillon about 10 years ago

Updated by Anonymous almost 7 years ago