See <http://ci.opensuse.org/job/obs_master_testsuite_api/1966/changes> Changes: [Stephan Kulow] [webui] test and fix submitting packages [Stephan Kulow] [api] work around mod_xrewrite bug [Stephan Kulow] [webui] add default architectures to new repositories [Stephan Kulow] [webui] rework the /home logic ------------------------------------------ [...truncated 418297 lines...] [29119:525.11] 2013-11-14 18:43:33 [2802]: GET /build/BaseDistro/_result?view=status&code=failed&code=broken&code=unresolvable [29119:525.13] 2013-11-14 18:43:33 [2803]: GET /_result?prpa=BaseDistro/BaseDistro_repo/i586&code=failed&code=broken&code=unresolvable [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.36]  (8.0ms) SELECT COUNT(*) FROM `release_targets` WHERE `release_targets`.`repository_id` IN (SELECT `repositories`.`id` FROM `repositories` WHERE `repositories`.`db_project_id` = 588327480) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.36] ReleaseTarget Load (0.5ms) SELECT `release_targets`.* FROM `release_targets` WHERE `release_targets`.`repository_id` IN (SELECT `repositories`.`id` FROM `repositories` WHERE `repositories`.`db_project_id` = 588327480) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.36] #<ActiveRecord::Relation [#<ReleaseTarget id: 913785863, repository_id: 91, target_repository_id: 95, trigger: nil>]> [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.36]  (0.3ms) SELECT `relationships`.`user_id` FROM `relationships` WHERE `relationships`.`project_id` = 588327480 AND `relationships`.`role_id` = 353348001 AND (user_id is not null) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.36] Relationship Load (0.3ms) SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`project_id` = 588327480 AND `relationships`.`role_id` = 353348001 AND (group_id is not null) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.36] User Load (0.2ms) SELECT `users`.* FROM `users` WHERE 1=0 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.36] CACHE (0.1ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'BaseDistro' ORDER BY `projects`.`id` ASC LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.36] Package Load (0.3ms) SELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0,200758022,95947991)) AND `packages`.`db_project_id` = 588327480 AND `packages`.`name` = 'patchinfo' LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.37] [REST] find( Directory, [{:project=>"BaseDistro", :package=>"patchinfo"}] ) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.37] params {:project=>"BaseDistro", :package=>"patchinfo"} [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.37] uri is: http://localhost:3200/source/:project/:package?:expand&:rev&:meta&:linkrev&:emptylink&:view&:extension&:lastworking&:withlinked&:deleted [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.37] http_do: method: get url: http://localhost:3200/source/BaseDistro/patchinfo? [29119:525.14] 2013-11-14 18:43:33 [2804]: GET /source/BaseDistro/patchinfo? [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.38] Comment Load (0.4ms) SELECT `comments`.* FROM `comments` WHERE `comments`.`project_id` = 588327480 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.38] User Load (0.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 164569715 ORDER BY `users`.`id` ASC LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.38] Comment Exists (0.2ms) SELECT 1 AS one FROM `comments` WHERE `comments`.`id` = 100 LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.39] User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 1038054164 ORDER BY `users`.`id` ASC LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.39] Comment Exists (0.2ms) SELECT 1 AS one FROM `comments` WHERE `comments`.`id` = 101 LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.39] User Load (0.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 235152081 ORDER BY `users`.`id` ASC LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.39] Project Exists (0.2ms) SELECT 1 AS one FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'BaseDistro' LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.39] Rendered webui/project/_tabs.html.erb (3.6ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.39] No alt/title text for sprite_tag [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] No alt/title text for sprite_tag [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] Rendered shared/_open_requests.html.erb (0.2ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] No alt/title text for sprite_tag [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] No alt/title text for sprite_tag [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] Flag Exists (0.2ms) SELECT 1 AS one FROM `flags` WHERE `flags`.`db_project_id` = 588327480 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] has_global_permission? change_project [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] Role Load (0.3ms) SELECT DISTINCT `roles`.* FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 1038054164 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] RolesStaticPermission Load (0.3ms) SELECT role_id FROM `roles_static_permissions` INNER JOIN `static_permissions` ON `static_permissions`.`id` = `roles_static_permissions`.`static_permission_id` WHERE `static_permissions`.`title` = 'change_project' [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] running local permission check: user tom, project BaseDistro, permission 'change_project' [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] Relationship Exists (0.3ms) SELECT 1 AS one FROM `relationships` WHERE `relationships`.`project_id` = 588327480 AND `relationships`.`user_id` = 1038054164 AND (role_id in (164569715,245448194)) LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] Relationship Exists (0.3ms) SELECT 1 AS one FROM `relationships` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` INNER JOIN `groups_users` ON `groups_users`.`group_id` = `groups`.`id` WHERE `relationships`.`project_id` = 588327480 AND `groups_users`.`user_id` = 1038054164 AND (role_id in (164569715,245448194)) LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] No alt/title text for sprite_tag [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.40] No alt/title text for sprite_tag [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.41] Rendered shared/_buildresult_box.html.erb (1.1ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.41] Rendered webui/comment/_new.html.erb (1.0ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.41] Rendered webui/comment/_expand_collapse.js.erb (0.2ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.41] User Load (0.2ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'Admin' LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.41] Rendered webui/comment/_links.html.erb (0.3ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.41] Rendered webui/comment/_reply.html.erb (1.0ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.41] CACHE (0.0ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'tom' LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.41] Rendered webui/comment/_links.html.erb (0.9ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.42] Rendered webui/comment/_reply.html.erb (1.1ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.42] User Load (0.2ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.42] Rendered webui/comment/_links.html.erb (0.3ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.42] Rendered webui/comment/_reply.html.erb (1.1ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.42] Rendered webui/comment/_child.html.erb (3.6ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.42] Rendered webui/comment/_child.html.erb (7.6ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.42] Rendered webui/comment/_show.html.erb (13.5ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.42]  (0.2ms) SELECT `watched_projects`.`project_id` FROM `watched_projects` WHERE `watched_projects`.`user_id` = 1038054164 [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.43]  (0.2ms) SELECT `projects`.`name` FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`id` IN (384404400) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.43] Rendered layouts/webui/_watch_and_search.html.erb (4.1ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.43] Rendered layouts/webui/_header.html.erb (4.8ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.43] Rendered layouts/webui/_personal_navigation.html.erb (1.4ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.43] Rendered layouts/webui/_flash.html.erb (0.2ms) [764176c6-2d2f-45de-ae14-63dffc393edf] [29107:6.43] Completed 200 OK in 121ms (Views: 41.0ms | ActiveRecord: 17.1ms | Backend: 0.0ms | XML: 1.0ms) [a0e711b1-cc67-4ef6-a9f0-957a7e50f3e5] [29107:6.45] Started GET "/assets/webui/application.js" for 127.0.0.1 at 2013-11-14 18:43:37 +0000 [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.51] Started GET "/project/buildresult?project=BaseDistro&index=" for 127.0.0.1 at 2013-11-14 18:43:37 +0000 [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.51] Processing by Webui::ProjectController#buildresult as */* [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.52] Parameters: {"project"=>"BaseDistro", "index"=>""} [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.52] Setting return_to: "/project/buildresult?project=BaseDistro&index=" [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.52] Authenticating with iChain mode: off [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.52] Authenticated request to "/project/buildresult?project=BaseDistro&index=" from tom [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.52] User Load (0.5ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'tom' LIMIT 1 [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.52] Configuration Load (0.3ms) SELECT `configurations`.* FROM `configurations` ORDER BY `configurations`.`id` ASC LIMIT 1 [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.52] Role Exists (0.3ms) SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 1038054164 AND `roles`.`title` = 'Admin' LIMIT 1 [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.52] Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'BaseDistro' ORDER BY `projects`.`id` ASC LIMIT 1 [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.52] DbProjectType Load (0.2ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 1 LIMIT 1 [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.53] [REST] find( Buildresult, [{:project=>"BaseDistro", :view=>"summary"}] ) [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.53] params {:project=>"BaseDistro", :view=>"summary"} [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.53] uri is: http://localhost:3200/build/:project/_result?:view&:package&:code&:lastbuild&:arch&:repository [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.53] http_do: method: get url: http://localhost:3200/build/BaseDistro/_result?view=summary [29119:525.30] 2013-11-14 18:43:33 [2805]: GET /build/BaseDistro/_result?view=summary [29119:525.33] 2013-11-14 18:43:33 [2806]: GET /_result?prpa=BaseDistro/BaseDistro_repo/i586&summary [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.54]  (0.6ms) SELECT COUNT(*) FROM `repositories` WHERE `repositories`.`db_project_id` = 588327480 [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.54] Rendered webui/project/_buildstatus.html.erb (3.0ms) [15420425-9ce7-40bd-91fe-54bdd5c20908] [29107:6.54] Completed 200 OK in 28ms (Views: 3.4ms | ActiveRecord: 2.1ms | Backend: 0.0ms | XML: 0.2ms) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Started GET "/project/show/My:Maintenance" for 127.0.0.1 at 2013-11-14 18:43:38 +0000 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Processing by Webui::ProjectController#show as HTML [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Parameters: {"project"=>"My:Maintenance"} [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Setting return_to: "/project/show/My:Maintenance" [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Authenticating with iChain mode: off [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Authenticated request to "/project/show/My:Maintenance" from tom [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] User Load (0.0ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'tom' LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Configuration Load (0.0ms) SELECT `configurations`.* FROM `configurations` ORDER BY `configurations`.`id` ASC LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Role Exists (0.0ms) SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 1038054164 AND `roles`.`title` = 'Admin' LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'My:Maintenance' ORDER BY `projects`.`id` ASC LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] DbProjectType Load (0.0ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 2 LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`id` IS NULL LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] DbProjectType Load (0.0ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`name` = 'maintenance_incident' LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55]  (0.0ms) SELECT projects.name FROM `projects` INNER JOIN `repositories` ON `repositories`.`db_project_id` = `projects`.`id` INNER JOIN `release_targets` ON `release_targets`.`repository_id` = `repositories`.`id` WHERE (projects.id not in (0,200758022,95947991)) AND (projects.name like 'My:Maintenance:%') AND `projects`.`type_id` = 3 AND (release_targets.trigger = 'maintenance') [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`maintenance_project_id` = 384404400 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55]  (0.0ms) SELECT name, db_project_id FROM `packages` WHERE (packages.db_project_id not in (0,200758022,95947991)) AND `packages`.`db_project_id` = 384404400 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] LinkedProject Load (0.0ms) SELECT `linked_projects`.* FROM `linked_projects` WHERE `linked_projects`.`db_project_id` = 384404400 ORDER BY `linked_projects`.`position` ASC [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55]  (0.0ms) SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND 1=0 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Project Load (0.0ms) SELECT prj.* FROM projects prj LEFT OUTER JOIN linked_projects lp ON lp.db_project_id = prj.id LEFT OUTER JOIN projects lprj ON lprj.id = lp.linked_db_project_id WHERE lprj.name = 'My:Maintenance' [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55]  (0.0ms) SELECT DISTINCT distinct bs_requests.id FROM `bs_requests` INNER JOIN `bs_request_actions` ON `bs_request_actions`.`bs_request_id` = `bs_requests`.`id` LEFT OUTER JOIN `reviews` ON `reviews`.`bs_request_id` = `bs_requests`.`id` WHERE (bs_requests.state in ('review')) AND ((reviews.state='new' and reviews.by_project='My:Maintenance')) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55]  (0.0ms) SELECT DISTINCT distinct bs_requests.id FROM `bs_requests` INNER JOIN `bs_request_actions` ON `bs_request_actions`.`bs_request_id` = `bs_requests`.`id` WHERE (bs_requests.state in ('new')) AND (bs_request_actions.target_project='My:Maintenance') [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55]  (0.0ms) SELECT DISTINCT distinct bs_requests.id FROM `bs_requests` INNER JOIN `bs_request_actions` ON `bs_request_actions`.`bs_request_id` = `bs_requests`.`id` WHERE (bs_requests.state in ('new')) AND (bs_request_actions.type in ('maintenance_incident')) AND (bs_request_actions.source_project='My:Maintenance') [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55]  (0.0ms) SELECT DISTINCT distinct bs_requests.id FROM `bs_requests` INNER JOIN `bs_request_actions` ON `bs_request_actions`.`bs_request_id` = `bs_requests`.`id` WHERE (bs_requests.state in ('new')) AND (bs_request_actions.type in ('maintenance_release')) AND ((bs_request_actions.source_project like 'My:Maintenance:%')) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] --> direct_http url: "/build/My:Maintenance/_result?view=status&code=failed&code=broken&code=unresolvable" [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] http_do: method: get url: http://localhost:3200/build/My:Maintenance/_result?view=status&code=failed&code=broken&code=unresolvable [29119:525.37] 2013-11-14 18:43:33 [2807]: GET /build/My:Maintenance/_result?view=status&code=failed&code=broken&code=unresolvable [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55]  (0.0ms) SELECT COUNT(*) FROM `release_targets` WHERE `release_targets`.`repository_id` IN (SELECT `repositories`.`id` FROM `repositories` WHERE `repositories`.`db_project_id` = 384404400) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55]  (0.0ms) SELECT `relationships`.`user_id` FROM `relationships` WHERE `relationships`.`project_id` = 384404400 AND `relationships`.`role_id` = 353348001 AND (user_id is not null) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Relationship Load (0.0ms) SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`project_id` = 384404400 AND `relationships`.`role_id` = 353348001 AND (group_id is not null) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] User Load (0.0ms) SELECT `users`.* FROM `users` WHERE 1=0 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Comment Load (0.0ms) SELECT `comments`.* FROM `comments` WHERE `comments`.`project_id` = 384404400 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Project Exists (0.0ms) SELECT 1 AS one FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'My' LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Project Exists (0.0ms) SELECT 1 AS one FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'My:Maintenance' LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Rendered webui/project/_tabs.html.erb (0.0ms) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] No alt/title text for sprite_tag [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] No alt/title text for sprite_tag [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Rendered shared/_open_requests.html.erb (0.0ms) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Flag Exists (0.0ms) SELECT 1 AS one FROM `flags` WHERE `flags`.`db_project_id` = 384404400 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] has_global_permission? change_project [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Role Load (0.0ms) SELECT DISTINCT `roles`.* FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 1038054164 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] RolesStaticPermission Load (0.0ms) SELECT role_id FROM `roles_static_permissions` INNER JOIN `static_permissions` ON `static_permissions`.`id` = `roles_static_permissions`.`static_permission_id` WHERE `static_permissions`.`title` = 'change_project' [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] running local permission check: user tom, project My:Maintenance, permission 'change_project' [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'My' ORDER BY `projects`.`id` ASC LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Relationship Exists (0.0ms) SELECT 1 AS one FROM `relationships` WHERE `relationships`.`project_id` = 384404400 AND `relationships`.`user_id` = 1038054164 AND (role_id in (164569715,245448194)) LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Relationship Exists (0.0ms) SELECT 1 AS one FROM `relationships` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` INNER JOIN `groups_users` ON `groups_users`.`group_id` = `groups`.`id` WHERE `relationships`.`project_id` = 384404400 AND `groups_users`.`user_id` = 1038054164 AND (role_id in (164569715,245448194)) LIMIT 1 [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] No alt/title text for sprite_tag [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] No alt/title text for sprite_tag [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Rendered layouts/webui/_watch_and_search.html.erb (0.0ms) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Rendered layouts/webui/_header.html.erb (0.0ms) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Rendered layouts/webui/_personal_navigation.html.erb (0.0ms) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Rendered layouts/webui/_flash.html.erb (0.0ms) [8a8fbb59-a08a-4a97-ad03-d7d808b3861d] [29107:7.55] Completed 200 OK in 0ms (Views: 0.0ms | ActiveRecord: 0.0ms | Backend: 0.0ms | XML: 0.0ms) [717e7d4b-eab2-44d8-8a90-5f43ef96f0ae] [29107:7.55] Started GET "/assets/webui/application.js" for 127.0.0.1 at 2013-11-14 18:43:38 +0000 [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Started GET "/project/toggle_watch/My:Maintenance" for 127.0.0.1 at 2013-11-14 18:43:38 +0000 [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Processing by Webui::ProjectController#toggle_watch as HTML [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Parameters: {"project"=>"My:Maintenance"} [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Setting return_to: "/project/toggle_watch/My:Maintenance" [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Authenticating with iChain mode: off [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Authenticated request to "/project/toggle_watch/My:Maintenance" from tom [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] User Load (0.0ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'tom' LIMIT 1 [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Configuration Load (0.0ms) SELECT `configurations`.* FROM `configurations` ORDER BY `configurations`.`id` ASC LIMIT 1 [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Role Exists (0.0ms) SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 1038054164 AND `roles`.`title` = 'Admin' LIMIT 1 [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'My:Maintenance' ORDER BY `projects`.`id` ASC LIMIT 1 [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] DbProjectType Load (0.0ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 2 LIMIT 1 [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Remove My:Maintenance from watchlist for tom [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] SQL (0.0ms) DELETE FROM `watched_projects` WHERE `watched_projects`.`id` IN (SELECT id FROM (SELECT `watched_projects`.`id` FROM `watched_projects` INNER JOIN `projects` ON `projects`.`id` = `watched_projects`.`project_id` AND (projects.id not in (0,200758022,95947991)) WHERE `watched_projects`.`user_id` = 1038054164 AND `projects`.`name` = 'My:Maintenance') __active_record_temp) [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] SQL (0.0ms) UPDATE `users` SET `users`.`updated_at` = '2013-11-14 18:43:38' WHERE `users`.`id` = 1038054164 [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Redirected to http://127.0.0.1:46812/project/show/My:Maintenance [de747be3-e98f-47ef-8843-908032be3790] [29107:7.55] Completed 302 Found in 0ms (ActiveRecord: 0.0ms | Backend: 0.0ms | XML: 0.0ms) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Started GET "/project/show/My:Maintenance" for 127.0.0.1 at 2013-11-14 18:43:38 +0000 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Processing by Webui::ProjectController#show as HTML [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Parameters: {"project"=>"My:Maintenance"} [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Setting return_to: "/project/show/My:Maintenance" [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Authenticating with iChain mode: off [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Authenticated request to "/project/show/My:Maintenance" from tom [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] User Load (0.0ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'tom' LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Configuration Load (0.0ms) SELECT `configurations`.* FROM `configurations` ORDER BY `configurations`.`id` ASC LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Role Exists (0.0ms) SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 1038054164 AND `roles`.`title` = 'Admin' LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'My:Maintenance' ORDER BY `projects`.`id` ASC LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] DbProjectType Load (0.0ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 2 LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`id` IS NULL LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] DbProjectType Load (0.0ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`name` = 'maintenance_incident' LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55]  (0.0ms) SELECT projects.name FROM `projects` INNER JOIN `repositories` ON `repositories`.`db_project_id` = `projects`.`id` INNER JOIN `release_targets` ON `release_targets`.`repository_id` = `repositories`.`id` WHERE (projects.id not in (0,200758022,95947991)) AND (projects.name like 'My:Maintenance:%') AND `projects`.`type_id` = 3 AND (release_targets.trigger = 'maintenance') [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`maintenance_project_id` = 384404400 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55]  (0.0ms) SELECT name, db_project_id FROM `packages` WHERE (packages.db_project_id not in (0,200758022,95947991)) AND `packages`.`db_project_id` = 384404400 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] LinkedProject Load (0.0ms) SELECT `linked_projects`.* FROM `linked_projects` WHERE `linked_projects`.`db_project_id` = 384404400 ORDER BY `linked_projects`.`position` ASC [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55]  (0.0ms) SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND 1=0 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Project Load (0.0ms)  SELECT prj.* FROM projects prj LEFT OUTER JOIN linked_projects lp ON lp.db_project_id = prj.id LEFT OUTER JOIN projects lprj ON lprj.id = lp.linked_db_project_id WHERE lprj.name = 'My:Maintenance'  [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55]  (0.0ms) SELECT DISTINCT distinct bs_requests.id FROM `bs_requests` INNER JOIN `bs_request_actions` ON `bs_request_actions`.`bs_request_id` = `bs_requests`.`id` LEFT OUTER JOIN `reviews` ON `reviews`.`bs_request_id` = `bs_requests`.`id` WHERE (bs_requests.state in ('review')) AND ((reviews.state='new' and reviews.by_project='My:Maintenance')) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55]  (0.0ms) SELECT DISTINCT distinct bs_requests.id FROM `bs_requests` INNER JOIN `bs_request_actions` ON `bs_request_actions`.`bs_request_id` = `bs_requests`.`id` WHERE (bs_requests.state in ('new')) AND (bs_request_actions.target_project='My:Maintenance') [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55]  (0.0ms) SELECT DISTINCT distinct bs_requests.id FROM `bs_requests` INNER JOIN `bs_request_actions` ON `bs_request_actions`.`bs_request_id` = `bs_requests`.`id` WHERE (bs_requests.state in ('new')) AND (bs_request_actions.type in ('maintenance_incident')) AND (bs_request_actions.source_project='My:Maintenance') [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55]  (0.0ms) SELECT DISTINCT distinct bs_requests.id FROM `bs_requests` INNER JOIN `bs_request_actions` ON `bs_request_actions`.`bs_request_id` = `bs_requests`.`id` WHERE (bs_requests.state in ('new')) AND (bs_request_actions.type in ('maintenance_release')) AND ((bs_request_actions.source_project like 'My:Maintenance:%')) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] --> direct_http url: "/build/My:Maintenance/_result?view=status&code=failed&code=broken&code=unresolvable" [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] http_do: method: get url: http://localhost:3200/build/My:Maintenance/_result?view=status&code=failed&code=broken&code=unresolvable [29119:525.58] 2013-11-14 18:43:33 [2808]: GET /build/My:Maintenance/_result?view=status&code=failed&code=broken&code=unresolvable [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55]  (0.0ms) SELECT COUNT(*) FROM `release_targets` WHERE `release_targets`.`repository_id` IN (SELECT `repositories`.`id` FROM `repositories` WHERE `repositories`.`db_project_id` = 384404400) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55]  (0.0ms) SELECT `relationships`.`user_id` FROM `relationships` WHERE `relationships`.`project_id` = 384404400 AND `relationships`.`role_id` = 353348001 AND (user_id is not null) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Relationship Load (0.0ms) SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`project_id` = 384404400 AND `relationships`.`role_id` = 353348001 AND (group_id is not null) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] User Load (0.0ms) SELECT `users`.* FROM `users` WHERE 1=0 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Comment Load (0.0ms) SELECT `comments`.* FROM `comments` WHERE `comments`.`project_id` = 384404400 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Project Exists (0.0ms) SELECT 1 AS one FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'My' LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Project Exists (0.0ms) SELECT 1 AS one FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'My:Maintenance' LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Rendered webui/project/_tabs.html.erb (0.0ms) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] No alt/title text for sprite_tag [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] No alt/title text for sprite_tag [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Rendered shared/_open_requests.html.erb (0.0ms) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Flag Exists (0.0ms) SELECT 1 AS one FROM `flags` WHERE `flags`.`db_project_id` = 384404400 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] has_global_permission? change_project [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Role Load (0.0ms) SELECT DISTINCT `roles`.* FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 1038054164 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] RolesStaticPermission Load (0.0ms) SELECT role_id FROM `roles_static_permissions` INNER JOIN `static_permissions` ON `static_permissions`.`id` = `roles_static_permissions`.`static_permission_id` WHERE `static_permissions`.`title` = 'change_project' [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] running local permission check: user tom, project My:Maintenance, permission 'change_project' [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'My' ORDER BY `projects`.`id` ASC LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Relationship Exists (0.0ms) SELECT 1 AS one FROM `relationships` WHERE `relationships`.`project_id` = 384404400 AND `relationships`.`user_id` = 1038054164 AND (role_id in (164569715,245448194)) LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Relationship Exists (0.0ms) SELECT 1 AS one FROM `relationships` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` INNER JOIN `groups_users` ON `groups_users`.`group_id` = `groups`.`id` WHERE `relationships`.`project_id` = 384404400 AND `groups_users`.`user_id` = 1038054164 AND (role_id in (164569715,245448194)) LIMIT 1 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] No alt/title text for sprite_tag [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] No alt/title text for sprite_tag [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55]  (0.0ms) SELECT `watched_projects`.`project_id` FROM `watched_projects` WHERE `watched_projects`.`user_id` = 1038054164 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55]  (0.0ms) SELECT `projects`.`name` FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND 1=0 [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Rendered layouts/webui/_watch_and_search.html.erb (0.0ms) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Rendered layouts/webui/_header.html.erb (0.0ms) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Rendered layouts/webui/_personal_navigation.html.erb (0.0ms) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Rendered layouts/webui/_flash.html.erb (0.0ms) [60db7c8e-5c6a-4417-b703-3777ce349262] [29107:7.55] Completed 200 OK in 0ms (Views: 0.0ms | ActiveRecord: 0.0ms | Backend: 0.0ms | XML: 0.0ms) [8b173cd8-27da-424e-b7bb-8d3169be4bb2] [29107:7.55] Started GET "/assets/webui/application.js" for 127.0.0.1 at 2013-11-14 18:43:38 +0000 [29107:540.01]  (0.0ms) ROLLBACK [29107:540.01]  (0.0ms) BEGIN [29107:540.01] -------------------------------------- [29107:540.01] WebuiPackageTest: test_is_binary_file? [29107:540.01] -------------------------------------- [29107:540.01]  (0.0ms) ROLLBACK [dc297055-5a95-4900-80be-e516e7a74fcd] [29622:0.00] Started POST "/test/killme" for 127.0.0.1 at 2013-11-14 18:43:38 +0000 [dc297055-5a95-4900-80be-e516e7a74fcd] [29622:0.00] Processing by TestController#killme as */* [dc297055-5a95-4900-80be-e516e7a74fcd] [29622:0.01] Can't verify CSRF token authenticity [dc297055-5a95-4900-80be-e516e7a74fcd] [29622:0.01] Validate XML request: #<ActionDispatch::Request:0x0000000432a8f8> [dc297055-5a95-4900-80be-e516e7a74fcd] [29622:0.01] no schema found, skipping validation for {"controller"=>"test", "action"=>"killme", "method"=>"POST", "type"=>"request"} [dc297055-5a95-4900-80be-e516e7a74fcd] [29622:0.01] Rendered status.xml.builder (0.4ms) [dc297055-5a95-4900-80be-e516e7a74fcd] [29622:0.01] no schema found, skipping validation for {"controller"=>"test", "action"=>"killme", "method"=>"POST", "type"=>"response"} [dc297055-5a95-4900-80be-e516e7a74fcd] [29622:0.01] Validate XML response: #<ActionDispatch::Response:0x0000000432a880> took 0ms [dc297055-5a95-4900-80be-e516e7a74fcd] [29622:0.01] Completed 200 OK in 6ms (Views: 1.3ms | ActiveRecord: 0.0ms | Backend: 0.0ms | XML: 0.0ms) + echo + cleanup + echo 'Killing backend processes' Killing backend processes + fuser -v <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/> + egrep 'perl|ruby' USER PID ACCESS COMMAND <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/>: ci ..c.. egrep ci ..c.. fuser ci ..c.. sh ci ..c.. sh + echo 'Remove log/tmp files to save disc space' Remove log/tmp files to save disc space + rm -rf src/api/log/backend_access.log src/api/log/test.log src/api/log/test.searchd.log src/api/log/test.searchd.query.log src/api/tmp/backend_config src/api/tmp/backend_data src/api/tmp/binlog src/api/tmp/cache src/api/tmp/capybara src/api/tmp/pids src/api/tmp/scheduler.done src/api/tmp/sessions src/api/tmp/sockets + exit 1 Build step 'Execute shell' marked build as failure [locks-and-latches] Releasing all the locks [locks-and-latches] All the locks released -- To unsubscribe, e-mail: obs-tests+unsubscribe@opensuse.org To contact the owner, e-mail: obs-tests+owner@opensuse.org