See http://ci.opensuse.org/job/obs_master_testsuite_api/1255/changes Changes: [Stephan Kulow] [webui] make the default font size 9pt for codemirror [adrian] [api] fix product building with repos accessable via /public route [adrian] [backend] fix two warning messages in product converter [adrian] [api] support search of maintained packages of a user [adrian] [api] support search for not maintained package containers [adrian] [api] owner search code cleanup and fixing [adrian] [api] follow the changed behaviour of the backend in interconnect case ------------------------------------------ [...truncated 130963 lines...] [DEBUG|# 4390] 2012-12-07 13:08:21 [10410]: PUT /source/kde4/_meta?user=king [DEBUG|# 4385] request took 0.008652853 [DEBUG|# 4385]  (0.1ms) RELEASE SAVEPOINT active_record_1 [DEBUG|# 4385] Validate XML response: #ActionDispatch::Response:0x000000071f0f20 took 0ms [INFO |# 4385] Completed 200 OK in 55ms (Views: 0.7ms | ActiveRecord: 4.9ms | Backend: 8.7ms | XML: 0.0ms) [INFO |# 4385] Started GET "/source/kde4/_meta" for 127.0.0.1 at 2012-12-07 13:08:21 +0100 [INFO |# 4385] Processing by SourceController#project_meta as XML [INFO |# 4385] Parameters: {"project"=>"kde4"} [DEBUG|# 4385] Validate XML request: #ActionDispatch::Request:0x000000078436c0 [DEBUG|# 4385] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"project_meta", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [DEBUG|# 4385] User Load (0.5ms) SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [DEBUG|# 4385] USER found: king [DEBUG|# 4385] User king initialised [DEBUG|# 4385] ProjectUserRoleRelationship Load (0.2ms) SELECT ur.db_project_id, ur.bs_user_id from flags f, project_user_role_relationships ur where f.flag = 'access' and ur.db_project_id = f.db_project_id [DEBUG|# 4385] Role Load (0.3ms) SELECT DISTINCT roles.id FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1 [DEBUG|# 4385] Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Validate XML response: #ActionDispatch::Response:0x000000078435a8 took 2ms [INFO |# 4385] Completed 200 OK in 12ms (Views: 0.5ms | ActiveRecord: 1.3ms | Backend: 0.0ms | XML: 0.0ms) [INFO |# 4385] Started GET "/source/kde4" for 127.0.0.1 at 2012-12-07 13:08:21 +0100 [INFO |# 4385] Processing by SourceController#index_project as XML [INFO |# 4385] Parameters: {"project"=>"kde4"} [DEBUG|# 4385] Validate XML request: #ActionDispatch::Request:0x000000078fdc00 [DEBUG|# 4385] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [DEBUG|# 4385] User Load (0.3ms) SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [DEBUG|# 4385] USER found: king [DEBUG|# 4385] User king initialised [DEBUG|# 4385] Role Load (0.4ms) SELECT DISTINCT roles.id FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1 [DEBUG|# 4385] Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Package Load (0.3ms) SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND (packages.db_project_id not in (0)) [DEBUG|# 4385] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [DEBUG|# 4385] Validate XML response: #ActionDispatch::Response:0x000000078fdbb0 took 0ms [INFO |# 4385] Completed 200 OK in 10ms (Views: 0.4ms | ActiveRecord: 1.1ms | Backend: 0.0ms | XML: 0.0ms) [INFO |# 4385] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2012-12-07 13:08:21 +0100 [INFO |# 4385] Processing by SourceController#package_meta as XML [INFO |# 4385] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [DEBUG|# 4385] Validate XML request: #ActionDispatch::Request:0x00000007a12ac8 [DEBUG|# 4385] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [DEBUG|# 4385] User Load (0.3ms) SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [DEBUG|# 4385] USER found: king [DEBUG|# 4385] User king initialised [DEBUG|# 4385] get_by_project_and_name {} [DEBUG|# 4385] Role Load (0.3ms) SELECT DISTINCT roles.id FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1 [DEBUG|# 4385] Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Package Load (0.2ms) SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [DEBUG|# 4385] Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] ----------------- rendering package kdebase ------------------------ [DEBUG|# 4385] PackageUserRoleRelationship Load (0.2ms) SELECT users.login as login, roles.title AS role_name FROM `package_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `package_user_role_relationships`.`bs_user_id` WHERE `package_user_role_relationships`.`db_package_id` = 2 [DEBUG|# 4385] PackageGroupRoleRelationship Load (0.2ms) SELECT groups.title as title, roles.title as role_name FROM `package_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `package_group_role_relationships`.`bs_group_id` WHERE `package_group_role_relationships`.`db_package_id` = 2 [DEBUG|# 4385] Flag Load (0.2ms) SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position [DEBUG|# 4385] ----------------- end rendering package kdebase ------------------------ [DEBUG|# 4385] Validate XML response: #ActionDispatch::Response:0x00000007a12a78 took 2ms [INFO |# 4385] Completed 200 OK in 17ms (Views: 0.3ms | ActiveRecord: 1.6ms | Backend: 0.0ms | XML: 0.2ms) [INFO |# 4385] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2012-12-07 13:08:21 +0100 [INFO |# 4385] Processing by SourceController#package_meta as XML [INFO |# 4385] Parameters: {""\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [DEBUG|# 4385] Validate XML request: #ActionDispatch::Request:0x0000000797d1f8 [DEBUG|# 4385] User Load (0.2ms) SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [DEBUG|# 4385] USER found: king [DEBUG|# 4385] User king initialised [DEBUG|# 4385] Role Load (0.3ms) SELECT DISTINCT roles.id FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1 [DEBUG|# 4385] Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Package Load (0.2ms) SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [DEBUG|# 4385] Project Load (0.1ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] get_by_project_and_name {} [DEBUG|# 4385] CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] CACHE (0.0ms) SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [DEBUG|# 4385] CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Flag Load (0.2ms) SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1 [DEBUG|# 4385] Flag Load (0.2ms) SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [DEBUG|# 4385] Flag Load (0.2ms) SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position [DEBUG|# 4385] flagcheck: package has default state, checking project [DEBUG|# 4385] Flag Load (0.2ms) SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [DEBUG|# 4385] disabled_for sourceaccess repo: arch: state:enable [DEBUG|# 4385] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [DEBUG|# 4385]  (0.1ms) SAVEPOINT active_record_1 [DEBUG|# 4385] PackageUserRoleRelationship Load (0.1ms) SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 2 [DEBUG|# 4385] ----------------- rendering package kdebase ------------------------ [DEBUG|# 4385] PackageUserRoleRelationship Load (0.2ms) SELECT users.login as login, roles.title AS role_name FROM `package_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `package_user_role_relationships`.`bs_user_id` WHERE `package_user_role_relationships`.`db_package_id` = 2 [DEBUG|# 4385] PackageGroupRoleRelationship Load (0.2ms) SELECT groups.title as title, roles.title as role_name FROM `package_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `package_group_role_relationships`.`bs_group_id` WHERE `package_group_role_relationships`.`db_package_id` = 2 [DEBUG|# 4385] ----------------- end rendering package kdebase ------------------------ [DEBUG|# 4385] [backend] PUT: /source/kde4/kdebase/_meta?user=king [DEBUG|# 4390] 2012-12-07 13:08:21 [10411]: PUT /source/kde4/kdebase/_meta?user=king [DEBUG|# 4385] request took 0.009662037 [DEBUG|# 4385] Package Load (0.6ms) SELECT packages.*, ( @activity:=( packages.activity_index - POWER( TIME_TO_SEC( TIMEDIFF( NOW(), packages.updated_at ))/86400, 1.55 ) /10 ) ) AS act_tmp, IF( @activity<0, 0, @activity ) AS activity_value FROM `packages` WHERE id = 2 LIMIT 1 [DEBUG|# 4385] PackageGroupRoleRelationship Load (0.3ms) SELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 2 [DEBUG|# 4385] ----------------- rendering package kdebase ------------------------ [DEBUG|# 4385] CACHE (0.0ms) SELECT users.login as login, roles.title AS role_name FROM `package_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `package_user_role_relationships`.`bs_user_id` WHERE `package_user_role_relationships`.`db_package_id` = 2 [DEBUG|# 4385] CACHE (0.0ms) SELECT groups.title as title, roles.title as role_name FROM `package_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `package_group_role_relationships`.`bs_group_id` WHERE `package_group_role_relationships`.`db_package_id` = 2 [DEBUG|# 4385] ----------------- end rendering package kdebase ------------------------ [DEBUG|# 4385] [backend] PUT: /source/kde4/kdebase/_meta?user=king [DEBUG|# 4390] 2012-12-07 13:08:21 [10412]: PUT /source/kde4/kdebase/_meta?user=king [DEBUG|# 4385] request took 0.008734536 [DEBUG|# 4385] CACHE (0.0ms) SELECT packages.*, ( @activity:=( packages.activity_index - POWER( TIME_TO_SEC( TIMEDIFF( NOW(), packages.updated_at ))/86400, 1.55 ) /10 ) ) AS act_tmp, IF( @activity<0, 0, @activity ) AS activity_value FROM `packages` WHERE id = 2 LIMIT 1 [DEBUG|# 4385] ----------------- rendering package kdebase ------------------------ [DEBUG|# 4385] CACHE (0.0ms) SELECT users.login as login, roles.title AS role_name FROM `package_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `package_user_role_relationships`.`bs_user_id` WHERE `package_user_role_relationships`.`db_package_id` = 2 [DEBUG|# 4385] CACHE (0.0ms) SELECT groups.title as title, roles.title as role_name FROM `package_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `package_group_role_relationships`.`bs_group_id` WHERE `package_group_role_relationships`.`db_package_id` = 2 [DEBUG|# 4385] ----------------- end rendering package kdebase ------------------------ [DEBUG|# 4385] [backend] PUT: /source/kde4/kdebase/_meta?user=king [DEBUG|# 4390] 2012-12-07 13:08:21 [10413]: PUT /source/kde4/kdebase/_meta?user=king [DEBUG|# 4385] request took 0.011111668 [DEBUG|# 4385] CACHE (0.0ms) SELECT packages.*, ( @activity:=( packages.activity_index - POWER( TIME_TO_SEC( TIMEDIFF( NOW(), packages.updated_at ))/86400, 1.55 ) /10 ) ) AS act_tmp, IF( @activity<0, 0, @activity ) AS activity_value FROM `packages` WHERE id = 2 LIMIT 1 [DEBUG|# 4385]  (0.1ms) RELEASE SAVEPOINT active_record_1 [DEBUG|# 4385] Validate XML response: #ActionDispatch::Response:0x0000000797d1d0 took 1ms [INFO |# 4385] Completed 200 OK in 182ms (Views: 1.1ms | ActiveRecord: 3.2ms | Backend: 29.5ms | XML: 0.0ms) [INFO |# 4385] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2012-12-07 13:08:21 +0100 [INFO |# 4385] Processing by SourceController#package_meta as XML [INFO |# 4385] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [DEBUG|# 4385] Validate XML request: #ActionDispatch::Request:0x000000049f9030 [DEBUG|# 4385] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [DEBUG|# 4385] User Load (0.3ms) SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [DEBUG|# 4385] USER found: king [DEBUG|# 4385] User king initialised [DEBUG|# 4385] get_by_project_and_name {} [DEBUG|# 4385] Role Load (0.3ms) SELECT DISTINCT roles.id FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1 [DEBUG|# 4385] Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Package Load (0.3ms) SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [DEBUG|# 4385] Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Validate XML response: #ActionDispatch::Response:0x000000049f90d0 took 2ms [INFO |# 4385] Completed 200 OK in 15ms (Views: 0.4ms | ActiveRecord: 1.3ms | Backend: 0.0ms | XML: 0.0ms) [INFO |# 4385] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2012-12-07 13:08:21 +0100 [INFO |# 4385] Processing by SourceController#package_meta as XML [INFO |# 4385] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [DEBUG|# 4385] Validate XML request: #ActionDispatch::Request:0x00000005a1a888 [DEBUG|# 4385] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [DEBUG|# 4385] User Load (0.3ms) SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [DEBUG|# 4385] USER found: king [DEBUG|# 4385] User king initialised [DEBUG|# 4385] get_by_project_and_name {} [DEBUG|# 4385] Role Load (0.3ms) SELECT DISTINCT roles.id FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1 [DEBUG|# 4385] Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Package Load (0.3ms) SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [DEBUG|# 4385] Project Load (0.1ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] ----------------- rendering package kdelibs ------------------------ [DEBUG|# 4385] Package Load (0.2ms) SELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) LIMIT 1 [DEBUG|# 4385] Project Load (0.1ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] PackageUserRoleRelationship Load (0.3ms) SELECT users.login as login, roles.title AS role_name FROM `package_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `package_user_role_relationships`.`bs_user_id` WHERE `package_user_role_relationships`.`db_package_id` = 1 [DEBUG|# 4385] PackageGroupRoleRelationship Load (0.2ms) SELECT groups.title as title, roles.title as role_name FROM `package_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `package_group_role_relationships`.`bs_group_id` WHERE `package_group_role_relationships`.`db_package_id` = 1 [DEBUG|# 4385] Flag Load (0.2ms) SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position [DEBUG|# 4385] ----------------- end rendering package kdelibs ------------------------ [DEBUG|# 4385] Validate XML response: #ActionDispatch::Response:0x00000005a1a838 took 2ms [INFO |# 4385] Completed 200 OK in 23ms (Views: 0.4ms | ActiveRecord: 2.3ms | Backend: 0.0ms | XML: 0.0ms) [INFO |# 4385] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2012-12-07 13:08:21 +0100 [INFO |# 4385] Processing by SourceController#package_meta as XML [INFO |# 4385] Parameters: {""\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n \n \n \n \n</package>\n", "project"=>"kde4", "package"=>"kdelibs"} [DEBUG|# 4385] Validate XML request: #ActionDispatch::Request:0x00000006a34a98 [DEBUG|# 4385] User Load (0.2ms) SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [DEBUG|# 4385] USER found: king [DEBUG|# 4385] User king initialised [DEBUG|# 4385] Role Load (0.2ms) SELECT DISTINCT roles.id FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1 [DEBUG|# 4385] Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Package Load (0.2ms) SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [DEBUG|# 4385] Project Load (0.1ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] get_by_project_and_name {} [DEBUG|# 4385] CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] CACHE (0.0ms) SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [DEBUG|# 4385] CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Flag Load (0.3ms) SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1 [DEBUG|# 4385] Flag Load (0.2ms) SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [DEBUG|# 4385] Flag Load (0.2ms) SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position [DEBUG|# 4385] flagcheck: package has default state, checking project [DEBUG|# 4385] Flag Load (0.1ms) SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [DEBUG|# 4385] disabled_for sourceaccess repo: arch: state:enable [DEBUG|# 4385] xml_disabled? X({"name"=>"kdelibs", "project"=>"kde4", "title"=>"blub", "description"=>"blub", "devel"=>X({"project"=>"home:coolo:test", "package"=>"kdelibs_DEVEL_package"}), "person"=>[X({"userid"=>"fredlibs", "role"=>"maintainer"}), X({"userid"=>"adrian", "role"=>"reviewer"})], "group"=>X({"groupid"=>"test_group", "role"=>"maintainer"})}) [DEBUG|# 4385]  (0.1ms) SAVEPOINT active_record_1 [DEBUG|# 4385] Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'home:coolo:test' AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Package Load (0.2ms) SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 601 AND `packages`.`name` = 'kdelibs_DEVEL_package' AND (packages.db_project_id not in (0)) LIMIT 1 [DEBUG|# 4385] Project Load (0.1ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] PackageUserRoleRelationship Load (0.1ms) SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 1 [DEBUG|# 4385] User Load (0.1ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1 [DEBUG|# 4385] Role Load (0.1ms) SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1 [DEBUG|# 4385] User Load (0.1ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 LIMIT 1 [DEBUG|# 4385] Role Load (0.1ms) SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 LIMIT 1 [DEBUG|# 4385] ----------------- rendering package kdelibs ------------------------ [DEBUG|# 4385] PackageUserRoleRelationship Load (0.2ms) SELECT users.login as login, roles.title AS role_name FROM `package_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `package_user_role_relationships`.`bs_user_id` WHERE `package_user_role_relationships`.`db_package_id` = 1 [DEBUG|# 4385] PackageGroupRoleRelationship Load (0.2ms) SELECT groups.title as title, roles.title as role_name FROM `package_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `package_group_role_relationships`.`bs_group_id` WHERE `package_group_role_relationships`.`db_package_id` = 1 [DEBUG|# 4385] ----------------- end rendering package kdelibs ------------------------ [DEBUG|# 4385] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [DEBUG|# 4390] 2012-12-07 13:08:21 [10414]: PUT /source/kde4/kdelibs/_meta?user=king [DEBUG|# 4385] request took 0.010583436 [DEBUG|# 4385] Package Load (0.3ms) SELECT packages.*, ( @activity:=( packages.activity_index - POWER( TIME_TO_SEC( TIMEDIFF( NOW(), packages.updated_at ))/86400, 1.55 ) /10 ) ) AS act_tmp, IF( @activity<0, 0, @activity ) AS activity_value FROM `packages` WHERE id = 1 LIMIT 1 [DEBUG|# 4385] User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [DEBUG|# 4385] User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [DEBUG|# 4385] PackageGroupRoleRelationship Load (0.2ms) SELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 1 [DEBUG|# 4385] Group Load (0.2ms) SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 LIMIT 1 [DEBUG|# 4385] CACHE (0.0ms) SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1 [DEBUG|# 4385] Group Load (0.2ms) SELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1 [DEBUG|# 4385] ----------------- rendering package kdelibs ------------------------ [DEBUG|# 4385] CACHE (0.0ms) SELECT users.login as login, roles.title AS role_name FROM `package_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `package_user_role_relationships`.`bs_user_id` WHERE `package_user_role_relationships`.`db_package_id` = 1 [DEBUG|# 4385] CACHE (0.0ms) SELECT groups.title as title, roles.title as role_name FROM `package_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `package_group_role_relationships`.`bs_group_id` WHERE `package_group_role_relationships`.`db_package_id` = 1 [DEBUG|# 4385] ----------------- end rendering package kdelibs ------------------------ [DEBUG|# 4385] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [DEBUG|# 4390] 2012-12-07 13:08:21 [10415]: PUT /source/kde4/kdelibs/_meta?user=king [DEBUG|# 4385] request took 0.0112726 [DEBUG|# 4385] CACHE (0.0ms) SELECT packages.*, ( @activity:=( packages.activity_index - POWER( TIME_TO_SEC( TIMEDIFF( NOW(), packages.updated_at ))/86400, 1.55 ) /10 ) ) AS act_tmp, IF( @activity<0, 0, @activity ) AS activity_value FROM `packages` WHERE id = 1 LIMIT 1 [DEBUG|# 4385] ----------------- rendering package kdelibs ------------------------ [DEBUG|# 4385] CACHE (0.0ms) SELECT users.login as login, roles.title AS role_name FROM `package_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `package_user_role_relationships`.`bs_user_id` WHERE `package_user_role_relationships`.`db_package_id` = 1 [DEBUG|# 4385] CACHE (0.0ms) SELECT groups.title as title, roles.title as role_name FROM `package_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `package_group_role_relationships`.`bs_group_id` WHERE `package_group_role_relationships`.`db_package_id` = 1 [DEBUG|# 4385] ----------------- end rendering package kdelibs ------------------------ [DEBUG|# 4385] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [DEBUG|# 4390] 2012-12-07 13:08:21 [10416]: PUT /source/kde4/kdelibs/_meta?user=king [DEBUG|# 4385] request took 0.014412501 [DEBUG|# 4385] CACHE (0.0ms) SELECT packages.*, ( @activity:=( packages.activity_index - POWER( TIME_TO_SEC( TIMEDIFF( NOW(), packages.updated_at ))/86400, 1.55 ) /10 ) ) AS act_tmp, IF( @activity<0, 0, @activity ) AS activity_value FROM `packages` WHERE id = 1 LIMIT 1 [DEBUG|# 4385]  (0.9ms) RELEASE SAVEPOINT active_record_1 [DEBUG|# 4385] Validate XML response: #ActionDispatch::Response:0x00000006a34a70 took 0ms [INFO |# 4385] Completed 200 OK in 96ms (Views: 0.9ms | ActiveRecord: 5.7ms | Backend: 36.3ms | XML: 0.0ms) [INFO |# 4385] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2012-12-07 13:08:21 +0100 [INFO |# 4385] Processing by SourceController#package_meta as XML [INFO |# 4385] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [DEBUG|# 4385] Validate XML request: #ActionDispatch::Request:0x000000072e0110 [DEBUG|# 4385] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [DEBUG|# 4385] User Load (12.4ms) SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [DEBUG|# 4385] USER found: king [DEBUG|# 4385] User king initialised [DEBUG|# 4385] get_by_project_and_name {} [DEBUG|# 4385] Role Load (0.5ms) SELECT DISTINCT roles.id FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1 [DEBUG|# 4385] Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Package Load (0.3ms) SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [DEBUG|# 4385] Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [DEBUG|# 4385] Validate XML response: #ActionDispatch::Response:0x000000072e00c0 took 2ms [INFO |# 4385] Completed 200 OK in 25ms (Views: 0.4ms | ActiveRecord: 13.6ms | Backend: 0.0ms | XML: 0.0ms) [DEBUG|# 4385]  (5.8ms) ROLLBACK [DEBUG|# 4385] kill 4390 + 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/: jenkins ..c.. sh jenkins ..c.. sh jenkins ..c.. egrep + 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/tmp/cache src/api/tmp/pids src/api/tmp/sessions src/api/tmp/sockets 'src/webui/log/*' src/webui/tmp/cache src/webui/tmp/pids src/webui/tmp/sessions src/webui/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 Recording test results -- To unsubscribe, e-mail: obs-tests+unsubscribe@opensuse.org To contact the owner, e-mail: obs-tests+owner@opensuse.org