[obs-tests] Build failed in Jenkins: obs_master_testsuite_api #1238
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1238/changes> Changes: [Stephan Kulow] [dist] update to current gems [Stephan Kulow] [api] validate package name to be valid [Stephan Kulow] [webui] port one more test to capybara [adrian] [dist] add note to restart memcached after database migration. [adrian] [api] reset cache of project/package meta xml also in failure case when write to backend failed [Stephan Kulow] [api] add a broken test case for later investigation [Stephan Kulow] [webui] port another test to capybara [adrian] [backend] Add support to define package support states and create .kwd files for kiwi ------------------------------------------ [...truncated 32683 lines...] [[0;37mDEBUG[0m|#26947] [1m[36mRole Load (0.2ms)[0m [1mSELECT DISTINCT roles.id FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 4 AND `roles`.`title` = 'Admin' LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (3000,3006)) LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mPackage Load (0.2ms)[0m [1mSELECT `packages`.* FROM `packages` WHERE `packages`.`db_project_id` = 2 AND `packages`.`name` = 'kdelibs-not' AND (packages.db_project_id not in (3000,3006)) LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [1m[35mLinkedProject Load (0.2ms)[0m SELECT `linked_projects`.* FROM `linked_projects` WHERE `linked_projects`.`db_project_id` = 2 ORDER BY position [[0;37mDEBUG[0m|#26947] Package::UnknownObjectError: errorcode kde4/kdelibs-not <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/app/models/package.rb>:92:in `get_by_project_and_name' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/app/controllers/wizard_controller.rb>:9:in `package_wizard' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/test/test_helper.rb>:47:in `process' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/test/functional/wizard_controller_test.rb>:17:in `test_wizard' [[31mERROR[0m|#26947] ReadAccessError: kde4/kdelibs-not [[32mINFO [0m|#26947] Completed 404 Not Found in 9ms (Views: 0.6ms | ActiveRecord: 0.9ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#26947] Started GET "/source/kde4/kdelibs/_wizard" for 127.0.0.1 at 2012-12-03 15:14:37 +0100 [[32mINFO [0m|#26947] Processing by WizardController#package_wizard as XML [[32mINFO [0m|#26947] Parameters: {"project"=>"kde4", "package"=>"kdelibs"} [[0;37mDEBUG[0m|#26947] Validate XML request: #<ActionDispatch::Request:0x00000004d37328> [[0;37mDEBUG[0m|#26947] no schema found, skipping validation for {"format"=>"xml", "controller"=>"wizard", "action"=>"package_wizard", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#26947] AUTH: ["Basic", "ZnJlZGxpYnM6Z2Vyw7ZsbGhlaW1lcg=="] [[0;37mDEBUG[0m|#26947] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'fredlibs') LIMIT 1[0m [[0;37mDEBUG[0m|#26947] USER found: fredlibs [[0;37mDEBUG[0m|#26947] User fredlibs initialised [[0;37mDEBUG[0m|#26947] get_by_project_and_name {} [[0;37mDEBUG[0m|#26947] [1m[35mRole Load (0.2ms)[0m SELECT DISTINCT roles.id FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 4 AND `roles`.`title` = 'Admin' LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'kde4' AND (projects.id not in (3000,3006)) LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [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 (3000,3006)) LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 AND (projects.id not in (3000,3006)) LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position [[0;37mDEBUG[0m|#26947] flagcheck: package has default state, checking project [[0;37mDEBUG[0m|#26947] [1m[36mFlag Load (0.1ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m [[0;37mDEBUG[0m|#26947] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|#26947] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|#26947] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' ORDER BY position LIMIT 1 [[0;37mDEBUG[0m|#26947] [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 [[0;37mDEBUG[0m|#26947] has_global_permission? change_package [[0;37mDEBUG[0m|#26947] [1m[35mRole Load (0.2ms)[0m SELECT DISTINCT `roles`.* FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 4 [[0;37mDEBUG[0m|#26947] [1m[36mRolesStaticPermission Load (0.2ms)[0m [1mSELECT role_id FROM `roles_static_permissions` INNER JOIN `static_permissions` ON `static_permissions`.`id` = `roles_static_permissions`.`static_permission_id` WHERE `static_permissions`.`title` = 'change_package'[0m [[0;37mDEBUG[0m|#26947] running local permission check: user fredlibs, package kdelibs, permission 'change_package' [[0;37mDEBUG[0m|#26947] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 1 AND `package_user_role_relationships`.`bs_user_id` = 4 AND (role_id in (1,3)) LIMIT 1 [[0;37mDEBUG[0m|#26947] package_wizard, {"format"=>"xml", "controller"=>"wizard", "action"=>"package_wizard", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#26947] --> direct_http url: #<URI::Generic:0x000000052da820 URL:/source/kde4/kdelibs/wizard.xml> [[0;37mDEBUG[0m|#26947] ActiveXML::Transport::ConnectionError: errorcode Failed to establish connection for http://localhost:3200/source/kde4/kdelibs/wizard.xml: Connection refused - connect(2) <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/lib/activexml/transport.rb>:369:in `rescue in http_do' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/lib/activexml/transport.rb>:388:in `http_do' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/lib/activexml/transport.rb>:219:in `direct_http' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/app/controllers/application_controller.rb>:650:in `backend_get' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/app/controllers/wizard_controller.rb>:21:in `package_wizard' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/test/test_helper.rb>:47:in `process' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/test/functional/wizard_controller_test.rb>:21:in `test_wizard' [[32mINFO [0m|#26947] Completed 400 Bad Request in 18ms (Views: 0.6ms | ActiveRecord: 2.1ms | Backend: 0.0ms | XML: 0.1ms) [[0;37mDEBUG[0m|#26947] [1m[36m (0.1ms)[0m [1mROLLBACK[0m [[0;37mDEBUG[0m|#26947] [1m[35m (0.0ms)[0m BEGIN [[32mINFO [0m|#26947] Started GET "/source/My:Maintenance/_meta" for 127.0.0.1 at 2012-12-03 15:14:38 +0100 [[32mINFO [0m|#26947] Processing by SourceController#project_meta as XML [[32mINFO [0m|#26947] Parameters: {"project"=>"My:Maintenance"} [[0;37mDEBUG[0m|#26947] Validate XML request: #<ActionDispatch::Request:0x00000004fc4b18> [[0;37mDEBUG[0m|#26947] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"project_meta", "project"=>"My:Maintenance", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#26947] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="] [[0;37mDEBUG[0m|#26947] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m [[0;37mDEBUG[0m|#26947] USER found: king [[0;37mDEBUG[0m|#26947] User king initialised [[0;37mDEBUG[0m|#26947] checking local project My, remote_project Maintenance [[0;37mDEBUG[0m|#26947] [1m[35mProjectUserRoleRelationship Load (0.2ms)[0m SELECT ur.db_project_id, ur.bs_user_id from flags f, project_user_role_relationships ur where f.flag = 'access' and ur.db_project_id = f.db_project_id [[0;37mDEBUG[0m|#26947] [1m[36mRole Load (0.2ms)[0m [1mSELECT DISTINCT roles.id 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 [[0;37mDEBUG[0m|#26947] [1m[35mProject Load (0.1ms)[0m SELECT id,name,remoteurl FROM `projects` WHERE `projects`.`name` = 'My' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'My:Maintenance' AND (projects.id not in (0)) LIMIT 1[0m [[0;37mDEBUG[0m|#26947] ----------------- rendering project My:Maintenance ------------------------ [[0;37mDEBUG[0m|#26947] [1m[35mDbProjectType Load (0.1ms)[0m SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 2 LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mCACHE (0.0ms)[0m [1mSELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 2 LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [1m[35mCACHE (0.0ms)[0m SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 2 LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mLinkedProject Load (0.2ms)[0m [1mSELECT `linked_projects`.* FROM `linked_projects` WHERE `linked_projects`.`db_project_id` = 2048 ORDER BY position[0m [[0;37mDEBUG[0m|#26947] [1m[35mProjectUserRoleRelationship Load (0.2ms)[0m SELECT users.login as login, roles.title as roletitle FROM `project_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `project_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `project_user_role_relationships`.`bs_user_id` WHERE `project_user_role_relationships`.`db_project_id` = 2048 [[0;37mDEBUG[0m|#26947] [1m[36mProjectGroupRoleRelationship Load (0.2ms)[0m [1mSELECT groups.title as grouptitle, roles.title as roletitle FROM `project_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `project_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `project_group_role_relationships`.`bs_group_id` WHERE `project_group_role_relationships`.`db_project_id` = 2048[0m [[0;37mDEBUG[0m|#26947] [1m[35mDownload Load (0.1ms)[0m SELECT `downloads`.* FROM `downloads` WHERE `downloads`.`db_project_id` = 2048 [[0;37mDEBUG[0m|#26947] [1m[36mRepository Load (0.2ms)[0m [1mSELECT `repositories`.* FROM `repositories` WHERE `repositories`.`db_project_id` = 2048 AND `repositories`.`remote_project_name` IS NULL[0m [[0;37mDEBUG[0m|#26947] [1m[35mFlag Load (0.1ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2048 [[0;37mDEBUG[0m|#26947] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`maintenance_project_id` = 2048 AND (projects.id not in (0))[0m [[0;37mDEBUG[0m|#26947] ----------------- end rendering project My:Maintenance ------------------------ [[0;37mDEBUG[0m|#26947] Validate XML response: #<ActionDispatch::Response:0x00000004fc4af0> took 2ms [[32mINFO [0m|#26947] Completed 200 OK in 20ms (Views: 0.4ms | ActiveRecord: 2.3ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#26947] Started GET "/search/project?match=%5Bmaintenance%2Fmaintains%2F%40project%3D%22BaseDistro2.0%3ALinkedUpdateProject%22%5D" for 127.0.0.1 at 2012-12-03 15:14:38 +0100 [[32mINFO [0m|#26947] Processing by SearchController#project as XML [[32mINFO [0m|#26947] Parameters: {"match"=>"[maintenance/maintains/@project=\"BaseDistro2.0:LinkedUpdateProject\"]"} [[0;37mDEBUG[0m|#26947] Validate XML request: #<ActionDispatch::Request:0x000000056715d8> [[0;37mDEBUG[0m|#26947] no schema found, skipping validation for {"match"=>"[maintenance/maintains/@project=\"BaseDistro2.0:LinkedUpdateProject\"]", "format"=>"xml", "controller"=>"search", "action"=>"project", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#26947] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="] [[0;37mDEBUG[0m|#26947] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#26947] USER found: king [[0;37mDEBUG[0m|#26947] User king initialised [[0;37mDEBUG[0m|#26947] searching in projects, predicate: 'maintenance/maintains/@project="BaseDistro2.0:LinkedUpdateProject"' [[0;37mDEBUG[0m|#26947] Class.find_each {:select=>"distinct(projects.id),projects.*", :include=>[:repositories], :joins=>"LEFT JOIN projects AS maintained ON projects.id = maintained.maintenance_project_id", :conditions=>["1 AND maintained.name = ?", "BaseDistro2.0:LinkedUpdateProject"], :order=>nil, :group=>"projects.id"} [[0;37mDEBUG[0m|#26947] [1m[36mRole Load (0.2ms)[0m [1mSELECT DISTINCT roles.id 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 [[0;37mDEBUG[0m|#26947] [1m[35mProject Load (0.2ms)[0m SELECT DISTINCT `projects`.id FROM `projects` LEFT OUTER JOIN `repositories` ON `repositories`.`db_project_id` = `projects`.`id` LEFT JOIN projects AS maintained ON projects.id = maintained.maintenance_project_id WHERE (projects.id not in (0)) AND (1 AND maintained.name = 'BaseDistro2.0:LinkedUpdateProject') AND (`projects`.`id` >= 0) ORDER BY `projects`.`id` ASC LIMIT 1000 [[0;37mDEBUG[0m|#26947] [1m[36mSQL (0.3ms)[0m [1mSELECT `projects`.`id` AS t0_r0, `projects`.`name` AS t0_r1, `projects`.`title` AS t0_r2, `projects`.`description` AS t0_r3, `projects`.`created_at` AS t0_r4, `projects`.`updated_at` AS t0_r5, `projects`.`remoteurl` AS t0_r6, `projects`.`remoteproject` AS t0_r7, `projects`.`type_id` AS t0_r8, `projects`.`maintenance_project_id` AS t0_r9, `projects`.`develproject_id` AS t0_r10, `repositories`.`id` AS t1_r0, `repositories`.`db_project_id` AS t1_r1, `repositories`.`name` AS t1_r2, `repositories`.`remote_project_name` AS t1_r3, `repositories`.`rebuild` AS t1_r4, `repositories`.`block` AS t1_r5, `repositories`.`linkedbuild` AS t1_r6, `repositories`.`hostsystem_id` AS t1_r7 FROM `projects` LEFT OUTER JOIN `repositories` ON `repositories`.`db_project_id` = `projects`.`id` LEFT JOIN projects AS maintained ON projects.id = maintained.maintenance_project_id WHERE `projects`.`id` IN (2048) AND (projects.id not in (0)) AND (1 AND maintained.name = 'BaseDistro2.0:LinkedUpdateProject') AND (`projects`.`id` >= 0) ORDER BY `projects`.`id` ASC[0m [[0;37mDEBUG[0m|#26947] no schema found, skipping validation for {"match"=>"[maintenance/maintains/@project=\"BaseDistro2.0:LinkedUpdateProject\"]", "format"=>"xml", "controller"=>"search", "action"=>"project", "method"=>"GET", "type"=>"response"} [[0;37mDEBUG[0m|#26947] Validate XML response: #<ActionDispatch::Response:0x000000056715b0> took 0ms [[32mINFO [0m|#26947] Completed 200 OK in 9ms (Views: 0.3ms | ActiveRecord: 0.9ms | Backend: 0.0ms | XML: 0.0ms) [[0;37mDEBUG[0m|#26947] [1m[35m (0.1ms)[0m ROLLBACK [[0;37mDEBUG[0m|#26947] [1m[36m (0.0ms)[0m [1mBEGIN[0m [[32mINFO [0m|#26947] Started GET "/source" for 127.0.0.1 at 2012-12-03 15:14:38 +0100 [[32mINFO [0m|#26947] Processing by SourceController#index as XML [[0;37mDEBUG[0m|#26947] Validate XML request: #<ActionDispatch::Request:0x0000000590f6a0> [[0;37mDEBUG[0m|#26947] no schema found, skipping validation for {"format"=>"xml", "action"=>"index", "controller"=>"source", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#26947] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="] [[0;37mDEBUG[0m|#26947] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#26947] USER found: king [[0;37mDEBUG[0m|#26947] User king initialised [[0;37mDEBUG[0m|#26947] [1m[36mRole Load (0.2ms)[0m [1mSELECT DISTINCT roles.id 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 [[0;37mDEBUG[0m|#26947] [1m[35mProjectUserRoleRelationship Load (0.2ms)[0m SELECT ur.db_project_id, ur.bs_user_id from flags f, project_user_role_relationships ur where f.flag = 'access' and ur.db_project_id = f.db_project_id [[0;37mDEBUG[0m|#26947] [1m[36mProject Load (0.2ms)[0m [1mSELECT name FROM `projects` WHERE (projects.id not in (0))[0m [[0;37mDEBUG[0m|#26947] Validate XML response: #<ActionDispatch::Response:0x0000000590f678> took 1ms [[32mINFO [0m|#26947] Completed 200 OK in 7ms (Views: 0.3ms | ActiveRecord: 0.8ms | Backend: 0.0ms | XML: 0.0ms) [[32mINFO [0m|#26947] Started GET "/source/Apache/_meta" for 127.0.0.1 at 2012-12-03 15:14:38 +0100 [[32mINFO [0m|#26947] Processing by SourceController#project_meta as XML [[32mINFO [0m|#26947] Parameters: {"project"=>"Apache"} [[0;37mDEBUG[0m|#26947] Validate XML request: #<ActionDispatch::Request:0x00000005997708> [[0;37mDEBUG[0m|#26947] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"project_meta", "project"=>"Apache", "method"=>"GET", "type"=>"request"} [[0;37mDEBUG[0m|#26947] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="] [[0;37mDEBUG[0m|#26947] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#26947] USER found: king [[0;37mDEBUG[0m|#26947] User king initialised [[0;37mDEBUG[0m|#26947] [1m[36mRole Load (0.2ms)[0m [1mSELECT DISTINCT roles.id 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 [[0;37mDEBUG[0m|#26947] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'Apache' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26947] ----------------- rendering project Apache ------------------------ [[0;37mDEBUG[0m|#26947] [1m[36mLinkedProject Load (15.4ms)[0m [1mSELECT `linked_projects`.* FROM `linked_projects` WHERE `linked_projects`.`db_project_id` = 226 ORDER BY position[0m [[0;37mDEBUG[0m|#26947] [1m[35mProjectUserRoleRelationship Load (0.2ms)[0m SELECT users.login as login, roles.title as roletitle FROM `project_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `project_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `project_user_role_relationships`.`bs_user_id` WHERE `project_user_role_relationships`.`db_project_id` = 226 [[0;37mDEBUG[0m|#26947] [1m[36mProjectGroupRoleRelationship Load (0.2ms)[0m [1mSELECT groups.title as grouptitle, roles.title as roletitle FROM `project_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `project_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `project_group_role_relationships`.`bs_group_id` WHERE `project_group_role_relationships`.`db_project_id` = 226[0m [[0;37mDEBUG[0m|#26947] [1m[35mDownload Load (0.1ms)[0m SELECT `downloads`.* FROM `downloads` WHERE `downloads`.`db_project_id` = 226 [[0;37mDEBUG[0m|#26947] [1m[36mRepository Load (0.2ms)[0m [1mSELECT `repositories`.* FROM `repositories` WHERE `repositories`.`db_project_id` = 226 AND `repositories`.`remote_project_name` IS NULL[0m [[0;37mDEBUG[0m|#26947] [1m[35mFlag Load (0.1ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 226 [[0;37mDEBUG[0m|#26947] [1m[36mReleaseTarget Load (0.1ms)[0m [1mSELECT `release_targets`.* FROM `release_targets` WHERE `release_targets`.`repository_id` = 75[0m [[0;37mDEBUG[0m|#26947] [1m[35mRepository Load (0.1ms)[0m SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`hostsystem_id` = 75 LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mPathElement Load (0.2ms)[0m [1mSELECT `path_elements`.* FROM `path_elements` WHERE `path_elements`.`parent_id` = 75 ORDER BY position[0m [[0;37mDEBUG[0m|#26947] [1m[35mRepositoryArchitecture Load (0.2ms)[0m SELECT architectures.name FROM `repository_architectures` INNER JOIN `architectures` ON `architectures`.`id` = `repository_architectures`.`architecture_id` WHERE `repository_architectures`.`repository_id` = 75 ORDER BY position [[0;37mDEBUG[0m|#26947] [1m[36mReleaseTarget Load (0.1ms)[0m [1mSELECT `release_targets`.* FROM `release_targets` WHERE `release_targets`.`repository_id` = 81[0m [[0;37mDEBUG[0m|#26947] [1m[35mRepository Load (0.1ms)[0m SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`hostsystem_id` = 81 LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mPathElement Load (0.2ms)[0m [1mSELECT `path_elements`.* FROM `path_elements` WHERE `path_elements`.`parent_id` = 81 ORDER BY position[0m [[0;37mDEBUG[0m|#26947] [1m[35mRepositoryArchitecture Load (0.2ms)[0m SELECT architectures.name FROM `repository_architectures` INNER JOIN `architectures` ON `architectures`.`id` = `repository_architectures`.`architecture_id` WHERE `repository_architectures`.`repository_id` = 81 ORDER BY position [[0;37mDEBUG[0m|#26947] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`maintenance_project_id` = 226 AND (projects.id not in (0))[0m [[0;37mDEBUG[0m|#26947] ----------------- end rendering project Apache ------------------------ [[0;37mDEBUG[0m|#26947] Validate XML response: #<ActionDispatch::Response:0x000000059976e0> took 53ms [[32mINFO [0m|#26947] Completed 200 OK in 91ms (Views: 0.3ms | ActiveRecord: 18.2ms | Backend: 0.0ms | XML: 0.2ms) [[32mINFO [0m|#26947] Started PUT "/source/Apache/_meta" for 127.0.0.1 at 2012-12-03 15:14:38 +0100 [[32mINFO [0m|#26947] Processing by SourceController#project_meta as XML [[32mINFO [0m|#26947] Parameters: {"<project name"=>"\"Apache\">\n <title>Up-to-date Apache packages</title>\n <description>description</description>\n <person userid=\"fred\" role=\"maintainer\"/>\n <person userid=\"fredlibs\" role=\"maintainer\"/>\n <repository name=\"SUSE_Linux_10.1\"/>\n <repository name=\"SUSE_Linux_Factory\">\n <arch>i586</arch>\n </repository>\n</project>\n", "project"=>"Apache"} [[0;37mDEBUG[0m|#26947] Validate XML request: #<ActionDispatch::Request:0x000000055f2d50> [[0;37mDEBUG[0m|#26947] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="] [[0;37mDEBUG[0m|#26947] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1 [[0;37mDEBUG[0m|#26947] USER found: king [[0;37mDEBUG[0m|#26947] User king initialised [[0;37mDEBUG[0m|#26947] [1m[36mRole Load (0.2ms)[0m [1mSELECT DISTINCT roles.id 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 [[0;37mDEBUG[0m|#26947] [1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`name` = 'Apache' AND (projects.id not in (0)) LIMIT 1 [[0;37mDEBUG[0m|#26947] Checking permission for the put [[0;37mDEBUG[0m|#26947] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 226 AND `flags`.`flag` = 'lock' AND `flags`.`status` = 'enable' LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [1m[35mRepository Load (0.2ms)[0m SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`db_project_id` = 226 [[0;37mDEBUG[0m|#26947] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|#26947] [1m[35mFlag Load (0.1ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 226 [[0;37mDEBUG[0m|#26947] disabled_for access repo: arch: state:enable [[0;37mDEBUG[0m|#26947] xml_disabled? X({"name"=>"Apache", "title"=>"Up-to-date Apache packages", "description"=>"description", "person"=>[X({"userid"=>"fred", "role"=>"maintainer"}), X({"userid"=>"fredlibs", "role"=>"maintainer"})], "repository"=>[X({"name"=>"SUSE_Linux_10.1"}), X({"name"=>"SUSE_Linux_Factory", "arch"=>"i586"})]}) [[0;37mDEBUG[0m|#26947] disabled_for sourceaccess repo: arch: state:enable [[0;37mDEBUG[0m|#26947] xml_disabled? X({"name"=>"Apache", "title"=>"Up-to-date Apache packages", "description"=>"description", "person"=>[X({"userid"=>"fred", "role"=>"maintainer"}), X({"userid"=>"fredlibs", "role"=>"maintainer"})], "repository"=>[X({"name"=>"SUSE_Linux_10.1"}), X({"name"=>"SUSE_Linux_Factory", "arch"=>"i586"})]}) [[0;37mDEBUG[0m|#26947] ### name comparison: self.name -> Apache, project_name -> Apache [[0;37mDEBUG[0m|#26947] [1m[36mDbProjectType Load (0.1ms)[0m [1mSELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`name` = 'standard' LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [1m[35m (0.2ms)[0m UPDATE `projects` SET `type_id` = 1, `updated_at` = '2012-12-03 14:14:38' WHERE `projects`.`id` = 226 [[0;37mDEBUG[0m|#26947] [1m[36mLinkedProject Load (0.2ms)[0m [1mSELECT `linked_projects`.* FROM `linked_projects` WHERE `linked_projects`.`db_project_id` = 226 ORDER BY position[0m [[0;37mDEBUG[0m|#26947] [1m[35mProjectUserRoleRelationship Load (0.2ms)[0m SELECT ur.db_project_id, ur.bs_user_id from flags f, project_user_role_relationships ur where f.flag = 'access' and ur.db_project_id = f.db_project_id [[0;37mDEBUG[0m|#26947] [1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`maintenance_project_id` = 226 AND (projects.id not in (0))[0m [[0;37mDEBUG[0m|#26947] [1m[35mProjectUserRoleRelationship Load (0.2ms)[0m SELECT `project_user_role_relationships`.* FROM `project_user_role_relationships` WHERE `project_user_role_relationships`.`db_project_id` = 226 [[0;37mDEBUG[0m|#26947] [1m[36mUser Load (0.1ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 1 LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [1m[35mRole Load (0.1ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mUser Load (0.1ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'fred' LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [1m[35mUser Load (0.1ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'fredlibs' LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mProjectGroupRoleRelationship Load (0.1ms)[0m [1mSELECT `project_group_role_relationships`.* FROM `project_group_role_relationships` WHERE `project_group_role_relationships`.`db_project_id` = 226[0m [[0;37mDEBUG[0m|#26947] [1m[35mDownload Load (0.1ms)[0m SELECT `downloads`.* FROM `downloads` WHERE `downloads`.`db_project_id` = 226 [[0;37mDEBUG[0m|#26947] modifying repository 'SUSE_Linux_10.1' [[0;37mDEBUG[0m|#26947] [1m[36mReleaseTarget Load (0.1ms)[0m [1mSELECT `release_targets`.* FROM `release_targets` WHERE `release_targets`.`repository_id` = 75[0m [[0;37mDEBUG[0m|#26947] [1m[35mRepository Load (0.2ms)[0m SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`hostsystem_id` = 75 LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mPathElement Load (0.2ms)[0m [1mSELECT `path_elements`.* FROM `path_elements` WHERE `path_elements`.`parent_id` = 75 ORDER BY position[0m [[0;37mDEBUG[0m|#26947] [1m[35m (0.2ms)[0m SELECT COUNT(*) FROM `architectures` INNER JOIN `repository_architectures` ON `architectures`.`id` = `repository_architectures`.`architecture_id` WHERE `repository_architectures`.`repository_id` = 75 [[0;37mDEBUG[0m|#26947] delete all of 75 [[0;37mDEBUG[0m|#26947] [1m[36mSQL (0.1ms)[0m [1mDELETE FROM `repository_architectures` WHERE (repository_id = 75)[0m [[0;37mDEBUG[0m|#26947] modifying repository 'SUSE_Linux_Factory' [[0;37mDEBUG[0m|#26947] [1m[35mReleaseTarget Load (0.2ms)[0m SELECT `release_targets`.* FROM `release_targets` WHERE `release_targets`.`repository_id` = 81 [[0;37mDEBUG[0m|#26947] [1m[36mRepository Load (0.3ms)[0m [1mSELECT `repositories`.* FROM `repositories` WHERE `repositories`.`hostsystem_id` = 81 LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [1m[35mPathElement Load (0.1ms)[0m SELECT `path_elements`.* FROM `path_elements` WHERE `path_elements`.`parent_id` = 81 ORDER BY position [[0;37mDEBUG[0m|#26947] [1m[36m (0.2ms)[0m [1mSELECT COUNT(*) FROM `architectures` INNER JOIN `repository_architectures` ON `architectures`.`id` = `repository_architectures`.`architecture_id` WHERE `repository_architectures`.`repository_id` = 81[0m [[0;37mDEBUG[0m|#26947] delete all of 81 [[0;37mDEBUG[0m|#26947] [1m[35mSQL (0.1ms)[0m DELETE FROM `repository_architectures` WHERE (repository_id = 81) [[0;37mDEBUG[0m|#26947] [1m[36mArchitecture Load (0.1ms)[0m [1mSELECT `architectures`.* FROM `architectures` [0m [[0;37mDEBUG[0m|#26947] [1m[35mRepository Load (0.1ms)[0m SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`id` = 81 LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mSQL (0.1ms)[0m [1mINSERT INTO `repository_architectures` (`architecture_id`, `position`, `repository_id`) VALUES (1, 1, 81)[0m [[0;37mDEBUG[0m|#26947] write_to_backend [[0;37mDEBUG[0m|#26947] ----------------- rendering project Apache ------------------------ [[0;37mDEBUG[0m|#26947] [1m[35mDbProjectType Load (0.1ms)[0m SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 1 LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mCACHE (0.0ms)[0m [1mSELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 1 LIMIT 1[0m [[0;37mDEBUG[0m|#26947] [1m[35mProjectUserRoleRelationship Load (0.2ms)[0m SELECT users.login as login, roles.title as roletitle FROM `project_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `project_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `project_user_role_relationships`.`bs_user_id` WHERE `project_user_role_relationships`.`db_project_id` = 226 [[0;37mDEBUG[0m|#26947] [1m[36mProjectGroupRoleRelationship Load (0.2ms)[0m [1mSELECT groups.title as grouptitle, roles.title as roletitle FROM `project_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `project_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `project_group_role_relationships`.`bs_group_id` WHERE `project_group_role_relationships`.`db_project_id` = 226[0m [[0;37mDEBUG[0m|#26947] [1m[35mRepository Load (0.2ms)[0m SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`db_project_id` = 226 AND `repositories`.`remote_project_name` IS NULL [[0;37mDEBUG[0m|#26947] [1m[36mReleaseTarget Load (0.1ms)[0m [1mSELECT `release_targets`.* FROM `release_targets` WHERE `release_targets`.`repository_id` = 75[0m [[0;37mDEBUG[0m|#26947] [1m[35mRepository Load (0.1ms)[0m SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`hostsystem_id` = 75 LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mPathElement Load (0.2ms)[0m [1mSELECT `path_elements`.* FROM `path_elements` WHERE `path_elements`.`parent_id` = 75 ORDER BY position[0m [[0;37mDEBUG[0m|#26947] [1m[35mRepositoryArchitecture Load (0.2ms)[0m SELECT architectures.name FROM `repository_architectures` INNER JOIN `architectures` ON `architectures`.`id` = `repository_architectures`.`architecture_id` WHERE `repository_architectures`.`repository_id` = 75 ORDER BY position [[0;37mDEBUG[0m|#26947] [1m[36mReleaseTarget Load (0.1ms)[0m [1mSELECT `release_targets`.* FROM `release_targets` WHERE `release_targets`.`repository_id` = 81[0m [[0;37mDEBUG[0m|#26947] [1m[35mRepository Load (0.2ms)[0m SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`hostsystem_id` = 81 LIMIT 1 [[0;37mDEBUG[0m|#26947] [1m[36mPathElement Load (0.2ms)[0m [1mSELECT `path_elements`.* FROM `path_elements` WHERE `path_elements`.`parent_id` = 81 ORDER BY position[0m [[0;37mDEBUG[0m|#26947] [1m[35mRepositoryArchitecture Load (0.2ms)[0m SELECT architectures.name FROM `repository_architectures` INNER JOIN `architectures` ON `architectures`.`id` = `repository_architectures`.`architecture_id` WHERE `repository_architectures`.`repository_id` = 81 ORDER BY position [[0;37mDEBUG[0m|#26947] ----------------- end rendering project Apache ------------------------ [[0;37mDEBUG[0m|#26947] [backend] PUT: /source/Apache/_meta?user=king [[0;37mDEBUG[0m|#26947] [1m[36m (0.2ms)[0m [1mROLLBACK TO SAVEPOINT active_record_1[0m [[0;37mDEBUG[0m|#26947] Errno::ECONNREFUSED: errorcode Connection refused - connect(2) <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/lib/opensuse/backend.rb>:97:in `put_or_post' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/lib/opensuse/backend.rb>:115:in `put' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/app/models/project.rb>:680:in `write_to_backend' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/app/models/project.rb>:689:in `block in store' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/app/models/project.rb>:687:in `store' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/app/controllers/source_controller.rb>:833:in `block in project_meta' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/app/controllers/source_controller.rb>:824:in `project_meta' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/test/test_helper.rb>:47:in `process' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/test/test_consistency_helper.rb>:22:in `block in resubmit_all_fixtures' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/lib/activexml/node.rb>:518:in `call' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/lib/activexml/node.rb>:518:in `block in method_missing' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/lib/activexml/node.rb>:516:in `method_missing' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/test/test_consistency_helper.rb>:17:in `resubmit_all_fixtures' <http://ci.opensuse.org/job/obs_master_testsuite_api/ws/src/api/test/functional/zzz_post_consistency_test.rb>:7:in `test_resubmit_fixtures' [[32mINFO [0m|#26947] Completed 400 Bad Request in 59ms (Views: 0.7ms | ActiveRecord: 7.6ms | Backend: 0.0ms | XML: 0.0ms) [[0;37mDEBUG[0m|#26947] [1m[35m (4.1ms)[0m ROLLBACK + echo + cleanup + echo 'Killing backend processes' Killing backend processes + 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/>:+ egrep 'perl|ruby' jenkins ..c.. sh jenkins ..c.. sh jenkins ..c.. sh + 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/cache src/api/tmp/pids src/api/tmp/sessions src/api/tmp/sockets 'src/webui/log/*' src/webui/tmp/cache src/webui/tmp/pids src/webui/tmp/sessions src/webui/tmp/sockets + exit 1 Build step 'Execute shell' marked build as failure [locks-and-latches] Releasing all the locks [locks-and-latches] All the locks released Recording test results -- To unsubscribe, e-mail: obs-tests+unsubscribe@opensuse.org To contact the owner, e-mail: obs-tests+owner@opensuse.org
See <http://ci.opensuse.org/job/obs_master_testsuite_api/1239/changes> -- To unsubscribe, e-mail: obs-tests+unsubscribe@opensuse.org To contact the owner, e-mail: obs-tests+owner@opensuse.org
participants (1)
-
admin＠opensuse.org