[obs-tests] Build failed in Jenkins: obs_master_testsuite_api #1315
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1315/changes> Changes: [mls] [backend] BSHTTP: support mode in cpio sender/receiver [mls] [backend] src server: implement sslcert management [mls] [backend] implement followup job handling in signer and worker ------------------------------------------ [...truncated 124035 lines...] [[0;37mDEBUG[0m|#31205] User king initialised [[0;37mDEBUG[0m|#31205] [1m[36mProjectUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] [1m[35mRole Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|#31205] [1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] Validate XML response: #<ActionDispatch::Response:0x00000007f67a28> took 2ms [[32mINFO [0m|#31205] Completed 200 OK in 9ms (Views: 0.5ms | ActiveRecord: 0.9ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#31205] Started GET "/source/kde4" for 127.0.0.1 at 2013-01-18 16:04:32 +0100 [[32mINFO [0m|#31205] Processing by SourceController#index_project as XML [[32mINFO [0m|#31205] Parameters: {"project"=>"kde4"} [[0;37mDEBUG[0m|#31205] Validate XML request: #<ActionDispatch::Request:0x00000007ff0cb0> [[0;37mDEBUG[0m|#31205] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#31205] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#31205] USER found: king [[0;37mDEBUG[0m|#31205] User king initialised [[0;37mDEBUG[0m|#31205] [1m[36mRole Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#31205] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [[0;37mDEBUG[0m|#31205] Validate XML response: #<ActionDispatch::Response:0x00000007ff0c60> took 0ms [[32mINFO [0m|#31205] Completed 200 OK in 8ms (Views: 0.4ms | ActiveRecord: 1.2ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#31205] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-18 16:04:32 +0100 [[32mINFO [0m|#31205] Processing by SourceController#package_meta as XML [[32mINFO [0m|#31205] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|#31205] Validate XML request: #<ActionDispatch::Request:0x00000008192988> [[0;37mDEBUG[0m|#31205] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#31205] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#31205] USER found: king [[0;37mDEBUG[0m|#31205] User king initialised [[0;37mDEBUG[0m|#31205] get_by_project_and_name {} [[0;37mDEBUG[0m|#31205] [1m[36mRole Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mProject Load (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#31205] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#31205] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position[0m [[0;37mDEBUG[0m|#31205] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#31205] Validate XML response: #<ActionDispatch::Response:0x00000008192960> took 1ms [[32mINFO [0m|#31205] Completed 200 OK in 16ms (Views: 0.0ms | ActiveRecord: 1.7ms | Backend: 0.0ms | XML: 0.3ms) [[32mINFO [0m|#31205] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-18 16:04:32 +0100 [[32mINFO [0m|#31205] Processing by SourceController#package_meta as XML [[32mINFO [0m|#31205] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|#31205] Validate XML request: #<ActionDispatch::Request:0x00000008093e60> [[0;37mDEBUG[0m|#31205] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#31205] USER found: king [[0;37mDEBUG[0m|#31205] User king initialised [[0;37mDEBUG[0m|#31205] [1m[36mRole Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] get_by_project_and_name {} [[0;37mDEBUG[0m|#31205] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mCACHE (0.0ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position [[0;37mDEBUG[0m|#31205] flagcheck: package has default state, checking project [[0;37mDEBUG[0m|#31205] [1m[36mFlag Load (0.1ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [[0;37mDEBUG[0m|#31205] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|#31205] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [[0;37mDEBUG[0m|#31205] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [[0;37mDEBUG[0m|#31205] [1m[36mPackageUserRoleRelationship Load (0.1ms)[0m [1mSELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 2[0m [[0;37mDEBUG[0m|#31205] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358521472)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `activity_index` = 10.000000000020343 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#31205] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-18 15:04:32' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#31205] [1m[36m (0.1ms)[0m [1mUPDATE `packages` SET `update_counter` = 1, `updated_at` = '2013-01-18 15:04:32' WHERE `packages`.`id` = 2[0m [[0;37mDEBUG[0m|#31205] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#31205] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#31205] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#31205] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#31210] 2013-01-18 16:04:32 [4240]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#31205] request took 0.009949652 [[0;37mDEBUG[0m|#31205] [1m[35mPackageGroupRoleRelationship Load (2.6ms)[0m SELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 2 [[0;37mDEBUG[0m|#31205] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358521473)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `activity_index` = 9.996975930703718 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#31205] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-18 15:04:33' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#31205] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 2, `updated_at` = '2013-01-18 15:04:33' WHERE `packages`.`id` = 2 [[0;37mDEBUG[0m|#31205] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#31205] [1m[36mPackageUserRoleRelationship Load (0.7ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] [1m[35mPackageGroupRoleRelationship Load (0.1ms)[0m 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 [[0;37mDEBUG[0m|#31205] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#31205] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#31210] 2013-01-18 16:04:33 [4241]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#31205] request took 0.008807662 [[0;37mDEBUG[0m|#31205] [1m[36mPackage Load (0.4ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358521473)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 9.993937752245316 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#31205] [1m[36mSQL (0.1ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-18 15:04:33' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#31205] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 3, `updated_at` = '2013-01-18 15:04:33' WHERE `packages`.`id` = 2 [[0;37mDEBUG[0m|#31205] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#31205] [1m[36mPackageUserRoleRelationship Load (7.6ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] [1m[35mPackageGroupRoleRelationship Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|#31205] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#31205] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#31210] 2013-01-18 16:04:33 [4242]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#31205] request took 0.009574307 [[0;37mDEBUG[0m|#31205] [1m[36m (0.1ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|#31205] Validate XML response: #<ActionDispatch::Response:0x00000008093e38> took 0ms [[32mINFO [0m|#31205] Completed 200 OK in 224ms (Views: 1.0ms | ActiveRecord: 16.1ms | Backend: 28.3ms | XML: 0.0ms) [[32mINFO [0m|#31205] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-18 16:04:33 +0100 [[32mINFO [0m|#31205] Processing by SourceController#package_meta as XML [[32mINFO [0m|#31205] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|#31205] Validate XML request: #<ActionDispatch::Request:0x00000006389e28> [[0;37mDEBUG[0m|#31205] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#31205] [1m[35mUser Load (8.9ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#31205] USER found: king [[0;37mDEBUG[0m|#31205] User king initialised [[0;37mDEBUG[0m|#31205] get_by_project_and_name {} [[0;37mDEBUG[0m|#31205] [1m[36mRole Load (0.4ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] [1m[35mProject Load (0.1ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mPackage Load (0.3ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] Validate XML response: #<ActionDispatch::Response:0x00000006389dd8> took 2ms [[32mINFO [0m|#31205] Completed 200 OK in 23ms (Views: 1.0ms | ActiveRecord: 10.0ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#31205] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-18 16:04:33 +0100 [[32mINFO [0m|#31205] Processing by SourceController#package_meta as XML [[32mINFO [0m|#31205] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|#31205] Validate XML request: #<ActionDispatch::Request:0x00000006aeebf0> [[0;37mDEBUG[0m|#31205] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#31205] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#31205] USER found: king [[0;37mDEBUG[0m|#31205] User king initialised [[0;37mDEBUG[0m|#31205] get_by_project_and_name {} [[0;37mDEBUG[0m|#31205] [1m[35mRole Load (0.4ms)[0m 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 [[0;37mDEBUG[0m|#31205] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mPackage Load (0.3ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#31205] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mPackageUserRoleRelationship Load (0.0ms)[0m 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 [[0;37mDEBUG[0m|#31205] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] [1m[35mFlag Load (0.3ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position [[0;37mDEBUG[0m|#31205] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#31205] Validate XML response: #<ActionDispatch::Response:0x00000006aeeb50> took 2ms [[32mINFO [0m|#31205] Completed 200 OK in 22ms (Views: 0.0ms | ActiveRecord: 2.2ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#31205] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-18 16:04:33 +0100 [[32mINFO [0m|#31205] Processing by SourceController#package_meta as XML [[32mINFO [0m|#31205] Parameters: {"<package name"=>"\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n <devel project=\"home:coolo:test\" package=\"kdelibs_DEVEL_package\"/>\n <person userid=\"fredlibs\" role=\"maintainer\"/>\n <person userid=\"adrian\" role=\"reviewer\"/>\n <group groupid=\"test_group\" role=\"maintainer\"/>\n</package>\n", "project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|#31205] Validate XML request: #<ActionDispatch::Request:0x000000073b5928> [[0;37mDEBUG[0m|#31205] [1m[36mUser Load (0.7ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#31205] USER found: king [[0;37mDEBUG[0m|#31205] User king initialised [[0;37mDEBUG[0m|#31205] [1m[35mRole Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#31205] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] get_by_project_and_name {} [[0;37mDEBUG[0m|#31205] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mCACHE (0.0ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position[0m [[0;37mDEBUG[0m|#31205] flagcheck: package has default state, checking project [[0;37mDEBUG[0m|#31205] [1m[35mFlag Load (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [[0;37mDEBUG[0m|#31205] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|#31205] 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"})}) [[0;37mDEBUG[0m|#31205] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|#31205] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'home:coolo:test' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `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[0m [[0;37mDEBUG[0m|#31205] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mRole Load (0.1ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mUser Load (0.1ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mRole Load (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358521473)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `activity_index` = 10.000000000020343 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#31205] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-18 15:04:33' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#31205] [1m[36m (0.1ms)[0m [1mUPDATE `packages` SET `update_counter` = 1, `updated_at` = '2013-01-18 15:04:33' WHERE `packages`.`id` = 1[0m [[0;37mDEBUG[0m|#31205] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#31205] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#31205] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#31205] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#31210] 2013-01-18 16:04:33 [4243]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#31205] request took 0.009522085 [[0;37mDEBUG[0m|#31205] [1m[35mUser Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mUser Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m SELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 1 [[0;37mDEBUG[0m|#31205] [1m[36mGroup Load (0.0ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358521473)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `activity_index` = 9.996961530375561 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#31205] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-18 15:04:33' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#31205] [1m[36m (0.1ms)[0m [1mUPDATE `packages` SET `update_counter` = 2, `updated_at` = '2013-01-18 15:04:33' WHERE `packages`.`id` = 1[0m [[0;37mDEBUG[0m|#31205] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#31205] [1m[35mPackageUserRoleRelationship Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|#31205] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#31205] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#31210] 2013-01-18 16:04:33 [4244]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#31205] request took 0.01003596 [[0;37mDEBUG[0m|#31205] [1m[35mPackage Load (0.6ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358521473)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `activity_index` = 9.99392356657836 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#31205] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-18 15:04:33' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#31205] [1m[36m (4.0ms)[0m [1mUPDATE `packages` SET `update_counter` = 3, `updated_at` = '2013-01-18 15:04:33' WHERE `packages`.`id` = 1[0m [[0;37mDEBUG[0m|#31205] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#31205] [1m[35mPackageUserRoleRelationship Load (0.4ms)[0m 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 [[0;37mDEBUG[0m|#31205] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#31205] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#31205] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#31210] 2013-01-18 16:04:33 [4245]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#31205] request took 0.010432926 [[0;37mDEBUG[0m|#31205] [1m[35m (0.1ms)[0m RELEASE SAVEPOINT active_record_1 [[0;37mDEBUG[0m|#31205] Validate XML response: #<ActionDispatch::Response:0x000000073b5900> took 0ms [[32mINFO [0m|#31205] Completed 200 OK in 102ms (Views: 0.9ms | ActiveRecord: 12.1ms | Backend: 30.0ms | XML: 0.0ms) [[32mINFO [0m|#31205] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-18 16:04:33 +0100 [[32mINFO [0m|#31205] Processing by SourceController#package_meta as XML [[32mINFO [0m|#31205] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|#31205] Validate XML request: #<ActionDispatch::Request:0x00000007bdcf20> [[0;37mDEBUG[0m|#31205] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#31205] [1m[36mUser Load (9.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#31205] USER found: king [[0;37mDEBUG[0m|#31205] User king initialised [[0;37mDEBUG[0m|#31205] get_by_project_and_name {} [[0;37mDEBUG[0m|#31205] [1m[35mRole Load (0.5ms)[0m 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 [[0;37mDEBUG[0m|#31205] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] [1m[35mPackage Load (0.3ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#31205] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#31205] Validate XML response: #<ActionDispatch::Response:0x00000007bdced0> took 2ms [[32mINFO [0m|#31205] Completed 200 OK in 22ms (Views: 0.5ms | ActiveRecord: 10.5ms | Backend: 0.0ms | XML: 0.0ms) [[0;37mDEBUG[0m|#31205] [1m[35m (36.2ms)[0m ROLLBACK [[0;37mDEBUG[0m|#31205] kill 31210 + echo + cleanup + echo 'Killing backend processes' Killing backend processes + 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/>: jenkins ..c.. sh jenkins ..c.. sh jenkins ..c.. sh + egrep 'perl|ruby' + 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/backend_config src/api/tmp/backend_data src/api/tmp/cache src/api/tmp/pids src/api/tmp/scheduler.done 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
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1316/changes> Changes: [mls] [backend] also recreate the sslcert when recreating the privkey ------------------------------------------ [...truncated 124037 lines...] [[0;37mDEBUG[0m|# 7140] User king initialised [[0;37mDEBUG[0m|# 7140] [1m[35mProjectUserRoleRelationship Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|# 7140] [1m[36mRole Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] Validate XML response: #<ActionDispatch::Response:0x0000000778ca60> took 2ms [[32mINFO [0m|# 7140] Completed 200 OK in 10ms (Views: 0.5ms | ActiveRecord: 1.2ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|# 7140] Started GET "/source/kde4" for 127.0.0.1 at 2013-01-18 17:30:38 +0100 [[32mINFO [0m|# 7140] Processing by SourceController#index_project as XML [[32mINFO [0m|# 7140] Parameters: {"project"=>"kde4"} [[0;37mDEBUG[0m|# 7140] Validate XML request: #<ActionDispatch::Request:0x00000007973ba8> [[0;37mDEBUG[0m|# 7140] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|# 7140] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] USER found: king [[0;37mDEBUG[0m|# 7140] User king initialised [[0;37mDEBUG[0m|# 7140] [1m[35mRole Load (0.4ms)[0m 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 [[0;37mDEBUG[0m|# 7140] [1m[36mProject Load (0.3ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackage Load (0.3ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 7140] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [[0;37mDEBUG[0m|# 7140] Validate XML response: #<ActionDispatch::Response:0x00000007973a68> took 0ms [[32mINFO [0m|# 7140] Completed 200 OK in 9ms (Views: 0.4ms | ActiveRecord: 1.3ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|# 7140] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-18 17:30:38 +0100 [[32mINFO [0m|# 7140] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 7140] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|# 7140] Validate XML request: #<ActionDispatch::Request:0x00000007a1ab60> [[0;37mDEBUG[0m|# 7140] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|# 7140] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] USER found: king [[0;37mDEBUG[0m|# 7140] User king initialised [[0;37mDEBUG[0m|# 7140] get_by_project_and_name {} [[0;37mDEBUG[0m|# 7140] [1m[35mRole Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|# 7140] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mProject Load (0.1ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 7140] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 7140] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position [[0;37mDEBUG[0m|# 7140] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 7140] Validate XML response: #<ActionDispatch::Response:0x00000007a1ab10> took 2ms [[32mINFO [0m|# 7140] Completed 200 OK in 16ms (Views: 0.3ms | ActiveRecord: 1.6ms | Backend: 0.0ms | XML: 0.3ms) [[32mINFO [0m|# 7140] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-18 17:30:38 +0100 [[32mINFO [0m|# 7140] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 7140] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|# 7140] Validate XML request: #<ActionDispatch::Request:0x00000007ae7548> [[0;37mDEBUG[0m|# 7140] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] USER found: king [[0;37mDEBUG[0m|# 7140] User king initialised [[0;37mDEBUG[0m|# 7140] [1m[35mRole Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 7140] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mProject Load (0.1ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] get_by_project_and_name {} [[0;37mDEBUG[0m|# 7140] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mCACHE (0.0ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position[0m [[0;37mDEBUG[0m|# 7140] flagcheck: package has default state, checking project [[0;37mDEBUG[0m|# 7140] [1m[35mFlag Load (0.1ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [[0;37mDEBUG[0m|# 7140] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|# 7140] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [[0;37mDEBUG[0m|# 7140] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackageUserRoleRelationship Load (0.1ms)[0m SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 2 [[0;37mDEBUG[0m|# 7140] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358526638)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 10.000000000020334 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 7140] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 7140] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 1, `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 2 [[0;37mDEBUG[0m|# 7140] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 7140] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 7140] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 7140] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 7145] 2013-01-18 17:30:38 [12569]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 7140] request took 0.011389892 [[0;37mDEBUG[0m|# 7140] [1m[36mPackageGroupRoleRelationship Load (0.5ms)[0m [1mSELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 2[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358526638)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `activity_index` = 9.996961170043408 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 7140] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 7140] [1m[36m (0.1ms)[0m [1mUPDATE `packages` SET `update_counter` = 2, `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 2[0m [[0;37mDEBUG[0m|# 7140] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 7140] [1m[35mPackageUserRoleRelationship Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|# 7140] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 7140] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 7145] 2013-01-18 17:30:38 [12570]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 7140] request took 0.00942337 [[0;37mDEBUG[0m|# 7140] [1m[35mPackage Load (0.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358526638)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `activity_index` = 9.993923367233936 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 7140] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 7140] [1m[36m (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3, `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 2[0m [[0;37mDEBUG[0m|# 7140] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 7140] [1m[35mPackageUserRoleRelationship Load (5.1ms)[0m 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 [[0;37mDEBUG[0m|# 7140] [1m[36mPackageGroupRoleRelationship Load (0.4ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 7140] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 7145] 2013-01-18 17:30:38 [12571]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 7140] request took 0.010479766 [[0;37mDEBUG[0m|# 7140] [1m[35m (7.2ms)[0m RELEASE SAVEPOINT active_record_1 [[0;37mDEBUG[0m|# 7140] Validate XML response: #<ActionDispatch::Response:0x00000007ae7520> took 0ms [[32mINFO [0m|# 7140] Completed 200 OK in 94ms (Views: 1.0ms | ActiveRecord: 18.3ms | Backend: 31.3ms | XML: 0.0ms) [[32mINFO [0m|# 7140] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-18 17:30:38 +0100 [[32mINFO [0m|# 7140] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 7140] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|# 7140] Validate XML request: #<ActionDispatch::Request:0x00000008051c40> [[0;37mDEBUG[0m|# 7140] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|# 7140] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] USER found: king [[0;37mDEBUG[0m|# 7140] User king initialised [[0;37mDEBUG[0m|# 7140] get_by_project_and_name {} [[0;37mDEBUG[0m|# 7140] [1m[35mRole Load (3.4ms)[0m 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 [[0;37mDEBUG[0m|# 7140] [1m[36mProject Load (0.3ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackage Load (0.3ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] Validate XML response: #<ActionDispatch::Response:0x00000008051bc8> took 2ms [[32mINFO [0m|# 7140] Completed 200 OK in 16ms (Views: 0.5ms | ActiveRecord: 4.5ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|# 7140] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-18 17:30:38 +0100 [[32mINFO [0m|# 7140] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 7140] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|# 7140] Validate XML request: #<ActionDispatch::Request:0x000000082aed08> [[0;37mDEBUG[0m|# 7140] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|# 7140] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|# 7140] USER found: king [[0;37mDEBUG[0m|# 7140] User king initialised [[0;37mDEBUG[0m|# 7140] get_by_project_and_name {} [[0;37mDEBUG[0m|# 7140] [1m[36mRole Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 7140] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mProject Load (0.1ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 7140] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position[0m [[0;37mDEBUG[0m|# 7140] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 7140] Validate XML response: #<ActionDispatch::Response:0x000000082aece0> took 1ms [[32mINFO [0m|# 7140] Completed 200 OK in 19ms (Views: 0.4ms | ActiveRecord: 2.2ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|# 7140] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-18 17:30:38 +0100 [[32mINFO [0m|# 7140] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 7140] Parameters: {"<package name"=>"\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n <devel project=\"home:coolo:test\" package=\"kdelibs_DEVEL_package\"/>\n <person userid=\"fredlibs\" role=\"maintainer\"/>\n <person userid=\"adrian\" role=\"reviewer\"/>\n <group groupid=\"test_group\" role=\"maintainer\"/>\n</package>\n", "project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|# 7140] Validate XML request: #<ActionDispatch::Request:0x00000008508d88> [[0;37mDEBUG[0m|# 7140] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|# 7140] USER found: king [[0;37mDEBUG[0m|# 7140] User king initialised [[0;37mDEBUG[0m|# 7140] [1m[36mRole Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mPackage Load (2.4ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] get_by_project_and_name {} [[0;37mDEBUG[0m|# 7140] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mCACHE (0.0ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mFlag Load (1.3ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position [[0;37mDEBUG[0m|# 7140] flagcheck: package has default state, checking project [[0;37mDEBUG[0m|# 7140] [1m[36mFlag Load (0.1ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [[0;37mDEBUG[0m|# 7140] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|# 7140] 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"})}) [[0;37mDEBUG[0m|# 7140] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [[0;37mDEBUG[0m|# 7140] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'home:coolo:test' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackage Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 7140] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 1 [[0;37mDEBUG[0m|# 7140] [1m[36mUser Load (0.1ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mRole Load (0.1ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mUser Load (0.1ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 42 LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mRole Load (0.1ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358526638)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 10.000000000020334 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 7140] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 7140] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 1, `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|# 7140] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 7140] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 7140] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 7140] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 7145] 2013-01-18 17:30:38 [12572]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 7140] request took 0.012315375 [[0;37mDEBUG[0m|# 7140] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mGroup Load (0.1ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mRole Load (0.1ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358526638)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `activity_index` = 9.996962036159603 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 7140] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 7140] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 2, `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|# 7140] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 7140] [1m[36mPackageUserRoleRelationship Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 7140] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 7140] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 7145] 2013-01-18 17:30:38 [12573]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 7140] request took 0.009657875 [[0;37mDEBUG[0m|# 7140] [1m[36mPackage Load (0.4ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358526638)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mSQL (0.4ms)[0m UPDATE `packages` SET `activity_index` = 9.993923521626524 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 7140] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 7140] [1m[35m (0.4ms)[0m UPDATE `packages` SET `update_counter` = 3, `updated_at` = '2013-01-18 16:30:38' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|# 7140] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 7140] [1m[36mPackageUserRoleRelationship Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 7140] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 7140] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 7145] 2013-01-18 17:30:38 [12574]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 7140] request took 0.010454947 [[0;37mDEBUG[0m|# 7140] [1m[36m (0.1ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|# 7140] Validate XML response: #<ActionDispatch::Response:0x00000008508d60> took 1ms [[32mINFO [0m|# 7140] Completed 200 OK in 233ms (Views: 1.0ms | ActiveRecord: 12.4ms | Backend: 32.4ms | XML: 0.0ms) [[32mINFO [0m|# 7140] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-18 17:30:39 +0100 [[32mINFO [0m|# 7140] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 7140] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|# 7140] Validate XML request: #<ActionDispatch::Request:0x00000007266130> [[0;37mDEBUG[0m|# 7140] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|# 7140] [1m[35mUser Load (9.0ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|# 7140] USER found: king [[0;37mDEBUG[0m|# 7140] User king initialised [[0;37mDEBUG[0m|# 7140] get_by_project_and_name {} [[0;37mDEBUG[0m|# 7140] [1m[36mRole Load (0.5ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 7140] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] [1m[36mPackage Load (0.3ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 7140] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 7140] Validate XML response: #<ActionDispatch::Response:0x000000072660b8> took 2ms [[32mINFO [0m|# 7140] Completed 200 OK in 23ms (Views: 0.5ms | ActiveRecord: 10.1ms | Backend: 0.0ms | XML: 0.0ms) [[0;37mDEBUG[0m|# 7140] [1m[36m (8.3ms)[0m [1mROLLBACK[0m [[0;37mDEBUG[0m|# 7140] kill 7145 + 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
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1317/changes> Changes: [adrian] [backend] product converter: die when a used condition is not defined. ------------------------------------------ [...truncated 124031 lines...] [[0;37mDEBUG[0m|#18692] User king initialised [[0;37mDEBUG[0m|#18692] [1m[35mProjectUserRoleRelationship Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|#18692] [1m[36mRole Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] Validate XML response: #<ActionDispatch::Response:0x00000004c8a308> took 2ms [[32mINFO [0m|#18692] Completed 200 OK in 10ms (Views: 0.5ms | ActiveRecord: 1.1ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#18692] Started GET "/source/kde4" for 127.0.0.1 at 2013-01-21 11:45:43 +0100 [[32mINFO [0m|#18692] Processing by SourceController#index_project as XML [[32mINFO [0m|#18692] Parameters: {"project"=>"kde4"} [[0;37mDEBUG[0m|#18692] Validate XML request: #<ActionDispatch::Request:0x00000005fc22e0> [[0;37mDEBUG[0m|#18692] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#18692] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#18692] USER found: king [[0;37mDEBUG[0m|#18692] User king initialised [[0;37mDEBUG[0m|#18692] [1m[35mRole Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|#18692] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackage Load (0.3ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#18692] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [[0;37mDEBUG[0m|#18692] Validate XML response: #<ActionDispatch::Response:0x00000005fc2290> took 0ms [[32mINFO [0m|#18692] Completed 200 OK in 9ms (Views: 0.4ms | ActiveRecord: 1.1ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#18692] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-21 11:45:43 +0100 [[32mINFO [0m|#18692] Processing by SourceController#package_meta as XML [[32mINFO [0m|#18692] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|#18692] Validate XML request: #<ActionDispatch::Request:0x000000063f1398> [[0;37mDEBUG[0m|#18692] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#18692] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#18692] USER found: king [[0;37mDEBUG[0m|#18692] User king initialised [[0;37mDEBUG[0m|#18692] get_by_project_and_name {} [[0;37mDEBUG[0m|#18692] [1m[35mRole Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|#18692] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#18692] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#18692] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position [[0;37mDEBUG[0m|#18692] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#18692] Validate XML response: #<ActionDispatch::Response:0x000000063f9278> took 2ms [[32mINFO [0m|#18692] Completed 200 OK in 17ms (Views: 0.4ms | ActiveRecord: 1.7ms | Backend: 0.0ms | XML: 0.3ms) [[32mINFO [0m|#18692] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-21 11:45:43 +0100 [[32mINFO [0m|#18692] Processing by SourceController#package_meta as XML [[32mINFO [0m|#18692] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|#18692] Validate XML request: #<ActionDispatch::Request:0x0000000707a060> [[0;37mDEBUG[0m|#18692] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#18692] USER found: king [[0;37mDEBUG[0m|#18692] User king initialised [[0;37mDEBUG[0m|#18692] [1m[35mRole Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#18692] [1m[36mProject Load (0.3ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] get_by_project_and_name {} [[0;37mDEBUG[0m|#18692] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mCACHE (0.0ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position[0m [[0;37mDEBUG[0m|#18692] flagcheck: package has default state, checking project [[0;37mDEBUG[0m|#18692] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [[0;37mDEBUG[0m|#18692] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|#18692] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [[0;37mDEBUG[0m|#18692] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackageUserRoleRelationship Load (0.1ms)[0m SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 2 [[0;37mDEBUG[0m|#18692] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358765143)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 10.000000000019929 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#18692] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-21 10:45:43' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#18692] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 1, `updated_at` = '2013-01-21 10:45:43' WHERE `packages`.`id` = 2 [[0;37mDEBUG[0m|#18692] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#18692] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#18692] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#18692] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#18697] 2013-01-21 11:45:43 [24085]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#18692] request took 0.010301033 [[0;37mDEBUG[0m|#18692] [1m[36mPackageGroupRoleRelationship Load (0.4ms)[0m [1mSELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 2[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358765143)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `activity_index` = 9.996961037340288 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#18692] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-21 10:45:43' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#18692] [1m[36m (0.1ms)[0m [1mUPDATE `packages` SET `update_counter` = 2, `updated_at` = '2013-01-21 10:45:43' WHERE `packages`.`id` = 2[0m [[0;37mDEBUG[0m|#18692] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#18692] [1m[35mPackageUserRoleRelationship Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|#18692] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#18692] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#18697] 2013-01-21 11:45:43 [24086]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#18692] request took 0.009547989 [[0;37mDEBUG[0m|#18692] [1m[35mPackage Load (0.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358765143)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `activity_index` = 9.99392242276273 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#18692] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-21 10:45:43' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#18692] [1m[36m (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3, `updated_at` = '2013-01-21 10:45:43' WHERE `packages`.`id` = 2[0m [[0;37mDEBUG[0m|#18692] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#18692] [1m[35mPackageUserRoleRelationship Load (8.6ms)[0m 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 [[0;37mDEBUG[0m|#18692] [1m[36mPackageGroupRoleRelationship Load (0.4ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#18692] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#18697] 2013-01-21 11:45:43 [24087]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#18692] request took 0.009904122 [[0;37mDEBUG[0m|#18692] [1m[35m (0.1ms)[0m RELEASE SAVEPOINT active_record_1 [[0;37mDEBUG[0m|#18692] Validate XML response: #<ActionDispatch::Response:0x0000000707a038> took 0ms [[32mINFO [0m|#18692] Completed 200 OK in 94ms (Views: 1.0ms | ActiveRecord: 15.0ms | Backend: 29.8ms | XML: 0.0ms) [[32mINFO [0m|#18692] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-21 11:45:43 +0100 [[32mINFO [0m|#18692] Processing by SourceController#package_meta as XML [[32mINFO [0m|#18692] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|#18692] Validate XML request: #<ActionDispatch::Request:0x00000007a14da0> [[0;37mDEBUG[0m|#18692] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#18692] [1m[36mUser Load (8.8ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#18692] USER found: king [[0;37mDEBUG[0m|#18692] User king initialised [[0;37mDEBUG[0m|#18692] get_by_project_and_name {} [[0;37mDEBUG[0m|#18692] [1m[35mRole Load (0.4ms)[0m 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 [[0;37mDEBUG[0m|#18692] [1m[36mProject Load (0.3ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] Validate XML response: #<ActionDispatch::Response:0x00000007a14d78> took 2ms [[32mINFO [0m|#18692] Completed 200 OK in 22ms (Views: 0.5ms | ActiveRecord: 9.9ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#18692] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-21 11:45:44 +0100 [[32mINFO [0m|#18692] Processing by SourceController#package_meta as XML [[32mINFO [0m|#18692] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|#18692] Validate XML request: #<ActionDispatch::Request:0x00000007790ae8> [[0;37mDEBUG[0m|#18692] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#18692] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#18692] USER found: king [[0;37mDEBUG[0m|#18692] User king initialised [[0;37mDEBUG[0m|#18692] get_by_project_and_name {} [[0;37mDEBUG[0m|#18692] [1m[36mRole Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] [1m[35mProject Load (0.3ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#18692] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mPackageUserRoleRelationship Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#18692] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position[0m [[0;37mDEBUG[0m|#18692] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#18692] Validate XML response: #<ActionDispatch::Response:0x00000007790ac0> took 2ms [[32mINFO [0m|#18692] Completed 200 OK in 21ms (Views: 0.4ms | ActiveRecord: 2.4ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#18692] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-21 11:45:44 +0100 [[32mINFO [0m|#18692] Processing by SourceController#package_meta as XML [[32mINFO [0m|#18692] Parameters: {"<package name"=>"\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n <devel project=\"home:coolo:test\" package=\"kdelibs_DEVEL_package\"/>\n <person userid=\"fredlibs\" role=\"maintainer\"/>\n <person userid=\"adrian\" role=\"reviewer\"/>\n <group groupid=\"test_group\" role=\"maintainer\"/>\n</package>\n", "project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|#18692] Validate XML request: #<ActionDispatch::Request:0x00000007bd4758> [[0;37mDEBUG[0m|#18692] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#18692] USER found: king [[0;37mDEBUG[0m|#18692] User king initialised [[0;37mDEBUG[0m|#18692] [1m[36mRole Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mProject Load (0.1ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] get_by_project_and_name {} [[0;37mDEBUG[0m|#18692] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mCACHE (0.0ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position [[0;37mDEBUG[0m|#18692] flagcheck: package has default state, checking project [[0;37mDEBUG[0m|#18692] [1m[36mFlag Load (0.1ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [[0;37mDEBUG[0m|#18692] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|#18692] 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"})}) [[0;37mDEBUG[0m|#18692] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [[0;37mDEBUG[0m|#18692] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'home:coolo:test' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackage Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#18692] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackageUserRoleRelationship Load (0.1ms)[0m SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 1 [[0;37mDEBUG[0m|#18692] [1m[36mUser Load (0.1ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mRole Load (0.1ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mUser Load (0.1ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 42 LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358765144)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 10.000000000019929 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#18692] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-21 10:45:44' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#18692] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 1, `updated_at` = '2013-01-21 10:45:44' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|#18692] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#18692] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#18692] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#18692] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#18697] 2013-01-21 11:45:44 [24088]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#18692] request took 0.009454532 [[0;37mDEBUG[0m|#18692] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mUser Load (0.1ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mGroup Load (0.1ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358765144)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `activity_index` = 9.996961675385934 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#18692] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-21 10:45:44' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#18692] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 2, `updated_at` = '2013-01-21 10:45:44' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|#18692] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#18692] [1m[36mPackageUserRoleRelationship Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#18692] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#18692] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#18697] 2013-01-21 11:45:44 [24089]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#18692] request took 0.010295442 [[0;37mDEBUG[0m|#18692] [1m[36mPackage Load (0.4ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358765144)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mSQL (0.4ms)[0m UPDATE `packages` SET `activity_index` = 9.993923548917724 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#18692] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-21 10:45:44' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#18692] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 3, `updated_at` = '2013-01-21 10:45:44' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|#18692] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#18692] [1m[36mPackageUserRoleRelationship Load (4.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] [1m[35mPackageGroupRoleRelationship Load (0.4ms)[0m 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 [[0;37mDEBUG[0m|#18692] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#18692] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#18697] 2013-01-21 11:45:44 [24090]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#18692] request took 0.010447876 [[0;37mDEBUG[0m|#18692] [1m[36m (0.2ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|#18692] Validate XML response: #<ActionDispatch::Response:0x00000007bd46b8> took 0ms [[32mINFO [0m|#18692] Completed 200 OK in 104ms (Views: 0.9ms | ActiveRecord: 12.8ms | Backend: 30.2ms | XML: 0.0ms) [[32mINFO [0m|#18692] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-21 11:45:44 +0100 [[32mINFO [0m|#18692] Processing by SourceController#package_meta as XML [[32mINFO [0m|#18692] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|#18692] Validate XML request: #<ActionDispatch::Request:0x000000082d0bb0> [[0;37mDEBUG[0m|#18692] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#18692] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#18692] USER found: king [[0;37mDEBUG[0m|#18692] User king initialised [[0;37mDEBUG[0m|#18692] get_by_project_and_name {} [[0;37mDEBUG[0m|#18692] [1m[36mRole Load (0.4ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#18692] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] [1m[36mPackage Load (0.3ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#18692] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#18692] Validate XML response: #<ActionDispatch::Response:0x000000082d0b88> took 2ms [[32mINFO [0m|#18692] Completed 200 OK in 26ms (Views: 0.5ms | ActiveRecord: 1.5ms | Backend: 0.0ms | XML: 0.0ms) [[0;37mDEBUG[0m|#18692] [1m[36m (8.4ms)[0m [1mROLLBACK[0m [[0;37mDEBUG[0m|#18692] kill 18697 + 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/>: 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
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1318/changes> Changes: [adrian] [api] avoid double listings in results of owner search ------------------------------------------ [...truncated 124034 lines...] [[0;37mDEBUG[0m|#26878] User king initialised [[0;37mDEBUG[0m|#26878] [1m[35mProjectUserRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#26878] [1m[36mRole Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] Validate XML response: #<ActionDispatch::Response:0x00000007559568> took 2ms [[32mINFO [0m|#26878] Completed 200 OK in 9ms (Views: 0.4ms | ActiveRecord: 0.8ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#26878] Started GET "/source/kde4" for 127.0.0.1 at 2013-01-21 13:10:36 +0100 [[32mINFO [0m|#26878] Processing by SourceController#index_project as XML [[32mINFO [0m|#26878] Parameters: {"project"=>"kde4"} [[0;37mDEBUG[0m|#26878] Validate XML request: #<ActionDispatch::Request:0x00000007706f00> [[0;37mDEBUG[0m|#26878] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#26878] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#26878] USER found: king [[0;37mDEBUG[0m|#26878] User king initialised [[0;37mDEBUG[0m|#26878] [1m[35mRole Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|#26878] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#26878] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [[0;37mDEBUG[0m|#26878] Validate XML response: #<ActionDispatch::Response:0x00000007706e10> took 0ms [[32mINFO [0m|#26878] Completed 200 OK in 8ms (Views: 0.3ms | ActiveRecord: 0.9ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#26878] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-21 13:10:36 +0100 [[32mINFO [0m|#26878] Processing by SourceController#package_meta as XML [[32mINFO [0m|#26878] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|#26878] Validate XML request: #<ActionDispatch::Request:0x00000007937d88> [[0;37mDEBUG[0m|#26878] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#26878] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#26878] USER found: king [[0;37mDEBUG[0m|#26878] User king initialised [[0;37mDEBUG[0m|#26878] get_by_project_and_name {} [[0;37mDEBUG[0m|#26878] [1m[35mRole Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#26878] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mProject Load (0.1ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#26878] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#26878] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position [[0;37mDEBUG[0m|#26878] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#26878] Validate XML response: #<ActionDispatch::Response:0x00000007937d60> took 2ms [[32mINFO [0m|#26878] Completed 200 OK in 15ms (Views: 0.3ms | ActiveRecord: 1.4ms | Backend: 0.0ms | XML: 0.2ms) [[32mINFO [0m|#26878] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-21 13:10:36 +0100 [[32mINFO [0m|#26878] Processing by SourceController#package_meta as XML [[32mINFO [0m|#26878] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|#26878] Validate XML request: #<ActionDispatch::Request:0x0000000773ab70> [[0;37mDEBUG[0m|#26878] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#26878] USER found: king [[0;37mDEBUG[0m|#26878] User king initialised [[0;37mDEBUG[0m|#26878] [1m[35mRole Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|#26878] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mProject Load (0.1ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] get_by_project_and_name {} [[0;37mDEBUG[0m|#26878] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mCACHE (0.0ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position[0m [[0;37mDEBUG[0m|#26878] flagcheck: package has default state, checking project [[0;37mDEBUG[0m|#26878] [1m[35mFlag Load (0.1ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [[0;37mDEBUG[0m|#26878] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|#26878] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [[0;37mDEBUG[0m|#26878] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 2 [[0;37mDEBUG[0m|#26878] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358770236)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 10.00000000001992 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#26878] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-21 12:10:36' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#26878] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 1, `updated_at` = '2013-01-21 12:10:36' WHERE `packages`.`id` = 2 [[0;37mDEBUG[0m|#26878] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#26878] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#26878] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#26878] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#26883] 2013-01-21 13:10:36 [32244]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#26878] request took 0.013391234 [[0;37mDEBUG[0m|#26878] [1m[36mPackageGroupRoleRelationship Load (0.4ms)[0m [1mSELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 2[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358770236)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `activity_index` = 9.996961375734621 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#26878] [1m[35mSQL (0.1ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-21 12:10:36' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#26878] [1m[36m (0.1ms)[0m [1mUPDATE `packages` SET `update_counter` = 2, `updated_at` = '2013-01-21 12:10:36' WHERE `packages`.`id` = 2[0m [[0;37mDEBUG[0m|#26878] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#26878] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#26878] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#26878] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#26883] 2013-01-21 13:10:37 [32245]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#26878] request took 0.008733494 [[0;37mDEBUG[0m|#26878] [1m[35mPackage Load (0.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358770237)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `activity_index` = 9.99392234903533 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#26878] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-21 12:10:37' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#26878] [1m[36m (0.3ms)[0m [1mUPDATE `packages` SET `update_counter` = 3, `updated_at` = '2013-01-21 12:10:37' WHERE `packages`.`id` = 2[0m [[0;37mDEBUG[0m|#26878] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#26878] [1m[35mPackageUserRoleRelationship Load (4.5ms)[0m 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 [[0;37mDEBUG[0m|#26878] [1m[36mPackageGroupRoleRelationship Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|#26878] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#26883] 2013-01-21 13:10:37 [32246]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|#26878] request took 0.008361299 [[0;37mDEBUG[0m|#26878] [1m[35m (0.1ms)[0m RELEASE SAVEPOINT active_record_1 [[0;37mDEBUG[0m|#26878] Validate XML response: #<ActionDispatch::Response:0x0000000773aa80> took 0ms [[32mINFO [0m|#26878] Completed 200 OK in 85ms (Views: 1.0ms | ActiveRecord: 10.6ms | Backend: 30.5ms | XML: 0.0ms) [[32mINFO [0m|#26878] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-21 13:10:37 +0100 [[32mINFO [0m|#26878] Processing by SourceController#package_meta as XML [[32mINFO [0m|#26878] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|#26878] Validate XML request: #<ActionDispatch::Request:0x0000000820ae10> [[0;37mDEBUG[0m|#26878] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#26878] [1m[36mUser Load (9.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#26878] USER found: king [[0;37mDEBUG[0m|#26878] User king initialised [[0;37mDEBUG[0m|#26878] get_by_project_and_name {} [[0;37mDEBUG[0m|#26878] [1m[35mRole Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|#26878] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mProject Load (0.1ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] Validate XML response: #<ActionDispatch::Response:0x0000000820ade8> took 2ms [[32mINFO [0m|#26878] Completed 200 OK in 21ms (Views: 0.4ms | ActiveRecord: 9.8ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#26878] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-21 13:10:37 +0100 [[32mINFO [0m|#26878] Processing by SourceController#package_meta as XML [[32mINFO [0m|#26878] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|#26878] Validate XML request: #<ActionDispatch::Request:0x000000082c16b0> [[0;37mDEBUG[0m|#26878] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#26878] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#26878] USER found: king [[0;37mDEBUG[0m|#26878] User king initialised [[0;37mDEBUG[0m|#26878] get_by_project_and_name {} [[0;37mDEBUG[0m|#26878] [1m[36mRole Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#26878] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mProject Load (0.1ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#26878] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position[0m [[0;37mDEBUG[0m|#26878] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#26878] Validate XML response: #<ActionDispatch::Response:0x000000082c1638> took 1ms [[32mINFO [0m|#26878] Completed 200 OK in 18ms (Views: 0.4ms | ActiveRecord: 1.8ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#26878] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-21 13:10:37 +0100 [[32mINFO [0m|#26878] Processing by SourceController#package_meta as XML [[32mINFO [0m|#26878] Parameters: {"<package name"=>"\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n <devel project=\"home:coolo:test\" package=\"kdelibs_DEVEL_package\"/>\n <person userid=\"fredlibs\" role=\"maintainer\"/>\n <person userid=\"adrian\" role=\"reviewer\"/>\n <group groupid=\"test_group\" role=\"maintainer\"/>\n</package>\n", "project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|#26878] Validate XML request: #<ActionDispatch::Request:0x000000083c3a40> [[0;37mDEBUG[0m|#26878] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#26878] USER found: king [[0;37mDEBUG[0m|#26878] User king initialised [[0;37mDEBUG[0m|#26878] [1m[36mRole Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] get_by_project_and_name {} [[0;37mDEBUG[0m|#26878] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mCACHE (0.0ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position [[0;37mDEBUG[0m|#26878] flagcheck: package has default state, checking project [[0;37mDEBUG[0m|#26878] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [[0;37mDEBUG[0m|#26878] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|#26878] 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"})}) [[0;37mDEBUG[0m|#26878] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [[0;37mDEBUG[0m|#26878] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'home:coolo:test' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackage Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#26878] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 1 [[0;37mDEBUG[0m|#26878] [1m[36mUser Load (0.1ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mRole Load (0.1ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mUser Load (0.1ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 42 LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mRole Load (0.1ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358770237)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 10.00000000001992 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#26878] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-21 12:10:37' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#26878] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 1, `updated_at` = '2013-01-21 12:10:37' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|#26878] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#26878] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#26878] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#26878] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#26883] 2013-01-21 13:10:37 [32247]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#26878] request took 0.131829359 [[0;37mDEBUG[0m|#26878] [1m[36mUser Load (0.7ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mGroup Load (0.1ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mRole Load (0.1ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358770237)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 9.99697584696972 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#26878] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-21 12:10:37' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#26878] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 2, `updated_at` = '2013-01-21 12:10:37' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|#26878] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#26878] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#26878] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#26878] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#26883] 2013-01-21 13:10:37 [32248]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#26878] request took 0.013412547 [[0;37mDEBUG[0m|#26878] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358770237)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 9.9939381806537 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|#26878] [1m[36mSQL (0.1ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-21 12:10:37' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|#26878] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 3, `updated_at` = '2013-01-21 12:10:37' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|#26878] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#26878] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|#26878] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|#26878] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#26883] 2013-01-21 13:10:37 [32249]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|#26878] request took 0.009127302 [[0;37mDEBUG[0m|#26878] [1m[36m (0.1ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|#26878] Validate XML response: #<ActionDispatch::Response:0x000000083c39f0> took 1ms [[32mINFO [0m|#26878] Completed 200 OK in 220ms (Views: 0.9ms | ActiveRecord: 8.1ms | Backend: 154.4ms | XML: 0.0ms) [[32mINFO [0m|#26878] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-21 13:10:37 +0100 [[32mINFO [0m|#26878] Processing by SourceController#package_meta as XML [[32mINFO [0m|#26878] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|#26878] Validate XML request: #<ActionDispatch::Request:0x00000006597d28> [[0;37mDEBUG[0m|#26878] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#26878] [1m[35mUser Load (6.3ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#26878] USER found: king [[0;37mDEBUG[0m|#26878] User king initialised [[0;37mDEBUG[0m|#26878] get_by_project_and_name {} [[0;37mDEBUG[0m|#26878] [1m[36mRole Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|#26878] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26878] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26878] Validate XML response: #<ActionDispatch::Response:0x00000006597bc0> took 2ms [[32mINFO [0m|#26878] Completed 200 OK in 19ms (Views: 0.4ms | ActiveRecord: 7.2ms | Backend: 0.0ms | XML: 0.0ms) [[0;37mDEBUG[0m|#26878] [1m[36m (6.8ms)[0m [1mROLLBACK[0m [[0;37mDEBUG[0m|#26878] kill 26883 + 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
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1319/changes> Changes: [ro] [backend] productconverter: fix wording in flavor package README ------------------------------------------ [...truncated 124046 lines...] [[0;37mDEBUG[0m|# 4472] User king initialised [[0;37mDEBUG[0m|# 4472] [1m[35mProjectUserRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 4472] [1m[36mRole Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] Validate XML response: #<ActionDispatch::Response:0x000000070bf908> took 2ms [[32mINFO [0m|# 4472] Completed 200 OK in 9ms (Views: 0.4ms | ActiveRecord: 0.8ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|# 4472] Started GET "/source/kde4" for 127.0.0.1 at 2013-01-22 13:05:40 +0100 [[32mINFO [0m|# 4472] Processing by SourceController#index_project as XML [[32mINFO [0m|# 4472] Parameters: {"project"=>"kde4"} [[0;37mDEBUG[0m|# 4472] Validate XML request: #<ActionDispatch::Request:0x000000073ddbd0> [[0;37mDEBUG[0m|# 4472] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|# 4472] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] USER found: king [[0;37mDEBUG[0m|# 4472] User king initialised [[0;37mDEBUG[0m|# 4472] [1m[35mRole Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 4472] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 4472] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [[0;37mDEBUG[0m|# 4472] Validate XML response: #<ActionDispatch::Response:0x000000073ddb30> took 0ms [[32mINFO [0m|# 4472] Completed 200 OK in 7ms (Views: 0.3ms | ActiveRecord: 0.7ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|# 4472] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-22 13:05:40 +0100 [[32mINFO [0m|# 4472] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 4472] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|# 4472] Validate XML request: #<ActionDispatch::Request:0x0000000758c800> [[0;37mDEBUG[0m|# 4472] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|# 4472] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] USER found: king [[0;37mDEBUG[0m|# 4472] User king initialised [[0;37mDEBUG[0m|# 4472] get_by_project_and_name {} [[0;37mDEBUG[0m|# 4472] [1m[35mRole Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 4472] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mProject Load (0.1ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 4472] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 4472] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position [[0;37mDEBUG[0m|# 4472] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 4472] Validate XML response: #<ActionDispatch::Response:0x0000000758c648> took 2ms [[32mINFO [0m|# 4472] Completed 200 OK in 15ms (Views: 0.3ms | ActiveRecord: 1.4ms | Backend: 0.0ms | XML: 0.2ms) [[32mINFO [0m|# 4472] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-22 13:05:40 +0100 [[32mINFO [0m|# 4472] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 4472] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|# 4472] Validate XML request: #<ActionDispatch::Request:0x000000076e3fc8> [[0;37mDEBUG[0m|# 4472] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] USER found: king [[0;37mDEBUG[0m|# 4472] User king initialised [[0;37mDEBUG[0m|# 4472] [1m[35mRole Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 4472] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] get_by_project_and_name {} [[0;37mDEBUG[0m|# 4472] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mCACHE (0.0ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position[0m [[0;37mDEBUG[0m|# 4472] flagcheck: package has default state, checking project [[0;37mDEBUG[0m|# 4472] [1m[35mFlag Load (0.1ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [[0;37mDEBUG[0m|# 4472] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|# 4472] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [[0;37mDEBUG[0m|# 4472] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackageUserRoleRelationship Load (0.1ms)[0m SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 2 [[0;37mDEBUG[0m|# 4472] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358856340)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 10.000000000019776 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 4472] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 4472] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 1, `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 2 [[0;37mDEBUG[0m|# 4472] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 4472] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 4472] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 4472] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 4477] 2013-01-22 13:05:40 [9840]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 4472] request took 0.01433973 [[0;37mDEBUG[0m|# 4472] [1m[36mPackageGroupRoleRelationship Load (0.4ms)[0m [1mSELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 2[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358856340)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `activity_index` = 9.996961491108241 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 4472] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 4472] [1m[36m (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 2, `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 2[0m [[0;37mDEBUG[0m|# 4472] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 4472] [1m[35mPackageUserRoleRelationship Load (0.3ms)[0m 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 [[0;37mDEBUG[0m|# 4472] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 4472] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 4477] 2013-01-22 13:05:40 [9841]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 4472] request took 0.008111747 [[0;37mDEBUG[0m|# 4472] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358856340)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `activity_index` = 9.993923304152354 WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 4472] [1m[35mSQL (0.1ms)[0m UPDATE `packages` SET `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 4472] [1m[36m (0.1ms)[0m [1mUPDATE `packages` SET `update_counter` = 3, `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 2[0m [[0;37mDEBUG[0m|# 4472] ----------------- rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 4472] [1m[35mPackageUserRoleRelationship Load (6.9ms)[0m 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 [[0;37mDEBUG[0m|# 4472] [1m[36mPackageGroupRoleRelationship Load (0.4ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] ----------------- end rendering package kdebase ------------------------ [[0;37mDEBUG[0m|# 4472] [backend] PUT: /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 4477] 2013-01-22 13:05:40 [9842]: PUT /source/kde4/kdebase/_meta?user=king [[0;37mDEBUG[0m|# 4472] request took 0.008507672 [[0;37mDEBUG[0m|# 4472] [1m[35m (0.1ms)[0m RELEASE SAVEPOINT active_record_1 [[0;37mDEBUG[0m|# 4472] Validate XML response: #<ActionDispatch::Response:0x000000076e3f50> took 0ms [[32mINFO [0m|# 4472] Completed 200 OK in 88ms (Views: 0.9ms | ActiveRecord: 12.6ms | Backend: 31.0ms | XML: 0.0ms) [[32mINFO [0m|# 4472] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-01-22 13:05:40 +0100 [[32mINFO [0m|# 4472] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 4472] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [[0;37mDEBUG[0m|# 4472] Validate XML request: #<ActionDispatch::Request:0x00000007ece288> [[0;37mDEBUG[0m|# 4472] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|# 4472] [1m[36mUser Load (9.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] USER found: king [[0;37mDEBUG[0m|# 4472] User king initialised [[0;37mDEBUG[0m|# 4472] get_by_project_and_name {} [[0;37mDEBUG[0m|# 4472] [1m[35mRole Load (0.4ms)[0m 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 [[0;37mDEBUG[0m|# 4472] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] Validate XML response: #<ActionDispatch::Response:0x00000007ece260> took 2ms [[32mINFO [0m|# 4472] Completed 200 OK in 21ms (Views: 0.5ms | ActiveRecord: 9.9ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|# 4472] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-22 13:05:40 +0100 [[32mINFO [0m|# 4472] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 4472] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|# 4472] Validate XML request: #<ActionDispatch::Request:0x00000007f89cb8> [[0;37mDEBUG[0m|# 4472] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|# 4472] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|# 4472] USER found: king [[0;37mDEBUG[0m|# 4472] User king initialised [[0;37mDEBUG[0m|# 4472] get_by_project_and_name {} [[0;37mDEBUG[0m|# 4472] [1m[36mRole Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mProject Load (0.1ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 4472] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mProject Load (0.1ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 4472] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position[0m [[0;37mDEBUG[0m|# 4472] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 4472] Validate XML response: #<ActionDispatch::Response:0x00000007f89c90> took 1ms [[32mINFO [0m|# 4472] Completed 200 OK in 18ms (Views: 0.3ms | ActiveRecord: 1.7ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|# 4472] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-22 13:05:40 +0100 [[32mINFO [0m|# 4472] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 4472] Parameters: {"<package name"=>"\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n <devel project=\"home:coolo:test\" package=\"kdelibs_DEVEL_package\"/>\n <person userid=\"fredlibs\" role=\"maintainer\"/>\n <person userid=\"adrian\" role=\"reviewer\"/>\n <group groupid=\"test_group\" role=\"maintainer\"/>\n</package>\n", "project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|# 4472] Validate XML request: #<ActionDispatch::Request:0x000000081e5138> [[0;37mDEBUG[0m|# 4472] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|# 4472] USER found: king [[0;37mDEBUG[0m|# 4472] User king initialised [[0;37mDEBUG[0m|# 4472] [1m[36mRole Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mProject Load (0.1ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] get_by_project_and_name {} [[0;37mDEBUG[0m|# 4472] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mCACHE (0.0ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position [[0;37mDEBUG[0m|# 4472] flagcheck: package has default state, checking project [[0;37mDEBUG[0m|# 4472] [1m[36mFlag Load (0.1ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [[0;37mDEBUG[0m|# 4472] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|# 4472] 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"})}) [[0;37mDEBUG[0m|# 4472] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [[0;37mDEBUG[0m|# 4472] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'home:coolo:test' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackage Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 4472] [1m[36mProject Load (0.1ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackageUserRoleRelationship Load (0.1ms)[0m SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 1 [[0;37mDEBUG[0m|# 4472] [1m[36mUser Load (0.1ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mRole Load (0.1ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mUser Load (0.1ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 42 LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mRole Load (0.1ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358856340)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 10.000000000019776 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 4472] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 4472] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 1, `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|# 4472] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 4472] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 4472] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 4472] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 4477] 2013-01-22 13:05:40 [9843]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 4472] request took 0.014782887 [[0;37mDEBUG[0m|# 4472] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mPackageGroupRoleRelationship Load (0.1ms)[0m [1mSELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mGroup Load (0.1ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mRole Load (0.1ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358856340)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `activity_index` = 9.996962166158438 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 4472] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 4472] [1m[35m (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2, `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|# 4472] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 4472] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m 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 [[0;37mDEBUG[0m|# 4472] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 4472] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 4477] 2013-01-22 13:05:40 [9844]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 4472] request took 0.008760909 [[0;37mDEBUG[0m|# 4472] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1358856340)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mSQL (0.4ms)[0m UPDATE `packages` SET `activity_index` = 9.993924235322897 WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) [[0;37mDEBUG[0m|# 4472] [1m[36mSQL (0.1ms)[0m [1mUPDATE `packages` SET `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0))[0m [[0;37mDEBUG[0m|# 4472] [1m[35m (0.1ms)[0m UPDATE `packages` SET `update_counter` = 3, `updated_at` = '2013-01-22 12:05:40' WHERE `packages`.`id` = 1 [[0;37mDEBUG[0m|# 4472] ----------------- rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 4472] [1m[36mPackageUserRoleRelationship Load (5.1ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] [1m[35mPackageGroupRoleRelationship Load (0.4ms)[0m 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 [[0;37mDEBUG[0m|# 4472] ----------------- end rendering package kdelibs ------------------------ [[0;37mDEBUG[0m|# 4472] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 4477] 2013-01-22 13:05:40 [9845]: PUT /source/kde4/kdelibs/_meta?user=king [[0;37mDEBUG[0m|# 4472] request took 0.009653308 [[0;37mDEBUG[0m|# 4472] [1m[36m (0.1ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|# 4472] Validate XML response: #<ActionDispatch::Response:0x000000081e5110> took 146ms [[32mINFO [0m|# 4472] Completed 200 OK in 248ms (Views: 0.8ms | ActiveRecord: 12.7ms | Backend: 33.2ms | XML: 0.0ms) [[32mINFO [0m|# 4472] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-01-22 13:05:40 +0100 [[32mINFO [0m|# 4472] Processing by SourceController#package_meta as XML [[32mINFO [0m|# 4472] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|# 4472] Validate XML request: #<ActionDispatch::Request:0x0000000830e320> [[0;37mDEBUG[0m|# 4472] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|# 4472] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|# 4472] USER found: king [[0;37mDEBUG[0m|# 4472] User king initialised [[0;37mDEBUG[0m|# 4472] get_by_project_and_name {} [[0;37mDEBUG[0m|# 4472] [1m[36mRole Load (0.3ms)[0m [1mSELECT 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[0m [[0;37mDEBUG[0m|# 4472] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|# 4472] [1m[35mProject Load (0.1ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|# 4472] Validate XML response: #<ActionDispatch::Response:0x000000083052c0> took 2ms [[32mINFO [0m|# 4472] Completed 200 OK in 12ms (Views: 0.4ms | ActiveRecord: 1.2ms | Backend: 0.0ms | XML: 0.0ms) [[0;37mDEBUG[0m|# 4472] [1m[36m (18.5ms)[0m [1mROLLBACK[0m [[0;37mDEBUG[0m|# 4472] kill 4477 + 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
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1320/changes> -- To unsubscribe, e-mail: obs-tests+unsubscribe@opensuse.org To contact the owner, e-mail: obs-tests+owner@opensuse.org
participants (1)
-
admin＠opensuse.org