See <http://ci.opensuse.org/job/obs_master_testsuite_api/1934/changes> Changes: [adrian] [api] support channel specific update info templates ------------------------------------------ [...truncated 216385 lines...] [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.83] xml_disabled? X({"name"=>"kde4", "title"=>"blub", "description"=>"bla", "person"=>[X({"userid"=>"fred", "role"=>"maintainer"}), X({"userid"=>"fredlibs", "role"=>"maintainer"}), X({"userid"=>"king", "role"=>"maintainer"}), X({"userid"=>"adrian", "role"=>"reviewer"})], "group"=>[X({"groupid"=>"test_group", "role"=>"maintainer"}), X({"groupid"=>"test_group", "role"=>"reviewer"})]}) [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.83] ### name comparison: self.name -> kde4, project_name -> kde4 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.83] [1m[35mDbProjectType Load (0.2ms)[0m SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`name` = 'standard' LIMIT 1 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.83] [1m[36mLinkedProject Load (0.3ms)[0m [1mSELECT `linked_projects`.* FROM `linked_projects` WHERE `linked_projects`.`db_project_id` = 2 ORDER BY `linked_projects`.`position` ASC[0m [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.83] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`maintenance_project_id` = 2 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.83] [1m[36mRelationship Load (0.2ms)[0m [1mSELECT `relationships`.* FROM `relationships` WHERE `relationships`.`project_id` = 2[0m [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.83] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 1 ORDER BY `users`.`id` ASC LIMIT 1 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.83] [1m[36mRole Load (0.4ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.84] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 ORDER BY `users`.`id` ASC LIMIT 1 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.84] [1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [["id", 3]] [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.84] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.84] [1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [["id", 3]] [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.84] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.84] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.84] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fred' LIMIT 1 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.84] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1[0m [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.84] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' LIMIT 1 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.84] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1[0m [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.84] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.85] [1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1[0m [["id", 3]] [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.85] [1m[35mCACHE (0.0ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1 [["id", 99]] [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.85] [1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1[0m [["id", 6]] [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.85] [1m[35mGroup Load (0.4ms)[0m SELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.85] [1m[36mCACHE (0.0ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.85] [1m[35mDownload Load (0.2ms)[0m SELECT `downloads`.* FROM `downloads` WHERE `downloads`.`db_project_id` = 2 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.85] [1m[36mSQL (0.2ms)[0m [1mUPDATE `projects` SET `updated_at` = '2013-11-08 10:14:57' WHERE `projects`.`id` = 2[0m [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.85] write_to_backend [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.85] [1m[35mDbProjectType Load (0.2ms)[0m SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 1 LIMIT 1 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.86] [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 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.86] [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 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.86] [1m[36mRepository Load (0.2ms)[0m [1mSELECT `repositories`.* FROM `repositories` WHERE `repositories`.`db_project_id` = 2 AND `repositories`.`remote_project_name` IS NULL[0m [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.86] Rendered models/_project.xml.builder (7.6ms) [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.86] [backend] PUT: /source/kde4/_meta?user=king [20024:338.72] 2013-11-08 10:14:57 [28255]: PUT /source/kde4/_meta?user=king [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.87] request took 0.010147244 0.010147244 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.87] [1m[35m (0.1ms)[0m RELEASE SAVEPOINT active_record_1 [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.87] Validate XML response: #<ActionDispatch::Response:0x00000007d43468> took 1ms [ab596c6e-87a6-4e05-818c-111789dfcf8d] [19987:350.87] Completed 200 OK in 59ms (Views: 1.0ms | ActiveRecord: 7.4ms | Backend: 10.1ms | XML: 0.0ms) [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.88] Started GET "/source/kde4/_meta" for 127.0.0.1 at 2013-11-08 10:14:57 +0000 [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.88] Processing by SourceController#show_project_meta as XML [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.88] Parameters: {"project"=>"kde4"} [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.88] Validate XML request: #<ActionDispatch::Request:0x000000095af510> [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.88] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_project_meta", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.88] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.88] USER found: king [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.88] User king initialised [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.88] [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 [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.88] [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 [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.89] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`name` = 'kde4' ORDER BY `projects`.`id` ASC LIMIT 1 [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.89] Validate XML response: #<ActionDispatch::Response:0x000000095af4e8> took 2ms [fcac1541-460c-4883-b01e-06c52b0c3ea3] [19987:350.89] Completed 200 OK in 11ms (Views: 0.1ms | ActiveRecord: 1.2ms | Backend: 0.0ms | XML: 0.0ms) [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.89] Started GET "/source/kde4" for 127.0.0.1 at 2013-11-08 10:14:57 +0000 [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.89] Processing by SourceController#show_project as XML [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.89] Parameters: {"project"=>"kde4"} [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.89] Validate XML request: #<ActionDispatch::Request:0x000000099dce08> [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.89] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"} [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.89] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.89] USER found: king [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.89] User king initialised [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.89] [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 [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.89] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`name` = 'kde4' ORDER BY `projects`.`id` ASC LIMIT 1[0m [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.90] [1m[35m (0.2ms)[0m SELECT `packages`.`name`, `packages`.`db_project_id` FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`db_project_id` = 2 [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.90] [1m[36m (0.2ms)[0m [1mSELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`id` IN (2)[0m [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.90] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_project", "project"=>"kde4", "method"=>"GET", "type"=>"response"} [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.90] Validate XML response: #<ActionDispatch::Response:0x000000099dcd68> took 0ms [57f0ec33-3770-4f21-a22a-5f782c45d511] [19987:350.90] Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 1.1ms | Backend: 0.0ms | XML: 0.0ms) [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.90] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-11-08 10:14:57 +0000 [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.90] Processing by SourceController#show_package_meta as XML [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.90] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.90] Validate XML request: #<ActionDispatch::Request:0x0000000939f978> [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.90] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.90] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.90] USER found: king [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.90] User king initialised [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.90] [1m[36mRole Exists (0.2ms)[0m [1mSELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1[0m [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.90] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`name` = 'kde4' ORDER BY `projects`.`id` ASC LIMIT 1 [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.91] [1m[36mPackage Load (0.3ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' LIMIT 1[0m [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.91] [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 [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.91] [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 [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.91] [1m[35mFlag Load (0.5ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.`position` ASC [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.91] Rendered models/_package.xml.builder (6.0ms) [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.91] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"response"} [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.91] Validate XML response: #<ActionDispatch::Response:0x0000000939f928> took 0ms [e8b85fbe-353d-4fa2-ba03-6748f6c164bd] [19987:350.91] Completed 200 OK in 14ms (Views: 0.2ms | ActiveRecord: 2.2ms | Backend: 0.0ms | XML: 0.2ms) [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.92] Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-11-08 10:14:57 +0000 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.92] Processing by SourceController#update_package_meta as XML [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.92] Parameters: {"<package name"=>"\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"} [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.92] Can't verify CSRF token authenticity [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.92] Validate XML request: #<ActionDispatch::Request:0x00000009d60de0> [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.92] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.92] USER found: king [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.92] User king initialised [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.92] [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 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.92] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`name` = 'kde4' ORDER BY `projects`.`id` ASC LIMIT 1[0m [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.93] [1m[35mPackage Load (0.0ms)[0m SELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' LIMIT 1 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.93] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.93] [1m[35mSQL (0.2ms)[0m INSERT INTO `cache_lines` (`created_at`, `key`, `package`, `project`) VALUES ('2013-11-08 10:14:57', 'projects/2-20131108101457000000000/exists_package/kdebase/allow_remote_packages=false/follow_project_links=false', 'kdebase', 'kde4') [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.93] [1m[36m (0.1ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.93] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`id` = 2 ORDER BY `packages`.`id` ASC LIMIT 1 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.93] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`id` = 2 ORDER BY `projects`.`id` ASC LIMIT 1[0m [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.93] [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 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.93] [1m[36mFlag Exists (0.2ms)[0m [1mSELECT 1 AS one FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY `flags`.`position` ASC [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] flagcheck: package has default state, checking project [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] disabled_for sourceaccess repo: arch: state:enable [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] xml_disabled? X({"name"=>"kdebase", "project"=>"kde4", "title"=>"blub", "description"=>"blub"}) [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] [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]] [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 2 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] [1m[36mPackage Load (0.4ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1383905697)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1[0m [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] update_activity 2.3832974904642295e-12 10 2013-11-08 10:14:57 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] [1m[35mCACHE (0.0ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1383905697)/10000000 ) ) as activity_value FROM `packages` WHERE id = 2 LIMIT 1 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`activity_index` = 10.000000000002384 WHERE `packages`.`id` = 2[0m [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `packages`.`updated_at` = '2013-11-08 10:14:57' WHERE `packages`.`id` = 2 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.94] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 2[0m [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.95] [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 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.95] [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 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.95] Rendered models/_package.xml.builder (4.2ms) [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.95] [backend] PUT: /source/kde4/kdebase/_meta?user=king [20024:338.81] 2013-11-08 10:14:57 [28256]: PUT /source/kde4/kdebase/_meta?user=king [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.96] request took 0.01083211 0.01083211 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.96] [1m[35m (0.1ms)[0m RELEASE SAVEPOINT active_record_1 [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.96] Validate XML response: #<ActionDispatch::Response:0x00000009d60d68> took 0ms [736a650a-cdfe-4a87-848a-4875ddba7a11] [19987:350.96] Completed 200 OK in 44ms (Views: 0.9ms | ActiveRecord: 4.4ms | Backend: 10.8ms | XML: 0.0ms) [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.96] Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2013-11-08 10:14:57 +0000 [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.96] Processing by SourceController#show_package_meta as XML [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.96] Parameters: {"project"=>"kde4", "package"=>"kdebase"} [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.96] Validate XML request: #<ActionDispatch::Request:0x00000009fb8a98> [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.96] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"} [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.97] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.97] USER found: king [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.97] User king initialised [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.97] [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 [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.97] [1m[36mPackage Load (0.1ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`id` = 2 ORDER BY `packages`.`id` ASC LIMIT 1[0m [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.97] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`name` = 'kde4' ORDER BY `projects`.`id` ASC LIMIT 1 [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.97] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdebase' LIMIT 1[0m [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.97] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"response"} [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.97] Validate XML response: #<ActionDispatch::Response:0x00000009fb9010> took 0ms [9ac14e08-1254-40c4-ae66-7d48a13eb4e8] [19987:350.97] Completed 200 OK in 10ms (Views: 0.1ms | ActiveRecord: 1.1ms | Backend: 0.0ms | XML: 0.0ms) [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.98] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-11-08 10:14:57 +0000 [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.98] Processing by SourceController#show_package_meta as XML [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.98] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.98] Validate XML request: #<ActionDispatch::Request:0x0000000a005ff0> [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.98] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.98] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.98] USER found: king [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.98] User king initialised [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.98] [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 [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.98] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`name` = 'kde4' ORDER BY `projects`.`id` ASC LIMIT 1 [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.98] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' LIMIT 1[0m [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.99] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`id` = 1234 ORDER BY `packages`.`id` ASC LIMIT 1 [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.99] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`id` = 601 ORDER BY `projects`.`id` ASC LIMIT 1[0m [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.99] [1m[35m (0.4ms)[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 [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.99] [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 [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.99] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.`position` ASC [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:350.99] Rendered models/_package.xml.builder (10.0ms) [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:351.00] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"response"} [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:351.00] Validate XML response: #<ActionDispatch::Response:0x0000000a005fc8> took 0ms [b7286b33-7f61-4ea3-b35a-d5fd3dfbc57e] [19987:351.00] Completed 200 OK in 18ms (Views: 0.2ms | ActiveRecord: 2.4ms | Backend: 0.0ms | XML: 0.0ms) [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.00] Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-11-08 10:14:57 +0000 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.00] Processing by SourceController#update_package_meta as XML [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.00] 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"} [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.00] Can't verify CSRF token authenticity [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.00] Validate XML request: #<ActionDispatch::Request:0x0000000a0cf440> [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.00] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.00] USER found: king [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.00] User king initialised [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.01] [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 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.01] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`name` = 'kde4' ORDER BY `projects`.`id` ASC LIMIT 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.01] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' LIMIT 1 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.01] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.01] [1m[35mSQL (0.2ms)[0m INSERT INTO `cache_lines` (`created_at`, `key`, `package`, `project`) VALUES ('2013-11-08 10:14:57', 'projects/2-20131108101457000000000/exists_package/kdelibs/allow_remote_packages=false/follow_project_links=false', 'kdelibs', 'kde4') [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.01] [1m[36m (0.1ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.01] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`id` = 1 ORDER BY `packages`.`id` ASC LIMIT 1 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.01] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`id` = 2 ORDER BY `projects`.`id` ASC LIMIT 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] [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 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] [1m[36mFlag Exists (0.2ms)[0m [1mSELECT 1 AS one FROM `flags` WHERE `flags`.`db_project_id` = 2 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY `flags`.`position` ASC [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] flagcheck: package has default state, checking project [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] disabled_for sourceaccess repo: arch: state:enable [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] 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"})}) [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] [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]] [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`name` = 'home:coolo:test' ORDER BY `projects`.`id` ASC LIMIT 1 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`db_project_id` = 601 AND `packages`.`name` = 'kdelibs_DEVEL_package' LIMIT 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] [1m[35mRelationship Load (0.2ms)[0m SELECT `relationships`.* FROM `relationships` WHERE `relationships`.`package_id` = 1 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.02] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY `users`.`id` ASC LIMIT 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 ORDER BY `roles`.`id` ASC LIMIT 1 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' LIMIT 1 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 ORDER BY `groups`.`id` ASC LIMIT 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 ORDER BY `roles`.`id` ASC LIMIT 1 [["id", 3]] [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] [1m[35mPackage Load (0.3ms)[0m SELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1383905697)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] update_activity 2.3832974904642295e-12 10 2013-11-08 10:14:57 +0000 2002-02-02 03:02:02 UTC 2002-02-02 03:02:02 UTC [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] [1m[36mCACHE (0.0ms)[0m [1mSELECT packages.*, ( packages.activity_index * POWER( 2.3276, (UNIX_TIMESTAMP(packages.updated_at) - 1383905697)/10000000 ) ) as activity_value FROM `packages` WHERE id = 1 LIMIT 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.03] [1m[35mSQL (0.1ms)[0m UPDATE `packages` SET `packages`.`activity_index` = 10.000000000002384 WHERE `packages`.`id` = 1 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.04] [1m[36mSQL (0.2ms)[0m [1mUPDATE `packages` SET `packages`.`updated_at` = '2013-11-08 10:14:57' WHERE `packages`.`id` = 1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.04] [1m[35mSQL (0.2ms)[0m UPDATE `packages` SET `update_counter` = 1 WHERE `packages`.`id` = 1 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.04] [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 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.04] [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 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.04] Rendered models/_package.xml.builder (5.0ms) [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.04] [backend] PUT: /source/kde4/kdelibs/_meta?user=king [20024:338.90] 2013-11-08 10:14:57 [28257]: PUT /source/kde4/kdelibs/_meta?user=king [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.05] request took 0.011971092 0.011971092 [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.06] [1m[36m (0.1ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.06] Validate XML response: #<ActionDispatch::Response:0x0000000a0cf418> took 0ms [0b4190e8-198c-40d8-96af-0d0ff8863442] [19987:351.06] Completed 200 OK in 58ms (Views: 1.0ms | ActiveRecord: 6.8ms | Backend: 12.0ms | XML: 0.0ms) [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.06] Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2013-11-08 10:14:57 +0000 [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.06] Processing by SourceController#show_package_meta as XML [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.06] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.06] Validate XML request: #<ActionDispatch::Request:0x0000000a376c20> [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.06] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.06] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.06] USER found: king [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.06] User king initialised [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.07] [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 [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.07] [1m[35mPackage Load (0.2ms)[0m SELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`id` = 1 ORDER BY `packages`.`id` ASC LIMIT 1 [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.07] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (projects.id not in (0)) AND `projects`.`name` = 'kde4' ORDER BY `projects`.`id` ASC LIMIT 1[0m [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.07] [1m[35mPackage Load (0.3ms)[0m SELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0)) AND `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs' LIMIT 1 [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.07] no schema found, skipping validation for {"controller"=>"source", "action"=>"show_package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"response"} [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.07] Validate XML response: #<ActionDispatch::Response:0x0000000a376bf8> took 0ms [fe65ec98-c404-476c-aed2-07fc697dc4ca] [19987:351.07] Completed 200 OK in 11ms (Views: 0.1ms | ActiveRecord: 1.4ms | Backend: 0.0ms | XML: 0.0ms) [19987:351.08] [1m[36m (4.5ms)[0m [1mROLLBACK[0m + echo + cleanup + echo 'Killing backend processes' Killing backend processes + egrep 'perl|ruby' + fuser -v <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/> USER PID ACCESS COMMAND <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/>: ci ..c.. 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/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