See http://ci.opensuse.org/job/obs_master_testsuite_api/1810/changes
Changes:
[Stephan Kulow] [api] refactor project status calculation
------------------------------------------
[...truncated 223047 lines...]
[4b20ccc3-4c09-4475-99db-a5e737493ec4] [325.00] [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
[4b20ccc3-4c09-4475-99db-a5e737493ec4] [325.00] [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
[4b20ccc3-4c09-4475-99db-a5e737493ec4] [325.01] Validate XML response: #ActionDispatch::Response:0x00000006b156b0 took 3ms
[4b20ccc3-4c09-4475-99db-a5e737493ec4] [325.01] Completed 200 OK in 11ms (Views: 0.2ms | ActiveRecord: 1.5ms | Backend: 0.0ms | XML: 0.0ms)
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.01] Started GET "/source/kde4" for 127.0.0.1 at 2013-09-22 05:18:57 +0000
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.01] Processing by SourceController#show_project as XML
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.01] Parameters: {"project"=>"kde4"}
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.01] Validate XML request: #ActionDispatch::Request:0x000000060bce48
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.01] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"}
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.01] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.01] USER found: king
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.01] User king initialised
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.01] [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
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.01] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.02] [1m[36m (0.3ms)[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
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.02] [1m[35m (0.2ms)[0m SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0))
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.02] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"}
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.02] Validate XML response: #ActionDispatch::Response:0x000000060bcc90 took 0ms
[e2afe9ed-d37a-4cd0-ae0a-d7fd7d364f6c] [325.02] Completed 200 OK in 8ms (Views: 0.2ms | ActiveRecord: 1.2ms | Backend: 0.0ms | XML: 0.0ms)
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.02] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-22 05:18:57 +0000
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.02] Processing by SourceController#package_meta as XML
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.02] Parameters: {"project"=>"kde4", "package"=>"kdebase"}
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.02] Validate XML request: #ActionDispatch::Request:0x000000073f5320
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.02] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"}
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.02] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.02] USER found: king
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.02] User king initialised
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.02] [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
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.02] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.03] [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
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.03] [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
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.03] [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
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.03] [1m[36m (0.3ms)[0m [1mSELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, title[0m
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.03] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.03] Rendered models/_package.xml.builder (5.6ms)
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.04] Validate XML response: #ActionDispatch::Response:0x000000073f52d0 took 1ms
[4682e5f5-1088-42f3-b352-b181e691d17d] [325.04] Completed 200 OK in 16ms (Views: 0.3ms | ActiveRecord: 2.2ms | Backend: 0.0ms | XML: 0.2ms)
[1a50993c-2323-4187-bbcc-693508a6073e] [325.04] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-22 05:18:57 +0000
[1a50993c-2323-4187-bbcc-693508a6073e] [325.04] Processing by SourceController#package_meta as XML
[1a50993c-2323-4187-bbcc-693508a6073e] [325.04] Parameters: {""\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"}
[1a50993c-2323-4187-bbcc-693508a6073e] [325.04] Validate XML request: #ActionDispatch::Request:0x0000000759a1f8
[1a50993c-2323-4187-bbcc-693508a6073e] [325.04] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.04] USER found: king
[1a50993c-2323-4187-bbcc-693508a6073e] [325.04] User king initialised
[1a50993c-2323-4187-bbcc-693508a6073e] [325.04] [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
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] [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
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] [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
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] [1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m [["id", 2]]
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] [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
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] flagcheck: package has default state, checking project
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] disabled_for sourceaccess repo: arch: state:enable
[1a50993c-2323-4187-bbcc-693508a6073e] [325.05] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"})
[1a50993c-2323-4187-bbcc-693508a6073e] [325.06] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1
[1a50993c-2323-4187-bbcc-693508a6073e] [325.06] [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]]
[1a50993c-2323-4187-bbcc-693508a6073e] [325.06] [1m[35mCACHE (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [["db_project_id", 2]]
[1a50993c-2323-4187-bbcc-693508a6073e] [325.06] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.06] update_activity 3.3637524499624153e-12 10 2013-09-22 05:18:57 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC
[1a50993c-2323-4187-bbcc-693508a6073e] [325.06] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1
[1a50993c-2323-4187-bbcc-693508a6073e] [325.06] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000003364 WHERE `packages`.`id` = 2[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.06] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-22 05:18:57' WHERE `packages`.`id` = 2
[1a50993c-2323-4187-bbcc-693508a6073e] [325.06] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.06] [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
[1a50993c-2323-4187-bbcc-693508a6073e] [325.07] [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
[1a50993c-2323-4187-bbcc-693508a6073e] [325.07] Rendered models/_package.xml.builder (4.9ms)
[1a50993c-2323-4187-bbcc-693508a6073e] [325.07] [backend] PUT: /source/kde4/kdebase/_meta?user=king
[316.20] 2013-09-22 05:18:57 [17769]: PUT /source/kde4/kdebase/_meta?user=king
[1a50993c-2323-4187-bbcc-693508a6073e] [325.08] request took 0.00906818 0.00906818
[1a50993c-2323-4187-bbcc-693508a6073e] [325.08] [1m[35mRelationship Load (0.4ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id is not null)
[1a50993c-2323-4187-bbcc-693508a6073e] [325.08] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id is not null)[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.08] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1
[1a50993c-2323-4187-bbcc-693508a6073e] [325.08] update_activity 10.0 2.3172133498721653e-06 2013-09-22 05:18:57 +0000 2013-09-22 05:18:57 UTC 2013-09-22 05:18:57 UTC
[1a50993c-2323-4187-bbcc-693508a6073e] [325.08] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.08] [1m[35mSQL (0.4ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.00000231721335 WHERE `packages`.`id` = 2
[1a50993c-2323-4187-bbcc-693508a6073e] [325.08] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-22 05:18:57' WHERE `packages`.`id` = 2[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.08] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2
[1a50993c-2323-4187-bbcc-693508a6073e] [325.09] [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
[1a50993c-2323-4187-bbcc-693508a6073e] [325.09] [1m[35m (0.5ms)[0m SELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, title
[1a50993c-2323-4187-bbcc-693508a6073e] [325.09] Rendered models/_package.xml.builder (5.2ms)
[1a50993c-2323-4187-bbcc-693508a6073e] [325.09] [backend] PUT: /source/kde4/kdebase/_meta?user=king
[316.22] 2013-09-22 05:18:57 [17770]: PUT /source/kde4/kdebase/_meta?user=king
[1a50993c-2323-4187-bbcc-693508a6073e] [325.10] request took 0.009837023 0.018905203000000002
[1a50993c-2323-4187-bbcc-693508a6073e] [325.10] [1m[36mPackage Load (0.5ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.10] update_activity 10.000001907348633 2.2339324156443277e-06 2013-09-22 05:18:57 +0000 2013-09-22 05:18:57 UTC 2013-09-22 05:18:57 UTC
[1a50993c-2323-4187-bbcc-693508a6073e] [325.10] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1
[1a50993c-2323-4187-bbcc-693508a6073e] [325.11] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000004141281048 WHERE `packages`.`id` = 2[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.11] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-22 05:18:57' WHERE `packages`.`id` = 2
[1a50993c-2323-4187-bbcc-693508a6073e] [325.11] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2[0m
[1a50993c-2323-4187-bbcc-693508a6073e] [325.11] [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
[1a50993c-2323-4187-bbcc-693508a6073e] [325.11] [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
[1a50993c-2323-4187-bbcc-693508a6073e] [325.11] Rendered models/_package.xml.builder (4.1ms)
[1a50993c-2323-4187-bbcc-693508a6073e] [325.11] [backend] PUT: /source/kde4/kdebase/_meta?user=king
[316.25] 2013-09-22 05:18:57 [17771]: PUT /source/kde4/kdebase/_meta?user=king
[1a50993c-2323-4187-bbcc-693508a6073e] [325.12] request took 0.009893372 0.028798575
[1a50993c-2323-4187-bbcc-693508a6073e] [325.12] [1m[35m (0.2ms)[0m RELEASE SAVEPOINT active_record_1
[1a50993c-2323-4187-bbcc-693508a6073e] [325.12] Validate XML response: #ActionDispatch::Response:0x0000000759a1a8 took 0ms
[1a50993c-2323-4187-bbcc-693508a6073e] [325.13] Completed 200 OK in 85ms (Views: 0.8ms | ActiveRecord: 8.8ms | Backend: 28.8ms | XML: 0.0ms)
[225956c1-a411-4da0-9415-1464e65225f9] [325.13] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-22 05:18:57 +0000
[225956c1-a411-4da0-9415-1464e65225f9] [325.13] Processing by SourceController#package_meta as XML
[225956c1-a411-4da0-9415-1464e65225f9] [325.13] Parameters: {"project"=>"kde4", "package"=>"kdebase"}
[225956c1-a411-4da0-9415-1464e65225f9] [325.13] Validate XML request: #ActionDispatch::Request:0x000000076555e8
[225956c1-a411-4da0-9415-1464e65225f9] [325.13] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"}
[225956c1-a411-4da0-9415-1464e65225f9] [325.13] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[225956c1-a411-4da0-9415-1464e65225f9] [325.13] USER found: king
[225956c1-a411-4da0-9415-1464e65225f9] [325.13] User king initialised
[225956c1-a411-4da0-9415-1464e65225f9] [325.13] [1m[35mRole Exists (0.5ms)[0m SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1
[225956c1-a411-4da0-9415-1464e65225f9] [325.13] [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
[225956c1-a411-4da0-9415-1464e65225f9] [325.13] [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
[225956c1-a411-4da0-9415-1464e65225f9] [325.14] [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
[225956c1-a411-4da0-9415-1464e65225f9] [325.14] [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
[225956c1-a411-4da0-9415-1464e65225f9] [325.14] Validate XML response: #ActionDispatch::Response:0x000000076555c0 took 1ms
[225956c1-a411-4da0-9415-1464e65225f9] [325.14] Completed 200 OK in 13ms (Views: 0.2ms | ActiveRecord: 1.6ms | Backend: 0.0ms | XML: 0.0ms)
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.14] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-22 05:18:57 +0000
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.14] Processing by SourceController#package_meta as XML
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.14] Parameters: {"project"=>"kde4", "package"=>"kdelibs"}
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.14] Validate XML request: #ActionDispatch::Request:0x0000000754a248
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.14] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"}
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.14] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.14] USER found: king
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.14] User king initialised
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.15] [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
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.15] [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
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.15] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' AND (packages.db_project_id not in (0)) LIMIT 1
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.15] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.15] [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
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.15] [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
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.16] [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
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.16] [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
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.16] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.16] Rendered models/_package.xml.builder (9.4ms)
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.16] Validate XML response: #ActionDispatch::Response:0x0000000754a1f8 took 1ms
[bf107aad-b2c0-43f8-89e1-35c34b992dad] [325.16] Completed 200 OK in 19ms (Views: 0.4ms | ActiveRecord: 2.8ms | Backend: 0.0ms | XML: 0.0ms)
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.16] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-22 05:18:57 +0000
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.16] Processing by SourceController#package_meta as XML
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.16] Parameters: {""\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n \n \n \n \n</package>\n", "project"=>"kde4", "package"=>"kdelibs"}
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.16] Validate XML request: #ActionDispatch::Request:0x000000079ad880
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.26] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.26] USER found: king
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.26] User king initialised
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.27] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.27] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.27] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.27] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.27] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.27] [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]]
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.27] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.27] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.27] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.27] flagcheck: package has default state, checking project
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] disabled_for sourceaccess repo: arch: state:enable
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] 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"})})
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] [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]]
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] [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]]
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] update_activity 3.3637524499624153e-12 10 2013-09-22 05:18:57 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000003364 WHERE `packages`.`id` = 1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.28] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-22 05:18:57' WHERE `packages`.`id` = 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.29] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.29] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.29] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.29] Rendered models/_package.xml.builder (4.3ms)
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.29] [backend] PUT: /source/kde4/kdelibs/_meta?user=king
[316.42] 2013-09-22 05:18:57 [17772]: PUT /source/kde4/kdelibs/_meta?user=king
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.30] request took 0.009776401 0.009776401
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.30] [1m[36mRelationship Load (0.4ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id is not null)[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.30] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.30] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id is not null)
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]]
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] update_activity 10.0 3.3691801406719066e-06 2013-09-22 05:18:57 +0000 2013-09-22 05:18:57 UTC 2013-09-22 05:18:57 UTC
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.31] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.00000336918014 WHERE `packages`.`id` = 1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.32] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-22 05:18:57' WHERE `packages`.`id` = 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.32] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.32] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.32] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.32] Rendered models/_package.xml.builder (4.3ms)
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.32] [backend] PUT: /source/kde4/kdelibs/_meta?user=king
[316.46] 2013-09-22 05:18:57 [17773]: PUT /source/kde4/kdelibs/_meta?user=king
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.33] request took 0.009445307 0.019221708
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.33] [1m[36mPackage Load (0.5ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.33] update_activity 10.000003814697266 2.0859142144521075e-06 2013-09-22 05:18:57 +0000 2013-09-22 05:18:57 UTC 2013-09-22 05:18:57 UTC
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.33] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379827137)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.34] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.00000590061148 WHERE `packages`.`id` = 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.34] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-22 05:18:57' WHERE `packages`.`id` = 1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.34] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1[0m
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.34] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.34] [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
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.34] Rendered models/_package.xml.builder (4.9ms)
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.34] [backend] PUT: /source/kde4/kdelibs/_meta?user=king
[316.48] 2013-09-22 05:18:57 [17774]: PUT /source/kde4/kdelibs/_meta?user=king
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.35] request took 0.007212809 0.026434517
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.35] [1m[35m (0.1ms)[0m RELEASE SAVEPOINT active_record_1
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.35] Validate XML response: #ActionDispatch::Response:0x000000079ad808 took 0ms
[4ec4471a-55e9-456c-b953-f2b8e3f04e98] [325.35] Completed 200 OK in 188ms (Views: 0.8ms | ActiveRecord: 11.1ms | Backend: 26.4ms | XML: 0.0ms)
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.35] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-22 05:18:57 +0000
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.36] Processing by SourceController#package_meta as XML
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.36] Parameters: {"project"=>"kde4", "package"=>"kdelibs"}
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.36] Validate XML request: #ActionDispatch::Request:0x00000006af5b08
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.36] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"}
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.36] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.36] USER found: king
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.36] User king initialised
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.36] [1m[35mRole Exists (0.3ms)[0m SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.36] [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
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.36] [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
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.36] [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
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.37] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.37] Validate XML response: #ActionDispatch::Response:0x00000006af5ae0 took 1ms
[659634fb-80fd-4293-9e84-2de98fd5ad2d] [325.37] Completed 200 OK in 12ms (Views: 0.2ms | ActiveRecord: 1.5ms | Backend: 0.0ms | XML: 0.0ms)
[325.37] [1m[36m (5.2ms)[0m [1mROLLBACK[0m
[325.37] kill 9731
+ echo
+ cleanup
+ echo 'Killing backend processes'
Killing backend processes
+ fuser -v http://ci.opensuse.org/job/obs_master_testsuite_api/ws/
+ egrep 'perl|ruby'
USER PID ACCESS COMMAND
http://ci.opensuse.org/job/obs_master_testsuite_api/ws/:
ci ..c.. sh
ci ..c.. sh
ci ..c.. egrep
ci ..c.. fuser
+ echo 'Remove log/tmp files to save disc space'
Remove log/tmp files to save disc space
+ rm -rf src/api/log/backend_access.log src/api/log/test.log src/api/tmp/backend_config src/api/tmp/backend_data src/api/tmp/cache src/api/tmp/pids src/api/tmp/scheduler.done src/api/tmp/sessions src/api/tmp/sockets 'src/webui/log/*' src/webui/tmp/cache src/webui/tmp/pids src/webui/tmp/sessions src/webui/tmp/sockets
+ exit 1
Build step 'Execute shell' marked build as failure
[locks-and-latches] Releasing all the locks
[locks-and-latches] All the locks released
--
To unsubscribe, e-mail: obs-tests+unsubscribe@opensuse.org
To contact the owner, e-mail: obs-tests+owner@opensuse.org