1443816 – Remote execution from Host Collections with non-admin user fails with error 'rendering 403 because of missing permission'

Bug 1443816 - Remote execution from Host Collections with non-admin user fails with error 'rendering 403 because of missing permission'

Summary: Remote execution from Host Collections with non-admin user fails with error '...

Keywords:
Status:	CLOSED ERRATA
Alias:	None
Product:	Red Hat Satellite
Classification:	Red Hat
Component:	Remote Execution
Sub Component:
Version:	6.2.8
Hardware:	x86_64
OS:	Linux
Priority:	high
Severity:	medium
Target Milestone:	Unspecified
Assignee:	Ivan Necas
QA Contact:	Roman Plevka
Docs Contact:
URL:
Whiteboard:
Depends On:	1487402 1532605
Blocks:
TreeView+	depends on / blocked

Reported:	2017-04-20 04:14 UTC by Mahesh Taru
Modified:	2021-06-10 12:13 UTC (History)
CC List:	15 users (show)
Fixed In Version:	rubygem-katello-3.4.5.43-1
Doc Type:	If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed:	2018-02-21 16:54:37 UTC
Target Upstream Version:
Embargoed:

Attachments	(Terms of Use)

Links
System	ID	Private	Priority	Status	Summary	Last Updated
Foreman Issue Tracker	19336	0	Normal	Closed	Remote execution from Host Collections with non-admin user fails with error 'rendering 403 because of missing permission...	2021-02-12 22:15:40 UTC
Foreman Issue Tracker	21794	0	Normal	Closed	The remote execution views in katello should require view_hosts, not edit_hosts permision	2021-02-12 22:15:39 UTC

Description Mahesh Taru 2017-04-20 04:14:23 UTC

Description of problem:
Remote execution with non-admin user having role 'Remote Execution User' or 'Remote Execution Manager' do not work and fails with error "rendering 403 because of missing permission ".

Version-Release number of selected component (if applicable):


How reproducible:
Always

Steps to Reproduce:
1. From satellite webui create non-admin user.
2. Assign role 'Remote Execution User' or 'Remote Execution Manager' or can assign all roles except 'Administrator' check mark.
3. Login satellite as non-admin user --> Hosts --> Host Collection --> Click on host collection name --> Collection actions --> Errata installation --> Select errata --> click on drop down of 'install selected' --> select 'via remote execution' or 'via remote execution -customize first'


Actual results:
On satellite webui:
*********************
Permission denied You are not authorized to perform this action.
Please request one of the required permissions listed below from a Satellite administrator:
*********************

Debug log entries from satellite terminal.
*********************
==> /var/log/foreman/production.log <==
2017-04-17 07:13:05 [sql] [D]    (1.0ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-17 07:13:05 [sql] [D]    (0.3ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-17 07:13:05 [sql] [D]   Katello::Event Load (0.5ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-17 07:13:05 [sql] [D]   SQL (0.6ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-17 07:13:05 [app] [I] Started POST "/katello/remote_execution" for 10.76.1.49 at 2017-04-17 07:13:05 +0530
2017-04-17 07:13:05 [app] [I] Processing by Katello::RemoteExecutionController#create as HTML
2017-04-17 07:13:05 [app] [I]   Parameters: {"name"=>"RHEA-2016:2832", "remote_action"=>"errata_install", "scoped_search"=>"", "host_ids"=>"37", "authenticity_token"=>"5Gkwl
WUAsZt7YnMHlotnGuqn9+Mp/v6zzj3JEgAYGMk=", "customize"=>"true"}
2017-04-17 07:13:05 [sql] [D]   ActiveRecord::SessionStore::Session Load (0.9ms)  SELECT  "sessions".* FROM "sessions"  WHERE "sessions"."session_id" = '735b9268eeb1f72303f0
d8fa64131868'  ORDER BY "sessions"."id" ASC LIMIT 1
2017-04-17 07:13:05 [sql] [D]   User Load (0.3ms)  SELECT  "users".* FROM "users"  WHERE "users"."id" = $1 LIMIT 1  [["id", 5]]
2017-04-17 07:13:05 [sql] [D]   Usergroup Load (0.7ms)  SELECT "usergroups".* FROM "usergroups" INNER JOIN "cached_usergroup_members" ON "usergroups"."id" = "cached_usergrou
p_members"."usergroup_id" WHERE "cached_usergroup_members"."user_id" = $1  ORDER BY usergroups.name  [["user_id", 5]]
2017-04-17 07:13:05 [sql] [D]   Taxonomy Load (0.8ms)  SELECT "taxonomies".* FROM "taxonomies" INNER JOIN "taxable_taxonomies" ON "taxonomies"."id" = "taxable_taxonomies"."t
axonomy_id" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."type" = 'Organization' AND "taxable_taxonomies"."taxable_id" = $1 AND "taxable_taxonomies"."taxab
le_type" = $2  ORDER BY "taxonomies"."title" ASC  [["taxable_id", 5], ["taxable_type", "User"]]
2017-04-17 07:13:05 [sql] [D]   Organization Load (0.6ms)  SELECT "taxonomies"."id" FROM "taxonomies"  WHERE "taxonomies"."type" IN ('Organization') AND (taxonomies.id = 1 o
r taxonomies.ancestry like '1/%' or taxonomies.ancestry = '1')  ORDER BY "taxonomies"."title" ASC
2017-04-17 07:13:05 [sql] [D]    (4.1ms)  SELECT COUNT(*) FROM "taxonomies"  WHERE "taxonomies"."type" IN ('Organization') AND ( (taxonomies.id in (1)))
2017-04-17 07:13:05 [sql] [D]   Organization Load (0.3ms)  SELECT  "taxonomies".* FROM "taxonomies"  WHERE "taxonomies"."type" IN ('Organization') AND ( (taxonomies.id in (1
)))  ORDER BY "taxonomies"."title" ASC LIMIT 1
2017-04-17 07:13:05 [sql] [D]   Taxonomy Load (0.6ms)  SELECT "taxonomies".* FROM "taxonomies" INNER JOIN "taxable_taxonomies" ON "taxonomies"."id" = "taxable_taxonomies"."t
axonomy_id" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."type" = 'Location' AND "taxable_taxonomies"."taxable_id" = $1 AND "taxable_taxonomies"."taxable_type"
 = $2  ORDER BY "taxonomies"."title" ASC  [["taxable_id", 5], ["taxable_type", "User"]]
2017-04-17 07:13:05 [sql] [D]   Location Load (0.5ms)  SELECT "taxonomies"."id" FROM "taxonomies"  WHERE "taxonomies"."type" IN ('Location') AND (taxonomies.id = 5 or taxono
mies.ancestry like '5/%' or taxonomies.ancestry = '5')  ORDER BY "taxonomies"."title" ASC
2017-04-17 07:13:05 [sql] [D]   Location Load (0.4ms)  SELECT "taxonomies"."id" FROM "taxonomies"  WHERE "taxonomies"."type" IN ('Location') AND (taxonomies.id = 2 or taxono
mies.ancestry like '2/%' or taxonomies.ancestry = '2')  ORDER BY "taxonomies"."title" ASC
2017-04-17 07:13:05 [sql] [D]    (0.4ms)  SELECT COUNT(*) FROM "taxonomies"  WHERE "taxonomies"."type" IN ('Location') AND ( (taxonomies.id in (5,2)))
2017-04-17 07:13:05 [sql] [D]   Location Load (0.3ms)  SELECT  "taxonomies".* FROM "taxonomies"  WHERE "taxonomies"."type" IN ('Location') AND ( (taxonomies.id in (5,2))) AND "taxonomies"."id" = 2  ORDER BY "taxonomies"."title" ASC LIMIT 1
2017-04-17 07:13:06 [sql] [D]   AuthSource Load (0.3ms)  SELECT  "auth_sources".* FROM "auth_sources"  WHERE "auth_sources"."id" = $1 LIMIT 1  [["id", 1]]
2017-04-17 07:13:06 [sql] [D]   Role Load (0.5ms)  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "cached_user_roles"."user_id" = $1  [["user_id", 5]]
2017-04-17 07:13:06 [sql] [D]    (0.6ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 5]]
2017-04-17 07:13:06 [sql] [D]    (0.6ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 18]]
2017-04-17 07:13:06 [sql] [D]    (0.5ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 19]]
2017-04-17 07:13:06 [sql] [D]    (0.5ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 8]]
2017-04-17 07:13:06 [sql] [D]    (0.4ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 15]]
2017-04-17 07:13:06 [sql] [D]    (0.3ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 3]]
2017-04-17 07:13:06 [sql] [D]    (0.5ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 10]]
2017-04-17 07:13:06 [sql] [D]    (0.4ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 12]]
2017-04-17 07:13:06 [sql] [D]    (0.3ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 16]]
2017-04-17 07:13:06 [sql] [D]    (0.3ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 14]]
2017-04-17 07:13:06 [sql] [D]    (0.5ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 29]]
2017-04-17 07:13:06 [sql] [D]    (0.3ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 4]]
2017-04-17 07:13:06 [sql] [D]    (0.6ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 6]]
2017-04-17 07:13:06 [sql] [D]    (0.4ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 20]]
2017-04-17 07:13:06 [sql] [D]    (0.4ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 9]]
2017-04-17 07:13:06 [sql] [D]    (0.3ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 21]]
2017-04-17 07:13:06 [sql] [D]    (0.4ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 2]]
2017-04-17 07:13:06 [sql] [D]    (0.4ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN
"filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 11]]
2017-04-17 07:13:06 [sql] [D]    (0.5ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 17]]
2017-04-17 07:13:06 [sql] [D]    (1.4ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 1]]
2017-04-17 07:13:06 [sql] [D]    (0.6ms)  SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1  ORDER BY filters.role_id, filters.id  [["role_id", 7]]
2017-04-17 07:13:06 [permissions] [D] rendering 403 because of missing permission 
2017-04-17 07:13:06 [app] [I]   Rendered common/403.html.erb within layouts/application (23.5ms)
2017-04-17 07:13:06 [app] [I]   Rendered layouts/_application_content.html.erb (2.6ms)
*********************


Expected results:
With 'Remote Execution User' or 'Remote Execution Manager' role, non-admin user should be able to perform remote actions on host systems.

Additional info:
Though user have all other default roles from satellite assigned i.e user can access organization, location, dashboard, hosts, host collections, content hosts, etc... still issue persist.

But if same user performs action from All Host, it works.

Login webui as non-admin user(with Remote exection user/manager role) Hosts --> All Hosts --> select host --> Select Action --> Run Job --> "Job category: Katello" --> "Job template: Install Errata - Katello SSH Default" --> "errata: mention errata to install" --> Submit

Debug logs:
*********************
2017-04-20 09:35:32 [sql] [D]   Katello::Event Load (0.3ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:32 [sql] [D]   SQL (0.5ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:33 [app] [I] Started GET "/content-hosts/content/views/content-host-errata.html" for 10.76.0.19 at 2017-04-20 09:35:33 +0530
2017-04-20 09:35:33 [app] [I] Started GET "/layouts/details-nutupane.html" for 10.76.0.19 at 2017-04-20 09:35:33 +0530
2017-04-20 09:35:33 [app] [I] Started GET "/api/v2/hosts/37/errata?page=1&search=" for 10.76.0.19 at 2017-04-20 09:35:33 +0530
2017-04-20 09:35:34 [sql] [D]    (0.8ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:34 [sql] [D]    (0.3ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:35 [sql] [D]   Katello::Event Load (0.7ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:35 [sql] [D]   SQL (0.6ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:36 [app] [I] Processing by Katello::Api::V2::HostErrataController#index as JSON
2017-04-20 09:35:36 [app] [I]   Parameters: {"page"=>"1", "search"=>"", "api_version"=>"v2", "host_id"=>"37"}
2017-04-20 09:35:37 [sql] [D]    (0.9ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:37 [sql] [D]    (0.3ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:37 [sql] [D]   Katello::Event Load (1.8ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:37 [sql] [D]   SQL (0.5ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:39 [sql] [D]    (0.6ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:39 [sql] [D]    (0.2ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:39 [sql] [D]   Katello::Event Load (0.3ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:39 [sql] [D]   SQL (0.5ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:41 [sql] [D]    (0.9ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:41 [sql] [D]    (0.6ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:39 [sql] [D]    (0.2ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:39 [sql] [D]   Katello::Event Load (0.3ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:39 [sql] [D]   SQL (0.5ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:41 [sql] [D]    (0.9ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:41 [sql] [D]    (0.6ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:41 [sql] [D]   Katello::Event Load (0.6ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:41 [sql] [D]   SQL (0.5ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:43 [sql] [D]    (0.7ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:43 [sql] [D]    (0.4ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:43 [sql] [D]   Katello::Event Load (0.3ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:43 [sql] [D]   SQL (0.6ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:43 [app] [I]   Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.105/app/views/katello/api/v2/host_errata/index.json.rabl within katello/api/v2/layouts/collection (3158.3ms)
2017-04-20 09:35:43 [app] [I] Completed 200 OK in 7159ms (Views: 3201.4ms | ActiveRecord: 520.0ms)
2017-04-20 09:35:45 [sql] [D]    (0.8ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:45 [sql] [D]    (0.3ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:45 [sql] [D]   Katello::Event Load (0.3ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:45 [sql] [D]   SQL (0.4ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:47 [sql] [D]    (24.7ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:47 [sql] [D]    (0.6ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:47 [sql] [D]   Katello::Event Load (0.3ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:47 [sql] [D]   SQL (0.4ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:49 [sql] [D]    (35.7ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:49 [sql] [D]    (0.6ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:49 [sql] [D]   Katello::Event Load (0.3ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:49 [sql] [D]   SQL (4.6ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:51 [sql] [D]    (22.2ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:51 [sql] [D]    (0.5ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:51 [sql] [D]   Katello::Event Load (0.3ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:51 [sql] [D]   SQL (0.4ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:53 [sql] [D]    (56.0ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:53 [sql] [D]    (0.5ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:53 [sql] [D]   Katello::Event Load (0.4ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:53 [sql] [D]   SQL (12.3ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:54 [app] [I] Started GET "/content-hosts/content/views/content-host-packages.html" for 10.76.0.19 at 2017-04-20 09:35:54 +0530
2017-04-20 09:35:54 [app] [I] Started GET "/api/v2/hosts/37/packages?page=1&search=" for 10.76.0.19 at 2017-04-20 09:35:54 +0530
2017-04-20 09:35:55 [sql] [D]    (1.2ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:55 [sql] [D]    (0.6ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:55 [sql] [D]   Katello::Event Load (0.3ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:55 [sql] [D]   SQL (6.0ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:57 [app] [I] Processing by Katello::Api::V2::HostPackagesController#index as JSON
2017-04-20 09:35:57 [app] [I]   Parameters: {"page"=>"1", "search"=>"", "api_version"=>"v2", "host_id"=>"37"}
2017-04-20 09:35:57 [sql] [D]    (0.9ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:58 [app] [I] Started GET "/api/v2/hosts/37/errata?page=1&search=" for 10.76.0.19 at 2017-04-20 09:35:58 +0530
2017-04-20 09:35:58 [app] [I] Processing by Katello::Api::V2::HostErrataController#index as JSON
2017-04-20 09:35:58 [app] [I]   Parameters: {"page"=>"1", "search"=>"", "api_version"=>"v2", "host_id"=>"37"}
2017-04-20 09:35:58 [app] [I]   Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.105/app/views/katello/api/v2/host_errata/index.json.rabl within katello/api/v2/layouts/collection (250.0ms)
2017-04-20 09:35:58 [app] [I] Completed 200 OK in 330ms (Views: 234.4ms | ActiveRecord: 30.4ms)
2017-04-20 09:35:59 [sql] [D]    (0.9ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:59 [sql] [D]   Katello::Event Load (0.4ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:59 [sql] [D]   SQL (0.7ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:00 [app] [I]   Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.105/app/views/katello/api/v2/host_packages/index.json.rabl within katello/api/v2/layouts/collection (475.5ms)
2017-04-20 09:36:00 [app] [I] Completed 200 OK in 3606ms (Views: 651.7ms | ActiveRecord: 387.8ms)
2017-04-20 09:36:01 [sql] [D]    (0.7ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:01 [sql] [D]    (0.3ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:01 [sql] [D]   Katello::Event Load (17.7ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:01 [sql] [D]   SQL (0.8ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:03 [sql] [D]    (0.7ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:03 [sql] [D]    (0.4ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:03 [sql] [D]   Katello::Event Load (0.5ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:03 [sql] [D]   SQL (0.7ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:05 [sql] [D]    (1.0ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:05 [sql] [D]    (0.5ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:05 [sql] [D]   Katello::Event Load (0.4ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  OR:
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:05 [sql] [D]   SQL (0.4ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:07 [sql] [D]    (0.8ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:07 [sql] [D]    (0.3ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:07 [sql] [D]   Katello::Event Load (0.3ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:07 [sql] [D]   SQL (0.4ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:09 [sql] [D]    (0.7ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:09 [sql] [D]    (0.6ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:09 [sql] [D]   Katello::Event Load (0.5ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:09 [sql] [D]   SQL (0.9ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:11 [sql] [D]    (6.7ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:11 [sql] [D]    (0.2ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:11 [sql] [D]   Katello::Event Load (8.5ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:11 [sql] [D]   SQL (5.5ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:13 [sql] [D]    (1.1ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:13 [sql] [D]    (0.5ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:13 [sql] [D]   Katello::Event Load (0.7ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:13 [sql] [D]   SQL (0.7ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:15 [sql] [D]    (0.7ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:15 [sql] [D]    (0.5ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:15 [sql] [D]   Katello::Event Load (0.3ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  OR:
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:15 [sql] [D]   SQL (0.5ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:17 [sql] [D]    (0.7ms)  SELECT  "katello_events"."object_id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:17 [sql] [D]    (0.5ms)  SELECT  "katello_events"."event_type" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f'  ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:17 [sql] [D]   Katello::Event Load (0.4ms)  SELECT  "katello_events".* FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:17 [sql] [D]   SQL (0.4ms)  UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events"  WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0  ORDER BY "katello_events"."created_at" ASC)
*********************

Comment 2 Ivan Necas 2017-04-20 17:14:18 UTC

Created redmine issue http://projects.theforeman.org/issues/19336 from this bug

Comment 3 Satellite Program 2017-05-03 00:07:47 UTC

Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/19336 has been resolved.

Comment 7 Jonathon Turel 2017-08-31 19:22:45 UTC

I was not able to verify this bug as the reproduction path is blocked by a new bug which I have opened: https://bugzilla.redhat.com/show_bug.cgi?id=1487402

Failed against Satellite 6.3 Snap 13 following the reproduction steps above.

Comment 9 Satellite Program 2017-09-01 06:08:00 UTC

Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/19336 has been resolved.

Comment 11 Roman Plevka 2017-11-28 12:36:21 UTC

failed qa:
- It would be probably more appropriate to put the permissions to 'view_hosts' instead of 'edit_hosts'

Comment 12 Ivan Necas 2017-11-28 13:14:43 UTC

Additional update proposed upstream https://github.com/Katello/katello/pull/7087

Comment 13 Satellite Program 2017-12-11 17:09:36 UTC

Upstream bug assigned to inecas

Comment 14 Satellite Program 2018-02-21 16:54:37 UTC

Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA.
> > 
> > For information on the advisory, and where to find the updated files, follow the link below.
> > 
> > If the solution does not work for you, open a new bug report.
> > 
> > https://access.redhat.com/errata/RHSA-2018:0336

Note You need to log in before you can comment on or make changes to this bug.