See http://ci.opensuse.org/job/obs_master_testsuite_api/1875/changes Changes: [Stephan Kulow] [webui] move the query for requests into a function and cache it ------------------------------------------ [...truncated 212779 lines...] [2416066a-b367-442b-bddd-4623c4662064] [19040:356.08] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`maintenance_project_id` = 2 AND (projects.id not in (0))[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`project_id` = 2 AND (user_id is not null) [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 1 ORDER BY `users`.`id` ASC LIMIT 1[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 2 ORDER BY `users`.`id` ASC LIMIT 1[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]] [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]] [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1 [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fred' LIMIT 1[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [2416066a-b367-442b-bddd-4623c4662064] [19040:356.09] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' LIMIT 1[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.10] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [2416066a-b367-442b-bddd-4623c4662064] [19040:356.10] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`project_id` = 2 AND (group_id is not null)[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.10] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1 [2416066a-b367-442b-bddd-4623c4662064] [19040:356.10] [1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [["id", 3]] [2416066a-b367-442b-bddd-4623c4662064] [19040:356.10] [1m[35mCACHE (0.0ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1 [["id", 99]] [2416066a-b367-442b-bddd-4623c4662064] [19040:356.10] [1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [["id", 6]] [2416066a-b367-442b-bddd-4623c4662064] [19040:356.10] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1 [2416066a-b367-442b-bddd-4623c4662064] [19040:356.10] [1m[36mCACHE (0.0ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.10] [1m[35mCACHE (0.0ms)[0m SELECT `configurations`.* FROM `configurations` ORDER BY `configurations`.`id` ASC LIMIT 1 [2416066a-b367-442b-bddd-4623c4662064] [19040:356.10] [1m[36mDownload Load (0.2ms)[0m [1mSELECT `downloads`.* FROM `downloads` WHERE `downloads`.`db_project_id` = 2[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.11] write_to_backend [2416066a-b367-442b-bddd-4623c4662064] [19040:356.11] [1m[35mDbProjectType Load (0.2ms)[0m SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 1 LIMIT 1 [2416066a-b367-442b-bddd-4623c4662064] [19040:356.11] [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`.`project_id` = 2 ORDER BY role_name, login[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.11] [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`.`project_id` = 2 ORDER BY role_name, title [2416066a-b367-442b-bddd-4623c4662064] [19040:356.11] [1m[36mRepository Load (0.2ms)[0m [1mSELECT `repositories`.* FROM `repositories` WHERE `repositories`.`db_project_id` = 2 AND `repositories`.`remote_project_name` IS NULL[0m [2416066a-b367-442b-bddd-4623c4662064] [19040:356.11] Rendered models/_project.xml.builder (7.7ms) [2416066a-b367-442b-bddd-4623c4662064] [19040:356.11] [backend] PUT: /source/kde4/_meta?user=king [19047:343.38] 2013-10-25 18:04:23 [26971]: PUT /source/kde4/_meta?user=king [2416066a-b367-442b-bddd-4623c4662064] [19040:356.13] request took 0.012193014 0.012193014 [2416066a-b367-442b-bddd-4623c4662064] [19040:356.13] [1m[35m (0.4ms)[0m RELEASE SAVEPOINT active_record_1 [2416066a-b367-442b-bddd-4623c4662064] [19040:356.13] Validate XML response: #ActionDispatch::Response:0x000000098cacb8 took 0ms [2416066a-b367-442b-bddd-4623c4662064] [19040:356.13] Completed 200 OK in 61ms (Views: 1.1ms | ActiveRecord: 7.4ms | Backend: 12.2ms | XML: 0.0ms) [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.13] Started GET "/source/kde4/_meta" for 127.0.0.1 at 2013-10-25 18:04:23 +0000 [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.13] Processing by SourceController#show_project_meta as XML [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.13] Parameters: {"project"=>"kde4"} [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.13] Validate XML request: #ActionDispatch::Request:0x0000000a756098 [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.13] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_project_meta", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.13] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.14] USER found: king [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.14] User king initialised [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.14] [1m[35mRelationship Load (0.3ms)[0m SELECT ur.project_id, ur.user_id from flags f, relationships ur where f.flag = 'access' and f.status = 'disable' and ur.project_id = f.db_project_id [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.14] [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 [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.14] [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 [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.14] Validate XML response: #ActionDispatch::Response:0x0000000a756070 took 1ms [aac9690b-12ed-4457-90d8-eff979ce633b] [19040:356.14] Completed 200 OK in 9ms (Views: 0.1ms | ActiveRecord: 1.1ms | Backend: 0.0ms | XML: 0.0ms) [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.14] Started GET "/source/kde4" for 127.0.0.1 at 2013-10-25 18:04:23 +0000 [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.14] Processing by SourceController#show_project as XML [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.14] Parameters: {"project"=>"kde4"} [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.14] Validate XML request: #ActionDispatch::Request:0x0000000a7bd4c8 [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.14] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.15] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.15] USER found: king [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.15] User king initialised [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.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 [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.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 [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.15] [1m[35m (0.2ms)[0m SELECT `packages`.`name`, `packages`.`db_project_id` FROM `packages` WHERE `packages`.`db_project_id` = 2 AND (packages.db_project_id not in (0)) [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.15] [1m[36m (0.2ms)[0m [1mSELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (2) AND (projects.id not in (0))[0m [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.15] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.15] Validate XML response: #ActionDispatch::Response:0x0000000a7bd4a0 took 0ms [442097e2-afa2-4be1-b945-8cf72ee676f0] [19040:356.15] Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 1.2ms | Backend: 0.0ms | XML: 0.0ms) [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.15] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-10-25 18:04:23 +0000 [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.15] Processing by SourceController#show_package_meta as XML [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.15] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.15] Validate XML request: #ActionDispatch::Request:0x0000000a841408 [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.15] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.16] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.16] USER found: king [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.16] User king initialised [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.16] [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 [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.16] [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 [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.16] [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 [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.16] [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 [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.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 [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.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 [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.17] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC[0m [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.17] Rendered models/_package.xml.builder (6.0ms) [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.17] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"response"} [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.17] Validate XML response: #ActionDispatch::Response:0x0000000a8413e0 took 0ms [77a81c5b-3d4c-4cee-afad-e05697780461] [19040:356.17] Completed 200 OK in 16ms (Views: 0.2ms | ActiveRecord: 2.2ms | Backend: 0.0ms | XML: 0.2ms) [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.17] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-10-25 18:04:23 +0000 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.17] Processing by SourceController#update_package_meta as XML [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.17] Parameters: {"<package name"=>""kdebase" project="kde4">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.17] Validate XML request: #ActionDispatch::Request:0x0000000ad59f80 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.18] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.18] USER found: king [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.18] User king initialised [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.18] [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 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.18] [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 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.18] [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 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.18] [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 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] [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 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] [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]] [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] [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 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] [1m[35mFlag Exists (0.2ms)[0m SELECT 1 AS one FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.position ASC[0m [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] flagcheck: package has default state, checking project [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] disabled_for sourceaccess repo: arch: state:enable [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] [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]] [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] [1m[35mCACHE (0.0ms)[0m SELECT 1 AS one FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [["db_project_id", 2]] [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.19] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (user_id is not null) [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.20] [1m[36mRelationship Load (0.3ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 AND (group_id is not null)[0m [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.20] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1382724263)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.20] update_activity 2.6334559329890073e-12 10 2013-10-25 18:04:23 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.20] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1382724263)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.20] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000002634 WHERE `packages`.`id` = 2 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.20] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-10-25 18:04:23' WHERE `packages`.`id` = 2[0m [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.20] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.20] [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 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.20] [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 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.21] Rendered models/_package.xml.builder (4.3ms) [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.21] [backend] PUT: /source/kde4/kdebase/_meta?user=king [19047:343.47] 2013-10-25 18:04:23 [26972]: PUT /source/kde4/kdebase/_meta?user=king [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.22] request took 0.013049477 0.013049477 [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.22] [1m[36m (0.4ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.33] Validate XML response: #ActionDispatch::Response:0x0000000ad59f58 took 114ms [f72563d1-10b8-4c6e-94ec-ccd7fb79c01a] [19040:356.34] Completed 200 OK in 161ms (Views: 1.1ms | ActiveRecord: 5.1ms | Backend: 13.0ms | XML: 0.0ms) [874c8133-c245-4909-aab5-142508587495] [19040:356.34] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-10-25 18:04:23 +0000 [874c8133-c245-4909-aab5-142508587495] [19040:356.34] Processing by SourceController#show_package_meta as XML [874c8133-c245-4909-aab5-142508587495] [19040:356.34] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [874c8133-c245-4909-aab5-142508587495] [19040:356.34] Validate XML request: #ActionDispatch::Request:0x000000043e49b0 [874c8133-c245-4909-aab5-142508587495] [19040:356.34] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [874c8133-c245-4909-aab5-142508587495] [19040:356.34] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [874c8133-c245-4909-aab5-142508587495] [19040:356.34] USER found: king [874c8133-c245-4909-aab5-142508587495] [19040:356.34] User king initialised [874c8133-c245-4909-aab5-142508587495] [19040:356.34] [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 [874c8133-c245-4909-aab5-142508587495] [19040:356.35] [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 [874c8133-c245-4909-aab5-142508587495] [19040:356.35] [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 [874c8133-c245-4909-aab5-142508587495] [19040:356.35] [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 [874c8133-c245-4909-aab5-142508587495] [19040:356.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 [874c8133-c245-4909-aab5-142508587495] [19040:356.35] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"response"} [874c8133-c245-4909-aab5-142508587495] [19040:356.35] Validate XML response: #ActionDispatch::Response:0x000000043e4938 took 0ms [874c8133-c245-4909-aab5-142508587495] [19040:356.35] Completed 200 OK in 14ms (Views: 0.2ms | ActiveRecord: 1.7ms | Backend: 0.0ms | XML: 0.0ms) [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.35] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-10-25 18:04:23 +0000 [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.36] Processing by SourceController#show_package_meta as XML [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.36] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.36] Validate XML request: #ActionDispatch::Request:0x00000004975960 [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.36] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.36] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.36] USER found: king [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.36] User king initialised [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.36] [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 [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.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 [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.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 [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.36] [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 [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.37] [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 [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.37] [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 [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.37] [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 [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.37] [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 [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.38] [1m[36mFlag Load (0.3ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC[0m [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.38] Rendered models/_package.xml.builder (10.5ms) [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.38] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"response"} [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.38] Validate XML response: #ActionDispatch::Response:0x000000049758e8 took 0ms [5bb7a804-8087-4e8f-9ba3-0c3d7120aba8] [19040:356.38] Completed 200 OK in 21ms (Views: 0.2ms | ActiveRecord: 3.0ms | Backend: 0.0ms | XML: 0.0ms) [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.38] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-10-25 18:04:23 +0000 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.38] Processing by SourceController#update_package_meta as XML [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.38] Parameters: {"<package name"=>""kdelibs" project="kde4">\n <title>blub</title>\n <description>blub</description>\n <devel project="home:coolo:test" package="kdelibs_DEVEL_package"/>\n <person userid="fredlibs" role="maintainer"/>\n <person userid="adrian" role="reviewer"/>\n <group groupid="test_group" role="maintainer"/>\n</package>\n", "project"=>"kde4", "package"=>"kdelibs"} [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.38] Validate XML request: #ActionDispatch::Request:0x0000000926b340 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.38] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.38] USER found: king [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.38] User king initialised [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.39] [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 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.39] [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 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.39] [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 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.39] [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 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.39] [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 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.39] [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]] [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] [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 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] [1m[35mFlag Exists (0.2ms)[0m SELECT 1 AS one FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] [1m[36mFlag Load (0.3ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.position ASC[0m [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] flagcheck: package has default state, checking project [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] disabled_for sourceaccess repo: arch: state:enable [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] 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"})}) [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] [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]] [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] [1m[35mCACHE (0.0ms)[0m SELECT 1 AS one FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1 [["db_project_id", 2]] [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] [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 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.40] [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 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.41] [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 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.41] [1m[36mRelationship Load (0.3ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (user_id is not null)[0m [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.41] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.41] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.41] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.41] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.41] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.41] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.41] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 AND (group_id is not null) [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.41] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.42] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]] [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.42] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.42] [1m[35mPackage Load (0.2ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1382724263)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.42] update_activity 2.6334559329890073e-12 10 2013-10-25 18:04:23 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.42] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1382724263)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.42] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000002634 WHERE `packages`.`id` = 1 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.42] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-10-25 18:04:23' WHERE `packages`.`id` = 1[0m [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.42] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.42] [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 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.43] [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 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.43] Rendered models/_package.xml.builder (4.8ms) [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.43] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [19047:343.69] 2013-10-25 18:04:23 [26973]: PUT /source/kde4/kdelibs/_meta?user=king [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.44] request took 0.011007615 0.011007615 [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.44] [1m[36m (0.4ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.44] Validate XML response: #ActionDispatch::Response:0x0000000926b318 took 0ms [112a4dac-bfdc-44d7-bbb3-30290792becc] [19040:356.44] Completed 200 OK in 61ms (Views: 1.1ms | ActiveRecord: 7.7ms | Backend: 11.0ms | XML: 0.0ms) [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.44] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-10-25 18:04:23 +0000 [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.44] Processing by SourceController#show_package_meta as XML [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.44] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.45] Validate XML request: #ActionDispatch::Request:0x0000000a04b960 [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.45] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.45] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.45] USER found: king [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.45] User king initialised [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.45] [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 [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.45] [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 [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.45] [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 [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.45] [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 [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.46] [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 [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.46] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"response"} [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.46] Validate XML response: #ActionDispatch::Response:0x0000000a04b938 took 0ms [91dc6261-30fa-4b70-ba10-d2c715926299] [19040:356.46] Completed 200 OK in 12ms (Views: 0.1ms | ActiveRecord: 1.4ms | Backend: 0.0ms | XML: 0.0ms) [19040:356.46] [1m[35m (4.4ms)[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/log/test.searchd.log src/api/log/test.searchd.query.log src/api/tmp/backend_config src/api/tmp/backend_data src/api/tmp/binlog src/api/tmp/cache src/api/tmp/miniprofiler src/api/tmp/pids src/api/tmp/scheduler.done src/api/tmp/sessions src/api/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