See http://ci.opensuse.org/job/obs_master_testsuite_api/1814/changes
Changes:
[Stephan Kulow] [api] fix some problems related to project status
------------------------------------------
[...truncated 223694 lines...]
[522a63e7-ec95-4077-afcc-8124b4ed6655] [361.63] [1m[35mRole Exists (0.3ms)[0m SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1
[522a63e7-ec95-4077-afcc-8124b4ed6655] [361.63] [1m[36mProject Load (0.3ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m
[522a63e7-ec95-4077-afcc-8124b4ed6655] [361.63] Validate XML response: #ActionDispatch::Response:0x0000000714ab48 took 2ms
[522a63e7-ec95-4077-afcc-8124b4ed6655] [361.63] Completed 200 OK in 10ms (Views: 0.1ms | ActiveRecord: 1.3ms | Backend: 0.0ms | XML: 0.0ms)
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.63] Started GET "/source/kde4" for 127.0.0.1 at 2013-09-23 07:40:04 +0000
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.63] Processing by SourceController#show_project as XML
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.63] Parameters: {"project"=>"kde4"}
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.63] Validate XML request: #ActionDispatch::Request:0x000000071b4c28
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.63] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"}
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.64] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.64] USER found: king
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.64] User king initialised
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.64] [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
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.64] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) LIMIT 1
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.64] [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
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.64] [1m[35m (0.2ms)[0m SELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0))
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.64] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"}
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.64] Validate XML response: #ActionDispatch::Response:0x000000071b4c00 took 0ms
[47248052-7508-42d2-ab91-c024ac17bd4a] [361.64] Completed 200 OK in 7ms (Views: 0.2ms | ActiveRecord: 1.2ms | Backend: 0.0ms | XML: 0.0ms)
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.64] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-23 07:40:04 +0000
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.64] Processing by SourceController#package_meta as XML
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.64] Parameters: {"project"=>"kde4", "package"=>"kdebase"}
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.64] Validate XML request: #ActionDispatch::Request:0x0000000757b730
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.64] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"}
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.64] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.65] USER found: king
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.65] User king initialised
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.65] [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
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.65] [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
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.65] [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
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.65] [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
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.66] [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
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.66] [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
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.66] [1m[35mFlag Load (0.3ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.66] Rendered models/_package.xml.builder (6.1ms)
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.66] Validate XML response: #ActionDispatch::Response:0x0000000757b6e0 took 1ms
[22686f20-ed15-4ef6-b861-36c9ab4c095b] [361.66] Completed 200 OK in 17ms (Views: 0.3ms | ActiveRecord: 2.2ms | Backend: 0.0ms | XML: 0.2ms)
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.66] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-23 07:40:04 +0000
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.66] Processing by SourceController#package_meta as XML
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.66] Parameters: {""\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"}
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.66] Validate XML request: #ActionDispatch::Request:0x0000000779be98
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.67] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.67] USER found: king
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.67] User king initialised
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.67] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.67] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.67] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.67] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] [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]]
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] flagcheck: package has default state, checking project
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] disabled_for sourceaccess repo: arch: state:enable
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"})
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] [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]]
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] [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]]
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] [1m[36mPackage Load (0.2ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] update_activity 3.33690065859593e-12 10 2013-09-23 07:40:04 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.68] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000003338 WHERE `packages`.`id` = 2[0m
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.69] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-23 07:40:04' WHERE `packages`.`id` = 2
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.69] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2[0m
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.69] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.69] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.69] Rendered models/_package.xml.builder (4.3ms)
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.69] [backend] PUT: /source/kde4/kdebase/_meta?user=king
[352.37] 2013-09-23 07:40:04 [9218]: PUT /source/kde4/kdebase/_meta?user=king
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.71] request took 0.015236889 0.015236889
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.71] [1m[35mRelationship Load (0.6ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id is not null)
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.71] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id is not null)[0m
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.71] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.71] update_activity 10.0 3.1091272830963136e-06 2013-09-23 07:40:04 +0000 2013-09-23 07:40:04 UTC 2013-09-23 07:40:04 UTC
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.71] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.71] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000003109127283 WHERE `packages`.`id` = 2
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.71] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-23 07:40:04' WHERE `packages`.`id` = 2[0m
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.72] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 2
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.72] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.72] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.72] Rendered models/_package.xml.builder (4.4ms)
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.72] [backend] PUT: /source/kde4/kdebase/_meta?user=king
[352.40] 2013-09-23 07:40:04 [9219]: PUT /source/kde4/kdebase/_meta?user=king
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.74] request took 0.013241203 0.028478092
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.74] [1m[36mPackage Load (0.5ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.74] update_activity 10.00000286102295 2.593188374130814e-06 2013-09-23 07:40:04 +0000 2013-09-23 07:40:04 UTC 2013-09-23 07:40:04 UTC
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.74] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.74] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000005454211323 WHERE `packages`.`id` = 2[0m
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.74] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-23 07:40:04' WHERE `packages`.`id` = 2
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.74] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 2[0m
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.75] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.75] [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
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.75] Rendered models/_package.xml.builder (4.7ms)
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.75] [backend] PUT: /source/kde4/kdebase/_meta?user=king
[352.42] 2013-09-23 07:40:04 [9220]: PUT /source/kde4/kdebase/_meta?user=king
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.76] request took 0.011694892 0.040172984
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.76] [1m[35m (0.4ms)[0m RELEASE SAVEPOINT active_record_1
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.76] Validate XML response: #ActionDispatch::Response:0x0000000779be70 took 0ms
[3941fe67-4a68-4010-a5ba-874d66c74e71] [361.76] Completed 200 OK in 98ms (Views: 1.0ms | ActiveRecord: 9.2ms | Backend: 40.2ms | XML: 0.0ms)
[95411acf-a89e-4052-a272-b36ca26dac67] [361.76] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-09-23 07:40:04 +0000
[95411acf-a89e-4052-a272-b36ca26dac67] [361.77] Processing by SourceController#package_meta as XML
[95411acf-a89e-4052-a272-b36ca26dac67] [361.77] Parameters: {"project"=>"kde4", "package"=>"kdebase"}
[95411acf-a89e-4052-a272-b36ca26dac67] [361.77] Validate XML request: #ActionDispatch::Request:0x0000000789c1d0
[95411acf-a89e-4052-a272-b36ca26dac67] [361.77] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"}
[95411acf-a89e-4052-a272-b36ca26dac67] [361.77] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[95411acf-a89e-4052-a272-b36ca26dac67] [361.77] USER found: king
[95411acf-a89e-4052-a272-b36ca26dac67] [361.77] User king initialised
[95411acf-a89e-4052-a272-b36ca26dac67] [361.77] [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
[95411acf-a89e-4052-a272-b36ca26dac67] [361.77] [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
[95411acf-a89e-4052-a272-b36ca26dac67] [361.78] [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
[95411acf-a89e-4052-a272-b36ca26dac67] [361.78] [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
[95411acf-a89e-4052-a272-b36ca26dac67] [361.78] [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
[95411acf-a89e-4052-a272-b36ca26dac67] [361.78] Validate XML response: #ActionDispatch::Response:0x0000000789c1a8 took 1ms
[95411acf-a89e-4052-a272-b36ca26dac67] [361.78] Completed 200 OK in 15ms (Views: 0.2ms | ActiveRecord: 1.8ms | Backend: 0.0ms | XML: 0.0ms)
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.78] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-23 07:40:04 +0000
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.78] Processing by SourceController#package_meta as XML
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.78] Parameters: {"project"=>"kde4", "package"=>"kdelibs"}
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.78] Validate XML request: #ActionDispatch::Request:0x0000000767a1e0
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.78] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"}
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.78] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.78] USER found: king
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.78] User king initialised
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.79] [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
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.79] [1m[36mProject Load (0.7ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (0)) ORDER BY `projects`.`id` ASC LIMIT 1[0m
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.79] [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
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.79] [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
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.79] [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
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.80] [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
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.80] [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
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.80] [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
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.80] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.80] Rendered models/_package.xml.builder (9.6ms)
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.91] Validate XML response: #ActionDispatch::Response:0x0000000767a1b8 took 106ms
[404b0351-ca1d-4d59-b83b-18ead1023093] [361.91] Completed 200 OK in 126ms (Views: 0.3ms | ActiveRecord: 3.2ms | Backend: 0.0ms | XML: 0.0ms)
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.91] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-23 07:40:04 +0000
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.91] Processing by SourceController#package_meta as XML
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.91] Parameters: {""\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n \n \n \n \n</package>\n", "project"=>"kde4", "package"=>"kdelibs"}
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.91] Validate XML request: #ActionDispatch::Request:0x00000003f0ea58
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.91] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.92] USER found: king
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.92] User king initialised
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.92] [1m[35mRole Exists (0.3ms)[0m SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.92] [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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.92] [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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.92] [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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.92] [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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] [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]]
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] [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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] [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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] flagcheck: package has default state, checking project
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] disabled_for sourceaccess repo: arch: state:enable
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] 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"})})
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] [1m[35m (0.1ms)[0m SAVEPOINT active_record_1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] [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]]
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] [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]]
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] [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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.93] [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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.94] [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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.94] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.94] update_activity 3.33690065859593e-12 10 2013-09-23 07:40:04 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.94] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.94] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000003338 WHERE `packages`.`id` = 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.94] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-23 07:40:04' WHERE `packages`.`id` = 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.94] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.94] [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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.95] [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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.95] Rendered models/_package.xml.builder (5.0ms)
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.95] [backend] PUT: /source/kde4/kdelibs/_meta?user=king
[352.62] 2013-09-23 07:40:04 [9221]: PUT /source/kde4/kdelibs/_meta?user=king
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.96] request took 0.016746935 0.016746935
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.97] [1m[36mRelationship Load (0.7ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id is not null)[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.97] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.97] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.97] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.97] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.97] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.97] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.97] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id is not null)
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.97] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.98] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]]
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.98] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.98] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.98] update_activity 10.0 4.580396193045157e-06 2013-09-23 07:40:04 +0000 2013-09-23 07:40:04 UTC 2013-09-23 07:40:04 UTC
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.98] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.98] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000004580396194 WHERE `packages`.`id` = 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.98] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-09-23 07:40:04' WHERE `packages`.`id` = 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.98] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 2 WHERE `packages`.`id` = 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.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` = 1 ORDER BY role_name, login[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.99] [1m[35m (0.3ms)[0m SELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, title
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.99] Rendered models/_package.xml.builder (4.9ms)
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [361.99] [backend] PUT: /source/kde4/kdelibs/_meta?user=king
[352.67] 2013-09-23 07:40:04 [9222]: PUT /source/kde4/kdelibs/_meta?user=king
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.00] request took 0.014901631 0.031648566
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.01] [1m[36mPackage Load (0.7ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.01] update_activity 10.000004768371582 2.860305485902009e-06 2013-09-23 07:40:04 +0000 2013-09-23 07:40:04 UTC 2013-09-23 07:40:04 UTC
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.01] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1379922004)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.01] [1m[36mSQL (0.3ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000007628677068 WHERE `packages`.`id` = 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.01] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-09-23 07:40:04' WHERE `packages`.`id` = 1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.01] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 3 WHERE `packages`.`id` = 1[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.02] [1m[35m (0.9ms)[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
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.02] [1m[36m (0.4ms)[0m [1mSELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 1 ORDER BY role_name, title[0m
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.02] Rendered models/_package.xml.builder (7.1ms)
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.02] [backend] PUT: /source/kde4/kdelibs/_meta?user=king
[352.70] 2013-09-23 07:40:04 [9223]: PUT /source/kde4/kdelibs/_meta?user=king
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.03] request took 0.012087488 0.043736054
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.03] [1m[35m (0.3ms)[0m RELEASE SAVEPOINT active_record_1
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.03] Validate XML response: #ActionDispatch::Response:0x00000003f0e1c0 took 1ms
[5ac6aceb-fdca-4526-85d1-abfa47b24419] [362.03] Completed 200 OK in 123ms (Views: 1.3ms | ActiveRecord: 12.9ms | Backend: 43.7ms | XML: 0.0ms)
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.04] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-09-23 07:40:04 +0000
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.04] Processing by SourceController#package_meta as XML
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.04] Parameters: {"project"=>"kde4", "package"=>"kdelibs"}
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.04] Validate XML request: #ActionDispatch::Request:0x00000006b7f038
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.04] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"}
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.04] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.04] USER found: king
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.04] User king initialised
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.04] [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
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.04] [1m[36mPackage Load (0.3ms)[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
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.05] [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
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.05] [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
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.05] [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
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.05] Validate XML response: #ActionDispatch::Response:0x00000006b7f010 took 2ms
[ad4522e1-38f6-467f-9724-126414cdb38b] [362.05] Completed 200 OK in 15ms (Views: 0.3ms | ActiveRecord: 1.8ms | Backend: 0.0ms | XML: 0.0ms)
[362.06] [1m[36m (5.3ms)[0m [1mROLLBACK[0m
[362.06] kill 1007
+ 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