See <http://ci.opensuse.org/job/obs_master_testsuite_api/1961/changes> Changes: [Stephan Kulow] [webui] specify url method [Stephan Kulow] [api] ignore missing templates [Stephan Kulow] [webui] test 'request deletion' in both package and project ------------------------------------------ [...truncated 416047 lines...] [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.47]  (0.3ms) 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='BaseDistro') [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.47] --> direct_http url: "/build/BaseDistro/_result?view=status&code=failed&code=broken&code=unresolvable" [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.47] http_do: method: get url: http://localhost:3200/build/BaseDistro/_result?view=status&code=failed&code=... [10352:551.17] 2013-11-13 14:53:47 [16515]: GET /build/BaseDistro/_result?view=status&code=failed&code=broken&code=unresolvable [10352:551.33] 2013-11-13 14:53:47 [16516]: GET /_result?prpa=BaseDistro/BaseDistro_repo/i586&code=failed&code=broken&code=unresolvable [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.49]  (1.1ms) SELECT COUNT(*) FROM `release_targets` WHERE `release_targets`.`repository_id` IN (SELECT `repositories`.`id` FROM `repositories` WHERE `repositories`.`db_project_id` = 588327480) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.49] 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) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.49] #<ActiveRecord::Relation [#<ReleaseTarget id: 913785863, repository_id: 91, target_repository_id: 95, trigger: nil>]> [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.49]  (1.1ms) SELECT `relationships`.`user_id` FROM `relationships` WHERE `relationships`.`project_id` = 588327480 AND `relationships`.`role_id` = 353348001 AND (user_id is not null) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.49] Relationship Load (0.3ms) SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`project_id` = 588327480 AND `relationships`.`role_id` = 353348001 AND (group_id is not null) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.49] User Load (0.2ms) SELECT `users`.* FROM `users` WHERE 1=0 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.50] 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 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.50] Package Load (0.4ms) 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 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.50] [REST] find( Directory, [{:project=>"BaseDistro", :package=>"patchinfo"}] ) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.50] params {:project=>"BaseDistro", :package=>"patchinfo"} [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.50] uri is: http://localhost:3200/source/:project/:package?:expand&:rev&:meta&:linkrev&:... [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.50] http_do: method: get url: http://localhost:3200/source/BaseDistro/patchinfo? [10352:551.20] 2013-11-13 14:53:47 [16517]: GET /source/BaseDistro/patchinfo? [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.60] Comment Load (0.5ms) SELECT `comments`.* FROM `comments` WHERE `comments`.`project_id` = 588327480 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.60] User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 164569715 ORDER BY `users`.`id` ASC LIMIT 1 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.60] Comment Exists (0.2ms) SELECT 1 AS one FROM `comments` WHERE `comments`.`id` = 100 LIMIT 1 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.60] User Load (0.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 1038054164 ORDER BY `users`.`id` ASC LIMIT 1 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.61] Comment Exists (0.2ms) SELECT 1 AS one FROM `comments` WHERE `comments`.`id` = 101 LIMIT 1 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.61] User Load (0.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 235152081 ORDER BY `users`.`id` ASC LIMIT 1 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.61] Project Exists (0.3ms) SELECT 1 AS one FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'BaseDistro' LIMIT 1 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.61] Rendered webui/app/views/webui/project/_tabs.html.erb (4.1ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.61] No alt/title text for sprite_tag [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.62] No alt/title text for sprite_tag [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.62] Rendered webui/app/views/shared/_open_requests.html.erb (0.2ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.62] No alt/title text for sprite_tag [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.62] No alt/title text for sprite_tag [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.62] Flag Exists (0.3ms) SELECT 1 AS one FROM `flags` WHERE `flags`.`db_project_id` = 588327480 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.62] has_global_permission? change_project [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.62] 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 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.62] 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' [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.62] running local permission check: user tom, project BaseDistro, permission 'change_project' [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.63] 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 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.63] 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 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.63] No alt/title text for sprite_tag [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.63] No alt/title text for sprite_tag [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.63] Rendered webui/app/views/shared/_buildresult_box.html.erb (1.3ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.63] Rendered webui/app/views/webui/comment/_new.html.erb (1.1ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.63] Rendered webui/app/views/webui/comment/_expand_collapse.js.erb (0.2ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.63] User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'Admin' LIMIT 1 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.64] Rendered webui/app/views/webui/comment/_links.html.erb (0.4ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.64] Rendered webui/app/views/webui/comment/_reply.html.erb (1.0ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.64] CACHE (0.1ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'tom' LIMIT 1 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.64] Rendered webui/app/views/webui/comment/_links.html.erb (1.0ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.64] Rendered webui/app/views/webui/comment/_reply.html.erb (1.0ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.64] User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.64] Rendered webui/app/views/webui/comment/_links.html.erb (0.5ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.65] Rendered webui/app/views/webui/comment/_reply.html.erb (1.1ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.65] Rendered webui/app/views/webui/comment/_child.html.erb (4.6ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.65] Rendered webui/app/views/webui/comment/_child.html.erb (8.8ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.65] Rendered webui/app/views/webui/comment/_show.html.erb (15.8ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.65]  (0.3ms) SELECT `watched_projects`.`project_id` FROM `watched_projects` WHERE `watched_projects`.`user_id` = 1038054164 [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.65]  (0.2ms) SELECT `projects`.`name` FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`id` IN (384404400) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.65] Rendered webui/app/views/layouts/webui/_watch_and_search.html.erb (5.0ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.65] Rendered webui/app/views/layouts/webui/_header.html.erb (5.9ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.66] Rendered webui/app/views/layouts/webui/_personal_navigation.html.erb (1.6ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.66] Rendered webui/app/views/layouts/webui/_flash.html.erb (0.2ms) [ec2c27b8-5583-4867-99bb-22be25cfb658] [10340:6.66] Completed 200 OK in 214ms (Views: 50.3ms | ActiveRecord: 11.8ms | Backend: 0.0ms | XML: 1.2ms) [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.73] Started GET "/project/buildresult?project=BaseDistro&index=" for 127.0.0.1 at 2013-11-13 14:53:51 +0000 [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.73] Processing by Webui::ProjectController#buildresult as */* [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.73] Parameters: {"project"=>"BaseDistro", "index"=>""} [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.73] Setting return_to: "/project/buildresult?project=BaseDistro&index=" [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.73] Authenticating with iChain mode: off [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.73] Authenticated request to "/project/buildresult?project=BaseDistro&index=" from tom [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.73] User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'tom' LIMIT 1 [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.73] Configuration Load (0.3ms) SELECT `configurations`.* FROM `configurations` ORDER BY `configurations`.`id` ASC LIMIT 1 [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.74] Role Exists (0.4ms) 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 [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.74] 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 [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.74] DbProjectType Load (0.2ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 1 LIMIT 1 [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.74] [REST] find( Buildresult, [{:project=>"BaseDistro", :view=>"summary"}] ) [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.74] params {:project=>"BaseDistro", :view=>"summary"} [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.74] uri is: http://localhost:3200/build/:project/_result?:view&:package&:code&:lastbuild... [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.74] http_do: method: get url: http://localhost:3200/build/BaseDistro/_result?view=summary [10352:551.43] 2013-11-13 14:53:47 [16518]: GET /build/BaseDistro/_result?view=summary [10352:551.60] 2013-11-13 14:53:47 [16519]: GET /_result?prpa=BaseDistro/BaseDistro_repo/i586&summary [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.76]  (0.4ms) SELECT COUNT(*) FROM `repositories` WHERE `repositories`.`db_project_id` = 588327480 [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.76] Rendered webui/app/views/webui/project/_buildstatus.html.erb (2.6ms) [b1838a8b-f42b-4e6c-af4e-55b7f6f55136] [10340:6.76] Completed 200 OK in 31ms (Views: 3.2ms | ActiveRecord: 1.9ms | Backend: 0.0ms | XML: 0.2ms) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Started GET "/project/show/My:Maintenance" for 127.0.0.1 at 2013-11-13 14:53:52 +0000 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Processing by Webui::ProjectController#show as HTML [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Parameters: {"project"=>"My:Maintenance"} [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Setting return_to: "/project/show/My:Maintenance" [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Authenticating with iChain mode: off [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Authenticated request to "/project/show/My:Maintenance" from tom [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] User Load (0.0ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'tom' LIMIT 1 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Configuration Load (0.0ms) SELECT `configurations`.* FROM `configurations` ORDER BY `configurations`.`id` ASC LIMIT 1 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] 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 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] 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 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] DbProjectType Load (0.0ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 2 LIMIT 1 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`id` IS NULL LIMIT 1 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] DbProjectType Load (0.0ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`name` = 'maintenance_incident' LIMIT 1 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77]  (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') [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`maintenance_project_id` = 384404400 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77]  (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 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] LinkedProject Load (0.0ms) SELECT `linked_projects`.* FROM `linked_projects` WHERE `linked_projects`.`db_project_id` = 384404400 ORDER BY `linked_projects`.`position` ASC [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77]  (0.0ms) SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND 1=0 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] 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'  [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77]  (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')) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77]  (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') [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77]  (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') [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77]  (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:%')) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] --> direct_http url: "/build/My:Maintenance/_result?view=status&code=failed&code=broken&code=unresolvable" [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] http_do: method: get url: http://localhost:3200/build/My:Maintenance/_result?view=status&code=failed&c... [10352:551.51] 2013-11-13 14:53:47 [16520]: GET /build/My:Maintenance/_result?view=status&code=failed&code=broken&code=unresolvable [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77]  (0.0ms) SELECT COUNT(*) FROM `release_targets` WHERE `release_targets`.`repository_id` IN (SELECT `repositories`.`id` FROM `repositories` WHERE `repositories`.`db_project_id` = 384404400) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77]  (0.0ms) SELECT `relationships`.`user_id` FROM `relationships` WHERE `relationships`.`project_id` = 384404400 AND `relationships`.`role_id` = 353348001 AND (user_id is not null) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Relationship Load (0.0ms) SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`project_id` = 384404400 AND `relationships`.`role_id` = 353348001 AND (group_id is not null) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] User Load (0.0ms) SELECT `users`.* FROM `users` WHERE 1=0 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Comment Load (0.0ms) SELECT `comments`.* FROM `comments` WHERE `comments`.`project_id` = 384404400 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Project Exists (0.0ms) SELECT 1 AS one FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'My' LIMIT 1 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] 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 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Rendered webui/app/views/webui/project/_tabs.html.erb (0.0ms) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] No alt/title text for sprite_tag [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] No alt/title text for sprite_tag [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Rendered webui/app/views/shared/_open_requests.html.erb (0.0ms) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] 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 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] has_global_permission? change_project [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] 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 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] 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' [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] running local permission check: user tom, project My:Maintenance, permission 'change_project' [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] 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 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] 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 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] 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 [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] No alt/title text for sprite_tag [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] No alt/title text for sprite_tag [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Rendered webui/app/views/layouts/webui/_watch_and_search.html.erb (0.0ms) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Rendered webui/app/views/layouts/webui/_header.html.erb (0.0ms) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Rendered webui/app/views/layouts/webui/_personal_navigation.html.erb (0.0ms) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Rendered webui/app/views/layouts/webui/_flash.html.erb (0.0ms) [e0858089-669f-474e-b7b8-22203c32da8b] [10340:7.77] Completed 200 OK in 0ms (Views: 0.0ms | ActiveRecord: 0.0ms | Backend: 0.0ms | XML: 0.0ms) [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] Started GET "/project/toggle_watch/My:Maintenance" for 127.0.0.1 at 2013-11-13 14:53:52 +0000 [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] Processing by Webui::ProjectController#toggle_watch as HTML [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] Parameters: {"project"=>"My:Maintenance"} [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] Setting return_to: "/project/toggle_watch/My:Maintenance" [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] Authenticating with iChain mode: off [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] Authenticated request to "/project/toggle_watch/My:Maintenance" from tom [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] User Load (0.0ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'tom' LIMIT 1 [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] Configuration Load (0.0ms) SELECT `configurations`.* FROM `configurations` ORDER BY `configurations`.`id` ASC LIMIT 1 [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] 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 [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] 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 [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] DbProjectType Load (0.0ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 2 LIMIT 1 [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] Remove My:Maintenance from watchlist for tom [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] 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) [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] SQL (0.0ms) UPDATE `users` SET `users`.`updated_at` = '2013-11-13 14:53:52' WHERE `users`.`id` = 1038054164 [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] Redirected to http://127.0.0.1:43029/project/show/My:Maintenance [27ced8c9-4bec-4b1b-afe5-4d99e48dfb75] [10340:7.77] Completed 302 Found in 0ms (ActiveRecord: 0.0ms | Backend: 0.0ms | XML: 0.0ms) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Started GET "/project/show/My:Maintenance" for 127.0.0.1 at 2013-11-13 14:53:52 +0000 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Processing by Webui::ProjectController#show as HTML [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Parameters: {"project"=>"My:Maintenance"} [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Setting return_to: "/project/show/My:Maintenance" [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Authenticating with iChain mode: off [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Authenticated request to "/project/show/My:Maintenance" from tom [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] User Load (0.0ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'tom' LIMIT 1 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Configuration Load (0.0ms) SELECT `configurations`.* FROM `configurations` ORDER BY `configurations`.`id` ASC LIMIT 1 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] 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 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] 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 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] DbProjectType Load (0.0ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 2 LIMIT 1 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`id` IS NULL LIMIT 1 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] DbProjectType Load (0.0ms) SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`name` = 'maintenance_incident' LIMIT 1 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77]  (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') [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Project Load (0.0ms) SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`maintenance_project_id` = 384404400 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77]  (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 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] LinkedProject Load (0.0ms) SELECT `linked_projects`.* FROM `linked_projects` WHERE `linked_projects`.`db_project_id` = 384404400 ORDER BY `linked_projects`.`position` ASC [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77]  (0.0ms) SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND 1=0 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] 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' [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77]  (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')) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77]  (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') [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77]  (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') [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77]  (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:%')) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] --> direct_http url: "/build/My:Maintenance/_result?view=status&code=failed&code=broken&code=unresolvable" [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] http_do: method: get url: http://localhost:3200/build/My:Maintenance/_result?view=status&code=failed&c... [10352:551.71] 2013-11-13 14:53:47 [16521]: GET /build/My:Maintenance/_result?view=status&code=failed&code=broken&code=unresolvable [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77]  (0.0ms) SELECT COUNT(*) FROM `release_targets` WHERE `release_targets`.`repository_id` IN (SELECT `repositories`.`id` FROM `repositories` WHERE `repositories`.`db_project_id` = 384404400) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77]  (0.0ms) SELECT `relationships`.`user_id` FROM `relationships` WHERE `relationships`.`project_id` = 384404400 AND `relationships`.`role_id` = 353348001 AND (user_id is not null) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Relationship Load (0.0ms) SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`project_id` = 384404400 AND `relationships`.`role_id` = 353348001 AND (group_id is not null) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] User Load (0.0ms) SELECT `users`.* FROM `users` WHERE 1=0 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Comment Load (0.0ms) SELECT `comments`.* FROM `comments` WHERE `comments`.`project_id` = 384404400 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Project Exists (0.0ms) SELECT 1 AS one FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND `projects`.`name` = 'My' LIMIT 1 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] 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 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Rendered webui/app/views/webui/project/_tabs.html.erb (0.0ms) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] No alt/title text for sprite_tag [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] No alt/title text for sprite_tag [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Rendered webui/app/views/shared/_open_requests.html.erb (0.0ms) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] 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 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] has_global_permission? change_project [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] 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 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] 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' [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] running local permission check: user tom, project My:Maintenance, permission 'change_project' [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] 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 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] 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 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] 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 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] No alt/title text for sprite_tag [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] No alt/title text for sprite_tag [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77]  (0.0ms) SELECT `watched_projects`.`project_id` FROM `watched_projects` WHERE `watched_projects`.`user_id` = 1038054164 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77]  (0.0ms) SELECT `projects`.`name` FROM `projects` WHERE (projects.id not in (0,200758022,95947991)) AND 1=0 [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Rendered webui/app/views/layouts/webui/_watch_and_search.html.erb (0.0ms) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Rendered webui/app/views/layouts/webui/_header.html.erb (0.0ms) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Rendered webui/app/views/layouts/webui/_personal_navigation.html.erb (0.0ms) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Rendered webui/app/views/layouts/webui/_flash.html.erb (0.0ms) [1709f319-2bdd-49c5-be24-a37ebe212958] [10340:7.77] Completed 200 OK in 0ms (Views: 0.0ms | ActiveRecord: 0.0ms | Backend: 0.0ms | XML: 0.0ms) [10340:567.01]  (0.0ms) ROLLBACK [10340:567.01]  (0.0ms) BEGIN [10340:567.01] -------------------------------------- [10340:567.01] WebuiPackageTest: test_is_binary_file? [10340:567.01] -------------------------------------- [10340:567.01]  (0.0ms) ROLLBACK [ab582972-270a-4e81-a5f0-a5b3a97608de] [10859:0.00] Started POST "/test/killme" for 127.0.0.1 at 2013-11-13 14:53:52 +0000 [ab582972-270a-4e81-a5f0-a5b3a97608de] [10859:0.00] Processing by TestController#killme as */* [ab582972-270a-4e81-a5f0-a5b3a97608de] [10859:0.00] Can't verify CSRF token authenticity [ab582972-270a-4e81-a5f0-a5b3a97608de] [10859:0.00] Validate XML request: #<ActionDispatch::Request:0x0000000482fad8> [ab582972-270a-4e81-a5f0-a5b3a97608de] [10859:0.00] no schema found, skipping validation for {"controller"=>"test", "action"=>"killme", "method"=>"POST", "type"=>"request"} [ab582972-270a-4e81-a5f0-a5b3a97608de] [10859:0.01] Rendered status.xml.builder (0.3ms) [ab582972-270a-4e81-a5f0-a5b3a97608de] [10859:0.01] no schema found, skipping validation for {"controller"=>"test", "action"=>"killme", "method"=>"POST", "type"=>"response"} [ab582972-270a-4e81-a5f0-a5b3a97608de] [10859:0.01] Validate XML response: #<ActionDispatch::Response:0x0000000482fa38> took 0ms [ab582972-270a-4e81-a5f0-a5b3a97608de] [10859:0.01] Completed 200 OK in 3ms (Views: 1.1ms | ActiveRecord: 0.0ms | Backend: 0.0ms | XML: 0.0ms) + echo + cleanup + echo 'Killing backend processes' Killing backend processes + egrep 'perl|ruby' + fuser -v <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/> USER PID ACCESS COMMAND <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/>: ci ..c.. sh ci ..c.. sh ci ..c.. egrep ci ..c.. fuser + 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/binlog src/api/tmp/cache src/api/tmp/capybara src/api/tmp/pids 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