See http://ci.opensuse.org/job/obs_master_testsuite_api/1720/changes
Changes:
[Stephan Kulow] [api] move duplicated rating function to a shared mixin
[Stephan Kulow] [api] move common code of project and package to HasAttributes
------------------------------------------
[...truncated 173905 lines...]
relationships ur where f.flag = 'access' and f.status = 'disable' and ur.project_id = f.db_project_id
[623e2fc6-8e64-49fb-ba64-653e0ae5fb06] [11252.97] [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
[623e2fc6-8e64-49fb-ba64-653e0ae5fb06] [11252.97] [1m[35mProject Load (0.3ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1
[623e2fc6-8e64-49fb-ba64-653e0ae5fb06] [11252.97] Validate XML response: #ActionDispatch::Response:0x00000007605a48 took 2ms
[623e2fc6-8e64-49fb-ba64-653e0ae5fb06] [11252.97] Completed 200 OK in 9ms (Views: 0.2ms | ActiveRecord: 1.0ms | Backend: 0.0ms | XML: 0.0ms)
[edb737da-2210-40d8-b800-d1388e6182af] [11252.97] Started GET "/source/kde4" for 127.0.0.1 at 2013-08-29 08:14:46 +0000
[edb737da-2210-40d8-b800-d1388e6182af] [11252.97] Processing by SourceController#show_project as XML
[edb737da-2210-40d8-b800-d1388e6182af] [11252.97] Parameters: {"project"=>"kde4"}
[edb737da-2210-40d8-b800-d1388e6182af] [11252.97] Validate XML request: #ActionDispatch::Request:0x00000007652370
[edb737da-2210-40d8-b800-d1388e6182af] [11252.97] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"}
[edb737da-2210-40d8-b800-d1388e6182af] [11252.97] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[edb737da-2210-40d8-b800-d1388e6182af] [11252.97] USER found: king
[edb737da-2210-40d8-b800-d1388e6182af] [11252.97] User king initialised
[edb737da-2210-40d8-b800-d1388e6182af] [11252.98] [1m[35mRole Exists (0.3ms)[0m SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1
[edb737da-2210-40d8-b800-d1388e6182af] [11252.98] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1[0m
[edb737da-2210-40d8-b800-d1388e6182af] [11252.98] [1m[35m (0.3ms)[0m SELECT `packages`.`name`, `packages`.`db_project_id` FROM `packages` WHERE `packages`.`db_project_id` = 2 AND (packages.db_project_id not in (0))
[edb737da-2210-40d8-b800-d1388e6182af] [11252.98] [1m[36m (0.2ms)[0m [1mSELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0))[0m
[edb737da-2210-40d8-b800-d1388e6182af] [11252.98] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"}
[edb737da-2210-40d8-b800-d1388e6182af] [11252.98] Validate XML response: #ActionDispatch::Response:0x000000076522d0 took 0ms
[edb737da-2210-40d8-b800-d1388e6182af] [11252.98] Completed 200 OK in 8ms (Views: 0.2ms | ActiveRecord: 1.4ms | Backend: 0.0ms | XML: 0.0ms)
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.98] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-29 08:14:46 +0000
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.98] Processing by SourceController#package_meta as XML
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.98] Parameters: {"project"=>"kde4", "package"=>"kdebase"}
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.98] Validate XML request: #ActionDispatch::Request:0x000000076a0520
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.98] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"}
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.98] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.98] USER found: king
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.98] User king initialised
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.98] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdebase", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"}
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.99] [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
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.99] [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
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.99] [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
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.99] [1m[35mProject Load (0.3ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11252.99] [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
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11253.00] [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
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11253.00] [1m[36mFlag Load (0.3ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC[0m
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11253.00] Rendered models/_package.xml.builder (6.1ms)
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11253.00] Validate XML response: #ActionDispatch::Response:0x000000076a04f8 took 1ms
[613c8d6b-b9c4-4155-a237-ff403e40d01d] [11253.00] Completed 200 OK in 18ms (Views: 0.4ms | ActiveRecord: 2.5ms | Backend: 0.0ms | XML: 0.3ms)
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.00] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-29 08:14:46 +0000
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.00] Processing by SourceController#package_meta as XML
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.00] Parameters: {""\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"}
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.00] Validate XML request: #ActionDispatch::Request:0x00000007735788
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.01] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.01] USER found: king
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.01] User king initialised
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.01] [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
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.01] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.01] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' AND (packages.db_project_id not in (0)) LIMIT 1[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.01] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.01] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdebase", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"} 2
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.01] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 2 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [["id", 2]]
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[36mFlag Load (0.3ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY `flags`.position ASC LIMIT 1[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] flagcheck: package has default state, checking project
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] disabled_for sourceaccess repo: arch: state:enable
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"})
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[35mCACHE (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY `flags`.position ASC LIMIT 1 [["db_package_id", 2]]
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[36mCACHE (0.0ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [["db_project_id", 2]]
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] update_activity 4.004230696511495e-12 10 2013-08-29 08:14:46 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000004004 WHERE `packages`.`id` = 2
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.02] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-29 08:14:46' WHERE `packages`.`id` = 2[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.03] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.13] [1m[36m (0.8ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, login[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.13] [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
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.13] Rendered models/_package.xml.builder (5.0ms)
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.13] [backend] PUT: /source/kde4/kdebase/_meta?user=king
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.14] request took 0.010628946 0.010628946
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.14] [1m[36mRelationship Load (0.5ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id > 0)[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.14] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id > 0)
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.14] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.14] update_activity 10.0 1.386966970231798e-05 2013-08-29 08:14:46 +0000 2013-08-29 08:14:46 UTC 2013-08-29 08:14:46 UTC
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.15] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.15] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000013869669703 WHERE `packages`.`id` = 2[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.15] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-29 08:14:46' WHERE `packages`.`id` = 2
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.15] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.15] [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
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.15] [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
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.15] Rendered models/_package.xml.builder (4.2ms)
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.15] [backend] PUT: /source/kde4/kdebase/_meta?user=king
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.16] request took 0.010617128 0.021246074
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.17] [1m[35mPackage Load (0.5ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.17] update_activity 10.000014305114746 2.215719885296292e-06 2013-08-29 08:14:46 +0000 2013-08-29 08:14:46 UTC 2013-08-29 08:14:46 UTC
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.17] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.17] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000016520834631 WHERE `packages`.`id` = 2
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.17] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-29 08:14:46' WHERE `packages`.`id` = 2[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.17] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.17] [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
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.17] [1m[35m (0.3ms)[0m SELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 2 ORDER BY role_name, title
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.18] Rendered models/_package.xml.builder (4.4ms)
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.18] [backend] PUT: /source/kde4/kdebase/_meta?user=king
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.19] request took 0.012404856 0.03365093
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.19] [1m[36m (0.3ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.19] Validate XML response: #ActionDispatch::Response:0x00000007735738 took 1ms
[8c90eeb1-6556-4c54-9464-de611d68847c] [11253.19] Completed 200 OK in 187ms (Views: 0.9ms | ActiveRecord: 9.5ms | Backend: 33.7ms | XML: 0.0ms)
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.19] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-08-29 08:14:46 +0000
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.19] Processing by SourceController#package_meta as XML
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.19] Parameters: {"project"=>"kde4", "package"=>"kdebase"}
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.19] Validate XML request: #ActionDispatch::Request:0x000000044c6dd8
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.19] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"}
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.20] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.20] USER found: king
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.20] User king initialised
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.20] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdebase", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"} 2
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.20] [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
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.20] [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
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.20] [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
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.20] [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
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.20] [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
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.21] Validate XML response: #ActionDispatch::Response:0x000000044c6db0 took 1ms
[4d20381e-930a-4382-b198-ac10415c5d73] [11253.21] Completed 200 OK in 13ms (Views: 0.2ms | ActiveRecord: 1.5ms | Backend: 0.0ms | XML: 0.0ms)
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-29 08:14:46 +0000
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] Processing by SourceController#package_meta as XML
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] Parameters: {"project"=>"kde4", "package"=>"kdelibs"}
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] Validate XML request: #ActionDispatch::Request:0x000000045f4ef8
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"}
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] USER found: king
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] User king initialised
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdelibs", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"}
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] [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
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] [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
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.21] [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
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.22] [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
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.22] [1m[36mPackage Load (0.3ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`id` = 1234 AND (packages.db_project_id not in (0)) ORDER BY `packages`.`id` ASC LIMIT 1[0m
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.22] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.22] [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
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.23] [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
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.23] [1m[36mFlag Load (0.3ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC[0m
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.23] Rendered models/_package.xml.builder (9.7ms)
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.23] Validate XML response: #ActionDispatch::Response:0x000000045f4e80 took 2ms
[acfddb7d-32bd-49fb-9f01-296cf9097992] [11253.23] Completed 200 OK in 21ms (Views: 0.4ms | ActiveRecord: 2.9ms | Backend: 0.0ms | XML: 0.0ms)
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.23] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-29 08:14:46 +0000
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.23] Processing by SourceController#package_meta as XML
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.23] Parameters: {""\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n \n \n \n \n</package>\n", "project"=>"kde4", "package"=>"kdelibs"}
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.23] Validate XML request: #ActionDispatch::Request:0x00000004758768
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.24] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.24] USER found: king
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.24] User king initialised
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.24] [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
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.24] [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
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.24] [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
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.24] [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
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.24] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdelibs", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"} 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.24] [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
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] [1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1 [["id", 2]]
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] [1m[36mFlag Load (0.3ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY `flags`.position ASC LIMIT 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] flagcheck: package has default state, checking project
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] disabled_for sourceaccess repo: arch: state:enable
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] 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"})})
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] [1m[35mCACHE (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY `flags`.position ASC LIMIT 1 [["db_package_id", 1]]
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] [1m[36mCACHE (0.0ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [["db_project_id", 2]]
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'home:coolo:test' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.25] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 601 AND `packages`.`name` = 'kdelibs_DEVEL_package' AND (packages.db_project_id not in (0)) LIMIT 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.26] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 601 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.26] [1m[36mPackage Load (0.3ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.26] update_activity 4.004230696511495e-12 10 2013-08-29 08:14:46 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.26] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.26] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000004004 WHERE `packages`.`id` = 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.26] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-29 08:14:46' WHERE `packages`.`id` = 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.26] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.26] [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
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.27] [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
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.27] Rendered models/_package.xml.builder (4.8ms)
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.27] [backend] PUT: /source/kde4/kdelibs/_meta?user=king
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.28] request took 0.010016031 0.010016031
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.28] [1m[35mRelationship Load (0.5ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id > 0)
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.28] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.28] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.28] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.28] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.28] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.28] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.29] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id > 0)[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.29] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.29] [1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [["id", 3]]
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.29] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.29] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.29] update_activity 10.0 3.5871234205034046e-06 2013-08-29 08:14:46 +0000 2013-08-29 08:14:46 UTC 2013-08-29 08:14:46 UTC
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.29] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.29] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.00000358712342 WHERE `packages`.`id` = 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.29] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-08-29 08:14:46' WHERE `packages`.`id` = 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.29] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.30] [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
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.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` = 1 ORDER BY role_name, title[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.30] Rendered models/_package.xml.builder (4.7ms)
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.30] [backend] PUT: /source/kde4/kdelibs/_meta?user=king
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.31] request took 0.009031399 0.01904743
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.31] [1m[35mPackage Load (0.6ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.31] update_activity 10.000003814697266 2.1103079672212955e-06 2013-08-29 08:14:46 +0000 2013-08-29 08:14:46 UTC 2013-08-29 08:14:46 UTC
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.31] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1377764086)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.31] [1m[35mSQL (0.3ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000005925005233 WHERE `packages`.`id` = 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.31] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-08-29 08:14:46' WHERE `packages`.`id` = 1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.31] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.32] [1m[36m (0.9ms)[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
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.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
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.32] Rendered models/_package.xml.builder (5.3ms)
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.32] [backend] PUT: /source/kde4/kdelibs/_meta?user=king
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.33] request took 0.010862887 0.029910317
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.33] [1m[36m (0.3ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.33] Validate XML response: #ActionDispatch::Response:0x00000004758718 took 0ms
[6b407f4b-d3ce-4641-a04c-cbbac926f210] [11253.33] Completed 200 OK in 102ms (Views: 0.9ms | ActiveRecord: 12.2ms | Backend: 29.9ms | XML: 0.0ms)
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.34] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-08-29 08:14:46 +0000
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.34] Processing by SourceController#package_meta as XML
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.34] Parameters: {"project"=>"kde4", "package"=>"kdelibs"}
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.34] Validate XML request: #ActionDispatch::Request:0x000000076423a8
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.34] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"}
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.34] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.34] USER found: king
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.34] User king initialised
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.34] get_by_project_and_name {"get_by_project_and_name"=>1, :package=>"kdelibs", :use_source=>false, :follow_project_links=>true, :user=>"users/2-20110729140021000000000", :project=>"kde4"} 1
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.34] [1m[36mRole Exists (0.4ms)[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
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.34] [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
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.35] [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
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.35] [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
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.35] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.35] Validate XML response: #ActionDispatch::Response:0x00000007642380 took 2ms
[f10bfa7d-4198-4748-8edf-207fc513df4c] [11253.35] Completed 200 OK in 13ms (Views: 0.3ms | ActiveRecord: 1.7ms | Backend: 0.0ms | XML: 0.0ms)
[11253.36] [1m[35m (11.1ms)[0m ROLLBACK
+ 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/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