[obs-tests] Build failed in Jenkins: obs_master_testsuite_api #1693
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1693/> ------------------------------------------ [...truncated 197231 lines...] [efef403a-e462-4a33-95be-2df747c94ede] [304.75] Parameters: {"project"=>"kde4"} [efef403a-e462-4a33-95be-2df747c94ede] [304.75] Validate XML request: #<ActionDispatch::Request:0x0000000736a158> [efef403a-e462-4a33-95be-2df747c94ede] [304.75] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [efef403a-e462-4a33-95be-2df747c94ede] [304.75] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [efef403a-e462-4a33-95be-2df747c94ede] [304.75] USER found: king [efef403a-e462-4a33-95be-2df747c94ede] [304.75] User king initialised [efef403a-e462-4a33-95be-2df747c94ede] [304.75] [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 [efef403a-e462-4a33-95be-2df747c94ede] [304.75] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [efef403a-e462-4a33-95be-2df747c94ede] [304.75] [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 [efef403a-e462-4a33-95be-2df747c94ede] [304.75] [1m[35m (0.2ms)[0m SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0)) [efef403a-e462-4a33-95be-2df747c94ede] [304.75] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [efef403a-e462-4a33-95be-2df747c94ede] [304.75] Validate XML response: #<ActionDispatch::Response:0x0000000736a130> took 0ms [efef403a-e462-4a33-95be-2df747c94ede] [304.75] Completed 200 OK in 6ms (Views: 0.2ms | ActiveRecord: 1.1ms | Backend: 0.0ms | XML: 0.0ms) [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.75] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-13 18:34:10 +0000 [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.75] Processing by SourceController#package_meta as XML [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.75] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.75] Validate XML request: #<ActionDispatch::Request:0x000000074be608> [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.75] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.75] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.76] USER found: king [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.76] User king initialised [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.76] 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"} [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.76] [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 [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.76] [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 [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.76] [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 [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.76] [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 [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.76] [1m[35m (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 [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.77] [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 [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.77] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.77] Rendered models/_package.xml.builder (5.7ms) [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.77] Validate XML response: #<ActionDispatch::Response:0x000000074be568> took 1ms [83875bf7-5caf-4d96-ae51-2da3d988afdc] [304.77] Completed 200 OK in 16ms (Views: 0.3ms | ActiveRecord: 2.1ms | Backend: 0.0ms | XML: 0.2ms) [37761485-d9db-4fc9-b52d-af063c9127ac] [304.77] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-13 18:34:10 +0000 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.77] Processing by SourceController#package_meta as XML [37761485-d9db-4fc9-b52d-af063c9127ac] [304.77] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [37761485-d9db-4fc9-b52d-af063c9127ac] [304.77] Validate XML request: #<ActionDispatch::Request:0x0000000746ebd0> [37761485-d9db-4fc9-b52d-af063c9127ac] [304.77] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.77] USER found: king [37761485-d9db-4fc9-b52d-af063c9127ac] [304.77] User king initialised [37761485-d9db-4fc9-b52d-af063c9127ac] [304.91] [1m[35mRole Exists (0.7ms)[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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.91] [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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.91] [1m[35mPackage Load (0.4ms)[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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.91] [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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.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"} 2 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.91] [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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.91] [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]] [37761485-d9db-4fc9-b52d-af063c9127ac] [304.91] [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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] [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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] flagcheck: package has default state, checking project [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] disabled_for sourceaccess repo: arch: state:enable [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] [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]] [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] [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]] [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] [1m[36mPackage Load (2.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] update_activity 4.486182351496665e-12 10 2013-08-13 18:34:10 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000004485 WHERE `packages`.`id` = 2[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.92] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-13 18:34:10' WHERE `packages`.`id` = 2 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.93] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.93] [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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.93] [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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.93] Rendered models/_package.xml.builder (4.5ms) [37761485-d9db-4fc9-b52d-af063c9127ac] [304.93] [backend] PUT: /source/kde4/kdebase/_meta?user=king [294.74] 2013-08-13 18:34:10 [14052]: PUT /source/kde4/kdebase/_meta?user=king [37761485-d9db-4fc9-b52d-af063c9127ac] [304.94] request took 0.009978044 0.009978044 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.94] [1m[35mRelationship Load (0.5ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id > 0) [37761485-d9db-4fc9-b52d-af063c9127ac] [304.94] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id > 0)[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.95] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.95] update_activity 10.0 2.5900149786913835e-06 2013-08-13 18:34:10 +0000 2013-08-13 18:34:10 UTC 2013-08-13 18:34:10 UTC [37761485-d9db-4fc9-b52d-af063c9127ac] [304.95] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.95] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.00000259001498 WHERE `packages`.`id` = 2 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.95] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-13 18:34:10' WHERE `packages`.`id` = 2[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.95] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.95] [1m[36m (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` = 2 ORDER BY role_name, login[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.96] [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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.96] Rendered models/_package.xml.builder (4.6ms) [37761485-d9db-4fc9-b52d-af063c9127ac] [304.96] [backend] PUT: /source/kde4/kdebase/_meta?user=king [294.76] 2013-08-13 18:34:10 [14053]: PUT /source/kde4/kdebase/_meta?user=king [37761485-d9db-4fc9-b52d-af063c9127ac] [304.97] request took 0.010044621 0.020022665000000002 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.97] [1m[36mPackage Load (0.6ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.97] update_activity 10.00000286102295 2.259623121332239e-06 2013-08-13 18:34:10 +0000 2013-08-13 18:34:10 UTC 2013-08-13 18:34:10 UTC [37761485-d9db-4fc9-b52d-af063c9127ac] [304.97] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.97] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.00000512064607 WHERE `packages`.`id` = 2[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.97] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-13 18:34:10' WHERE `packages`.`id` = 2 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.97] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2[0m [37761485-d9db-4fc9-b52d-af063c9127ac] [304.98] [1m[35m (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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.98] [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 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.98] Rendered models/_package.xml.builder (4.9ms) [37761485-d9db-4fc9-b52d-af063c9127ac] [304.98] [backend] PUT: /source/kde4/kdebase/_meta?user=king [294.78] 2013-08-13 18:34:10 [14054]: PUT /source/kde4/kdebase/_meta?user=king [37761485-d9db-4fc9-b52d-af063c9127ac] [304.99] request took 0.012292094 0.032314759 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.99] [1m[35m (0.2ms)[0m RELEASE SAVEPOINT active_record_1 [37761485-d9db-4fc9-b52d-af063c9127ac] [304.99] Validate XML response: #<ActionDispatch::Response:0x0000000746eba8> took 1ms [37761485-d9db-4fc9-b52d-af063c9127ac] [304.99] Completed 200 OK in 223ms (Views: 1.4ms | ActiveRecord: 11.7ms | Backend: 32.3ms | XML: 0.0ms) [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.00] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-13 18:34:10 +0000 [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.00] Processing by SourceController#package_meta as XML [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.00] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.00] Validate XML request: #<ActionDispatch::Request:0x000000046fc760> [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.00] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.00] [1m[36mUser Load (0.6ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.00] USER found: king [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.00] User king initialised [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.00] 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 [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.01] [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 [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.01] [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 [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.01] [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 [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.01] [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 [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.01] [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 [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.01] Validate XML response: #<ActionDispatch::Response:0x000000046fc710> took 2ms [e7ad5333-0714-46ab-ae17-c9963f2214f0] [305.01] Completed 200 OK in 16ms (Views: 0.3ms | ActiveRecord: 1.8ms | Backend: 0.0ms | XML: 0.0ms) [56726593-c093-445a-bd33-88d18da4c550] [305.02] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-13 18:34:10 +0000 [56726593-c093-445a-bd33-88d18da4c550] [305.02] Processing by SourceController#package_meta as XML [56726593-c093-445a-bd33-88d18da4c550] [305.02] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [56726593-c093-445a-bd33-88d18da4c550] [305.02] Validate XML request: #<ActionDispatch::Request:0x000000063d8be0> [56726593-c093-445a-bd33-88d18da4c550] [305.02] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [56726593-c093-445a-bd33-88d18da4c550] [305.02] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [56726593-c093-445a-bd33-88d18da4c550] [305.02] USER found: king [56726593-c093-445a-bd33-88d18da4c550] [305.02] User king initialised [56726593-c093-445a-bd33-88d18da4c550] [305.02] 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"} [56726593-c093-445a-bd33-88d18da4c550] [305.02] [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 [56726593-c093-445a-bd33-88d18da4c550] [305.02] [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 [56726593-c093-445a-bd33-88d18da4c550] [305.02] [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 [56726593-c093-445a-bd33-88d18da4c550] [305.02] [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 [56726593-c093-445a-bd33-88d18da4c550] [305.03] [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 [56726593-c093-445a-bd33-88d18da4c550] [305.03] [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 [56726593-c093-445a-bd33-88d18da4c550] [305.03] [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 [56726593-c093-445a-bd33-88d18da4c550] [305.03] [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 [56726593-c093-445a-bd33-88d18da4c550] [305.03] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [56726593-c093-445a-bd33-88d18da4c550] [305.03] Rendered models/_package.xml.builder (9.5ms) [56726593-c093-445a-bd33-88d18da4c550] [305.04] Validate XML response: #<ActionDispatch::Response:0x000000063d8bb8> took 2ms [56726593-c093-445a-bd33-88d18da4c550] [305.04] Completed 200 OK in 20ms (Views: 0.3ms | ActiveRecord: 2.7ms | Backend: 0.0ms | XML: 0.0ms) [343e445d-a3df-4be0-9eed-9f255329ff48] [305.04] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-13 18:34:10 +0000 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.04] Processing by SourceController#package_meta as XML [343e445d-a3df-4be0-9eed-9f255329ff48] [305.04] 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"} [343e445d-a3df-4be0-9eed-9f255329ff48] [305.04] Validate XML request: #<ActionDispatch::Request:0x00000006b6a110> [343e445d-a3df-4be0-9eed-9f255329ff48] [305.04] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.04] USER found: king [343e445d-a3df-4be0-9eed-9f255329ff48] [305.04] User king initialised [343e445d-a3df-4be0-9eed-9f255329ff48] [305.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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.05] 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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.05] [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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.05] [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]] [343e445d-a3df-4be0-9eed-9f255329ff48] [305.05] [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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.05] [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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] flagcheck: package has default state, checking project [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] disabled_for sourceaccess repo: arch: state:enable [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] 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"})}) [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] [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]] [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] [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]] [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] [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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] [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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] [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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] update_activity 4.486182351496665e-12 10 2013-08-13 18:34:10 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.06] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000004485 WHERE `packages`.`id` = 1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.07] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-13 18:34:10' WHERE `packages`.`id` = 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.07] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.07] [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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.07] [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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.07] Rendered models/_package.xml.builder (4.4ms) [343e445d-a3df-4be0-9eed-9f255329ff48] [305.07] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [294.88] 2013-08-13 18:34:10 [14055]: PUT /source/kde4/kdelibs/_meta?user=king [343e445d-a3df-4be0-9eed-9f255329ff48] [305.08] request took 0.011683045 0.011683045 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.09] [1m[36mRelationship Load (0.7ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id > 0)[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.09] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.09] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.09] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.09] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.09] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.09] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.09] [1m[35mRelationship Load (0.4ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id > 0) [343e445d-a3df-4be0-9eed-9f255329ff48] [305.09] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.10] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]] [343e445d-a3df-4be0-9eed-9f255329ff48] [305.10] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.10] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.10] update_activity 10.0 3.848362852025915e-06 2013-08-13 18:34:10 +0000 2013-08-13 18:34:10 UTC 2013-08-13 18:34:10 UTC [343e445d-a3df-4be0-9eed-9f255329ff48] [305.10] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.10] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000003848362851 WHERE `packages`.`id` = 1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.10] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-13 18:34:10' WHERE `packages`.`id` = 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.10] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.11] [1m[36m (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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.11] [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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.11] Rendered models/_package.xml.builder (4.8ms) [343e445d-a3df-4be0-9eed-9f255329ff48] [305.11] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [294.91] 2013-08-13 18:34:10 [14056]: PUT /source/kde4/kdelibs/_meta?user=king [343e445d-a3df-4be0-9eed-9f255329ff48] [305.12] request took 0.008372906 0.020055951 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.12] [1m[36mPackage Load (0.7ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.12] update_activity 10.000003814697266 2.0510344593613236e-06 2013-08-13 18:34:10 +0000 2013-08-13 18:34:10 UTC 2013-08-13 18:34:10 UTC [343e445d-a3df-4be0-9eed-9f255329ff48] [305.12] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376418850)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.12] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000005865731724 WHERE `packages`.`id` = 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.12] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-13 18:34:10' WHERE `packages`.`id` = 1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.12] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1[0m [343e445d-a3df-4be0-9eed-9f255329ff48] [305.13] [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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.13] [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 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.13] Rendered models/_package.xml.builder (5.2ms) [343e445d-a3df-4be0-9eed-9f255329ff48] [305.13] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [294.93] 2013-08-13 18:34:10 [14057]: PUT /source/kde4/kdelibs/_meta?user=king [343e445d-a3df-4be0-9eed-9f255329ff48] [305.14] request took 0.008368421 0.028424371999999996 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.14] [1m[35m (0.2ms)[0m RELEASE SAVEPOINT active_record_1 [343e445d-a3df-4be0-9eed-9f255329ff48] [305.14] Validate XML response: #<ActionDispatch::Response:0x00000006b6a098> took 1ms [343e445d-a3df-4be0-9eed-9f255329ff48] [305.14] Completed 200 OK in 100ms (Views: 1.1ms | ActiveRecord: 12.0ms | Backend: 28.4ms | XML: 0.0ms) [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.14] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-13 18:34:10 +0000 [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.14] Processing by SourceController#package_meta as XML [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.14] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.14] Validate XML request: #<ActionDispatch::Request:0x0000000730da20> [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.14] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.15] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.15] USER found: king [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.15] User king initialised [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.15] 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 [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.15] [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 [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.15] [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 [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.15] [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 [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.15] [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 [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.16] [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 [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.16] Validate XML response: #<ActionDispatch::Response:0x0000000730d9f8> took 2ms [c88a28a5-15fb-406a-a5a4-25466d35b5a0] [305.16] Completed 200 OK in 14ms (Views: 0.4ms | ActiveRecord: 1.7ms | Backend: 0.0ms | XML: 0.0ms) [305.17] [1m[36m (7.8ms)[0m [1mROLLBACK[0m [305.17] kill 6799 + 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/1694/changes> Changes: [adrian] [api] support auto-accept for requests. ------------------------------------------ [...truncated 197516 lines...] [447be368-51e1-4c3f-8f34-35db5f291165] [311.33] Parameters: {"project"=>"kde4"} [447be368-51e1-4c3f-8f34-35db5f291165] [311.33] Validate XML request: #<ActionDispatch::Request:0x00000006efdf70> [447be368-51e1-4c3f-8f34-35db5f291165] [311.33] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [447be368-51e1-4c3f-8f34-35db5f291165] [311.34] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [447be368-51e1-4c3f-8f34-35db5f291165] [311.34] USER found: king [447be368-51e1-4c3f-8f34-35db5f291165] [311.34] User king initialised [447be368-51e1-4c3f-8f34-35db5f291165] [311.34] [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 [447be368-51e1-4c3f-8f34-35db5f291165] [311.34] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [447be368-51e1-4c3f-8f34-35db5f291165] [311.34] [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 [447be368-51e1-4c3f-8f34-35db5f291165] [311.34] [1m[35m (0.2ms)[0m SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0)) [447be368-51e1-4c3f-8f34-35db5f291165] [311.34] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [447be368-51e1-4c3f-8f34-35db5f291165] [311.34] Validate XML response: #<ActionDispatch::Response:0x00000006efdf48> took 0ms [447be368-51e1-4c3f-8f34-35db5f291165] [311.34] Completed 200 OK in 7ms (Views: 0.2ms | ActiveRecord: 1.1ms | Backend: 0.0ms | XML: 0.0ms) [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.34] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-14 11:37:01 +0000 [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.34] Processing by SourceController#package_meta as XML [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.34] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.34] Validate XML request: #<ActionDispatch::Request:0x00000007527b08> [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.34] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.34] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.35] USER found: king [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.35] User king initialised [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.35] 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"} [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.35] [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 [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.35] [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 [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.35] [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 [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.35] [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 [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.36] [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 [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.36] [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 [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.36] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.36] Rendered models/_package.xml.builder (5.8ms) [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.49] Validate XML response: #<ActionDispatch::Response:0x000000075279f0> took 131ms [77e8e9e6-398e-4325-ae7b-3895b54e42c3] [311.49] Completed 200 OK in 147ms (Views: 0.4ms | ActiveRecord: 2.2ms | Backend: 0.0ms | XML: 0.3ms) [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.49] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-14 11:37:01 +0000 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.49] Processing by SourceController#package_meta as XML [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.49] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.49] Validate XML request: #<ActionDispatch::Request:0x00000003c44fc0> [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.50] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.50] USER found: king [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.50] User king initialised [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.50] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.50] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] 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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] [1m[35mPackage Load (0.3ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] [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]] [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] flagcheck: package has default state, checking project [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] disabled_for sourceaccess repo: arch: state:enable [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.51] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.52] [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]] [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.52] [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]] [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.52] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.52] update_activity 4.462982349907712e-12 10 2013-08-14 11:37:01 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.52] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.52] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000004462 WHERE `packages`.`id` = 2[0m [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.52] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:37:01' WHERE `packages`.`id` = 2 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.52] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2[0m [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.52] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.53] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.53] Rendered models/_package.xml.builder (4.5ms) [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.53] [backend] PUT: /source/kde4/kdebase/_meta?user=king [302.32] 2013-08-14 11:37:01 [19535]: PUT /source/kde4/kdebase/_meta?user=king [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.53] request took 0.007502515 0.007502515 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.54] [1m[35mRelationship Load (0.3ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id > 0) [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.54] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id > 0)[0m [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.54] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.54] update_activity 10.0 2.106499892693979e-06 2013-08-14 11:37:01 +0000 2013-08-14 11:37:01 UTC 2013-08-14 11:37:01 UTC [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.54] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.54] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000002106499892 WHERE `packages`.`id` = 2 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.54] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:37:01' WHERE `packages`.`id` = 2[0m [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.54] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.54] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.55] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.55] Rendered models/_package.xml.builder (4.4ms) [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.55] [backend] PUT: /source/kde4/kdebase/_meta?user=king [302.34] 2013-08-14 11:37:01 [19536]: PUT /source/kde4/kdebase/_meta?user=king [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.55] request took 0.008004295 0.01550681 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.56] [1m[36mPackage Load (0.4ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.56] update_activity 10.000001907348633 1.9311628959797046e-06 2013-08-14 11:37:01 +0000 2013-08-14 11:37:01 UTC 2013-08-14 11:37:01 UTC [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.56] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.56] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000003838511528 WHERE `packages`.`id` = 2[0m [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.56] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:37:01' WHERE `packages`.`id` = 2 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.56] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2[0m [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.56] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.57] [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 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.57] Rendered models/_package.xml.builder (4.4ms) [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.57] [backend] PUT: /source/kde4/kdebase/_meta?user=king [302.36] 2013-08-14 11:37:01 [19537]: PUT /source/kde4/kdebase/_meta?user=king [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.58] request took 0.010128029 0.025634839 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.58] [1m[35m (0.3ms)[0m RELEASE SAVEPOINT active_record_1 [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.58] Validate XML response: #<ActionDispatch::Response:0x00000003c44e30> took 1ms [694fcfba-a3d8-493f-8480-7f3b1fe1230a] [311.58] Completed 200 OK in 84ms (Views: 0.9ms | ActiveRecord: 9.3ms | Backend: 25.6ms | XML: 0.0ms) [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.58] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-14 11:37:01 +0000 [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.58] Processing by SourceController#package_meta as XML [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.58] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.58] Validate XML request: #<ActionDispatch::Request:0x000000065a1e68> [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.58] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.58] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.58] USER found: king [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.58] User king initialised [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.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 [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.59] [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 [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.59] [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 [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.59] [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 [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.59] [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 [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.59] [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 [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.60] Validate XML response: #<ActionDispatch::Response:0x000000065a1e18> took 2ms [da354dcf-3596-43d9-a1d0-44cdc916a188] [311.60] Completed 200 OK in 13ms (Views: 0.2ms | ActiveRecord: 1.6ms | Backend: 0.0ms | XML: 0.0ms) [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-14 11:37:01 +0000 [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] Processing by SourceController#package_meta as XML [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] Validate XML request: #<ActionDispatch::Request:0x000000066059e0> [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] USER found: king [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] User king initialised [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] 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"} [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] [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 [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] [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 [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] [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 [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.60] [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 [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.61] [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 [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.61] [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 [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.61] [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 [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.61] [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 [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.62] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.62] Rendered models/_package.xml.builder (9.4ms) [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.62] Validate XML response: #<ActionDispatch::Response:0x000000066059b8> took 2ms [9a9195e9-ac33-4a7a-9f5c-f764afa68d01] [311.62] Completed 200 OK in 21ms (Views: 0.4ms | ActiveRecord: 2.8ms | Backend: 0.0ms | XML: 0.0ms) [33609179-1123-405f-a203-06734da3bb85] [311.62] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-14 11:37:01 +0000 [33609179-1123-405f-a203-06734da3bb85] [311.62] Processing by SourceController#package_meta as XML [33609179-1123-405f-a203-06734da3bb85] [311.62] 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"} [33609179-1123-405f-a203-06734da3bb85] [311.62] Validate XML request: #<ActionDispatch::Request:0x00000006b9f450> [33609179-1123-405f-a203-06734da3bb85] [311.62] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.62] USER found: king [33609179-1123-405f-a203-06734da3bb85] [311.62] User king initialised [33609179-1123-405f-a203-06734da3bb85] [311.63] [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 [33609179-1123-405f-a203-06734da3bb85] [311.63] [1m[36mProject Load (0.3ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.63] [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 [33609179-1123-405f-a203-06734da3bb85] [311.63] [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 [33609179-1123-405f-a203-06734da3bb85] [311.63] 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 [33609179-1123-405f-a203-06734da3bb85] [311.63] [1m[35mPackage Load (0.3ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1 [33609179-1123-405f-a203-06734da3bb85] [311.63] [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]] [33609179-1123-405f-a203-06734da3bb85] [311.64] [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 [33609179-1123-405f-a203-06734da3bb85] [311.64] [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 [33609179-1123-405f-a203-06734da3bb85] [311.64] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [33609179-1123-405f-a203-06734da3bb85] [311.64] flagcheck: package has default state, checking project [33609179-1123-405f-a203-06734da3bb85] [311.64] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [33609179-1123-405f-a203-06734da3bb85] [311.64] disabled_for sourceaccess repo: arch: state:enable [33609179-1123-405f-a203-06734da3bb85] [311.64] 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"})}) [33609179-1123-405f-a203-06734da3bb85] [311.64] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [33609179-1123-405f-a203-06734da3bb85] [311.64] [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]] [33609179-1123-405f-a203-06734da3bb85] [311.64] [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]] [33609179-1123-405f-a203-06734da3bb85] [311.64] [1m[36mProject Load (0.3ms)[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 [33609179-1123-405f-a203-06734da3bb85] [311.64] [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 [33609179-1123-405f-a203-06734da3bb85] [311.64] [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 [33609179-1123-405f-a203-06734da3bb85] [311.64] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [33609179-1123-405f-a203-06734da3bb85] [311.65] update_activity 4.462982349907712e-12 10 2013-08-14 11:37:01 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [33609179-1123-405f-a203-06734da3bb85] [311.65] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.65] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000004462 WHERE `packages`.`id` = 1 [33609179-1123-405f-a203-06734da3bb85] [311.65] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:37:01' WHERE `packages`.`id` = 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.65] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1 [33609179-1123-405f-a203-06734da3bb85] [311.65] [1m[36m (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 [33609179-1123-405f-a203-06734da3bb85] [311.65] [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 [33609179-1123-405f-a203-06734da3bb85] [311.65] Rendered models/_package.xml.builder (4.8ms) [33609179-1123-405f-a203-06734da3bb85] [311.65] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [302.45] 2013-08-14 11:37:01 [19538]: PUT /source/kde4/kdelibs/_meta?user=king [33609179-1123-405f-a203-06734da3bb85] [311.66] request took 0.007665071 0.007665071 [33609179-1123-405f-a203-06734da3bb85] [311.66] [1m[36mRelationship Load (0.3ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id > 0)[0m [33609179-1123-405f-a203-06734da3bb85] [311.66] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1 [33609179-1123-405f-a203-06734da3bb85] [311.67] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.67] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1 [33609179-1123-405f-a203-06734da3bb85] [311.67] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.67] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [33609179-1123-405f-a203-06734da3bb85] [311.67] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.67] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id > 0) [33609179-1123-405f-a203-06734da3bb85] [311.67] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.67] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]] [33609179-1123-405f-a203-06734da3bb85] [311.67] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.67] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [33609179-1123-405f-a203-06734da3bb85] [311.67] update_activity 10.0 3.1272846239584465e-06 2013-08-14 11:37:01 +0000 2013-08-14 11:37:01 UTC 2013-08-14 11:37:01 UTC [33609179-1123-405f-a203-06734da3bb85] [311.67] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.68] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000003127284623 WHERE `packages`.`id` = 1 [33609179-1123-405f-a203-06734da3bb85] [311.68] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:37:01' WHERE `packages`.`id` = 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.68] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1 [33609179-1123-405f-a203-06734da3bb85] [311.68] [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 [33609179-1123-405f-a203-06734da3bb85] [311.68] [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 [33609179-1123-405f-a203-06734da3bb85] [311.68] Rendered models/_package.xml.builder (4.5ms) [33609179-1123-405f-a203-06734da3bb85] [311.68] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [302.48] 2013-08-14 11:37:01 [19539]: PUT /source/kde4/kdelibs/_meta?user=king [33609179-1123-405f-a203-06734da3bb85] [311.69] request took 0.009296262 0.016961333 [33609179-1123-405f-a203-06734da3bb85] [311.69] [1m[36mPackage Load (0.7ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.69] update_activity 10.00000286102295 2.080533239576552e-06 2013-08-14 11:37:01 +0000 2013-08-14 11:37:01 UTC 2013-08-14 11:37:01 UTC [33609179-1123-405f-a203-06734da3bb85] [311.69] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376480221)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [33609179-1123-405f-a203-06734da3bb85] [311.70] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000004941556188 WHERE `packages`.`id` = 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.70] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:37:01' WHERE `packages`.`id` = 1 [33609179-1123-405f-a203-06734da3bb85] [311.70] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1[0m [33609179-1123-405f-a203-06734da3bb85] [311.70] [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 [33609179-1123-405f-a203-06734da3bb85] [311.70] [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 [33609179-1123-405f-a203-06734da3bb85] [311.70] Rendered models/_package.xml.builder (4.8ms) [33609179-1123-405f-a203-06734da3bb85] [311.70] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [302.50] 2013-08-14 11:37:01 [19540]: PUT /source/kde4/kdelibs/_meta?user=king [33609179-1123-405f-a203-06734da3bb85] [311.71] request took 0.00914086 0.026102193 [33609179-1123-405f-a203-06734da3bb85] [311.71] [1m[35m (0.2ms)[0m RELEASE SAVEPOINT active_record_1 [33609179-1123-405f-a203-06734da3bb85] [311.72] Validate XML response: #<ActionDispatch::Response:0x00000006b9f428> took 1ms [33609179-1123-405f-a203-06734da3bb85] [311.72] Completed 200 OK in 94ms (Views: 1.0ms | ActiveRecord: 11.4ms | Backend: 26.1ms | XML: 0.0ms) [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.72] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-14 11:37:01 +0000 [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.72] Processing by SourceController#package_meta as XML [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.72] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.72] Validate XML request: #<ActionDispatch::Request:0x00000006ed3ec8> [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.72] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.72] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.72] USER found: king [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.72] User king initialised [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.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 [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.72] [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 [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.73] [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 [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.73] [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 [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.73] [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 [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.73] [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 [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.73] Validate XML response: #<ActionDispatch::Response:0x00000006ed3ea0> took 2ms [43cf8d3a-354b-4c97-bcff-1cc5b3abf69c] [311.73] Completed 200 OK in 14ms (Views: 0.3ms | ActiveRecord: 1.8ms | Backend: 0.0ms | XML: 0.0ms) [311.75] [1m[36m (12.7ms)[0m [1mROLLBACK[0m [311.75] kill 12387 + 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/1695/changes> Changes: [adrian] [backend] support "accept_at" element in backend request parser (even when not used anymore) [adrian] [api] fix validation of grouplist answer ------------------------------------------ [...truncated 197524 lines...] [9c391537-218c-484a-8bcc-c462344b7938] [320.84] Parameters: {"project"=>"kde4"} [9c391537-218c-484a-8bcc-c462344b7938] [320.84] Validate XML request: #<ActionDispatch::Request:0x00000006c06560> [9c391537-218c-484a-8bcc-c462344b7938] [320.84] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [9c391537-218c-484a-8bcc-c462344b7938] [320.84] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [9c391537-218c-484a-8bcc-c462344b7938] [320.84] USER found: king [9c391537-218c-484a-8bcc-c462344b7938] [320.84] User king initialised [9c391537-218c-484a-8bcc-c462344b7938] [320.84] [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 [9c391537-218c-484a-8bcc-c462344b7938] [320.85] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [9c391537-218c-484a-8bcc-c462344b7938] [320.85] [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 [9c391537-218c-484a-8bcc-c462344b7938] [320.85] [1m[35m (0.3ms)[0m SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0)) [9c391537-218c-484a-8bcc-c462344b7938] [320.85] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [9c391537-218c-484a-8bcc-c462344b7938] [320.85] Validate XML response: #<ActionDispatch::Response:0x00000006c06538> took 0ms [9c391537-218c-484a-8bcc-c462344b7938] [320.85] Completed 200 OK in 7ms (Views: 0.3ms | ActiveRecord: 1.3ms | Backend: 0.0ms | XML: 0.0ms) [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.85] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-14 11:52:09 +0000 [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.85] Processing by SourceController#package_meta as XML [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.85] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.85] Validate XML request: #<ActionDispatch::Request:0x00000006ca6ab0> [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.85] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.85] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.85] USER found: king [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.85] User king initialised [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.85] 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"} [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.86] [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 [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.86] [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 [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.86] [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 [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.86] [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 [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.86] [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 [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.87] [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 [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.87] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.87] Rendered models/_package.xml.builder (5.9ms) [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.87] Validate XML response: #<ActionDispatch::Response:0x00000006ca6a88> took 2ms [fe0f3dd1-d1dd-48e9-9490-a87cbe4589ca] [320.87] Completed 200 OK in 18ms (Views: 0.4ms | ActiveRecord: 2.4ms | Backend: 0.0ms | XML: 0.3ms) [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.87] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-14 11:52:09 +0000 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.87] Processing by SourceController#package_meta as XML [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.87] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.87] Validate XML request: #<ActionDispatch::Request:0x00000007299d50> [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.88] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.88] USER found: king [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.88] User king initialised [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.88] [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 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.88] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.88] [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 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.88] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.88] 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 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.88] [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 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.88] [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]] [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [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 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [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 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] flagcheck: package has default state, checking project [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] disabled_for sourceaccess repo: arch: state:enable [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [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]] [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [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]] [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481129)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] update_activity 4.46264000202783e-12 10 2013-08-14 11:52:09 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481129)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000004462 WHERE `packages`.`id` = 2[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:52:09' WHERE `packages`.`id` = 2 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.89] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.90] [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` = 2 ORDER BY role_name, login [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.90] [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 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.90] Rendered models/_package.xml.builder (5.0ms) [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.90] [backend] PUT: /source/kde4/kdebase/_meta?user=king [311.93] 2013-08-14 11:52:09 [28062]: PUT /source/kde4/kdebase/_meta?user=king [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.91] request took 0.010277559 0.010277559 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.91] [1m[35mRelationship Load (0.6ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id > 0) [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.91] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id > 0)[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.92] [1m[35mPackage Load (0.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481129)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.92] update_activity 10.0 2.7099693263018573e-06 2013-08-14 11:52:09 +0000 2013-08-14 11:52:09 UTC 2013-08-14 11:52:09 UTC [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.92] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481129)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.92] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000002709969326 WHERE `packages`.`id` = 2 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.92] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:52:09' WHERE `packages`.`id` = 2[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.92] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.93] [1m[36m (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` = 2 ORDER BY role_name, login[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.93] [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 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.93] Rendered models/_package.xml.builder (5.1ms) [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.93] [backend] PUT: /source/kde4/kdebase/_meta?user=king [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.94] request took 0.008212885 0.018490444 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.94] [1m[36mPackage Load (0.6ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481129)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.94] update_activity 10.00000286102295 2.1315283245510526e-06 2013-08-14 11:52:09 +0000 2013-08-14 11:52:09 UTC 2013-08-14 11:52:09 UTC [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.94] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481129)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.94] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000004992551274 WHERE `packages`.`id` = 2[0m [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.94] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:52:09' WHERE `packages`.`id` = 2 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.94] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2[0m [311.97] 2013-08-14 11:52:09 [28063]: PUT /source/kde4/kdebase/_meta?user=king [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.95] [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` = 2 ORDER BY role_name, login [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.95] [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 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.95] Rendered models/_package.xml.builder (4.9ms) [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.95] [backend] PUT: /source/kde4/kdebase/_meta?user=king [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.96] request took 0.007526602 0.026017046000000002 [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.96] [1m[35m (0.2ms)[0m RELEASE SAVEPOINT active_record_1 [311.98] 2013-08-14 11:52:09 [28064]: PUT /source/kde4/kdebase/_meta?user=king [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.96] Validate XML response: #<ActionDispatch::Response:0x00000007299d28> took 0ms [df6db70b-bf4f-43ec-86d8-59b162dbf43b] [320.96] Completed 200 OK in 87ms (Views: 1.0ms | ActiveRecord: 9.9ms | Backend: 26.0ms | XML: 0.0ms) [63c6082d-818a-4230-8bff-b55fc2fed631] [320.96] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-14 11:52:10 +0000 [63c6082d-818a-4230-8bff-b55fc2fed631] [320.96] Processing by SourceController#package_meta as XML [63c6082d-818a-4230-8bff-b55fc2fed631] [320.96] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [63c6082d-818a-4230-8bff-b55fc2fed631] [320.96] Validate XML request: #<ActionDispatch::Request:0x0000000743bdc0> [63c6082d-818a-4230-8bff-b55fc2fed631] [320.96] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [63c6082d-818a-4230-8bff-b55fc2fed631] [320.97] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [63c6082d-818a-4230-8bff-b55fc2fed631] [320.97] USER found: king [63c6082d-818a-4230-8bff-b55fc2fed631] [320.97] User king initialised [63c6082d-818a-4230-8bff-b55fc2fed631] [320.97] 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 [63c6082d-818a-4230-8bff-b55fc2fed631] [320.97] [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 [63c6082d-818a-4230-8bff-b55fc2fed631] [320.97] [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 [63c6082d-818a-4230-8bff-b55fc2fed631] [320.97] [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 [63c6082d-818a-4230-8bff-b55fc2fed631] [320.97] [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 [63c6082d-818a-4230-8bff-b55fc2fed631] [320.97] [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 [63c6082d-818a-4230-8bff-b55fc2fed631] [320.98] Validate XML response: #<ActionDispatch::Response:0x0000000743bd98> took 2ms [63c6082d-818a-4230-8bff-b55fc2fed631] [320.98] Completed 200 OK in 14ms (Views: 0.4ms | ActiveRecord: 1.7ms | Backend: 0.0ms | XML: 0.0ms) [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.98] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-14 11:52:10 +0000 [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.98] Processing by SourceController#package_meta as XML [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.98] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.98] Validate XML request: #<ActionDispatch::Request:0x000000075ba688> [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.98] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.98] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.98] USER found: king [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.98] User king initialised [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.98] 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"} [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.98] [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 [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.98] [1m[36mProject Load (0.3ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.99] [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 [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.99] [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 [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.99] [1m[35mPackage Load (0.3ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1 [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.99] [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 [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [320.99] [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 [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [321.00] [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 [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [321.00] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [321.00] Rendered models/_package.xml.builder (9.7ms) [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [321.13] Validate XML response: #<ActionDispatch::Response:0x000000075ba660> took 134ms [ec2173a3-25ef-401d-8a9b-ebb9e85da24d] [321.13] Completed 200 OK in 154ms (Views: 0.4ms | ActiveRecord: 2.8ms | Backend: 0.0ms | XML: 0.0ms) [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.14] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-14 11:52:10 +0000 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.14] Processing by SourceController#package_meta as XML [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.14] 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"} [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.14] Validate XML request: #<ActionDispatch::Request:0x00000003ee5950> [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.14] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.14] USER found: king [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.14] User king initialised [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.14] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.14] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.15] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.15] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.15] 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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.15] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.15] [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]] [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.15] [1m[35mFlag Load (0.4ms)[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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.15] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.15] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.15] flagcheck: package has default state, checking project [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.15] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.15] disabled_for sourceaccess repo: arch: state:enable [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] 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"})}) [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] [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]] [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] [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]] [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481130)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] update_activity 4.4626396250072195e-12 10 2013-08-14 11:52:10 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481130)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000004462 WHERE `packages`.`id` = 1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.16] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:52:10' WHERE `packages`.`id` = 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.17] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.17] [1m[36m (0.8ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, login[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.17] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.17] Rendered models/_package.xml.builder (5.3ms) [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.17] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [312.20] 2013-08-14 11:52:10 [28065]: PUT /source/kde4/kdelibs/_meta?user=king [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.18] request took 0.008911672 0.008911672 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.18] [1m[36mRelationship Load (0.6ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id > 0)[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.18] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.19] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.19] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.19] [1m[36mRole Load (0.3ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.19] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.19] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.19] [1m[35mRelationship Load (0.3ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id > 0) [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.19] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.19] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]] [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.19] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.20] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481130)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.20] update_activity 10.0 3.789889591711539e-06 2013-08-14 11:52:10 +0000 2013-08-14 11:52:10 UTC 2013-08-14 11:52:10 UTC [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.20] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481130)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.20] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000003789889591 WHERE `packages`.`id` = 1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.20] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:52:10' WHERE `packages`.`id` = 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.20] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.20] [1m[36m (0.8ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, login[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.21] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.21] Rendered models/_package.xml.builder (4.9ms) [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.21] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [312.23] 2013-08-14 11:52:10 [28066]: PUT /source/kde4/kdelibs/_meta?user=king [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.22] request took 0.011896999 0.020808671 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.22] [1m[36mPackage Load (0.6ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481130)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.22] update_activity 10.000003814697266 2.5308794445461696e-06 2013-08-14 11:52:10 +0000 2013-08-14 11:52:10 UTC 2013-08-14 11:52:10 UTC [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.22] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1376481130)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.22] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.00000634557671 WHERE `packages`.`id` = 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.22] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-14 11:52:10' WHERE `packages`.`id` = 1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.23] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1[0m [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.23] [1m[35m (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` = 1 ORDER BY role_name, login [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.23] [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 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.23] Rendered models/_package.xml.builder (5.8ms) [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.23] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [312.26] 2013-08-14 11:52:10 [28067]: PUT /source/kde4/kdelibs/_meta?user=king [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.25] request took 0.01893623 0.039744901 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.25] [1m[35m (0.3ms)[0m RELEASE SAVEPOINT active_record_1 [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.26] Validate XML response: #<ActionDispatch::Response:0x00000003ee5798> took 1ms [c8192ff7-97bd-41c6-b8da-16a3f12eea44] [321.26] Completed 200 OK in 118ms (Views: 1.3ms | ActiveRecord: 13.2ms | Backend: 39.7ms | XML: 0.0ms) [2b336166-7688-46e5-afc4-ab7af0079519] [321.26] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-14 11:52:10 +0000 [2b336166-7688-46e5-afc4-ab7af0079519] [321.26] Processing by SourceController#package_meta as XML [2b336166-7688-46e5-afc4-ab7af0079519] [321.26] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [2b336166-7688-46e5-afc4-ab7af0079519] [321.26] Validate XML request: #<ActionDispatch::Request:0x00000006a1f670> [2b336166-7688-46e5-afc4-ab7af0079519] [321.26] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [2b336166-7688-46e5-afc4-ab7af0079519] [321.26] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [2b336166-7688-46e5-afc4-ab7af0079519] [321.26] USER found: king [2b336166-7688-46e5-afc4-ab7af0079519] [321.26] User king initialised [2b336166-7688-46e5-afc4-ab7af0079519] [321.26] 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 [2b336166-7688-46e5-afc4-ab7af0079519] [321.26] [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 [2b336166-7688-46e5-afc4-ab7af0079519] [321.27] [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 [2b336166-7688-46e5-afc4-ab7af0079519] [321.27] [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 [2b336166-7688-46e5-afc4-ab7af0079519] [321.27] [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 [2b336166-7688-46e5-afc4-ab7af0079519] [321.27] [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 [2b336166-7688-46e5-afc4-ab7af0079519] [321.27] Validate XML response: #<ActionDispatch::Response:0x00000006a1f5f8> took 2ms [2b336166-7688-46e5-afc4-ab7af0079519] [321.27] Completed 200 OK in 15ms (Views: 0.4ms | ActiveRecord: 1.7ms | Backend: 0.0ms | XML: 0.0ms) [321.29] [1m[36m (16.3ms)[0m [1mROLLBACK[0m [321.29] kill 20624 + 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/1696/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