[obs-tests] Build failed in Jenkins: obs_master_testsuite_api #1680
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1680/changes> Changes: [ancor] [api] renaming the routes for deleting user roles [ancor] [webui] more RESTfull approach when adding and removing relationships [ancor] [api] Thinking Sphinx based search [ancor] [api] Thinking Sphinx related files added to .gitignore [ancor] [webui] Use the new sphinx-based search [Stephan Kulow] [api] move maintainer/owner handling into own modul [Stephan Kulow] [webui][api] Introduce comments for projects, package and requests in the API and display them in the UI ------------------------------------------ [...truncated 164217 lines...] [0e014b38-7cbd-41e7-b85b-ecadcec19371] [290.63] [1m[35m (0.2ms)[0m SELECT `packages`.`name`, `packages`.`db_project_id` FROM `packages` WHERE `packages`.`db_project_id` = 2 AND (packages.db_project_id not in (0)) [0e014b38-7cbd-41e7-b85b-ecadcec19371] [290.64] [1m[36m (0.2ms)[0m [1mSELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0))[0m [0e014b38-7cbd-41e7-b85b-ecadcec19371] [290.64] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [0e014b38-7cbd-41e7-b85b-ecadcec19371] [290.64] Validate XML response: #<ActionDispatch::Response:0x0000000582a960> took 0ms [0e014b38-7cbd-41e7-b85b-ecadcec19371] [290.64] Completed 200 OK in 7ms (Views: 0.2ms | ActiveRecord: 1.2ms | Backend: 0.0ms | XML: 0.0ms) [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-07 12:00:28 +0000 [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] Processing by SourceController#package_meta as XML [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] Validate XML request: #<ActionDispatch::Request:0x0000000625a200> [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] USER found: king [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] User king initialised [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdebase", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"} [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] [1m[36mRole Exists (0.3ms)[0m [1mSELECT DISTINCT 1 AS one 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 [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] [1m[35mProject Load (0.3ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [56a61d70-19fb-4863-9acd-e459deab589e] [290.64] [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 [56a61d70-19fb-4863-9acd-e459deab589e] [290.65] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [56a61d70-19fb-4863-9acd-e459deab589e] [290.65] ----------------- rendering package kdebase ------------------------ [56a61d70-19fb-4863-9acd-e459deab589e] [290.65] [1m[36mRelationship Load (0.5ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, login[0m [56a61d70-19fb-4863-9acd-e459deab589e] [290.65] [1m[35mRelationship Load (0.3ms)[0m SELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, title [56a61d70-19fb-4863-9acd-e459deab589e] [290.65] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC[0m [56a61d70-19fb-4863-9acd-e459deab589e] [290.65] ----------------- end rendering package kdebase ------------------------ [56a61d70-19fb-4863-9acd-e459deab589e] [290.65] Validate XML response: #<ActionDispatch::Response:0x0000000625a1b0> took 1ms [56a61d70-19fb-4863-9acd-e459deab589e] [290.65] Completed 200 OK in 14ms (Views: 0.2ms | ActiveRecord: 2.2ms | Backend: 0.0ms | XML: 0.2ms) [0b58bc5e-c038-427b-b883-e1590af6094e] [290.65] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-07 12:00:28 +0000 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.65] Processing by SourceController#package_meta as XML [0b58bc5e-c038-427b-b883-e1590af6094e] [290.65] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [0b58bc5e-c038-427b-b883-e1590af6094e] [290.65] Validate XML request: #<ActionDispatch::Request:0x000000064652c0> [0b58bc5e-c038-427b-b883-e1590af6094e] [290.66] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.66] USER found: king [0b58bc5e-c038-427b-b883-e1590af6094e] [290.66] User king initialised [0b58bc5e-c038-427b-b883-e1590af6094e] [290.66] [1m[36mRole Exists (0.3ms)[0m [1mSELECT DISTINCT 1 AS one 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 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.66] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.66] [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 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.66] [1m[35mProject Load (0.3ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.66] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdebase", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"} 2 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.66] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [["id", 2]] [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [1m[36mFlag Load (0.3ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY `flags`.position ASC LIMIT 1[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [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 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] flagcheck: package has default state, checking project [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] disabled_for sourceaccess repo: arch: state:enable [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [1m[35mCACHE (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY `flags`.position ASC LIMIT 1 [["db_package_id", 2]] [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [1m[36mCACHE (0.0ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [["db_project_id", 2]] [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id > 0) [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] update_activity 4.696390081980505e-12 10 2013-08-07 12:00:28 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.67] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000004697 WHERE `packages`.`id` = 2[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.68] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-07 12:00:28' WHERE `packages`.`id` = 2 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.68] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.68] ----------------- rendering package kdebase ------------------------ [0b58bc5e-c038-427b-b883-e1590af6094e] [290.68] [1m[35mRelationship Load (0.5ms)[0m SELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, login [0b58bc5e-c038-427b-b883-e1590af6094e] [290.68] [1m[36mRelationship Load (0.3ms)[0m [1mSELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, title[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.68] ----------------- end rendering package kdebase ------------------------ [0b58bc5e-c038-427b-b883-e1590af6094e] [290.68] [backend] PUT: /source/kde4/kdebase/_meta?user=king [282.08] 2013-08-07 12:00:28 [10426]: PUT /source/kde4/kdebase/_meta?user=king [0b58bc5e-c038-427b-b883-e1590af6094e] [290.69] request took 0.007376194 0.007376194 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.69] [1m[35mRelationship Load (0.5ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id > 0) [0b58bc5e-c038-427b-b883-e1590af6094e] [290.69] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.69] update_activity 10.0 1.6777327767124883e-06 2013-08-07 12:00:28 +0000 2013-08-07 12:00:28 UTC 2013-08-07 12:00:28 UTC [0b58bc5e-c038-427b-b883-e1590af6094e] [290.69] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.69] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000001677732778 WHERE `packages`.`id` = 2[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.69] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-07 12:00:28' WHERE `packages`.`id` = 2 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.69] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.69] ----------------- rendering package kdebase ------------------------ [0b58bc5e-c038-427b-b883-e1590af6094e] [290.70] [1m[35mRelationship Load (0.6ms)[0m SELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, login [0b58bc5e-c038-427b-b883-e1590af6094e] [290.70] [1m[36mRelationship Load (0.3ms)[0m [1mSELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, title[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.70] ----------------- end rendering package kdebase ------------------------ [0b58bc5e-c038-427b-b883-e1590af6094e] [290.70] [backend] PUT: /source/kde4/kdebase/_meta?user=king [282.10] 2013-08-07 12:00:28 [10427]: PUT /source/kde4/kdebase/_meta?user=king [0b58bc5e-c038-427b-b883-e1590af6094e] [290.71] request took 0.009683697 0.017059891 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.71] [1m[35mPackage Load (1.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.71] update_activity 10.000001907348633 1.9536250167422824e-06 2013-08-07 12:00:28 +0000 2013-08-07 12:00:28 UTC 2013-08-07 12:00:28 UTC [0b58bc5e-c038-427b-b883-e1590af6094e] [290.71] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.71] [1m[35mSQL (0.4ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.00000386097365 WHERE `packages`.`id` = 2 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.71] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-07 12:00:28' WHERE `packages`.`id` = 2[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.72] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.72] ----------------- rendering package kdebase ------------------------ [0b58bc5e-c038-427b-b883-e1590af6094e] [290.72] [1m[36mRelationship Load (0.6ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, login[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.72] [1m[35mRelationship Load (0.3ms)[0m SELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, title [0b58bc5e-c038-427b-b883-e1590af6094e] [290.72] ----------------- end rendering package kdebase ------------------------ [0b58bc5e-c038-427b-b883-e1590af6094e] [290.72] [backend] PUT: /source/kde4/kdebase/_meta?user=king [282.12] 2013-08-07 12:00:28 [10428]: PUT /source/kde4/kdebase/_meta?user=king [0b58bc5e-c038-427b-b883-e1590af6094e] [290.73] request took 0.010952923 0.028012814 [0b58bc5e-c038-427b-b883-e1590af6094e] [290.73] [1m[36m (0.2ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [0b58bc5e-c038-427b-b883-e1590af6094e] [290.73] Validate XML response: #<ActionDispatch::Response:0x00000006465270> took 1ms [0b58bc5e-c038-427b-b883-e1590af6094e] [290.73] Completed 200 OK in 79ms (Views: 1.2ms | ActiveRecord: 10.1ms | Backend: 28.0ms | XML: 0.0ms) [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-07 12:00:28 +0000 [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] Processing by SourceController#package_meta as XML [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] Validate XML request: #<ActionDispatch::Request:0x000000066d0d20> [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] USER found: king [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] User king initialised [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdebase", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"} 2 [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] [1m[36mRole Exists (0.3ms)[0m [1mSELECT DISTINCT 1 AS one 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 [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1 [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.74] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.75] [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 [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.75] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.75] Validate XML response: #<ActionDispatch::Response:0x000000066d0cf8> took 1ms [85cdbcc1-b191-48b7-8eb7-5dd4daa7e87f] [290.75] Completed 200 OK in 12ms (Views: 0.2ms | ActiveRecord: 1.5ms | Backend: 0.0ms | XML: 0.0ms) [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.75] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-07 12:00:28 +0000 [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.75] Processing by SourceController#package_meta as XML [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.75] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.75] Validate XML request: #<ActionDispatch::Request:0x000000067a4468> [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.75] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.75] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.75] USER found: king [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.75] User king initialised [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.75] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdelibs", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"} [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.75] [1m[36mRole Exists (0.2ms)[0m [1mSELECT DISTINCT 1 AS one 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 [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.76] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.76] [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 [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.76] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.76] ----------------- rendering package kdelibs ------------------------ [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.76] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1[0m [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.76] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.76] [1m[36mRelationship Load (0.6ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, login[0m [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.76] [1m[35mRelationship Load (0.3ms)[0m SELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, title [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.77] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC[0m [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.77] ----------------- end rendering package kdelibs ------------------------ [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.77] Validate XML response: #<ActionDispatch::Response:0x000000067a4440> took 1ms [9ac7d0cc-94f1-4f12-ad4b-6aa31f25c69a] [290.77] Completed 200 OK in 16ms (Views: 0.2ms | ActiveRecord: 2.6ms | Backend: 0.0ms | XML: 0.0ms) [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.77] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-07 12:00:28 +0000 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.77] Processing by SourceController#package_meta as XML [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.77] 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"} [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.77] Validate XML request: #<ActionDispatch::Request:0x000000068dae18> [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.77] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.77] USER found: king [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.77] User king initialised [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.77] [1m[36mRole Exists (0.3ms)[0m [1mSELECT DISTINCT 1 AS one 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 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.77] [1m[35mProject Load (0.3ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] [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 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdelibs", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"} 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [["id", 2]] [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] [1m[36mFlag Load (0.3ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY `flags`.position ASC LIMIT 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] [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 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] [1m[36mFlag Load (0.3ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] flagcheck: package has default state, checking project [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] disabled_for sourceaccess repo: arch: state:enable [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] 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"})}) [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.78] [1m[35mCACHE (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY `flags`.position ASC LIMIT 1 [["db_package_id", 1]] [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.79] [1m[36mCACHE (0.0ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [["db_project_id", 2]] [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.79] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'home:coolo:test' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.79] [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 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.79] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.79] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id > 0)[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.79] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.79] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.79] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.79] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.80] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.80] update_activity 4.696390081980505e-12 10 2013-08-07 12:00:28 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.80] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.80] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000004697 WHERE `packages`.`id` = 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.80] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-07 12:00:28' WHERE `packages`.`id` = 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.80] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.80] ----------------- rendering package kdelibs ------------------------ [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.80] [1m[36mRelationship Load (0.5ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, login[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.80] [1m[35mRelationship Load (0.3ms)[0m SELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, title [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.80] ----------------- end rendering package kdelibs ------------------------ [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.80] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [282.21] 2013-08-07 12:00:28 [10429]: PUT /source/kde4/kdelibs/_meta?user=king [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.81] request took 0.009121823 0.009121823 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.81] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.81] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.82] [1m[36mRelationship Load (0.4ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id > 0)[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.82] [1m[35mGroup Load (0.3ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.82] [1m[36mRole Load (0.3ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.82] [1m[35mGroup Load (0.3ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.82] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.82] update_activity 10.0 2.9495744793503374e-06 2013-08-07 12:00:28 +0000 2013-08-07 12:00:28 UTC 2013-08-07 12:00:28 UTC [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.82] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.82] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.00000294957448 WHERE `packages`.`id` = 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.82] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-07 12:00:28' WHERE `packages`.`id` = 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.83] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.83] ----------------- rendering package kdelibs ------------------------ [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.83] [1m[35mRelationship Load (0.6ms)[0m SELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, login [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.83] [1m[36mRelationship Load (0.3ms)[0m [1mSELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, title[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.83] ----------------- end rendering package kdelibs ------------------------ [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.83] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [282.23] 2013-08-07 12:00:28 [10430]: PUT /source/kde4/kdelibs/_meta?user=king [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.84] request took 0.00903765 0.018159473 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.84] [1m[35mPackage Load (0.5ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.84] update_activity 10.00000286102295 1.8178588814205593e-06 2013-08-07 12:00:28 +0000 2013-08-07 12:00:28 UTC 2013-08-07 12:00:28 UTC [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.84] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375876828)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.84] [1m[35mSQL (0.4ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000004678881831 WHERE `packages`.`id` = 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.84] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-07 12:00:28' WHERE `packages`.`id` = 1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.84] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.85] ----------------- rendering package kdelibs ------------------------ [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.85] [1m[36mRelationship Load (0.8ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, login[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.85] [1m[35mRelationship Load (0.3ms)[0m SELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, title [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.85] ----------------- end rendering package kdelibs ------------------------ [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.85] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [282.26] 2013-08-07 12:00:28 [10431]: PUT /source/kde4/kdelibs/_meta?user=king [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.86] request took 0.011336098 0.029495570999999998 [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.86] [1m[36m (0.2ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.86] Validate XML response: #<ActionDispatch::Response:0x000000068dada0> took 0ms [9f4e0dfe-bcb2-4f8c-a8b5-83485f124d23] [290.86] Completed 200 OK in 95ms (Views: 1.0ms | ActiveRecord: 12.1ms | Backend: 29.5ms | XML: 0.0ms) [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.87] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-07 12:00:28 +0000 [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.87] Processing by SourceController#package_meta as XML [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.87] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.87] Validate XML request: #<ActionDispatch::Request:0x00000006f5f108> [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.87] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.87] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.87] USER found: king [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.87] User king initialised [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.87] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdelibs", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"} 1 [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.87] [1m[36mRole Exists (0.3ms)[0m [1mSELECT DISTINCT 1 AS one 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 [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.87] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1 [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.88] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.88] [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 [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.88] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.88] Validate XML response: #<ActionDispatch::Response:0x00000006f5f0e0> took 1ms [7fc86778-ce83-4995-826d-d46ec5c7037d] [290.88] Completed 200 OK in 13ms (Views: 0.2ms | ActiveRecord: 1.5ms | Backend: 0.0ms | XML: 0.0ms) [290.90] [1m[35m (21.9ms)[0m ROLLBACK [290.90] kill 3386 + echo + cleanup + echo 'Killing backend processes' Killing backend processes + fuser -v <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/> + egrep 'perl|ruby' USER PID ACCESS COMMAND <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/>: ci ..c.. sh ci ..c.. sh ci ..c.. egrep ci ..c.. fuser + echo 'Remove log/tmp files to save disc space' Remove log/tmp files to save disc space + rm -rf src/api/log/backend_access.log src/api/log/test.log src/api/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 -- 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/1681/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