[obs-tests] Build failed in Jenkins: obs_master_testsuite_api #1791
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1791/changes> Changes: [adrian] [api] fix fixtures, define issues from real source and rescan all sources after fixtures setup. [mls] [backend] improve/cleanup linked package handling a bit ------------------------------------------ [...truncated 175972 lines...] [d5e10e44-b438-43c7-bd76-01ceff43a40e] [11339.27] Validate XML request: #<ActionDispatch::Request:0x00000006abd078> [d5e10e44-b438-43c7-bd76-01ceff43a40e] [11339.27] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"project_meta", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [d5e10e44-b438-43c7-bd76-01ceff43a40e] [11339.27] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [d5e10e44-b438-43c7-bd76-01ceff43a40e] [11339.27] USER found: king [d5e10e44-b438-43c7-bd76-01ceff43a40e] [11339.27] User king initialised [d5e10e44-b438-43c7-bd76-01ceff43a40e] [11339.27] [1m[36mRelationship Load (0.4ms)[0m [1mSELECT ur.project_id, ur.user_id from flags f, relationships ur where f.flag = 'access' and f.status = 'disable' and ur.project_id = f.db_project_id[0m [d5e10e44-b438-43c7-bd76-01ceff43a40e] [11339.28] [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 [d5e10e44-b438-43c7-bd76-01ceff43a40e] [11339.28] [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 [d5e10e44-b438-43c7-bd76-01ceff43a40e] [11339.28] Validate XML response: #<ActionDispatch::Response:0x00000006abd050> took 2ms [d5e10e44-b438-43c7-bd76-01ceff43a40e] [11339.28] Completed 200 OK in 11ms (Views: 0.2ms | ActiveRecord: 1.3ms | Backend: 0.0ms | XML: 0.0ms) [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.28] Started GET "/source/kde4" for 127.0.0.1 at 2013-09-17 20:56:58 +0000 [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.28] Processing by SourceController#show_project as XML [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.28] Parameters: {"project"=>"kde4"} [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.28] Validate XML request: #<ActionDispatch::Request:0x00000006bba480> [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.28] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.28] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.28] USER found: king [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.28] User king initialised [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.28] [1m[36mRole Exists (0.2ms)[0m [1mSELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1[0m [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.28] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.29] [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 [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.29] [1m[35m (0.2ms)[0m SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0)) [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.29] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.29] Validate XML response: #<ActionDispatch::Response:0x00000006bba390> took 0ms [5bd78a3c-6bfa-498f-81b1-9215eac08a69] [11339.29] Completed 200 OK in 6ms (Views: 0.2ms | ActiveRecord: 1.0ms | Backend: 0.0ms | XML: 0.0ms) [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.29] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-17 20:56:58 +0000 [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.29] Processing by SourceController#package_meta as XML [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.29] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.29] Validate XML request: #<ActionDispatch::Request:0x0000000727a590> [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.29] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.29] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.29] USER found: king [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.29] User king initialised [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.29] [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 [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.29] [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 [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.29] [1m[35mPackage Load (0.3ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1 [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.30] [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 [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.30] [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 [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.30] [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 [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.30] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.30] Rendered models/_package.xml.builder (5.5ms) [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.30] Validate XML response: #<ActionDispatch::Response:0x0000000727a540> took 1ms [74ee7bbc-b6f6-49ec-aa48-d2cd9bee134f] [11339.30] Completed 200 OK in 16ms (Views: 0.3ms | ActiveRecord: 2.1ms | Backend: 0.0ms | XML: 0.2ms) [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.31] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-17 20:56:58 +0000 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.31] Processing by SourceController#package_meta as XML [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.31] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.31] Validate XML request: #<ActionDispatch::Request:0x00000007422320> [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.31] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.31] USER found: king [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.31] User king initialised [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.31] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.31] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.31] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] [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]] [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] flagcheck: package has default state, checking project [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] disabled_for sourceaccess repo: arch: state:enable [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] [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]] [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] [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]] [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.32] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.33] update_activity 3.4722378816423097e-12 10 2013-09-17 20:56:58 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.33] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.33] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000003473 WHERE `packages`.`id` = 2[0m [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.33] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-17 20:56:58' WHERE `packages`.`id` = 2 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.33] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2[0m [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.33] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.33] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.33] Rendered models/_package.xml.builder (4.1ms) [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.33] [backend] PUT: /source/kde4/kdebase/_meta?user=king [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.35] request took 0.013009203 0.013009203 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.35] [1m[35mRelationship Load (0.6ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id is not null) [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.35] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id is not null)[0m [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.35] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.35] update_activity 10.0 2.8149949179755315e-06 2013-09-17 20:56:58 +0000 2013-09-17 20:56:58 UTC 2013-09-17 20:56:58 UTC [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.35] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.35] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000002814994918 WHERE `packages`.`id` = 2 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.35] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-17 20:56:58' WHERE `packages`.`id` = 2[0m [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.35] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.36] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.36] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.36] Rendered models/_package.xml.builder (5.0ms) [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.36] [backend] PUT: /source/kde4/kdebase/_meta?user=king [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.37] request took 0.008875198 0.021884401 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.37] [1m[36mPackage Load (0.4ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.37] update_activity 10.00000286102295 2.1656078320962413e-06 2013-09-17 20:56:58 +0000 2013-09-17 20:56:58 UTC 2013-09-17 20:56:58 UTC [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.37] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.37] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000005026630781 WHERE `packages`.`id` = 2[0m [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.37] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-17 20:56:58' WHERE `packages`.`id` = 2 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.38] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2[0m [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.38] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.38] [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 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.38] Rendered models/_package.xml.builder (4.3ms) [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.38] [backend] PUT: /source/kde4/kdebase/_meta?user=king [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.39] request took 0.008732628 0.030617029 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.39] [1m[35m (0.2ms)[0m RELEASE SAVEPOINT active_record_1 [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.39] Validate XML response: #<ActionDispatch::Response:0x00000007422140> took 0ms [65e3485e-ecd9-4bc7-9387-120d98ec9cd7] [11339.39] Completed 200 OK in 85ms (Views: 0.8ms | ActiveRecord: 8.2ms | Backend: 30.6ms | XML: 0.0ms) [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.39] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-17 20:56:58 +0000 [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.40] Processing by SourceController#package_meta as XML [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.40] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.40] Validate XML request: #<ActionDispatch::Request:0x00000007b044e0> [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.40] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.40] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.40] USER found: king [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.40] User king initialised [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.40] [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 [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.40] [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 [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.40] [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 [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.40] [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 [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.41] [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 [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.41] Validate XML response: #<ActionDispatch::Response:0x00000007b044b8> took 1ms [0a0ff6ef-57a9-4b8e-a77f-4a1c97817a09] [11339.41] Completed 200 OK in 12ms (Views: 0.2ms | ActiveRecord: 1.5ms | Backend: 0.0ms | XML: 0.0ms) [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.41] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-17 20:56:58 +0000 [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.41] Processing by SourceController#package_meta as XML [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.41] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.41] Validate XML request: #<ActionDispatch::Request:0x00000007aec728> [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.41] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.41] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.41] USER found: king [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.41] User king initialised [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.41] [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 [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.41] [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 [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.42] [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 [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.42] [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 [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.42] [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 [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.42] [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 [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.42] [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` = 1 ORDER BY role_name, login [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.43] [1m[36m (0.3ms)[0m [1mSELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, title[0m [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.43] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.43] Rendered models/_package.xml.builder (9.1ms) [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.54] Validate XML response: #<ActionDispatch::Response:0x00000007aec6d8> took 108ms [303145b4-7e3b-4ddb-84a2-ad8820e97cc6] [11339.54] Completed 200 OK in 127ms (Views: 0.4ms | ActiveRecord: 2.7ms | Backend: 0.0ms | XML: 0.0ms) [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.54] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-17 20:56:58 +0000 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.54] Processing by SourceController#package_meta as XML [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.54] 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"} [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.54] Validate XML request: #<ActionDispatch::Request:0x00000003fc9100> [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.54] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.54] USER found: king [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.54] User king initialised [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.55] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.55] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.55] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.55] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.55] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.55] [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]] [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.55] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] flagcheck: package has default state, checking project [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] disabled_for sourceaccess repo: arch: state:enable [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] 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"})}) [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] [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]] [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] [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]] [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] update_activity 3.4722378816423097e-12 10 2013-09-17 20:56:58 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.56] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.57] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000003473 WHERE `packages`.`id` = 1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.57] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-17 20:56:58' WHERE `packages`.`id` = 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.57] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.57] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.57] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.57] Rendered models/_package.xml.builder (4.8ms) [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.57] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.60] request took 0.030535628 0.030535628 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.61] [1m[36mRelationship Load (0.6ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id is not null)[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.61] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.61] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.61] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.61] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.61] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.61] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.61] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id is not null) [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.61] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.62] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]] [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.62] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.62] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.62] update_activity 10.0 6.117368185961688e-06 2013-09-17 20:56:58 +0000 2013-09-17 20:56:58 UTC 2013-09-17 20:56:58 UTC [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.62] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.62] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000006117368185 WHERE `packages`.`id` = 1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.62] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-17 20:56:58' WHERE `packages`.`id` = 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.62] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.63] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.63] [1m[35m (0.3ms)[0m SELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, title [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.63] Rendered models/_package.xml.builder (4.6ms) [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.63] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.64] request took 0.010397438 0.040933066 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.64] [1m[36mPackage Load (0.4ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.64] update_activity 10.000005722045898 2.2497442033555774e-06 2013-09-17 20:56:58 +0000 2013-09-17 20:56:58 UTC 2013-09-17 20:56:58 UTC [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.64] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379451418)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.64] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000007971790101 WHERE `packages`.`id` = 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.64] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-17 20:56:58' WHERE `packages`.`id` = 1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.64] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1[0m [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.65] [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` = 1 ORDER BY role_name, login [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.65] [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 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.65] Rendered models/_package.xml.builder (4.2ms) [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.65] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.66] request took 0.009431098 0.050364163999999996 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.66] [1m[35m (0.3ms)[0m RELEASE SAVEPOINT active_record_1 [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.66] Validate XML response: #<ActionDispatch::Response:0x00000003fc8cf0> took 0ms [1c9a39d2-0a85-40aa-becb-70bd3e948d25] [11339.66] Completed 200 OK in 120ms (Views: 0.8ms | ActiveRecord: 11.5ms | Backend: 50.4ms | XML: 0.0ms) [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.66] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-17 20:56:58 +0000 [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.66] Processing by SourceController#package_meta as XML [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.66] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.66] Validate XML request: #<ActionDispatch::Request:0x00000006a42468> [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.66] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.66] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.67] USER found: king [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.67] User king initialised [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.67] [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 [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.67] [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 [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.67] [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 [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.67] [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 [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.67] [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 [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.68] Validate XML response: #<ActionDispatch::Response:0x00000006a42418> took 2ms [68732913-3419-499e-a18a-3b2df6fadf0f] [11339.68] Completed 200 OK in 13ms (Views: 0.2ms | ActiveRecord: 1.4ms | Backend: 0.0ms | XML: 0.0ms) [11339.68] [1m[36m (5.6ms)[0m [1mROLLBACK[0m + 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.. egrep ci ..c.. fuser ci ..c.. sh ci ..c.. sh + 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/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/1792/changes> Changes: [mls] [backend] refactor putprojectconfig a bit ------------------------------------------ [...truncated 176052 lines...] [c83d3e89-70c6-49c3-ba2a-f9a3e4c73c87] [11339.41] Validate XML request: #<ActionDispatch::Request:0x000000075bcfa0> [c83d3e89-70c6-49c3-ba2a-f9a3e4c73c87] [11339.41] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"project_meta", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [c83d3e89-70c6-49c3-ba2a-f9a3e4c73c87] [11339.41] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [c83d3e89-70c6-49c3-ba2a-f9a3e4c73c87] [11339.41] USER found: king [c83d3e89-70c6-49c3-ba2a-f9a3e4c73c87] [11339.41] User king initialised [c83d3e89-70c6-49c3-ba2a-f9a3e4c73c87] [11339.41] [1m[36mRelationship Load (0.3ms)[0m [1mSELECT ur.project_id, ur.user_id from flags f, relationships ur where f.flag = 'access' and f.status = 'disable' and ur.project_id = f.db_project_id[0m [c83d3e89-70c6-49c3-ba2a-f9a3e4c73c87] [11339.41] [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 [c83d3e89-70c6-49c3-ba2a-f9a3e4c73c87] [11339.42] [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 [c83d3e89-70c6-49c3-ba2a-f9a3e4c73c87] [11339.42] Validate XML response: #<ActionDispatch::Response:0x000000075bcf78> took 1ms [c83d3e89-70c6-49c3-ba2a-f9a3e4c73c87] [11339.42] Completed 200 OK in 8ms (Views: 0.2ms | ActiveRecord: 1.0ms | Backend: 0.0ms | XML: 0.0ms) [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.42] Started GET "/source/kde4" for 127.0.0.1 at 2013-09-18 00:08:14 +0000 [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.42] Processing by SourceController#show_project as XML [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.42] Parameters: {"project"=>"kde4"} [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.42] Validate XML request: #<ActionDispatch::Request:0x0000000763fdb0> [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.42] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.42] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.42] USER found: king [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.42] User king initialised [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.42] [1m[36mRole Exists (0.2ms)[0m [1mSELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1[0m [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.42] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.42] [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 [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.43] [1m[35m (0.2ms)[0m SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0)) [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.43] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.43] Validate XML response: #<ActionDispatch::Response:0x0000000763fd88> took 0ms [59c3012f-683c-43e9-83d2-df0d54c5c122] [11339.43] Completed 200 OK in 6ms (Views: 0.2ms | ActiveRecord: 1.0ms | Backend: 0.0ms | XML: 0.0ms) [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-18 00:08:14 +0000 [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] Processing by SourceController#package_meta as XML [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] Validate XML request: #<ActionDispatch::Request:0x000000079fc2a0> [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] USER found: king [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] User king initialised [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] [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 [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] [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 [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] [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 [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.43] [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 [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.44] [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 [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.44] [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 [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.44] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.44] Rendered models/_package.xml.builder (5.6ms) [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.44] Validate XML response: #<ActionDispatch::Response:0x000000079fc278> took 1ms [3e65ea51-fecf-4243-bf45-81e3038caa03] [11339.44] Completed 200 OK in 16ms (Views: 0.3ms | ActiveRecord: 2.1ms | Backend: 0.0ms | XML: 0.2ms) [9c86369e-f344-4f73-9809-1834918c275d] [11339.44] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-18 00:08:14 +0000 [9c86369e-f344-4f73-9809-1834918c275d] [11339.45] Processing by SourceController#package_meta as XML [9c86369e-f344-4f73-9809-1834918c275d] [11339.45] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [9c86369e-f344-4f73-9809-1834918c275d] [11339.45] Validate XML request: #<ActionDispatch::Request:0x000000074f2cf0> [9c86369e-f344-4f73-9809-1834918c275d] [11339.56] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.56] USER found: king [9c86369e-f344-4f73-9809-1834918c275d] [11339.56] User king initialised [9c86369e-f344-4f73-9809-1834918c275d] [11339.57] [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 [9c86369e-f344-4f73-9809-1834918c275d] [11339.57] [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 [9c86369e-f344-4f73-9809-1834918c275d] [11339.57] [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 [9c86369e-f344-4f73-9809-1834918c275d] [11339.57] [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 [9c86369e-f344-4f73-9809-1834918c275d] [11339.57] [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 [9c86369e-f344-4f73-9809-1834918c275d] [11339.57] [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]] [9c86369e-f344-4f73-9809-1834918c275d] [11339.57] [1m[35mFlag Load (0.3ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY `flags`.position ASC LIMIT 1 [9c86369e-f344-4f73-9809-1834918c275d] [11339.57] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] flagcheck: package has default state, checking project [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] disabled_for sourceaccess repo: arch: state:enable [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] [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]] [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] [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]] [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] update_activity 3.468873054351029e-12 10 2013-09-18 00:08:14 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.00000000000347 WHERE `packages`.`id` = 2[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 00:08:14' WHERE `packages`.`id` = 2 [9c86369e-f344-4f73-9809-1834918c275d] [11339.58] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.59] [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 [9c86369e-f344-4f73-9809-1834918c275d] [11339.59] [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 [9c86369e-f344-4f73-9809-1834918c275d] [11339.59] Rendered models/_package.xml.builder (4.6ms) [9c86369e-f344-4f73-9809-1834918c275d] [11339.59] [backend] PUT: /source/kde4/kdebase/_meta?user=king [9c86369e-f344-4f73-9809-1834918c275d] [11339.60] request took 0.010978987 0.010978987 [9c86369e-f344-4f73-9809-1834918c275d] [11339.60] [1m[35mRelationship Load (0.3ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id is not null) [9c86369e-f344-4f73-9809-1834918c275d] [11339.60] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id is not null)[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.60] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [9c86369e-f344-4f73-9809-1834918c275d] [11339.60] update_activity 10.0 2.5054094968018707e-06 2013-09-18 00:08:14 +0000 2013-09-18 00:08:14 UTC 2013-09-18 00:08:14 UTC [9c86369e-f344-4f73-9809-1834918c275d] [11339.60] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.60] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000002505409498 WHERE `packages`.`id` = 2 [9c86369e-f344-4f73-9809-1834918c275d] [11339.61] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 00:08:14' WHERE `packages`.`id` = 2[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.61] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2 [9c86369e-f344-4f73-9809-1834918c275d] [11339.61] [1m[36m (0.5ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, login[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.61] [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 [9c86369e-f344-4f73-9809-1834918c275d] [11339.61] Rendered models/_package.xml.builder (4.0ms) [9c86369e-f344-4f73-9809-1834918c275d] [11339.61] [backend] PUT: /source/kde4/kdebase/_meta?user=king [9c86369e-f344-4f73-9809-1834918c275d] [11339.62] request took 0.007079211 0.018058198 [9c86369e-f344-4f73-9809-1834918c275d] [11339.62] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.62] update_activity 10.00000286102295 1.7305215199788412e-06 2013-09-18 00:08:14 +0000 2013-09-18 00:08:14 UTC 2013-09-18 00:08:14 UTC [9c86369e-f344-4f73-9809-1834918c275d] [11339.62] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [9c86369e-f344-4f73-9809-1834918c275d] [11339.62] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000004591544469 WHERE `packages`.`id` = 2[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.62] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 00:08:14' WHERE `packages`.`id` = 2 [9c86369e-f344-4f73-9809-1834918c275d] [11339.62] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2[0m [9c86369e-f344-4f73-9809-1834918c275d] [11339.63] [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 [9c86369e-f344-4f73-9809-1834918c275d] [11339.63] [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 [9c86369e-f344-4f73-9809-1834918c275d] [11339.63] Rendered models/_package.xml.builder (3.9ms) [9c86369e-f344-4f73-9809-1834918c275d] [11339.63] [backend] PUT: /source/kde4/kdebase/_meta?user=king [9c86369e-f344-4f73-9809-1834918c275d] [11339.64] request took 0.007098538 0.025156736 [9c86369e-f344-4f73-9809-1834918c275d] [11339.64] [1m[35m (0.1ms)[0m RELEASE SAVEPOINT active_record_1 [9c86369e-f344-4f73-9809-1834918c275d] [11339.64] Validate XML response: #<ActionDispatch::Response:0x000000074f2cc8> took 0ms [9c86369e-f344-4f73-9809-1834918c275d] [11339.64] Completed 200 OK in 191ms (Views: 0.7ms | ActiveRecord: 8.2ms | Backend: 25.2ms | XML: 0.0ms) [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.64] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-18 00:08:14 +0000 [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.64] Processing by SourceController#package_meta as XML [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.64] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.64] Validate XML request: #<ActionDispatch::Request:0x00000004732748> [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.64] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.64] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.64] USER found: king [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.64] User king initialised [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.64] [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 [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.65] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1[0m [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.65] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.65] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1[0m [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.65] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.65] Validate XML response: #<ActionDispatch::Response:0x000000047326f8> took 2ms [e5e8101b-3724-4e8a-8ed7-e8d4b0aadf58] [11339.65] Completed 200 OK in 13ms (Views: 0.2ms | ActiveRecord: 1.4ms | Backend: 0.0ms | XML: 0.0ms) [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.65] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-18 00:08:14 +0000 [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.65] Processing by SourceController#package_meta as XML [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.65] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.66] Validate XML request: #<ActionDispatch::Request:0x00000006ad4c00> [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.66] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.66] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.66] USER found: king [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.66] User king initialised [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.66] [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 [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.66] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.66] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.66] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.67] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1 [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.67] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.67] [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 [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.67] [1m[36m (0.3ms)[0m [1mSELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, title[0m [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.67] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.67] Rendered models/_package.xml.builder (9.1ms) [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.67] Validate XML response: #<ActionDispatch::Response:0x00000006ad4ac0> took 2ms [cd5dca51-e3c2-4c01-8017-d46eb1ed51d1] [11339.67] Completed 200 OK in 20ms (Views: 0.3ms | ActiveRecord: 2.6ms | Backend: 0.0ms | XML: 0.0ms) [a7c67449-464c-465a-876c-144e67b60619] [11339.68] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-18 00:08:14 +0000 [a7c67449-464c-465a-876c-144e67b60619] [11339.68] Processing by SourceController#package_meta as XML [a7c67449-464c-465a-876c-144e67b60619] [11339.68] Parameters: {"<package name"=>"\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n <devel project=\"home:coolo:test\" package=\"kdelibs_DEVEL_package\"/>\n <person userid=\"fredlibs\" role=\"maintainer\"/>\n <person userid=\"adrian\" role=\"reviewer\"/>\n <group groupid=\"test_group\" role=\"maintainer\"/>\n</package>\n", "project"=>"kde4", "package"=>"kdelibs"} [a7c67449-464c-465a-876c-144e67b60619] [11339.68] Validate XML request: #<ActionDispatch::Request:0x00000007263390> [a7c67449-464c-465a-876c-144e67b60619] [11339.68] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.68] USER found: king [a7c67449-464c-465a-876c-144e67b60619] [11339.68] User king initialised [a7c67449-464c-465a-876c-144e67b60619] [11339.68] [1m[35mRole Exists (0.2ms)[0m SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.68] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.68] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.69] [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 [a7c67449-464c-465a-876c-144e67b60619] [11339.69] [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 [a7c67449-464c-465a-876c-144e67b60619] [11339.69] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [["id", 2]] [a7c67449-464c-465a-876c-144e67b60619] [11339.69] [1m[35mFlag Load (0.3ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY `flags`.position ASC LIMIT 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.69] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.69] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [a7c67449-464c-465a-876c-144e67b60619] [11339.69] flagcheck: package has default state, checking project [a7c67449-464c-465a-876c-144e67b60619] [11339.69] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.69] disabled_for sourceaccess repo: arch: state:enable [a7c67449-464c-465a-876c-144e67b60619] [11339.69] xml_disabled? X({"name"=>"kdelibs", "project"=>"kde4", "title"=>"blub", "description"=>"blub", "devel"=>X({"project"=>"home:coolo:test", "package"=>"kdelibs_DEVEL_package"}), "person"=>[X({"userid"=>"fredlibs", "role"=>"maintainer"}), X({"userid"=>"adrian", "role"=>"reviewer"})], "group"=>X({"groupid"=>"test_group", "role"=>"maintainer"})}) [a7c67449-464c-465a-876c-144e67b60619] [11339.69] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [a7c67449-464c-465a-876c-144e67b60619] [11339.69] [1m[36mCACHE (0.0ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY `flags`.position ASC LIMIT 1[0m [["db_package_id", 1]] [a7c67449-464c-465a-876c-144e67b60619] [11339.69] [1m[35mCACHE (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [["db_project_id", 2]] [a7c67449-464c-465a-876c-144e67b60619] [11339.70] [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 [a7c67449-464c-465a-876c-144e67b60619] [11339.70] [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 [a7c67449-464c-465a-876c-144e67b60619] [11339.70] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.70] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.70] update_activity 3.468873054351029e-12 10 2013-09-18 00:08:14 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [a7c67449-464c-465a-876c-144e67b60619] [11339.70] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.70] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.00000000000347 WHERE `packages`.`id` = 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.70] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 00:08:14' WHERE `packages`.`id` = 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.70] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.71] [1m[36m (0.5ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, login[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.71] [1m[35m (0.4ms)[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 [a7c67449-464c-465a-876c-144e67b60619] [11339.71] Rendered models/_package.xml.builder (4.4ms) [a7c67449-464c-465a-876c-144e67b60619] [11339.71] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [a7c67449-464c-465a-876c-144e67b60619] [11339.74] request took 0.027356293 0.027356293 [a7c67449-464c-465a-876c-144e67b60619] [11339.74] [1m[36mRelationship Load (3.0ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id is not null)[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.74] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.74] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.74] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.74] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.75] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.75] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.75] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id is not null) [a7c67449-464c-465a-876c-144e67b60619] [11339.75] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.75] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]] [a7c67449-464c-465a-876c-144e67b60619] [11339.75] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.75] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.75] update_activity 10.0 5.801601542366876e-06 2013-09-18 00:08:14 +0000 2013-09-18 00:08:14 UTC 2013-09-18 00:08:14 UTC [a7c67449-464c-465a-876c-144e67b60619] [11339.75] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.75] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000005801601542 WHERE `packages`.`id` = 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.75] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 00:08:14' WHERE `packages`.`id` = 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.75] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.76] [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 [a7c67449-464c-465a-876c-144e67b60619] [11339.76] [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 [a7c67449-464c-465a-876c-144e67b60619] [11339.76] Rendered models/_package.xml.builder (4.7ms) [a7c67449-464c-465a-876c-144e67b60619] [11339.76] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [a7c67449-464c-465a-876c-144e67b60619] [11339.77] request took 0.009646491 0.037002784 [a7c67449-464c-465a-876c-144e67b60619] [11339.77] [1m[36mPackage Load (0.4ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.77] update_activity 10.000005722045898 2.149078581068251e-06 2013-09-18 00:08:14 +0000 2013-09-18 00:08:14 UTC 2013-09-18 00:08:14 UTC [a7c67449-464c-465a-876c-144e67b60619] [11339.77] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379462894)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.77] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.00000787112448 WHERE `packages`.`id` = 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.77] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 00:08:14' WHERE `packages`.`id` = 1 [a7c67449-464c-465a-876c-144e67b60619] [11339.78] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1[0m [a7c67449-464c-465a-876c-144e67b60619] [11339.78] [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` = 1 ORDER BY role_name, login [a7c67449-464c-465a-876c-144e67b60619] [11339.78] [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 [a7c67449-464c-465a-876c-144e67b60619] [11339.78] Rendered models/_package.xml.builder (4.2ms) [a7c67449-464c-465a-876c-144e67b60619] [11339.78] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [a7c67449-464c-465a-876c-144e67b60619] [11339.79] request took 0.011551891 0.048554675 [a7c67449-464c-465a-876c-144e67b60619] [11339.79] [1m[35m (0.3ms)[0m RELEASE SAVEPOINT active_record_1 [a7c67449-464c-465a-876c-144e67b60619] [11339.79] Validate XML response: #<ActionDispatch::Response:0x00000007263340> took 0ms [a7c67449-464c-465a-876c-144e67b60619] [11339.80] Completed 200 OK in 118ms (Views: 0.8ms | ActiveRecord: 13.4ms | Backend: 48.6ms | XML: 0.0ms) [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.80] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-18 00:08:14 +0000 [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.80] Processing by SourceController#package_meta as XML [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.80] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.80] Validate XML request: #<ActionDispatch::Request:0x000000079cce10> [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.80] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.80] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.80] USER found: king [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.80] User king initialised [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.80] [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 [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.80] [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 [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.80] [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 [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.81] [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 [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.81] [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 [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.81] Validate XML response: #<ActionDispatch::Response:0x000000079ccde8> took 1ms [74841fea-8cff-4f14-961e-f0d5aae06a39] [11339.81] Completed 200 OK in 12ms (Views: 0.2ms | ActiveRecord: 1.4ms | Backend: 0.0ms | XML: 0.0ms) [11339.82] [1m[36m (5.5ms)[0m [1mROLLBACK[0m + 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/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/1793/changes> Changes: [Stephan Kulow] [api] remove deprecated calls during seeding ------------------------------------------ Started by upstream project "obs_master_check_deps" build number 885 originally caused by: Started by upstream project "obs_master_update_deps" build number 543 originally caused by: Started by an SCM change [EnvInject] - Loading node environment variables. Building remotely on obs_master_deps_chroot in workspace <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/> Checkout:obs_master_testsuite_api / <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/> - hudson.remoting.Channel@4c8f4c8f:obs_master_deps_chroot Using strategy: Default Last Built Revision: Revision 61825c02b733d72304716ab508de4704eb3385dd (origin/master) Fetching changes from 1 remote Git repository Fetching upstream changes from origin Commencing build of Revision e577692f84869a59b3f276fc0b5d89d5cec33247 (origin/master) Checking out Revision e577692f84869a59b3f276fc0b5d89d5cec33247 (origin/master) [locks-and-latches] Checking to see if we really have the locks [locks-and-latches] Have all the locks, build can start [obs_master_testsuite_api] $ /bin/sh -xe /tmp/hudson2587272388089782386.sh + sh dist/ci/obs_testsuite_api.sh ++ dirname dist/ci/obs_testsuite_api.sh + . dist/ci/obs_testsuite_common.sh + setup_git + echo 'Checking status' Checking status + git status # Not currently on any branch. nothing to commit, working directory clean + echo 'Setup git submodules' Setup git submodules + git submodule init + git submodule update + echo 'Setup backend configuration template' Setup backend configuration template + sed -i -e 's|my $hostname = .*$|my $hostname = '\''localhost'\'';|' -e 's|our $bsuser = '\''obsrun'\'';|our $bsuser = '\''jenkins'\'';|' -e 's|our $bsgroup = '\''obsrun'\'';|our $bsgroup = '\''jenkins'\'';|' src/backend/BSConfig.pm.template + cp src/backend/BSConfig.pm.template src/backend/BSConfig.pm + echo 'Set environment variables' Set environment variables + export RAILS_ENV=test + RAILS_ENV=test + ret=0 + setup_api + echo 'Enter API rails root' Enter API rails root + cd src/api + echo 'Setup database configuration' Setup database configuration + cp config/database.yml.example config/database.yml + sed -i 's|database: api|database: ci_api|' config/database.yml + echo 'Setup additional configuration' Setup additional configuration + cp config/options.yml.example config/options.yml + cp config/thinking_sphinx.yml.example config/thinking_sphinx.yml + chmod a+x script/start_test_backend + echo 'Initialize test database, load seed data' Initialize test database, load seed data + bundle exec rake db:drop db:create db:setup --trace ** Invoke db:drop (first_time) ** Invoke db:load_config (first_time) ** Execute db:load_config ** Execute db:drop ** Invoke db:create (first_time) ** Invoke db:load_config ** Execute db:create ** Invoke db:setup (first_time) ** Execute db:setup ** Invoke db:structure:load (first_time) ** Invoke environment (first_time) ** Execute environment ** Invoke db:load_config ** Execute db:structure:load ** Invoke db:seed (first_time) ** Execute db:seed ** Invoke db:abort_if_pending_migrations (first_time) ** Invoke environment ** Execute db:abort_if_pending_migrations Seeding architectures table... Seeding roles table... Seeding users table... Seeding roles_users table... Seeding static_permissions table... Seeding static permissions for admin role in roles_static_permissions table... Seeding static permissions for maintainer role in roles_static_permissions table... Seeding static permissions for reader role in roles_static_permissions table... Seeding static permissions for downloader role in roles_static_permissions table... Seeding attrib_namespaces table... Seeding attrib_types table... Seeding db_project_type table by loading test fixtures rake aborted! You cannot call create unless the parent is saved /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/collection_association.rb:454:in `create_record' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/collection_association.rb:121:in `create' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/collection_proxy.rb:260:in `create' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/db/seeds.rb>:115:in `block in <top (required)>' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/core.rb:194:in `initialize' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/inheritance.rb:27:in `new' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/inheritance.rb:27:in `new' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/persistence.rb:36:in `create' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/relation.rb:121:in `block in create' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/relation.rb:270:in `scoping' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/relation.rb:121:in `create' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/relation.rb:133:in `first_or_create' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/db/seeds.rb>:114:in `<top (required)>' /usr/lib64/ruby/gems/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:222:in `load' /usr/lib64/ruby/gems/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:222:in `block in load' /usr/lib64/ruby/gems/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:213:in `load_dependency' /usr/lib64/ruby/gems/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:222:in `load' /usr/lib64/ruby/gems/2.0.0/gems/railties-4.0.0/lib/rails/engine.rb:540:in `load_seed' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:153:in `load_seed' /usr/lib64/ruby/gems/2.0.0/gems/activerecord-4.0.0/lib/active_record/railties/databases.rake:181:in `block (2 levels) in <top (required)>' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:236:in `call' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:236:in `block in execute' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:231:in `each' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:231:in `execute' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:175:in `block in invoke_with_call_chain' /usr/lib64/ruby/2.0.0/monitor.rb:211:in `mon_synchronize' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:168:in `invoke_with_call_chain' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:161:in `invoke' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/lib/tasks/databases.rake>:93:in `block (2 levels) in <top (required)>' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:236:in `call' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:236:in `block in execute' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:231:in `each' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:231:in `execute' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:175:in `block in invoke_with_call_chain' /usr/lib64/ruby/2.0.0/monitor.rb:211:in `mon_synchronize' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:168:in `invoke_with_call_chain' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:161:in `invoke' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:149:in `invoke_task' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:106:in `block (2 levels) in top_level' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:106:in `each' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:106:in `block in top_level' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:115:in `run_with_threads' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:100:in `top_level' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:78:in `block in run' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:165:in `standard_exception_handling' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:75:in `run' /usr/lib64/ruby/gems/2.0.0/gems/rake-10.1.0/bin/rake:33:in `<top (required)>' /usr/bin/rake:23:in `load' /usr/bin/rake:23:in `<main>' Tasks: TOP => db:seed 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/1794/changes> Changes: [Stephan Kulow] [api] fix seeds on empty database ------------------------------------------ [...truncated 229215 lines...] [faab8c4d-7536-4063-82bc-28fcc0e98f93] [347.64] [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 [faab8c4d-7536-4063-82bc-28fcc0e98f93] [347.64] [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 [faab8c4d-7536-4063-82bc-28fcc0e98f93] [347.76] Validate XML response: #<ActionDispatch::Response:0x00000007a25628> took 125ms [faab8c4d-7536-4063-82bc-28fcc0e98f93] [347.76] Completed 200 OK in 133ms (Views: 0.3ms | ActiveRecord: 1.3ms | Backend: 0.0ms | XML: 0.0ms) [c1cd92f7-535b-425c-9433-b435e9198824] [347.76] Started GET "/source/kde4" for 127.0.0.1 at 2013-09-18 05:43:44 +0000 [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] Processing by SourceController#show_project as XML [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] Parameters: {"project"=>"kde4"} [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] Validate XML request: #<ActionDispatch::Request:0x00000003e58d98> [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] [1m[35mUser Load (0.6ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] USER found: king [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] User king initialised [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] [1m[36mRole Exists (0.3ms)[0m [1mSELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1[0m [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] [1m[35mProject Load (0.3ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1 [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] [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 [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] [1m[35m (0.2ms)[0m SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0)) [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] Validate XML response: #<ActionDispatch::Response:0x00000003e5fe18> took 0ms [c1cd92f7-535b-425c-9433-b435e9198824] [347.77] Completed 200 OK in 9ms (Views: 0.3ms | ActiveRecord: 1.6ms | Backend: 0.0ms | XML: 0.0ms) [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-18 05:43:44 +0000 [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] Processing by SourceController#package_meta as XML [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] Validate XML request: #<ActionDispatch::Request:0x000000043486f0> [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] USER found: king [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] User king initialised [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] [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 [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] [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 [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] [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 [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.78] [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 [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.79] [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 [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.79] [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 [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.79] [1m[35mFlag Load (0.3ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.79] Rendered models/_package.xml.builder (5.8ms) [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.79] Validate XML response: #<ActionDispatch::Response:0x0000000423ab50> took 2ms [4eeb6370-929b-48dd-8a2c-d3b33509fe2a] [347.79] Completed 200 OK in 17ms (Views: 0.3ms | ActiveRecord: 2.3ms | Backend: 0.0ms | XML: 0.2ms) [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.80] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-18 05:43:44 +0000 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.80] Processing by SourceController#package_meta as XML [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.80] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.80] Validate XML request: #<ActionDispatch::Request:0x000000045b2d00> [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.80] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.80] USER found: king [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.80] User king initialised [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.80] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.80] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] [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]] [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] flagcheck: package has default state, checking project [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] disabled_for sourceaccess repo: arch: state:enable [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.81] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.82] [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]] [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.82] [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]] [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.82] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.82] update_activity 3.462978700238852e-12 10 2013-09-18 05:43:44 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.82] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.82] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000003462 WHERE `packages`.`id` = 2[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.82] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 05:43:44' WHERE `packages`.`id` = 2 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.82] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.83] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.83] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.83] Rendered models/_package.xml.builder (4.9ms) [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.83] [backend] PUT: /source/kde4/kdebase/_meta?user=king [338.83] 2013-09-18 05:43:44 [10242]: PUT /source/kde4/kdebase/_meta?user=king [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.84] request took 0.012084999 0.012084999 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.84] [1m[35mRelationship Load (0.6ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id is not null) [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.84] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id is not null)[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.85] [1m[35mPackage Load (0.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.85] update_activity 10.0 2.9400542930320455e-06 2013-09-18 05:43:44 +0000 2013-09-18 05:43:44 UTC 2013-09-18 05:43:44 UTC [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.85] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.85] [1m[35mSQL (0.4ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000002940054292 WHERE `packages`.`id` = 2 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.85] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 05:43:44' WHERE `packages`.`id` = 2[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.85] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.85] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.86] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.86] Rendered models/_package.xml.builder (5.0ms) [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.86] [backend] PUT: /source/kde4/kdebase/_meta?user=king [338.86] 2013-09-18 05:43:44 [10243]: PUT /source/kde4/kdebase/_meta?user=king [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.87] request took 0.017597249 0.029682248 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.88] [1m[36mPackage Load (0.7ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.88] update_activity 10.00000286102295 3.2251631772076643e-06 2013-09-18 05:43:44 +0000 2013-09-18 05:43:44 UTC 2013-09-18 05:43:44 UTC [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.88] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.88] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000006086186126 WHERE `packages`.`id` = 2[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.88] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 05:43:44' WHERE `packages`.`id` = 2 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.88] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.89] [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 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.89] [1m[36m (0.4ms)[0m [1mSELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, title[0m [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.89] Rendered models/_package.xml.builder (5.0ms) [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.89] [backend] PUT: /source/kde4/kdebase/_meta?user=king [338.89] 2013-09-18 05:43:44 [10244]: PUT /source/kde4/kdebase/_meta?user=king [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.90] request took 0.010157785 0.039840033000000004 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.90] [1m[35m (0.2ms)[0m RELEASE SAVEPOINT active_record_1 [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.90] Validate XML response: #<ActionDispatch::Response:0x000000045b2be8> took 1ms [f2073fe7-c2ae-4854-bfa2-c6f8ad4b3238] [347.90] Completed 200 OK in 104ms (Views: 1.0ms | ActiveRecord: 10.2ms | Backend: 39.8ms | XML: 0.0ms) [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.90] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-18 05:43:44 +0000 [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.90] Processing by SourceController#package_meta as XML [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.90] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.90] Validate XML request: #<ActionDispatch::Request:0x00000007567ac8> [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.90] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.91] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.91] USER found: king [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.91] User king initialised [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.91] [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 [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.91] [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 [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.91] [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 [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.91] [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 [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.92] [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 [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.92] Validate XML response: #<ActionDispatch::Response:0x00000007567a50> took 2ms [30dec918-d7c8-406b-84b5-26a4b648a2a1] [347.92] Completed 200 OK in 14ms (Views: 0.3ms | ActiveRecord: 1.7ms | Backend: 0.0ms | XML: 0.0ms) [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.92] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-18 05:43:44 +0000 [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.92] Processing by SourceController#package_meta as XML [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.92] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.92] Validate XML request: #<ActionDispatch::Request:0x000000075f07d8> [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.92] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.92] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.92] USER found: king [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.92] User king initialised [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.92] [1m[35mRole Exists (0.3ms)[0m SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1 [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.93] [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 [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.93] [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 [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.93] [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 [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.93] [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 [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.93] [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 [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.94] [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` = 1 ORDER BY role_name, login [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.94] [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 [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.94] [1m[35mFlag Load (0.3ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.94] Rendered models/_package.xml.builder (10.2ms) [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.94] Validate XML response: #<ActionDispatch::Response:0x000000075f06e8> took 2ms [ffbe8cd7-3d85-4147-8721-6d14726cea5b] [347.94] Completed 200 OK in 21ms (Views: 0.4ms | ActiveRecord: 2.9ms | Backend: 0.0ms | XML: 0.0ms) [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.94] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-18 05:43:44 +0000 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.94] Processing by SourceController#package_meta as XML [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.94] 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"} [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.95] Validate XML request: #<ActionDispatch::Request:0x0000000778e798> [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.95] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.95] USER found: king [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.95] User king initialised [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.95] [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 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.95] [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 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.95] [1m[35mPackage Load (0.3ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.96] [1m[36mProject Load (0.3ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.96] [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 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.96] [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]] [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.96] [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 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.97] [1m[36mFlag Load (0.3ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.97] [1m[35mFlag Load (0.3ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.97] flagcheck: package has default state, checking project [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.97] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.97] disabled_for sourceaccess repo: arch: state:enable [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.97] 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"})}) [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.97] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.97] [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]] [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.97] [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]] [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.97] [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 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.97] [1m[35mPackage Load (0.3ms)[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 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.98] [1m[36mProject Load (0.3ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.98] [1m[35mPackage Load (0.4ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.98] update_activity 3.462978700238852e-12 10 2013-09-18 05:43:44 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.98] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.98] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000003462 WHERE `packages`.`id` = 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.98] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 05:43:44' WHERE `packages`.`id` = 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.98] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.99] [1m[36m (1.0ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, login[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.99] [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 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.99] Rendered models/_package.xml.builder (7.0ms) [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [347.99] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [338.99] 2013-09-18 05:43:44 [10245]: PUT /source/kde4/kdelibs/_meta?user=king [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.00] request took 0.010964153 0.010964153 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.01] [1m[36mRelationship Load (0.7ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id is not null)[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.01] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.01] [1m[36mRole Load (0.3ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.01] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.01] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.01] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.01] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.02] [1m[35mRelationship Load (0.3ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id is not null) [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.02] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.02] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]] [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.02] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.02] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.02] update_activity 10.0 4.264408791506732e-06 2013-09-18 05:43:44 +0000 2013-09-18 05:43:44 UTC 2013-09-18 05:43:44 UTC [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.02] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.02] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000004264408792 WHERE `packages`.`id` = 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.02] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 05:43:44' WHERE `packages`.`id` = 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.02] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.03] [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 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.03] [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 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.03] Rendered models/_package.xml.builder (4.8ms) [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.03] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [339.03] 2013-09-18 05:43:44 [10246]: PUT /source/kde4/kdelibs/_meta?user=king [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.04] request took 0.01443759 0.025401743 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.05] [1m[36mPackage Load (0.5ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.05] update_activity 10.000003814697266 2.8365464122207076e-06 2013-09-18 05:43:44 +0000 2013-09-18 05:43:44 UTC 2013-09-18 05:43:44 UTC [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.05] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379483024)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.05] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000006651243678 WHERE `packages`.`id` = 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.05] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-18 05:43:44' WHERE `packages`.`id` = 1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.05] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1[0m [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.05] [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` = 1 ORDER BY role_name, login [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.06] [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 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.06] Rendered models/_package.xml.builder (4.8ms) [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.06] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [339.06] 2013-09-18 05:43:44 [10247]: PUT /source/kde4/kdelibs/_meta?user=king [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.07] request took 0.011717783 0.037119526 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.07] [1m[35m (0.3ms)[0m RELEASE SAVEPOINT active_record_1 [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.07] Validate XML response: #<ActionDispatch::Response:0x0000000778e770> took 1ms [c18a009f-293c-4f1b-b6e3-941ce5ccb47f] [348.07] Completed 200 OK in 127ms (Views: 1.0ms | ActiveRecord: 14.1ms | Backend: 37.1ms | XML: 0.0ms) [6782cea4-908d-4086-b27f-d81ae196b085] [348.07] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-18 05:43:44 +0000 [6782cea4-908d-4086-b27f-d81ae196b085] [348.07] Processing by SourceController#package_meta as XML [6782cea4-908d-4086-b27f-d81ae196b085] [348.07] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [6782cea4-908d-4086-b27f-d81ae196b085] [348.07] Validate XML request: #<ActionDispatch::Request:0x000000079fb300> [6782cea4-908d-4086-b27f-d81ae196b085] [348.07] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [6782cea4-908d-4086-b27f-d81ae196b085] [348.08] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [6782cea4-908d-4086-b27f-d81ae196b085] [348.08] USER found: king [6782cea4-908d-4086-b27f-d81ae196b085] [348.08] User king initialised [6782cea4-908d-4086-b27f-d81ae196b085] [348.08] [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 [6782cea4-908d-4086-b27f-d81ae196b085] [348.08] [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 [6782cea4-908d-4086-b27f-d81ae196b085] [348.08] [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 [6782cea4-908d-4086-b27f-d81ae196b085] [348.08] [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 [6782cea4-908d-4086-b27f-d81ae196b085] [348.09] [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 [6782cea4-908d-4086-b27f-d81ae196b085] [348.09] Validate XML response: #<ActionDispatch::Response:0x000000079fb2d8> took 1ms [6782cea4-908d-4086-b27f-d81ae196b085] [348.09] Completed 200 OK in 13ms (Views: 0.3ms | ActiveRecord: 1.6ms | Backend: 0.0ms | XML: 0.0ms) [348.09] [1m[36m (5.5ms)[0m [1mROLLBACK[0m [348.09] kill 1889 + 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/1795/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