[obs-tests] Build failed in Jenkins: obs_master_testsuite_api #1672
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1672/changes> Changes: [Stephan Kulow] [api] remove more of rexml usage [Stephan Kulow] [api] fix testsuite failure ------------------------------------------ [...truncated 165135 lines...] [5a773e15-cdf4-4521-ac24-fce43dfc6fd9] [275.53] [1m[36m (0.2ms)[0m [1mSELECT `packages`.`name`, `packages`.`db_project_id` FROM `packages` WHERE `packages`.`db_project_id` = 2 AND (packages.db_project_id not in (0))[0m [5a773e15-cdf4-4521-ac24-fce43dfc6fd9] [275.54] [1m[35m (0.2ms)[0m SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0)) [5a773e15-cdf4-4521-ac24-fce43dfc6fd9] [275.54] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [5a773e15-cdf4-4521-ac24-fce43dfc6fd9] [275.54] Validate XML response: #<ActionDispatch::Response:0x0000000379e188> took 0ms [5a773e15-cdf4-4521-ac24-fce43dfc6fd9] [275.54] Completed 200 OK in 6ms (Views: 0.2ms | ActiveRecord: 1.1ms | Backend: 0.0ms | XML: 0.0ms) [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-05 12:11:07 +0000 [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] Processing by SourceController#package_meta as XML [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] Validate XML request: #<ActionDispatch::Request:0x0000000385de70> [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] USER found: king [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] User king initialised [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] 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"} [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] [1m[35mRole Exists (0.2ms)[0m SELECT 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 [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] [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 [984d8914-63f7-471f-9e48-ac41a1759acf] [275.54] [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 [984d8914-63f7-471f-9e48-ac41a1759acf] [275.55] [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 [984d8914-63f7-471f-9e48-ac41a1759acf] [275.55] ----------------- rendering package kdebase ------------------------ [984d8914-63f7-471f-9e48-ac41a1759acf] [275.55] [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 [984d8914-63f7-471f-9e48-ac41a1759acf] [275.55] [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 [984d8914-63f7-471f-9e48-ac41a1759acf] [275.55] [1m[35mFlag Load (0.4ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [984d8914-63f7-471f-9e48-ac41a1759acf] [275.55] ----------------- end rendering package kdebase ------------------------ [984d8914-63f7-471f-9e48-ac41a1759acf] [275.55] Validate XML response: #<ActionDispatch::Response:0x0000000385de48> took 1ms [984d8914-63f7-471f-9e48-ac41a1759acf] [275.55] Completed 200 OK in 14ms (Views: 0.2ms | ActiveRecord: 2.2ms | Backend: 0.0ms | XML: 0.2ms) [ccc29ebb-412c-4955-a587-83279a32409b] [275.55] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-05 12:11:07 +0000 [ccc29ebb-412c-4955-a587-83279a32409b] [275.55] Processing by SourceController#package_meta as XML [ccc29ebb-412c-4955-a587-83279a32409b] [275.55] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [ccc29ebb-412c-4955-a587-83279a32409b] [275.55] Validate XML request: #<ActionDispatch::Request:0x000000039754e8> [ccc29ebb-412c-4955-a587-83279a32409b] [275.56] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [ccc29ebb-412c-4955-a587-83279a32409b] [275.56] USER found: king [ccc29ebb-412c-4955-a587-83279a32409b] [275.56] User king initialised [ccc29ebb-412c-4955-a587-83279a32409b] [275.56] [1m[35mRole Exists (0.3ms)[0m SELECT 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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.56] [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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.56] [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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.56] [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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.56] 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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.56] [1m[35mPackage Load (0.5ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1 [ccc29ebb-412c-4955-a587-83279a32409b] [275.56] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [["id", 2]] [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [1m[35mFlag Load (0.3ms)[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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] flagcheck: package has default state, checking project [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] disabled_for sourceaccess repo: arch: state:enable [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [1m[36mCACHE (0.0ms)[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 [["db_package_id", 2]] [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [1m[35mCACHE (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [["db_project_id", 2]] [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id > 0)[0m [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] update_activity 4.765197365866632e-12 10 2013-08-05 12:11:07 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000004766 WHERE `packages`.`id` = 2 [ccc29ebb-412c-4955-a587-83279a32409b] [275.57] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:11:07' WHERE `packages`.`id` = 2[0m [ccc29ebb-412c-4955-a587-83279a32409b] [275.58] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2 [ccc29ebb-412c-4955-a587-83279a32409b] [275.58] ----------------- rendering package kdebase ------------------------ [ccc29ebb-412c-4955-a587-83279a32409b] [275.58] [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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.58] [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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.58] ----------------- end rendering package kdebase ------------------------ [ccc29ebb-412c-4955-a587-83279a32409b] [275.58] [backend] PUT: /source/kde4/kdebase/_meta?user=king [267.32] 2013-08-05 12:11:07 [29889]: PUT /source/kde4/kdebase/_meta?user=king [ccc29ebb-412c-4955-a587-83279a32409b] [275.60] request took 0.017521107 0.017521107 [ccc29ebb-412c-4955-a587-83279a32409b] [275.60] [1m[36mRelationship Load (0.5ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id > 0)[0m [ccc29ebb-412c-4955-a587-83279a32409b] [275.60] [1m[35mPackage Load (0.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [ccc29ebb-412c-4955-a587-83279a32409b] [275.60] update_activity 10.0 2.9013112739280417e-06 2013-08-05 12:11:07 +0000 2013-08-05 12:11:07 UTC 2013-08-05 12:11:07 UTC [ccc29ebb-412c-4955-a587-83279a32409b] [275.60] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [ccc29ebb-412c-4955-a587-83279a32409b] [275.60] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000002901311275 WHERE `packages`.`id` = 2 [ccc29ebb-412c-4955-a587-83279a32409b] [275.60] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:11:07' WHERE `packages`.`id` = 2[0m [ccc29ebb-412c-4955-a587-83279a32409b] [275.60] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2 [ccc29ebb-412c-4955-a587-83279a32409b] [275.60] ----------------- rendering package kdebase ------------------------ [ccc29ebb-412c-4955-a587-83279a32409b] [275.61] [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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.61] [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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.61] ----------------- end rendering package kdebase ------------------------ [ccc29ebb-412c-4955-a587-83279a32409b] [275.61] [backend] PUT: /source/kde4/kdebase/_meta?user=king [267.35] 2013-08-05 12:11:07 [29890]: PUT /source/kde4/kdebase/_meta?user=king [ccc29ebb-412c-4955-a587-83279a32409b] [275.62] request took 0.009712115 0.027233222 [ccc29ebb-412c-4955-a587-83279a32409b] [275.62] [1m[36mPackage Load (0.4ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [ccc29ebb-412c-4955-a587-83279a32409b] [275.62] update_activity 10.00000286102295 1.8210322768599898e-06 2013-08-05 12:11:07 +0000 2013-08-05 12:11:07 UTC 2013-08-05 12:11:07 UTC [ccc29ebb-412c-4955-a587-83279a32409b] [275.62] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [ccc29ebb-412c-4955-a587-83279a32409b] [275.62] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000004682055225 WHERE `packages`.`id` = 2[0m [ccc29ebb-412c-4955-a587-83279a32409b] [275.62] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:11:07' WHERE `packages`.`id` = 2 [ccc29ebb-412c-4955-a587-83279a32409b] [275.62] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2[0m [ccc29ebb-412c-4955-a587-83279a32409b] [275.62] ----------------- rendering package kdebase ------------------------ [ccc29ebb-412c-4955-a587-83279a32409b] [275.62] [1m[35mRelationship Load (0.7ms)[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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.63] [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 [ccc29ebb-412c-4955-a587-83279a32409b] [275.63] ----------------- end rendering package kdebase ------------------------ [ccc29ebb-412c-4955-a587-83279a32409b] [275.63] [backend] PUT: /source/kde4/kdebase/_meta?user=king [267.37] 2013-08-05 12:11:07 [29891]: PUT /source/kde4/kdebase/_meta?user=king [ccc29ebb-412c-4955-a587-83279a32409b] [275.64] request took 0.01044283 0.037676052 [ccc29ebb-412c-4955-a587-83279a32409b] [275.64] [1m[35m (0.3ms)[0m RELEASE SAVEPOINT active_record_1 [ccc29ebb-412c-4955-a587-83279a32409b] [275.64] Validate XML response: #<ActionDispatch::Response:0x00000003975d58> took 0ms [ccc29ebb-412c-4955-a587-83279a32409b] [275.64] Completed 200 OK in 85ms (Views: 0.9ms | ActiveRecord: 9.3ms | Backend: 37.7ms | XML: 0.0ms) [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.64] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-05 12:11:07 +0000 [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.64] Processing by SourceController#package_meta as XML [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.64] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.64] Validate XML request: #<ActionDispatch::Request:0x00000005f45010> [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.64] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.64] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.64] USER found: king [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.64] User king initialised [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.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"} 2 [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.65] [1m[35mRole Exists (0.3ms)[0m SELECT 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 [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.65] [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 [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.65] [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 [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.65] [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 [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.65] [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 [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.65] Validate XML response: #<ActionDispatch::Response:0x00000005f44fc0> took 2ms [18725304-30f5-41f8-9f7c-a268e8ffcbaa] [275.65] Completed 200 OK in 13ms (Views: 0.3ms | ActiveRecord: 1.6ms | Backend: 0.0ms | XML: 0.0ms) [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-05 12:11:07 +0000 [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] Processing by SourceController#package_meta as XML [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] Validate XML request: #<ActionDispatch::Request:0x000000061feb58> [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] USER found: king [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] User king initialised [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] 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"} [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] [1m[35mRole Exists (0.3ms)[0m SELECT 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 [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] [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 [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] [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 [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] [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 [3d27245f-59f5-42c9-b757-98d21983ce39] [275.66] ----------------- rendering package kdelibs ------------------------ [3d27245f-59f5-42c9-b757-98d21983ce39] [275.67] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1 [3d27245f-59f5-42c9-b757-98d21983ce39] [275.67] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [3d27245f-59f5-42c9-b757-98d21983ce39] [275.67] [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 [3d27245f-59f5-42c9-b757-98d21983ce39] [275.67] [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 [3d27245f-59f5-42c9-b757-98d21983ce39] [275.67] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [3d27245f-59f5-42c9-b757-98d21983ce39] [275.67] ----------------- end rendering package kdelibs ------------------------ [3d27245f-59f5-42c9-b757-98d21983ce39] [275.67] Validate XML response: #<ActionDispatch::Response:0x000000061feb30> took 1ms [3d27245f-59f5-42c9-b757-98d21983ce39] [275.67] Completed 200 OK in 16ms (Views: 0.2ms | ActiveRecord: 2.6ms | Backend: 0.0ms | XML: 0.0ms) [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.67] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-05 12:11:07 +0000 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] Processing by SourceController#package_meta as XML [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] 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"} [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] Validate XML request: #<ActionDispatch::Request:0x00000006368e30> [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] USER found: king [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] User king initialised [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] [1m[35mRole Exists (0.2ms)[0m SELECT 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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] [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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] [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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] [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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] 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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.68] [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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [["id", 2]] [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] [1m[35mFlag Load (0.3ms)[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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] [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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] flagcheck: package has default state, checking project [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] disabled_for sourceaccess repo: arch: state:enable [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] 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"})}) [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] [1m[36mCACHE (0.0ms)[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 [["db_package_id", 1]] [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] [1m[35mCACHE (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [["db_project_id", 2]] [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'home:coolo:test' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.69] [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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id > 0) [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] update_activity 4.765197365866632e-12 10 2013-08-05 12:11:07 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000004766 WHERE `packages`.`id` = 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:11:07' WHERE `packages`.`id` = 1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.70] ----------------- rendering package kdelibs ------------------------ [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.71] [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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.71] [1m[36mRelationship Load (0.4ms)[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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.71] ----------------- end rendering package kdelibs ------------------------ [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.71] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [267.45] 2013-08-05 12:11:07 [29892]: PUT /source/kde4/kdelibs/_meta?user=king [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.72] request took 0.009160997 0.009160997 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.72] [1m[35mUser Load (0.5ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.72] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.72] [1m[35mRelationship Load (0.4ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id > 0) [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.72] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.72] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.72] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.72] [1m[35mPackage Load (0.1ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.73] update_activity 10.0 2.609220919785676e-06 2013-08-05 12:11:07 +0000 2013-08-05 12:11:07 UTC 2013-08-05 12:11:07 UTC [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.73] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.73] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.00000260922092 WHERE `packages`.`id` = 1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.73] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:11:07' WHERE `packages`.`id` = 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.73] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.73] ----------------- rendering package kdelibs ------------------------ [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.73] [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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.73] [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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.73] ----------------- end rendering package kdelibs ------------------------ [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.73] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [267.48] 2013-08-05 12:11:07 [29893]: PUT /source/kde4/kdelibs/_meta?user=king [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.74] request took 0.009961165 0.019122161999999998 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.74] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.74] update_activity 10.00000286102295 1.843218450193052e-06 2013-08-05 12:11:07 +0000 2013-08-05 12:11:07 UTC 2013-08-05 12:11:07 UTC [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.74] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375704667)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.74] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.0000047042414 WHERE `packages`.`id` = 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.74] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:11:07' WHERE `packages`.`id` = 1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.75] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1[0m [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.75] ----------------- rendering package kdelibs ------------------------ [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.75] [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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.75] [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 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.75] ----------------- end rendering package kdelibs ------------------------ [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.75] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [267.50] 2013-08-05 12:11:07 [29894]: PUT /source/kde4/kdelibs/_meta?user=king [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.76] request took 0.00985764 0.028979802 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.76] [1m[35m (0.1ms)[0m RELEASE SAVEPOINT active_record_1 [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.76] Validate XML response: #<ActionDispatch::Response:0x00000006368de0> took 0ms [a6b8e5f6-80f9-40b4-b629-63569abe903e] [275.76] Completed 200 OK in 88ms (Views: 1.0ms | ActiveRecord: 10.6ms | Backend: 29.0ms | XML: 0.0ms) [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.76] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-05 12:11:07 +0000 [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.77] Processing by SourceController#package_meta as XML [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.77] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.77] Validate XML request: #<ActionDispatch::Request:0x00000006d5c6a8> [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.77] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.77] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.77] USER found: king [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.77] User king initialised [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.77] 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 [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.77] [1m[35mRole Exists (0.4ms)[0m SELECT 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 [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.77] [1m[36mPackage Load (0.3ms)[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 [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.78] [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 [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.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 [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.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 [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.78] Validate XML response: #<ActionDispatch::Response:0x00000006d5c680> took 1ms [2c8e43cd-18d9-4ace-9461-70783b1f3651] [275.78] Completed 200 OK in 15ms (Views: 0.2ms | ActiveRecord: 1.7ms | Backend: 0.0ms | XML: 0.0ms) [275.79] [1m[36m (5.3ms)[0m [1mROLLBACK[0m [275.79] kill 22795 + 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/1673/changes> Changes: [Stephan Kulow] [api] give the group controller a sane structure ------------------------------------------ [...truncated 165190 lines...] [45835c41-b1a9-4cb2-bd63-0058b3831771] [279.38] [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)) [45835c41-b1a9-4cb2-bd63-0058b3831771] [279.38] [1m[36m (0.2ms)[0m [1mSELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0))[0m [45835c41-b1a9-4cb2-bd63-0058b3831771] [279.38] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [45835c41-b1a9-4cb2-bd63-0058b3831771] [279.38] Validate XML response: #<ActionDispatch::Response:0x0000000696ce08> took 0ms [45835c41-b1a9-4cb2-bd63-0058b3831771] [279.38] Completed 200 OK in 6ms (Views: 0.1ms | ActiveRecord: 1.0ms | Backend: 0.0ms | XML: 0.0ms) [d333f53f-f9e4-497d-9544-0b58247d2571] [279.38] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-05 12:21:33 +0000 [d333f53f-f9e4-497d-9544-0b58247d2571] [279.38] Processing by SourceController#package_meta as XML [d333f53f-f9e4-497d-9544-0b58247d2571] [279.38] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [d333f53f-f9e4-497d-9544-0b58247d2571] [279.38] Validate XML request: #<ActionDispatch::Request:0x00000006ad2b30> [d333f53f-f9e4-497d-9544-0b58247d2571] [279.38] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [d333f53f-f9e4-497d-9544-0b58247d2571] [279.38] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [d333f53f-f9e4-497d-9544-0b58247d2571] [279.38] USER found: king [d333f53f-f9e4-497d-9544-0b58247d2571] [279.38] User king initialised [d333f53f-f9e4-497d-9544-0b58247d2571] [279.38] 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"} [d333f53f-f9e4-497d-9544-0b58247d2571] [279.39] [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 [d333f53f-f9e4-497d-9544-0b58247d2571] [279.39] [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 [d333f53f-f9e4-497d-9544-0b58247d2571] [279.39] [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 [d333f53f-f9e4-497d-9544-0b58247d2571] [279.39] [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 [d333f53f-f9e4-497d-9544-0b58247d2571] [279.39] ----------------- rendering package kdebase ------------------------ [d333f53f-f9e4-497d-9544-0b58247d2571] [279.39] [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 [d333f53f-f9e4-497d-9544-0b58247d2571] [279.39] [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 [d333f53f-f9e4-497d-9544-0b58247d2571] [279.39] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC[0m [d333f53f-f9e4-497d-9544-0b58247d2571] [279.39] ----------------- end rendering package kdebase ------------------------ [d333f53f-f9e4-497d-9544-0b58247d2571] [279.48] Validate XML response: #<ActionDispatch::Response:0x00000006ad2b08> took 88ms [d333f53f-f9e4-497d-9544-0b58247d2571] [279.48] Completed 200 OK in 100ms (Views: 0.2ms | ActiveRecord: 2.0ms | Backend: 0.0ms | XML: 0.2ms) [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.48] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-05 12:21:33 +0000 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.49] Processing by SourceController#package_meta as XML [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.49] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.49] Validate XML request: #<ActionDispatch::Request:0x000000035c2940> [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.49] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.49] USER found: king [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.49] User king initialised [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.49] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.49] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.49] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] 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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] [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]] [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC[0m [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] flagcheck: package has default state, checking project [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] disabled_for sourceaccess repo: arch: state:enable [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] [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]] [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] [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]] [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.50] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id > 0) [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.51] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.51] update_activity 4.764945356301783e-12 10 2013-08-05 12:21:33 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.51] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.51] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000004764 WHERE `packages`.`id` = 2[0m [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.51] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:21:33' WHERE `packages`.`id` = 2 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.51] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2[0m [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.51] ----------------- rendering package kdebase ------------------------ [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.51] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.51] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.51] ----------------- end rendering package kdebase ------------------------ [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.51] [backend] PUT: /source/kde4/kdebase/_meta?user=king [271.90] 2013-08-05 12:21:33 [13320]: PUT /source/kde4/kdebase/_meta?user=king [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.53] request took 0.014983123 0.014983123 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.53] [1m[35mRelationship Load (0.5ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id > 0) [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.53] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.53] update_activity 10.0 2.517413209985804e-06 2013-08-05 12:21:33 +0000 2013-08-05 12:21:33 UTC 2013-08-05 12:21:33 UTC [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.53] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.53] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.00000251741321 WHERE `packages`.`id` = 2[0m [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.53] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:21:33' WHERE `packages`.`id` = 2 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.53] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2[0m [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.53] ----------------- rendering package kdebase ------------------------ [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.54] [1m[35mRelationship Load (0.7ms)[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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.54] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.54] ----------------- end rendering package kdebase ------------------------ [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.54] [backend] PUT: /source/kde4/kdebase/_meta?user=king [271.92] 2013-08-05 12:21:33 [13321]: PUT /source/kde4/kdebase/_meta?user=king [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.55] request took 0.01130817 0.026291293 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.55] [1m[35mPackage Load (0.5ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.55] update_activity 10.00000286102295 2.17824622436806e-06 2013-08-05 12:21:33 +0000 2013-08-05 12:21:33 UTC 2013-08-05 12:21:33 UTC [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.55] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.55] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000005039269174 WHERE `packages`.`id` = 2 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.55] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:21:33' WHERE `packages`.`id` = 2[0m [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.55] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.55] ----------------- rendering package kdebase ------------------------ [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.56] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.56] [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 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.56] ----------------- end rendering package kdebase ------------------------ [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.56] [backend] PUT: /source/kde4/kdebase/_meta?user=king [271.94] 2013-08-05 12:21:33 [13322]: PUT /source/kde4/kdebase/_meta?user=king [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.57] request took 0.012015733 0.038307026 [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.57] [1m[36m (0.3ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.57] Validate XML response: #<ActionDispatch::Response:0x000000035c28a0> took 0ms [b29d4f63-def7-49f4-9b90-53be50b6d04e] [279.57] Completed 200 OK in 86ms (Views: 0.9ms | ActiveRecord: 9.1ms | Backend: 38.3ms | XML: 0.0ms) [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.57] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-05 12:21:33 +0000 [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.58] Processing by SourceController#package_meta as XML [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.58] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.58] Validate XML request: #<ActionDispatch::Request:0x00000005c2c478> [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.58] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.58] [1m[35mUser Load (0.5ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.58] USER found: king [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.58] User king initialised [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.58] 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 [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.58] [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 [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.58] [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 [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.58] [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 [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.59] [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 [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.59] [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 [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.59] Validate XML response: #<ActionDispatch::Response:0x00000005c2c360> took 2ms [be82b6ea-32a7-4696-b988-8a44ee6901af] [279.59] Completed 200 OK in 14ms (Views: 0.2ms | ActiveRecord: 1.6ms | Backend: 0.0ms | XML: 0.0ms) [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.59] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-05 12:21:33 +0000 [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.59] Processing by SourceController#package_meta as XML [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.59] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.59] Validate XML request: #<ActionDispatch::Request:0x00000005e3e018> [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.59] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.59] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.59] USER found: king [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.59] User king initialised [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.59] 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"} [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.60] [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 [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.60] [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 [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.60] [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 [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.60] [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 [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.60] ----------------- rendering package kdelibs ------------------------ [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.60] [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 [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.60] [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 [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.60] [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 [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.61] [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 [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.61] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC[0m [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.61] ----------------- end rendering package kdelibs ------------------------ [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.61] Validate XML response: #<ActionDispatch::Response:0x00000005e3df28> took 2ms [8985ae8a-ba4e-4820-a65c-f0ee1948b93c] [279.61] Completed 200 OK in 17ms (Views: 0.2ms | ActiveRecord: 2.6ms | Backend: 0.0ms | XML: 0.0ms) [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.61] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-05 12:21:33 +0000 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.61] Processing by SourceController#package_meta as XML [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.61] 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"} [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.61] Validate XML request: #<ActionDispatch::Request:0x0000000617d800> [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.61] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.61] USER found: king [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.61] User king initialised [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.62] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.62] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.62] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.62] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.62] 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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.62] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.62] [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]] [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.62] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.62] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] flagcheck: package has default state, checking project [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] disabled_for sourceaccess repo: arch: state:enable [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] 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"})}) [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] [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]] [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] [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]] [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id > 0)[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.63] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] update_activity 4.764945356301783e-12 10 2013-08-05 12:21:33 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000004764 WHERE `packages`.`id` = 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:21:33' WHERE `packages`.`id` = 1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] ----------------- rendering package kdelibs ------------------------ [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] ----------------- end rendering package kdelibs ------------------------ [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.64] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [272.03] 2013-08-05 12:21:33 [13323]: PUT /source/kde4/kdelibs/_meta?user=king [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.66] request took 0.017630663 0.017630663 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.66] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.66] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.66] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id > 0)[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] update_activity 10.0 3.41371805579574e-06 2013-08-05 12:21:33 +0000 2013-08-05 12:21:33 UTC 2013-08-05 12:21:33 UTC [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000003413718057 WHERE `packages`.`id` = 1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:21:33' WHERE `packages`.`id` = 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] ----------------- rendering package kdelibs ------------------------ [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] [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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.67] ----------------- end rendering package kdelibs ------------------------ [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.68] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [272.06] 2013-08-05 12:21:33 [13324]: PUT /source/kde4/kdelibs/_meta?user=king [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.68] request took 0.008979292 0.026609955 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.69] [1m[35mPackage Load (0.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.69] update_activity 10.000003814697266 1.7729346398954038e-06 2013-08-05 12:21:33 +0000 2013-08-05 12:21:33 UTC 2013-08-05 12:21:33 UTC [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.69] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705293)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.69] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000005587631906 WHERE `packages`.`id` = 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.69] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:21:33' WHERE `packages`.`id` = 1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.69] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.69] ----------------- rendering package kdelibs ------------------------ [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.70] [1m[36mRelationship Load (7.9ms)[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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.70] [1m[35mRelationship Load (0.5ms)[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 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.70] ----------------- end rendering package kdelibs ------------------------ [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.70] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [272.09] 2013-08-05 12:21:33 [13325]: PUT /source/kde4/kdelibs/_meta?user=king [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.71] request took 0.008619968 0.035229923 [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.71] [1m[36m (0.2ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.71] Validate XML response: #<ActionDispatch::Response:0x0000000617d788> took 0ms [0c39a9d9-d46d-41ff-b7aa-13476551d647] [279.71] Completed 200 OK in 101ms (Views: 0.8ms | ActiveRecord: 18.2ms | Backend: 35.2ms | XML: 0.0ms) [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.71] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-05 12:21:33 +0000 [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.72] Processing by SourceController#package_meta as XML [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.72] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.72] Validate XML request: #<ActionDispatch::Request:0x00000006890bd8> [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.72] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.72] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.72] USER found: king [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.72] User king initialised [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.72] 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 [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.72] [1m[36mRole Exists (0.4ms)[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 [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.72] [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 [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.72] [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 [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.73] [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 [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.73] [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 [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.73] Validate XML response: #<ActionDispatch::Response:0x00000006890bb0> took 2ms [10791279-ab6b-4d3b-93b4-92811c47dcf7] [279.73] Completed 200 OK in 13ms (Views: 0.3ms | ActiveRecord: 1.6ms | Backend: 0.0ms | XML: 0.0ms) [279.74] [1m[35m (13.1ms)[0m ROLLBACK [279.74] kill 6286 + 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.. sh 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/1674/> ------------------------------------------ [...truncated 165134 lines...] [bd274aac-f35e-4a04-84f7-19b75088c0c8] [283.91] [1m[36m (0.2ms)[0m [1mSELECT `packages`.`name`, `packages`.`db_project_id` FROM `packages` WHERE `packages`.`db_project_id` = 2 AND (packages.db_project_id not in (0))[0m [bd274aac-f35e-4a04-84f7-19b75088c0c8] [283.91] [1m[35m (0.2ms)[0m SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0)) [bd274aac-f35e-4a04-84f7-19b75088c0c8] [283.91] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [bd274aac-f35e-4a04-84f7-19b75088c0c8] [283.91] Validate XML response: #<ActionDispatch::Response:0x00000005d3b940> took 0ms [bd274aac-f35e-4a04-84f7-19b75088c0c8] [283.91] Completed 200 OK in 7ms (Views: 0.2ms | ActiveRecord: 1.2ms | Backend: 0.0ms | XML: 0.0ms) [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.91] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-05 12:26:36 +0000 [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.91] Processing by SourceController#package_meta as XML [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.91] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.91] Validate XML request: #<ActionDispatch::Request:0x00000005e79d70> [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.91] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.91] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.91] USER found: king [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.91] User king initialised [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.91] 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"} [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.92] [1m[35mRole Exists (0.3ms)[0m SELECT 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 [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.92] [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 [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.92] [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 [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.92] [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 [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.92] ----------------- rendering package kdebase ------------------------ [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.92] [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 [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.92] [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 [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.92] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.92] ----------------- end rendering package kdebase ------------------------ [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.93] Validate XML response: #<ActionDispatch::Response:0x00000005e79c30> took 2ms [09f87358-d236-41fb-b8f2-046b343e3e9d] [283.93] Completed 200 OK in 15ms (Views: 0.2ms | ActiveRecord: 2.3ms | Backend: 0.0ms | XML: 0.3ms) [8b50db3d-988c-475b-b290-53664e223326] [283.93] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-05 12:26:36 +0000 [8b50db3d-988c-475b-b290-53664e223326] [283.93] Processing by SourceController#package_meta as XML [8b50db3d-988c-475b-b290-53664e223326] [283.93] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [8b50db3d-988c-475b-b290-53664e223326] [283.93] Validate XML request: #<ActionDispatch::Request:0x0000000610e6f8> [8b50db3d-988c-475b-b290-53664e223326] [283.93] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [8b50db3d-988c-475b-b290-53664e223326] [283.93] USER found: king [8b50db3d-988c-475b-b290-53664e223326] [283.93] User king initialised [8b50db3d-988c-475b-b290-53664e223326] [283.94] [1m[35mRole Exists (0.4ms)[0m SELECT 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 [8b50db3d-988c-475b-b290-53664e223326] [283.94] [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 [8b50db3d-988c-475b-b290-53664e223326] [283.94] [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 [8b50db3d-988c-475b-b290-53664e223326] [283.94] [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 [8b50db3d-988c-475b-b290-53664e223326] [283.94] 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 [8b50db3d-988c-475b-b290-53664e223326] [283.94] [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 [8b50db3d-988c-475b-b290-53664e223326] [283.94] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [["id", 2]] [8b50db3d-988c-475b-b290-53664e223326] [283.94] [1m[35mFlag Load (0.3ms)[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 [8b50db3d-988c-475b-b290-53664e223326] [283.94] [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 [8b50db3d-988c-475b-b290-53664e223326] [283.95] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [8b50db3d-988c-475b-b290-53664e223326] [283.95] flagcheck: package has default state, checking project [8b50db3d-988c-475b-b290-53664e223326] [283.95] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [8b50db3d-988c-475b-b290-53664e223326] [283.95] disabled_for sourceaccess repo: arch: state:enable [8b50db3d-988c-475b-b290-53664e223326] [283.95] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [8b50db3d-988c-475b-b290-53664e223326] [283.95] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [8b50db3d-988c-475b-b290-53664e223326] [283.95] [1m[36mCACHE (0.0ms)[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 [["db_package_id", 2]] [8b50db3d-988c-475b-b290-53664e223326] [283.95] [1m[35mCACHE (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [["db_project_id", 2]] [8b50db3d-988c-475b-b290-53664e223326] [283.95] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id > 0)[0m [8b50db3d-988c-475b-b290-53664e223326] [283.95] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [8b50db3d-988c-475b-b290-53664e223326] [283.95] update_activity 4.764823382017968e-12 10 2013-08-05 12:26:36 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [8b50db3d-988c-475b-b290-53664e223326] [283.95] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [8b50db3d-988c-475b-b290-53664e223326] [283.95] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000004764 WHERE `packages`.`id` = 2 [8b50db3d-988c-475b-b290-53664e223326] [283.95] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:26:36' WHERE `packages`.`id` = 2[0m [8b50db3d-988c-475b-b290-53664e223326] [283.95] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2 [8b50db3d-988c-475b-b290-53664e223326] [283.95] ----------------- rendering package kdebase ------------------------ [8b50db3d-988c-475b-b290-53664e223326] [283.96] [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 [8b50db3d-988c-475b-b290-53664e223326] [283.96] [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 [8b50db3d-988c-475b-b290-53664e223326] [283.96] ----------------- end rendering package kdebase ------------------------ [8b50db3d-988c-475b-b290-53664e223326] [283.96] [backend] PUT: /source/kde4/kdebase/_meta?user=king [275.84] 2013-08-05 12:26:36 [21116]: PUT /source/kde4/kdebase/_meta?user=king [8b50db3d-988c-475b-b290-53664e223326] [283.97] request took 0.011261866 0.011261866 [8b50db3d-988c-475b-b290-53664e223326] [283.97] [1m[36mRelationship Load (0.6ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id > 0)[0m [8b50db3d-988c-475b-b290-53664e223326] [283.97] [1m[35mPackage Load (0.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [8b50db3d-988c-475b-b290-53664e223326] [283.97] update_activity 10.0 2.2336840629577638e-06 2013-08-05 12:26:36 +0000 2013-08-05 12:26:36 UTC 2013-08-05 12:26:36 UTC [8b50db3d-988c-475b-b290-53664e223326] [283.97] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [8b50db3d-988c-475b-b290-53664e223326] [283.97] [1m[35mSQL (0.4ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000002233684063 WHERE `packages`.`id` = 2 [8b50db3d-988c-475b-b290-53664e223326] [283.98] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:26:36' WHERE `packages`.`id` = 2[0m [8b50db3d-988c-475b-b290-53664e223326] [283.98] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2 [8b50db3d-988c-475b-b290-53664e223326] [283.98] ----------------- rendering package kdebase ------------------------ [8b50db3d-988c-475b-b290-53664e223326] [283.98] [1m[36mRelationship Load (1.0ms)[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 [8b50db3d-988c-475b-b290-53664e223326] [283.98] [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 [8b50db3d-988c-475b-b290-53664e223326] [283.98] ----------------- end rendering package kdebase ------------------------ [8b50db3d-988c-475b-b290-53664e223326] [283.98] [backend] PUT: /source/kde4/kdebase/_meta?user=king [275.86] 2013-08-05 12:26:36 [21117]: PUT /source/kde4/kdebase/_meta?user=king [8b50db3d-988c-475b-b290-53664e223326] [283.99] request took 0.010746751 0.022008617 [8b50db3d-988c-475b-b290-53664e223326] [283.99] [1m[36mPackage Load (0.7ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [8b50db3d-988c-475b-b290-53664e223326] [284.00] update_activity 10.000001907348633 2.276897430419922e-06 2013-08-05 12:26:36 +0000 2013-08-05 12:26:36 UTC 2013-08-05 12:26:36 UTC [8b50db3d-988c-475b-b290-53664e223326] [284.00] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [8b50db3d-988c-475b-b290-53664e223326] [284.00] [1m[36mSQL (0.4ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000004184246063 WHERE `packages`.`id` = 2[0m [8b50db3d-988c-475b-b290-53664e223326] [284.00] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:26:36' WHERE `packages`.`id` = 2 [8b50db3d-988c-475b-b290-53664e223326] [284.00] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2[0m [8b50db3d-988c-475b-b290-53664e223326] [284.00] ----------------- rendering package kdebase ------------------------ [8b50db3d-988c-475b-b290-53664e223326] [284.00] [1m[35mRelationship Load (1.0ms)[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 [8b50db3d-988c-475b-b290-53664e223326] [284.00] [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 [8b50db3d-988c-475b-b290-53664e223326] [284.01] ----------------- end rendering package kdebase ------------------------ [8b50db3d-988c-475b-b290-53664e223326] [284.01] [backend] PUT: /source/kde4/kdebase/_meta?user=king [275.89] 2013-08-05 12:26:36 [21118]: PUT /source/kde4/kdebase/_meta?user=king [8b50db3d-988c-475b-b290-53664e223326] [284.02] request took 0.010038251 0.032046868 [8b50db3d-988c-475b-b290-53664e223326] [284.02] [1m[35m (0.2ms)[0m RELEASE SAVEPOINT active_record_1 [8b50db3d-988c-475b-b290-53664e223326] [284.02] Validate XML response: #<ActionDispatch::Response:0x0000000610e6d0> took 1ms [8b50db3d-988c-475b-b290-53664e223326] [284.02] Completed 200 OK in 88ms (Views: 1.1ms | ActiveRecord: 11.0ms | Backend: 32.0ms | XML: 0.0ms) [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.02] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-05 12:26:36 +0000 [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.02] Processing by SourceController#package_meta as XML [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.02] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.02] Validate XML request: #<ActionDispatch::Request:0x0000000646dfd8> [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.02] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.03] [1m[36mUser Load (0.6ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.03] USER found: king [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.03] User king initialised [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.03] 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 [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.03] [1m[35mRole Exists (0.5ms)[0m SELECT 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 [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.03] [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 [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.03] [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 [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.04] [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 [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.04] [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 [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.04] Validate XML response: #<ActionDispatch::Response:0x0000000646df88> took 2ms [abfb3e29-c795-4e8b-97b4-6e072a2d297f] [284.04] Completed 200 OK in 16ms (Views: 0.4ms | ActiveRecord: 2.0ms | Backend: 0.0ms | XML: 0.0ms) [08efe582-34fb-4082-a93e-edca0f166117] [284.04] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-05 12:26:36 +0000 [08efe582-34fb-4082-a93e-edca0f166117] [284.04] Processing by SourceController#package_meta as XML [08efe582-34fb-4082-a93e-edca0f166117] [284.04] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [08efe582-34fb-4082-a93e-edca0f166117] [284.04] Validate XML request: #<ActionDispatch::Request:0x00000006879820> [08efe582-34fb-4082-a93e-edca0f166117] [284.04] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [08efe582-34fb-4082-a93e-edca0f166117] [284.04] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [08efe582-34fb-4082-a93e-edca0f166117] [284.04] USER found: king [08efe582-34fb-4082-a93e-edca0f166117] [284.04] User king initialised [08efe582-34fb-4082-a93e-edca0f166117] [284.04] 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"} [08efe582-34fb-4082-a93e-edca0f166117] [284.05] [1m[35mRole Exists (0.3ms)[0m SELECT 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 [08efe582-34fb-4082-a93e-edca0f166117] [284.05] [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 [08efe582-34fb-4082-a93e-edca0f166117] [284.05] [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 [08efe582-34fb-4082-a93e-edca0f166117] [284.05] [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 [08efe582-34fb-4082-a93e-edca0f166117] [284.05] ----------------- rendering package kdelibs ------------------------ [08efe582-34fb-4082-a93e-edca0f166117] [284.05] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1 [08efe582-34fb-4082-a93e-edca0f166117] [284.05] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [08efe582-34fb-4082-a93e-edca0f166117] [284.06] [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 [08efe582-34fb-4082-a93e-edca0f166117] [284.06] [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 [08efe582-34fb-4082-a93e-edca0f166117] [284.06] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [08efe582-34fb-4082-a93e-edca0f166117] [284.06] ----------------- end rendering package kdelibs ------------------------ [08efe582-34fb-4082-a93e-edca0f166117] [284.06] Validate XML response: #<ActionDispatch::Response:0x000000068797a8> took 2ms [08efe582-34fb-4082-a93e-edca0f166117] [284.06] Completed 200 OK in 18ms (Views: 0.2ms | ActiveRecord: 2.9ms | Backend: 0.0ms | XML: 0.0ms) [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.06] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-05 12:26:36 +0000 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.06] Processing by SourceController#package_meta as XML [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.06] 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"} [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.06] Validate XML request: #<ActionDispatch::Request:0x00000006925918> [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.06] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.06] USER found: king [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.06] User king initialised [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.07] [1m[35mRole Exists (0.3ms)[0m SELECT 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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.07] [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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.07] [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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.07] [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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.07] 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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.07] [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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.07] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [["id", 2]] [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.07] [1m[35mFlag Load (0.3ms)[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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] [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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] flagcheck: package has default state, checking project [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] disabled_for sourceaccess repo: arch: state:enable [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] 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"})}) [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] [1m[36mCACHE (0.0ms)[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 [["db_package_id", 1]] [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] [1m[35mCACHE (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [["db_project_id", 2]] [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'home:coolo:test' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] [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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id > 0) [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.08] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] update_activity 4.764823382017968e-12 10 2013-08-05 12:26:36 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000004764 WHERE `packages`.`id` = 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:26:36' WHERE `packages`.`id` = 1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] ----------------- rendering package kdelibs ------------------------ [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] [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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.09] [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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.10] ----------------- end rendering package kdelibs ------------------------ [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.10] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [275.98] 2013-08-05 12:26:36 [21119]: PUT /source/kde4/kdelibs/_meta?user=king [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.11] request took 0.010695142 0.010695142 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.11] [1m[35mUser Load (0.6ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.11] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.12] [1m[35mRelationship Load (0.4ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id > 0) [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.12] [1m[36mGroup Load (0.3ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.12] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.12] [1m[36mGroup Load (0.3ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.12] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.12] update_activity 10.0 3.6522194191261573e-06 2013-08-05 12:26:36 +0000 2013-08-05 12:26:36 UTC 2013-08-05 12:26:36 UTC [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.12] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.12] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.00000365221942 WHERE `packages`.`id` = 1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.12] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:26:36' WHERE `packages`.`id` = 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.13] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.13] ----------------- rendering package kdelibs ------------------------ [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.13] [1m[36mRelationship Load (0.7ms)[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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.13] [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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.13] ----------------- end rendering package kdelibs ------------------------ [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.13] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [276.01] 2013-08-05 12:26:36 [21120]: PUT /source/kde4/kdelibs/_meta?user=king [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.14] request took 0.009888417 0.020583559 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.14] [1m[36mPackage Load (0.7ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.14] update_activity 10.000003814697266 2.014912940837719e-06 2013-08-05 12:26:36 +0000 2013-08-05 12:26:36 UTC 2013-08-05 12:26:36 UTC [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.14] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1375705596)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.15] [1m[36mSQL (0.4ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000005829610206 WHERE `packages`.`id` = 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.15] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-05 12:26:36' WHERE `packages`.`id` = 1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.15] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1[0m [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.15] ----------------- rendering package kdelibs ------------------------ [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.15] [1m[35mRelationship Load (0.8ms)[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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.15] [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 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.15] ----------------- end rendering package kdelibs ------------------------ [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.15] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [276.04] 2013-08-05 12:26:36 [21121]: PUT /source/kde4/kdelibs/_meta?user=king [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.16] request took 0.01085972 0.031443279000000005 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.17] [1m[35m (0.3ms)[0m RELEASE SAVEPOINT active_record_1 [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.17] Validate XML response: #<ActionDispatch::Response:0x000000069258f0> took 1ms [eb687fda-9e39-4b2f-bc11-d7a5178ff1c2] [284.17] Completed 200 OK in 106ms (Views: 1.6ms | ActiveRecord: 12.9ms | Backend: 31.4ms | XML: 0.0ms) [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.17] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-05 12:26:36 +0000 [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.17] Processing by SourceController#package_meta as XML [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.17] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.17] Validate XML request: #<ActionDispatch::Request:0x00000007013f68> [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.17] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.18] [1m[36mUser Load (0.6ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.18] USER found: king [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.18] User king initialised [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.18] 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 [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.18] [1m[35mRole Exists (0.5ms)[0m SELECT 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 [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.18] [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 [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.18] [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 [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.18] [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 [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.18] [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 [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.31] Validate XML response: #<ActionDispatch::Response:0x00000007013f40> took 122ms [04234ddf-189b-4c10-a8fa-3a5efd0efba3] [284.31] Completed 200 OK in 135ms (Views: 0.3ms | ActiveRecord: 1.9ms | Backend: 0.0ms | XML: 0.0ms) [284.32] [1m[36m (12.8ms)[0m [1mROLLBACK[0m [284.32] kill 14007 + echo + cleanup + echo 'Killing backend processes' Killing backend processes + egrep 'perl|ruby' + fuser -v <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/> USER PID ACCESS COMMAND <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/>: ci ..c.. sh ci ..c.. sh ci ..c.. egrep ci ..c.. fuser + echo 'Remove log/tmp files to save disc space' Remove log/tmp files to save disc space + rm -rf src/api/log/backend_access.log src/api/log/test.log src/api/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/1675/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