See <http://ci.opensuse.org/job/obs_master_testsuite_api/1725/changes> Changes: [mls] [backend] route all notifications through the src server's notify() function [mls] [backend] implement lastnotifications streaming service ------------------------------------------ [...truncated 206292 lines...] [36f1223d-d5e8-454f-8a33-151395d065d6] [319.35] Parameters: {"project"=>"kde4"} [36f1223d-d5e8-454f-8a33-151395d065d6] [319.35] Validate XML request: #<ActionDispatch::Request:0x00000007528e18> [36f1223d-d5e8-454f-8a33-151395d065d6] [319.35] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [36f1223d-d5e8-454f-8a33-151395d065d6] [319.35] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [36f1223d-d5e8-454f-8a33-151395d065d6] [319.35] USER found: king [36f1223d-d5e8-454f-8a33-151395d065d6] [319.35] User king initialised [36f1223d-d5e8-454f-8a33-151395d065d6] [319.36] [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 [36f1223d-d5e8-454f-8a33-151395d065d6] [319.36] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m [36f1223d-d5e8-454f-8a33-151395d065d6] [319.36] [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)) [36f1223d-d5e8-454f-8a33-151395d065d6] [319.36] [1m[36m (0.2ms)[0m [1mSELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0))[0m [36f1223d-d5e8-454f-8a33-151395d065d6] [319.36] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [36f1223d-d5e8-454f-8a33-151395d065d6] [319.36] Validate XML response: #<ActionDispatch::Response:0x00000007528df0> took 0ms [36f1223d-d5e8-454f-8a33-151395d065d6] [319.36] Completed 200 OK in 7ms (Views: 0.2ms | ActiveRecord: 1.2ms | Backend: 0.0ms | XML: 0.0ms) [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.36] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-30 17:11:50 +0000 [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.36] Processing by SourceController#package_meta as XML [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.36] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.36] Validate XML request: #<ActionDispatch::Request:0x0000000759b238> [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.36] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.36] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.36] USER found: king [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.36] User king initialised [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.36] 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"} [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.37] [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 [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.37] [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 [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.37] [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 [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.37] [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 [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.37] [1m[36m (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 [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.38] [1m[35m (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 [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.38] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC[0m [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.38] Rendered models/_package.xml.builder (6.6ms) [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.38] Validate XML response: #<ActionDispatch::Response:0x0000000759b210> took 2ms [1b6df473-bfc7-430e-aa39-981fd1cbdd54] [319.38] Completed 200 OK in 18ms (Views: 0.4ms | ActiveRecord: 2.5ms | Backend: 0.0ms | XML: 0.3ms) [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.38] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-30 17:11:50 +0000 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.38] Processing by SourceController#package_meta as XML [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.38] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.38] Validate XML request: #<ActionDispatch::Request:0x000000076219a0> [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.39] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.39] USER found: king [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.39] User king initialised [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.39] [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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.39] 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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.39] [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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] [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]] [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] [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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] [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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC[0m [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] flagcheck: package has default state, checking project [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] disabled_for sourceaccess repo: arch: state:enable [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] [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]] [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] [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]] [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882710)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] update_activity 3.964301502118692e-12 10 2013-08-30 17:11:50 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882710)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.40] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000003965 WHERE `packages`.`id` = 2 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.41] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-30 17:11:50' WHERE `packages`.`id` = 2[0m [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.41] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.41] [1m[36m (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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.41] [1m[35m (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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.41] Rendered models/_package.xml.builder (4.3ms) [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.41] [backend] PUT: /source/kde4/kdebase/_meta?user=king [310.47] 2013-08-30 17:11:50 [15645]: PUT /source/kde4/kdebase/_meta?user=king [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.42] request took 0.010704707 0.010704707 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.42] [1m[36mRelationship Load (0.4ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id > 0)[0m [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.43] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id > 0) [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.43] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882710)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.43] update_activity 10.0 2.4844098974157264e-06 2013-08-30 17:11:50 +0000 2013-08-30 17:11:50 UTC 2013-08-30 17:11:50 UTC [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.43] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882710)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.43] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000002484409897 WHERE `packages`.`id` = 2[0m [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.43] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-30 17:11:50' WHERE `packages`.`id` = 2 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.43] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2[0m [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.43] [1m[35m (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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.43] [1m[36m (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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.44] Rendered models/_package.xml.builder (4.2ms) [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.44] [backend] PUT: /source/kde4/kdebase/_meta?user=king [310.49] 2013-08-30 17:11:50 [15646]: PUT /source/kde4/kdebase/_meta?user=king [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.45] request took 0.011306154 0.022010861 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.45] [1m[35mPackage Load (0.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882710)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.45] update_activity 10.00000286102295 2.296682861116197e-06 2013-08-30 17:11:50 +0000 2013-08-30 17:11:50 UTC 2013-08-30 17:11:50 UTC [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.45] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882710)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.45] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.00000515770581 WHERE `packages`.`id` = 2 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.45] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-30 17:11:50' WHERE `packages`.`id` = 2[0m [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.45] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.46] [1m[36m (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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.46] [1m[35m (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 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.46] Rendered models/_package.xml.builder (4.1ms) [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.46] [backend] PUT: /source/kde4/kdebase/_meta?user=king [310.51] 2013-08-30 17:11:50 [15647]: PUT /source/kde4/kdebase/_meta?user=king [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.47] request took 0.01283153 0.034842391 [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.47] [1m[36m (0.3ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.47] Validate XML response: #<ActionDispatch::Response:0x00000007621978> took 0ms [5bf8ece2-e195-4a8f-9895-89c9207943f0] [319.47] Completed 200 OK in 90ms (Views: 0.8ms | ActiveRecord: 8.7ms | Backend: 34.8ms | XML: 0.0ms) [0effe175-06cd-479c-afb4-32f07917fea2] [319.47] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-30 17:11:50 +0000 [0effe175-06cd-479c-afb4-32f07917fea2] [319.48] Processing by SourceController#package_meta as XML [0effe175-06cd-479c-afb4-32f07917fea2] [319.48] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [0effe175-06cd-479c-afb4-32f07917fea2] [319.48] Validate XML request: #<ActionDispatch::Request:0x00000007791858> [0effe175-06cd-479c-afb4-32f07917fea2] [319.48] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [0effe175-06cd-479c-afb4-32f07917fea2] [319.48] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [0effe175-06cd-479c-afb4-32f07917fea2] [319.48] USER found: king [0effe175-06cd-479c-afb4-32f07917fea2] [319.48] User king initialised [0effe175-06cd-479c-afb4-32f07917fea2] [319.48] 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 [0effe175-06cd-479c-afb4-32f07917fea2] [319.48] [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 [0effe175-06cd-479c-afb4-32f07917fea2] [319.48] [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 [0effe175-06cd-479c-afb4-32f07917fea2] [319.48] [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 [0effe175-06cd-479c-afb4-32f07917fea2] [319.60] [1m[35mPackage Load (4.9ms)[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 [0effe175-06cd-479c-afb4-32f07917fea2] [319.61] [1m[36mProject Load (1.1ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [0effe175-06cd-479c-afb4-32f07917fea2] [319.61] Validate XML response: #<ActionDispatch::Response:0x000000077917e0> took 1ms [0effe175-06cd-479c-afb4-32f07917fea2] [319.61] Completed 200 OK in 134ms (Views: 0.4ms | ActiveRecord: 7.1ms | Backend: 0.0ms | XML: 0.0ms) [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.61] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-30 17:11:50 +0000 [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.61] Processing by SourceController#package_meta as XML [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.61] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.61] Validate XML request: #<ActionDispatch::Request:0x000000040982c0> [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.61] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.62] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.62] USER found: king [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.62] User king initialised [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.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"} [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.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 [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.62] [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 [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.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 [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.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 [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.63] [1m[36mPackage Load (0.3ms)[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 [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.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 [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.63] [1m[36m (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 [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.63] [1m[35m (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 [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.63] [1m[36mFlag Load (0.3ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC[0m [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.63] Rendered models/_package.xml.builder (10.3ms) [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.64] Validate XML response: #<ActionDispatch::Response:0x000000040981d0> took 2ms [6bda9069-bbfd-46ac-b92c-e64b7fd84f2c] [319.64] Completed 200 OK in 23ms (Views: 0.4ms | ActiveRecord: 3.0ms | Backend: 0.0ms | XML: 0.0ms) [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.64] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-30 17:11:50 +0000 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.64] Processing by SourceController#package_meta as XML [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.64] 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"} [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.64] Validate XML request: #<ActionDispatch::Request:0x000000044d8600> [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.64] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.64] USER found: king [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.64] User king initialised [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.65] [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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.65] [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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.65] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.65] 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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.65] [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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.65] [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]] [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.65] [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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] [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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] flagcheck: package has default state, checking project [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] disabled_for sourceaccess repo: arch: state:enable [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] 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"})}) [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] [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]] [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] [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]] [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] [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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] [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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] [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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882711)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] update_activity 3.964301167199593e-12 10 2013-08-30 17:11:51 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.66] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882711)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.67] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000003965 WHERE `packages`.`id` = 1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.67] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-30 17:11:51' WHERE `packages`.`id` = 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.67] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.67] [1m[35m (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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.67] [1m[36m (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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.67] Rendered models/_package.xml.builder (5.1ms) [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.67] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [310.73] 2013-08-30 17:11:51 [15648]: PUT /source/kde4/kdelibs/_meta?user=king [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.69] request took 0.012835089 0.012835089 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.69] [1m[35mRelationship Load (0.4ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id > 0) [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.69] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.69] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.69] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.69] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.69] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.69] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.70] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id > 0)[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.70] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.70] [1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [["id", 3]] [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.70] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.70] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882711)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.70] update_activity 10.0 3.8367730599862556e-06 2013-08-30 17:11:51 +0000 2013-08-30 17:11:51 UTC 2013-08-30 17:11:51 UTC [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.70] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882711)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.70] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.00000383677306 WHERE `packages`.`id` = 1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.70] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-30 17:11:51' WHERE `packages`.`id` = 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.70] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.71] [1m[35m (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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.71] [1m[36m (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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.71] Rendered models/_package.xml.builder (4.6ms) [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.71] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [310.76] 2013-08-30 17:11:51 [15649]: PUT /source/kde4/kdelibs/_meta?user=king [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.72] request took 0.014429089 0.027264178 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.73] [1m[35mPackage Load (0.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882711)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.73] update_activity 10.000003814697266 2.7131703164842394e-06 2013-08-30 17:11:51 +0000 2013-08-30 17:11:51 UTC 2013-08-30 17:11:51 UTC [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.73] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377882711)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.73] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000006527867582 WHERE `packages`.`id` = 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.73] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-30 17:11:51' WHERE `packages`.`id` = 1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.73] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.73] [1m[36m (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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.73] [1m[35m (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 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.73] Rendered models/_package.xml.builder (4.8ms) [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.73] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [310.79] 2013-08-30 17:11:51 [15650]: PUT /source/kde4/kdelibs/_meta?user=king [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.75] request took 0.012002004 0.039266182 [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.75] [1m[36m (4.6ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.75] Validate XML response: #<ActionDispatch::Response:0x000000044d85b0> took 0ms [38a774be-52b0-4a15-8cf8-c27bd121ebce] [319.75] Completed 200 OK in 114ms (Views: 0.9ms | ActiveRecord: 15.7ms | Backend: 39.3ms | XML: 0.0ms) [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.76] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-30 17:11:51 +0000 [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.76] Processing by SourceController#package_meta as XML [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.76] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.76] Validate XML request: #<ActionDispatch::Request:0x000000072bb2c0> [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.76] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.76] [1m[35mUser Load (0.5ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.76] USER found: king [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.76] User king initialised [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.76] 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 [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.76] [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 [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.76] [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 [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.77] [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 [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.77] [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 [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.77] [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 [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.77] Validate XML response: #<ActionDispatch::Response:0x000000072bb298> took 2ms [bc209ff9-f589-4be3-8c80-1e038455f08f] [319.77] Completed 200 OK in 14ms (Views: 0.2ms | ActiveRecord: 1.6ms | Backend: 0.0ms | XML: 0.0ms) [319.78] [1m[35m (5.6ms)[0m ROLLBACK [319.78] kill 8342 + 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