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: {""\"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: {""\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n \n \n \n \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