See http://ci.opensuse.org/job/obs_master_testsuite_api/790/changes
Changes:
[Sascha Peilicke] [webui] Fix description collapsing after moving to description_wrapper
[bbrunner] [webui] -Fixed nil value in show patchinfo
[Stephan Kulow] [api] more porting of find calls
[Stephan Kulow] [api] port more usages of :conditions
[Stephan Kulow] [api] fix more usage of find with passed :conditions
[Stephan Kulow] [api] remove anonymous_user model, we do not allow anonymous users,
[Stephan Kulow] [api] switch to simplecov
[Stephan Kulow] [api] remove some functions without documentation and coverage
[Stephan Kulow] [api] finally remove the very confusing develproject_id in db_packages
[Stephan Kulow] [api] trying to increase coverage (and found one real bug :)
[Stephan Kulow] [api] replace some more calls
[Stephan Kulow] [api] increase coverage - by removing more rbac and adding architectures
[Stephan Kulow] [api] cover group controll - removed one unreachable function
[Stephan Kulow] [webui-testsuite] wait_for_javascript fails when there is a popup
[Stephan Kulow] [api] trying to fix some things brakeman complains about
------------------------------------------
[...truncated 123826 lines...]
[[0;37mDEBUG[0m|#17806] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mGroup Load (0.2ms)[0m SELECT `groups`.* FROM `groups` WHERE (title = BINARY 'test_group') LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mProjectGroupRoleRelationship Load (0.2ms)[0m [1mSELECT `project_group_role_relationships`.* FROM `project_group_role_relationships` WHERE (db_project_id = 2 AND role_id = 7 AND bs_group_id = 99) LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mSQL (0.2ms)[0m INSERT INTO `project_group_role_relationships` (`bs_group_id`, `db_project_id`, `role_id`) VALUES (99, 2, 7)
[[0;37mDEBUG[0m|#17806] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDownload Load (0.2ms)[0m SELECT `downloads`.* FROM `downloads` WHERE `downloads`.`db_project_id` = 2
[[0;37mDEBUG[0m|#17806] [1m[36mRepository Load (0.2ms)[0m [1mSELECT `repositories`.* FROM `repositories` WHERE `repositories`.`db_project_id` = 2[0m
[[0;37mDEBUG[0m|#17806] ----------------- rendering project kde4 ------------------------
[[0;37mDEBUG[0m|#17806] [1m[35mDbProjectType Load (0.2ms)[0m SELECT `db_project_types`.* FROM `db_project_types` WHERE `db_project_types`.`id` = 1 LIMIT 1
[[0;37mDEBUG[0m|#17806] [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|#17806] [1m[35mProjectUserRoleRelationship Load (0.3ms)[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` = 2
[[0;37mDEBUG[0m|#17806] [1m[36mProjectGroupRoleRelationship Load (0.3ms)[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` = 2[0m
[[0;37mDEBUG[0m|#17806] [1m[35mRepository Load (0.2ms)[0m SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`db_project_id` = 2 AND (ISNULL(remote_project_name))
[[0;37mDEBUG[0m|#17806] ----------------- end rendering project kde4 ------------------------
[[0;37mDEBUG[0m|#17806] [backend] PUT: /source/kde4/_meta?user=king
[[0;37mDEBUG[0m|#17811] 2012-04-10 13:11:00 [23516]: PUT /source/kde4/_meta?user=king
[[0;37mDEBUG[0m|#17806] request took 0.015422444
[[0;37mDEBUG[0m|#17806] [1m[36m (0.2ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
[[32mINFO [0m|#17806] Completed 200 OK in 76ms (Views: 1.1ms | ActiveRecord: 9.0ms | Backend: 15.4ms | XML: 0.4ms)
[[32mINFO [0m|#17806]
Started GET "/source/kde4/_meta" for 127.0.0.1 at 2012-04-10 13:11:00 +0200
[[32mINFO [0m|#17806] Processing by SourceController#project_meta as XML
[[32mINFO [0m|#17806] Parameters: {"project"=>"kde4"}
[[0;37mDEBUG[0m|#17806] Validate XML request: #ActionDispatch::Request:0x0000000698b678
[[0;37mDEBUG[0m|#17806] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"project_meta", "project"=>"kde4", "method"=>"GET", "type"=>"request"}
[[0;37mDEBUG[0m|#17806] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="]
[[0;37mDEBUG[0m|#17806] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1
[[0;37mDEBUG[0m|#17806] USER found: king
[[0;37mDEBUG[0m|#17806] User king initialised
[[0;37mDEBUG[0m|#17806] [1m[36mRole Load (0.4ms)[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|#17806] [1m[35mDbProject Load (0.3ms)[0m SELECT `db_projects`.* FROM `db_projects` WHERE (name = BINARY 'kde4') LIMIT 1
[[32mINFO [0m|#17806] Completed 200 OK in 6ms (Views: 0.6ms | ActiveRecord: 1.0ms | Backend: 0.0ms | XML: 0.0ms)
[[32mINFO [0m|#17806]
Started GET "/source/kde4" for 127.0.0.1 at 2012-04-10 13:11:00 +0200
[[32mINFO [0m|#17806] Processing by SourceController#index_project as XML
[[32mINFO [0m|#17806] Parameters: {"project"=>"kde4"}
[[0;37mDEBUG[0m|#17806] Validate XML request: #ActionDispatch::Request:0x000000069e10c8
[[0;37mDEBUG[0m|#17806] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"index_project", "project"=>"kde4", "method"=>"GET", "type"=>"request"}
[[0;37mDEBUG[0m|#17806] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="]
[[0;37mDEBUG[0m|#17806] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] USER found: king
[[0;37mDEBUG[0m|#17806] User king initialised
[[0;37mDEBUG[0m|#17806] [1m[35mRole Load (0.4ms)[0m SELECT 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
[[0;37mDEBUG[0m|#17806] [1m[36mDbProject Load (0.2ms)[0m [1mSELECT id,name FROM `db_projects` WHERE (name = BINARY 'kde4') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbPackage Load (0.2ms)[0m SELECT db_packages.name FROM `db_packages` WHERE `db_packages`.`db_project_id` = 2
[[32mINFO [0m|#17806] Completed 200 OK in 7ms (Views: 0.5ms | ActiveRecord: 1.2ms | Backend: 0.0ms | XML: 0.0ms)
[[32mINFO [0m|#17806]
Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2012-04-10 13:11:00 +0200
[[32mINFO [0m|#17806] Processing by SourceController#package_meta as XML
[[32mINFO [0m|#17806] Parameters: {"project"=>"kde4", "package"=>"kdebase"}
[[0;37mDEBUG[0m|#17806] Validate XML request: #ActionDispatch::Request:0x00000006a3a588
[[0;37mDEBUG[0m|#17806] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"}
[[0;37mDEBUG[0m|#17806] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="]
[[0;37mDEBUG[0m|#17806] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] USER found: king
[[0;37mDEBUG[0m|#17806] User king initialised
[[0;37mDEBUG[0m|#17806] [1m[35mRole Load (0.3ms)[0m SELECT 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
[[0;37mDEBUG[0m|#17806] [1m[36mDbProject Load (0.2ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE (name = BINARY 'kde4') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbPackage Load (0.3ms)[0m SELECT `db_packages`.* FROM `db_packages` WHERE `db_packages`.`db_project_id` = 2 AND (name = BINARY 'kdebase') LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mDbProject Load (0.2ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE `db_projects`.`id` = 2 LIMIT 1[0m
[[32mINFO [0m|#17806] Completed 200 OK in 9ms (Views: 0.5ms | ActiveRecord: 1.3ms | Backend: 0.0ms | XML: 0.3ms)
[[32mINFO [0m|#17806]
Started PUT "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2012-04-10 13:11:00 +0200
[[32mINFO [0m|#17806] Processing by SourceController#package_meta as XML
[[32mINFO [0m|#17806] Parameters: {""\"kdebase\" project=\"kde4\">\n <title>blub</title>\n <description>blub</description>\n</package>\n", "project"=>"kde4", "package"=>"kdebase"}
[[33mWARN [0m|#17806] WARNING: Can't verify CSRF token authenticity
[[0;37mDEBUG[0m|#17806] Validate XML request: #ActionDispatch::Request:0x00000006aa3fd8
[[0;37mDEBUG[0m|#17806] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="]
[[0;37mDEBUG[0m|#17806] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1
[[0;37mDEBUG[0m|#17806] USER found: king
[[0;37mDEBUG[0m|#17806] User king initialised
[[0;37mDEBUG[0m|#17806] [1m[36mRole Load (0.3ms)[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|#17806] [1m[35mDbProject Load (0.2ms)[0m SELECT `db_projects`.* FROM `db_projects` WHERE (name = BINARY 'kde4') LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mDbPackage Load (0.3ms)[0m [1mSELECT `db_packages`.* FROM `db_packages` WHERE `db_packages`.`db_project_id` = 2 AND (name = BINARY 'kdebase') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbProject Load (0.2ms)[0m SELECT `db_projects`.* FROM `db_projects` WHERE `db_projects`.`id` = 2 LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mCACHE (0.0ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE (name = BINARY 'kde4') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mCACHE (0.0ms)[0m SELECT `db_packages`.* FROM `db_packages` WHERE `db_packages`.`db_project_id` = 2 AND (name = BINARY 'kdebase') LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mCACHE (0.0ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE `db_projects`.`id` = 2 LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [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 position LIMIT 1
[[0;37mDEBUG[0m|#17806] [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|#17806] [1m[35mCACHE (0.0ms)[0m SELECT 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
[[0;37mDEBUG[0m|#17806] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position[0m
[[0;37mDEBUG[0m|#17806] flagcheck: package has default state, checking project
[[0;37mDEBUG[0m|#17806] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2
[[0;37mDEBUG[0m|#17806] disabled_for sourceaccess repo: arch: state:enable
[[0;37mDEBUG[0m|#17806] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbPackage Load (0.3ms)[0m SELECT pack.*
FROM db_packages pack
LEFT OUTER JOIN db_projects pro ON pack.db_project_id = pro.id
WHERE pro.name = BINARY 'kde4' AND pack.name = BINARY 'kdebase'
[[0;37mDEBUG[0m|#17806] [1m[36mCACHE (0.0ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE `db_projects`.`id` = 2 LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mPackageUserRoleRelationship Load (0.3ms)[0m SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 2
[[0;37mDEBUG[0m|#17806] [1m[36mPackageGroupRoleRelationship Load (0.2ms)[0m [1mSELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 2[0m
[[0;37mDEBUG[0m|#17806] [1m[35mCACHE (0.0ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 2 ORDER BY position
[[0;37mDEBUG[0m|#17806] [1m[36mDbPackage Load (0.3ms)[0m [1mSELECT db_packages.*, ( @activity:=( db_packages.activity_index - POWER( TIME_TO_SEC( TIMEDIFF( NOW(), db_packages.updated_at ))/86400, 1.55 ) /10 ) ) AS act_tmp,
IF( @activity<0, 0, @activity ) AS activity_value FROM `db_packages` WHERE id = 2 LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35m (0.3ms)[0m UPDATE `db_packages` SET `activity_index` = 85.3110061353901, `updated_at` = '2012-04-10 11:11:00', `update_counter` = 1 WHERE `db_packages`.`id` = 2
[[0;37mDEBUG[0m|#17806] ----------------- rendering package kdebase ------------------------
[[0;37mDEBUG[0m|#17806] [1m[36mPackageUserRoleRelationship Load (0.3ms)[0m [1mSELECT users.login as login, roles.title AS role_name FROM `package_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `package_user_role_relationships`.`bs_user_id` WHERE `package_user_role_relationships`.`db_package_id` = 2[0m
[[0;37mDEBUG[0m|#17806] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m SELECT groups.title as title, roles.title as role_name FROM `package_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `package_group_role_relationships`.`bs_group_id` WHERE `package_group_role_relationships`.`db_package_id` = 2
[[0;37mDEBUG[0m|#17806] ----------------- end rendering package kdebase ------------------------
[[0;37mDEBUG[0m|#17806] [backend] PUT: /source/kde4/kdebase/_meta?user=king
[[0;37mDEBUG[0m|#17811] 2012-04-10 13:11:00 [23517]: PUT /source/kde4/kdebase/_meta?user=king
[[0;37mDEBUG[0m|#17806] request took 0.014606345
[[0;37mDEBUG[0m|#17806] [1m[36m (0.2ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
[[32mINFO [0m|#17806] Completed 200 OK in 47ms (Views: 1.1ms | ActiveRecord: 4.7ms | Backend: 14.6ms | XML: 0.1ms)
[[32mINFO [0m|#17806]
Started GET "/source/kde4/kdebase/_meta" for 127.0.0.1 at 2012-04-10 13:11:00 +0200
[[32mINFO [0m|#17806] Processing by SourceController#package_meta as XML
[[32mINFO [0m|#17806] Parameters: {"project"=>"kde4", "package"=>"kdebase"}
[[0;37mDEBUG[0m|#17806] Validate XML request: #ActionDispatch::Request:0x00000006bda988
[[0;37mDEBUG[0m|#17806] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdebase", "method"=>"GET", "type"=>"request"}
[[0;37mDEBUG[0m|#17806] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="]
[[0;37mDEBUG[0m|#17806] [1m[35mUser Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1
[[0;37mDEBUG[0m|#17806] USER found: king
[[0;37mDEBUG[0m|#17806] User king initialised
[[0;37mDEBUG[0m|#17806] [1m[36mRole Load (0.4ms)[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|#17806] [1m[35mDbProject Load (0.3ms)[0m SELECT `db_projects`.* FROM `db_projects` WHERE (name = BINARY 'kde4') LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mDbPackage Load (0.3ms)[0m [1mSELECT `db_packages`.* FROM `db_packages` WHERE `db_packages`.`db_project_id` = 2 AND (name = BINARY 'kdebase') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbProject Load (0.2ms)[0m SELECT `db_projects`.* FROM `db_projects` WHERE `db_projects`.`id` = 2 LIMIT 1
[[32mINFO [0m|#17806] Completed 200 OK in 9ms (Views: 0.6ms | ActiveRecord: 1.5ms | Backend: 0.0ms | XML: 0.0ms)
[[32mINFO [0m|#17806]
Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2012-04-10 13:11:00 +0200
[[32mINFO [0m|#17806] Processing by SourceController#package_meta as XML
[[32mINFO [0m|#17806] Parameters: {"project"=>"kde4", "package"=>"kdelibs"}
[[0;37mDEBUG[0m|#17806] Validate XML request: #ActionDispatch::Request:0x00000006c3b918
[[0;37mDEBUG[0m|#17806] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"}
[[0;37mDEBUG[0m|#17806] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="]
[[0;37mDEBUG[0m|#17806] [1m[36mUser Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] USER found: king
[[0;37mDEBUG[0m|#17806] User king initialised
[[0;37mDEBUG[0m|#17806] [1m[35mRole Load (0.3ms)[0m SELECT 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
[[0;37mDEBUG[0m|#17806] [1m[36mDbProject Load (0.2ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE (name = BINARY 'kde4') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbPackage Load (0.3ms)[0m SELECT `db_packages`.* FROM `db_packages` WHERE `db_packages`.`db_project_id` = 2 AND (name = BINARY 'kdelibs') LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mDbProject Load (0.2ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE `db_projects`.`id` = 2 LIMIT 1[0m
[[32mINFO [0m|#17806] Completed 200 OK in 8ms (Views: 0.5ms | ActiveRecord: 1.3ms | Backend: 0.0ms | XML: 0.0ms)
[[32mINFO [0m|#17806]
Started PUT "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2012-04-10 13:11:00 +0200
[[32mINFO [0m|#17806] Processing by SourceController#package_meta as XML
[[32mINFO [0m|#17806] Parameters: {""\"kdelibs\" project=\"kde4\">\n <title>blub</title>\n <description>Changed description</description>\n \n \n \n \n \n \n \n <build>\n <enable/>\n </build>\n</package>\n", "project"=>"kde4", "package"=>"kdelibs"}
[[33mWARN [0m|#17806] WARNING: Can't verify CSRF token authenticity
[[0;37mDEBUG[0m|#17806] Validate XML request: #ActionDispatch::Request:0x00000006caaa48
[[0;37mDEBUG[0m|#17806] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="]
[[0;37mDEBUG[0m|#17806] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1
[[0;37mDEBUG[0m|#17806] USER found: king
[[0;37mDEBUG[0m|#17806] User king initialised
[[0;37mDEBUG[0m|#17806] [1m[36mRole Load (0.4ms)[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|#17806] [1m[35mDbProject Load (0.2ms)[0m SELECT `db_projects`.* FROM `db_projects` WHERE (name = BINARY 'kde4') LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mDbPackage Load (0.3ms)[0m [1mSELECT `db_packages`.* FROM `db_packages` WHERE `db_packages`.`db_project_id` = 2 AND (name = BINARY 'kdelibs') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbProject Load (0.2ms)[0m SELECT `db_projects`.* FROM `db_projects` WHERE `db_projects`.`id` = 2 LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mCACHE (0.0ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE (name = BINARY 'kde4') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mCACHE (0.0ms)[0m SELECT `db_packages`.* FROM `db_packages` WHERE `db_packages`.`db_project_id` = 2 AND (name = BINARY 'kdelibs') LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mCACHE (0.0ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE `db_projects`.`id` = 2 LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [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 position LIMIT 1
[[0;37mDEBUG[0m|#17806] [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|#17806] [1m[35mCACHE (0.0ms)[0m SELECT 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
[[0;37mDEBUG[0m|#17806] [1m[36mFlag Load (0.2ms)[0m [1mSELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position[0m
[[0;37mDEBUG[0m|#17806] flagcheck: package has default state, checking project
[[0;37mDEBUG[0m|#17806] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_project_id` = 2
[[0;37mDEBUG[0m|#17806] disabled_for sourceaccess repo: arch: state:enable
[[0;37mDEBUG[0m|#17806] [1m[36m (0.1ms)[0m [1mSAVEPOINT active_record_1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbPackage Load (0.3ms)[0m SELECT pack.*
FROM db_packages pack
LEFT OUTER JOIN db_projects pro ON pack.db_project_id = pro.id
WHERE pro.name = BINARY 'kde4' AND pack.name = BINARY 'kdelibs'
[[0;37mDEBUG[0m|#17806] [1m[36mCACHE (0.0ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE `db_projects`.`id` = 2 LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbProject Load (7.0ms)[0m SELECT `db_projects`.* FROM `db_projects` WHERE (name = BINARY 'home:Iggy') LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mDbPackage Load (0.8ms)[0m [1mSELECT `db_packages`.* FROM `db_packages` WHERE `db_packages`.`db_project_id` = 502 AND (name = BINARY 'TestPack') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbProject Load (0.2ms)[0m SELECT `db_projects`.* FROM `db_projects` WHERE `db_projects`.`id` = 502 LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE `package_user_role_relationships`.`db_package_id` = 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mRole Load (0.2ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 6 LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE (login = BINARY 'Iggy') LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mPackageUserRoleRelationship Load (0.2ms)[0m [1mSELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE (db_package_id = 1 AND role_id = 3 AND bs_user_id = 267) LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mSQL (0.2ms)[0m INSERT INTO `package_user_role_relationships` (`bs_user_id`, `db_package_id`, `role_id`) VALUES (267, 1, 3)
[[0;37mDEBUG[0m|#17806] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = BINARY 'Iggy') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mPackageUserRoleRelationship Load (0.2ms)[0m SELECT `package_user_role_relationships`.* FROM `package_user_role_relationships` WHERE (db_package_id = 1 AND role_id = 4 AND bs_user_id = 267) LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mSQL (0.2ms)[0m [1mINSERT INTO `package_user_role_relationships` (`bs_user_id`, `db_package_id`, `role_id`) VALUES (267, 1, 4)[0m
[[0;37mDEBUG[0m|#17806] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m SELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE `package_group_role_relationships`.`db_package_id` = 1
[[0;37mDEBUG[0m|#17806] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`id` = 99 LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mRole Load (0.2ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`id` = 3 LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mGroup Load (0.2ms)[0m [1mSELECT `groups`.* FROM `groups` WHERE `groups`.`title` = 'test_group' LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mPackageGroupRoleRelationship Load (0.2ms)[0m SELECT `package_group_role_relationships`.* FROM `package_group_role_relationships` WHERE (db_package_id = 1 AND role_id = 7 AND bs_group_id = 99) LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mSQL (0.2ms)[0m [1mINSERT INTO `package_group_role_relationships` (`bs_group_id`, `db_package_id`, `role_id`) VALUES (99, 1, 7)[0m
[[0;37mDEBUG[0m|#17806] [1m[35mFlag Load (0.3ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 1 ORDER BY position
[[0;37mDEBUG[0m|#17806] [1m[36mDbPackage Load (0.2ms)[0m [1mSELECT `db_packages`.* FROM `db_packages` WHERE `db_packages`.`id` = 1 LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35m (0.2ms)[0m SELECT MAX(`flags`.`position`) AS max_id FROM `flags` WHERE `flags`.`db_package_id` = 1
[[0;37mDEBUG[0m|#17806] [1m[36mSQL (0.2ms)[0m [1mINSERT INTO `flags` (`architecture_id`, `db_package_id`, `db_project_id`, `flag`, `position`, `repo`, `status`) VALUES (NULL, 1, NULL, 'build', 1, NULL, 'enable')[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbPackage Load (0.3ms)[0m SELECT db_packages.*, ( @activity:=( db_packages.activity_index - POWER( TIME_TO_SEC( TIMEDIFF( NOW(), db_packages.updated_at ))/86400, 1.55 ) /10 ) ) AS act_tmp,
IF( @activity<0, 0, @activity ) AS activity_value FROM `db_packages` WHERE id = 1 LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36m (0.3ms)[0m [1mUPDATE `db_packages` SET `description` = 'Changed description', `develpackage_id` = 10095, `activity_index` = 85.3110061353901, `updated_at` = '2012-04-10 11:11:01', `update_counter` = 1 WHERE `db_packages`.`id` = 1[0m
[[0;37mDEBUG[0m|#17806] ----------------- rendering package kdelibs ------------------------
[[0;37mDEBUG[0m|#17806] [1m[35mPackageUserRoleRelationship Load (0.3ms)[0m SELECT users.login as login, roles.title AS role_name FROM `package_user_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_user_role_relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `package_user_role_relationships`.`bs_user_id` WHERE `package_user_role_relationships`.`db_package_id` = 1
[[0;37mDEBUG[0m|#17806] [1m[36mPackageGroupRoleRelationship Load (0.3ms)[0m [1mSELECT groups.title as title, roles.title as role_name FROM `package_group_role_relationships` INNER JOIN `roles` ON `roles`.`id` = `package_group_role_relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `package_group_role_relationships`.`bs_group_id` WHERE `package_group_role_relationships`.`db_package_id` = 1[0m
[[0;37mDEBUG[0m|#17806] ----------------- end rendering package kdelibs ------------------------
[[0;37mDEBUG[0m|#17806] [backend] PUT: /source/kde4/kdelibs/_meta?user=king
[[0;37mDEBUG[0m|#17811] 2012-04-10 13:11:01 [23518]: PUT /source/kde4/kdelibs/_meta?user=king
[[0;37mDEBUG[0m|#17806] request took 0.016776199
[[0;37mDEBUG[0m|#17806] [1m[35m (0.2ms)[0m RELEASE SAVEPOINT active_record_1
[[32mINFO [0m|#17806] Completed 200 OK in 205ms (Views: 1.2ms | ActiveRecord: 16.5ms | Backend: 16.8ms | XML: 0.4ms)
[[32mINFO [0m|#17806]
Started GET "/source/kde4/kdelibs/_meta" for 127.0.0.1 at 2012-04-10 13:11:01 +0200
[[32mINFO [0m|#17806] Processing by SourceController#package_meta as XML
[[32mINFO [0m|#17806] Parameters: {"project"=>"kde4", "package"=>"kdelibs"}
[[0;37mDEBUG[0m|#17806] Validate XML request: #ActionDispatch::Request:0x00000005389fa0
[[0;37mDEBUG[0m|#17806] no schema found, skipping validation for {"format"=>"xml", "controller"=>"source", "action"=>"package_meta", "project"=>"kde4", "package"=>"kdelibs", "method"=>"GET", "type"=>"request"}
[[0;37mDEBUG[0m|#17806] AUTH: ["Basic", "a2luZzpzdW5mbG93ZXI="]
[[0;37mDEBUG[0m|#17806] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE (login = 'king') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] USER found: king
[[0;37mDEBUG[0m|#17806] User king initialised
[[0;37mDEBUG[0m|#17806] [1m[35mRole Load (0.4ms)[0m SELECT 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
[[0;37mDEBUG[0m|#17806] [1m[36mDbProject Load (0.3ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE (name = BINARY 'kde4') LIMIT 1[0m
[[0;37mDEBUG[0m|#17806] [1m[35mDbPackage Load (0.3ms)[0m SELECT `db_packages`.* FROM `db_packages` WHERE `db_packages`.`db_project_id` = 2 AND (name = BINARY 'kdelibs') LIMIT 1
[[0;37mDEBUG[0m|#17806] [1m[36mDbProject Load (0.2ms)[0m [1mSELECT `db_projects`.* FROM `db_projects` WHERE `db_projects`.`id` = 2 LIMIT 1[0m
[[32mINFO [0m|#17806] Completed 200 OK in 10ms (Views: 0.6ms | ActiveRecord: 1.5ms | Backend: 0.0ms | XML: 0.0ms)
[[0;37mDEBUG[0m|#17806] [1m[35m (197.8ms)[0m ROLLBACK
[[0;37mDEBUG[0m|#17806] kill 17811
+ 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/:
jenkins ..c.. sh
jenkins ..c.. sh
jenkins ..c.. egrep
+ echo 'Remove log/tmp files to save disc space'
Remove log/tmp files to save disc space
+ rm -rf src/api/log/backend_access.log src/api/log/test.log src/api/tmp/backend_config src/api/tmp/backend_data src/api/tmp/cache src/api/tmp/pids src/api/tmp/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