All pastes #961644 Raw Edit

Meins

public text v1 · immutable
#961644 ·published 2008-03-29 01:28 UTC
rendered paste body
Processing SourceController#package_meta (for ::ffff:127.0.42.2 at 2008-03-29 02:25:30) [PUT]
  Session ID: BAh7BiIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo%0ASGFzaHsABjoKQHVzZWR7AA%3D%3D--4f4ae8f387319849b401645480857a6c951893b4
  Parameters: {"project"=>"base_toolchain", "action"=>"package_meta", "package"=>"aaa_base", "controller"=>"source"}
checking schema map for controller 'source', action 'package_meta'
schema_file: package
schema_path: /srv/www/docs/api/frontend/package.xsd
trying to validate against schema '/srv/www/docs/api/frontend/package.xsd'
validation tmpfile: /srv/www/obs/frontend/tmp/opensuse_frontend_validator.20603.0
validation succeeded
AUTH:
no authentication string was sent
Rendering status
errorcode 'unknown' - Authentication required
Rendering status (401)
Filter chain halted as [#<ActionController::Filters::ClassMethods::SymbolFilter:0xb7381e60 @filter=:extract_user>] rendered_or_redirected.
Completed in 0.03906 (25 reqs/sec) | Rendering: 0.00126 (3%) | DB: 0.00000 (0%) | 401 Unauthorized [http://127.0.42.2/source/base_toolchain/aaa_base/_meta]
add validation mapping: "source", :filelist => :directory
add validation mapping: "source", :index => :directory
add validation mapping: "source", :packagelist => :directory
add validation mapping: "source", :project_meta => :project
add validation mapping: "source", :package_meta => :package
add validation mapping: "source", :pattern_meta => :pattern


Processing SourceController#package_meta (for ::ffff:127.0.42.2 at 2008-03-29 02:25:30) [PUT]
  Session ID: BAh7BiIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo%0ASGFzaHsABjoKQHVzZWR7AA%3D%3D--4f4ae8f387319849b401645480857a6c951893b4
  Parameters: {"project"=>"base_toolchain", "action"=>"package_meta", "package"=>"aaa_base", "controller"=>"source"}
checking schema map for controller 'source', action 'package_meta'
schema_file: package
schema_path: /srv/www/docs/api/frontend/package.xsd
trying to validate against schema '/srv/www/docs/api/frontend/package.xsd'
validation tmpfile: /srv/www/obs/frontend/tmp/opensuse_frontend_validator.20602.0
validation succeeded
AUTH: BasicYWRtaW46b3BlbnN1c2U=
  SQL (0.001952)   SHOW TABLES
  User Columns (0.003001)   SHOW FIELDS FROM `users`
  User Load (0.001840)   SELECT * FROM `users` WHERE (login = 'admin') LIMIT 1
USER found: Admin
User Admin initialised
User's source backend <:>, rpm backend: <:>
initializing model Package
Package.find( "aaa_base", {:project=>"base_toolchain"} )
prepared find args: ["aaa_base", {:project=>"base_toolchain", :name=>"aaa_base"}]
[BSSQL] find( Package, ["aaa_base", {:project=>"base_toolchain", :name=>"aaa_base"}] )
retrieving target_uri for model ':package'
retrieving option hash for model ':package'
[BSSQL] query_from_options: {:project=>"base_toolchain", :name=>"aaa_base"}
[BSSQL] query_from_options: query is: '@project='base_toolchain' and @name='aaa_base''
  DbPackage Columns (0.002714)   SHOW FIELDS FROM `db_packages`
[BSSQL] join string: ", db_projects"
[BSSQL] find conditions: ["db_packages.name LIKE BINARY ? AND db_packages.db_project_id = db_projects.id AND db_projects.name = ?", "aaa\\_base", "base_toolchain"]
  DbPackage Load (0.001772)   SELECT db_packages.* FROM `db_packages` , db_projects WHERE (db_packages.name LIKE BINARY 'aaa\\_base' AND db_packages.db_project_id = db_projects.id AND db_projects.name = 'base_toolchain')
[BSSQL] query @project='base_toolchain' and @name='aaa_base' returned no objects
User Admin wants to create a package in base_toolchain
  Join Table Columns (0.002084)   SHOW FIELDS FROM `roles_users`
  Role Load (0.001182)   SELECT * FROM `roles` INNER JOIN roles_users ON roles.id = roles_users.role_id WHERE (roles_users.user_id = 1 )
  Role Columns (0.001672)   SHOW FIELDS FROM `roles`
  Join Table Columns (0.002055)   SHOW FIELDS FROM `groups_users`
  Group Load (0.001288)   SELECT * FROM `groups` INNER JOIN groups_users ON groups.id = groups_users.group_id WHERE (groups_users.user_id = 1 )
  Join Table Columns (0.027089)   SHOW FIELDS FROM `roles_static_permissions`
  StaticPermission Load (0.001649)   SELECT * FROM `static_permissions` INNER JOIN roles_static_permissions ON static_permissions.id = roles_static_permissions.static_permission_id WHERE (roles_static_permissions.role_id = 1 )
  StaticPermission Columns (0.002137)   SHOW FIELDS FROM `static_permissions`
add_person: role: "maintainer"
Save Package
XML <package name='aaa_base'>

  <title>T itle of New Package</title>

  <description>LONG DESCRIPTION
GOES
HERE
  </description>

  <person role='maintainer' userid='admin'/>
  <person role='bugowner' userid='admin'/>


<!--
  use one of the examples below to disable building of this package
  on a certain architecture, in a certain repository,
  or a combination thereof:

  <disable arch="x86_64"/>
  <disable repository="SUSE_SLE-10"/>
  <disable repository="SUSE_SLE-10" arch="x86_64"/>

-->

<person role='maintainer' userid='Admin'/></package>
[BSSQL] saving object











  SQL (0.001018)   BEGIN
  DbPackage Load (0.001074)    SELECT pack.*
 FROM db_packages pack
 LEFT OUTER JOIN db_projects pro ON pack.db_project_id = pro.id
 WHERE pro.name = BINARY 'base_toolchain' AND pack.name = BINARY 'aaa_base'

  SQL (0.001450)   SHOW TABLES
  DbProject Load (0.001391)   SELECT * FROM `db_projects` WHERE (name = BINARY 'base_toolchain') LIMIT 1
  DbProject Columns (0.001819)   SHOW FIELDS FROM `db_projects`
  DbPackage Create (0.001310)   INSERT INTO `db_packages` (`name`, `updated_at`, `activity_index`, `db_project_id`, `title`, `url`, `description`, `created_at`, `update_counter`) VALUES('aaa_base', NULL, 100.0, 2, NULL, NULL, NULL, NULL, 0)
  PackageUserRoleRelationship Load (0.001392)   SELECT * FROM `package_user_role_relationships` WHERE (package_user_role_relationships.db_package_id = 1)
  User Load (0.001466)   SELECT * FROM `users` WHERE (`users`.`login` = 'admin') LIMIT 1
  Role Load (0.000854)   SELECT * FROM `roles`
  PackageUserRoleRelationship Columns (0.001830)   SHOW FIELDS FROM `package_user_role_relationships`
  PackageUserRoleRelationship Create (0.001371)   INSERT INTO `package_user_role_relationships` (`role_id`, `bs_user_id`, `db_package_id`) VALUES(3, 1, 1)
  User Load (0.001243)   SELECT * FROM `users` WHERE (`users`.`login` = 'admin') LIMIT 1
  PackageUserRoleRelationship Create (0.000963)   INSERT INTO `package_user_role_relationships` (`role_id`, `bs_user_id`, `db_package_id`) VALUES(4, 1, 1)
  User Load (0.001056)   SELECT * FROM `users` WHERE (`users`.`login` = 'Admin') LIMIT 1
  PackageUserRoleRelationship Create (0.000000)   Mysql::Error: Duplicate entry '1-1-3' for key 2: INSERT INTO `package_user_role_relationships` (`role_id`, `bs_user_id`, `db_package_id`) VALUES(3, 1, 1)
  SQL (0.014844)   ROLLBACK


ActiveRecord::StatementInvalid (Mysql::Error: Duplicate entry '1-1-3' for key 2: INSERT INTO `package_user_role_relationships` (`role_id`, `bs_user_id`, `db_package_id`) VALUES(3, 1, 1)):
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:150:in `log'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:281:in `execute'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:156:in `insert_sql'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:291:in `insert_sql'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/query_cache.rb:19:in `insert'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:2272:in `create_without_callbacks'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/callbacks.rb:226:in `create_without_timestamps'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/timestamp.rb:29:in `create'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:2238:in `create_or_update_without_callbacks'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/callbacks.rb:213:in `create_or_update'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1972:in `save_without_validation'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/validations.rb:934:in `save_without_transactions'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/transactions.rb:108:in `save'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/transactions.rb:80:in `transaction'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/transactions.rb:100:in `transaction'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/transactions.rb:108:in `save'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/transactions.rb:120:in `rollback_active_record_state!'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/transactions.rb:108:in `save'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:572:in `create'
    /app/models/db_package.rb:105:in `store_axml'
    /srv/www/obs/common/lib/activexml/node.rb:308:in `call'
    /srv/www/obs/common/lib/activexml/node.rb:308:in `method_missing'
    /usr/lib/ruby/1.8/rexml/element.rb:934:in `each'
    /usr/lib/ruby/1.8/rexml/xpath.rb:53:in `each'
    /usr/lib/ruby/1.8/rexml/element.rb:934:in `each'
    /srv/www/obs/common/lib/activexml/node.rb:306:in `method_missing'
    /app/models/db_package.rb:85:in `store_axml'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/transactions.rb:80:in `transaction'
    /app/models/db_package.rb:67:in `store_axml'
    /app/models/db_package.rb:39:in `store_axml'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/transactions.rb:80:in `transaction'
    /app/models/db_package.rb:29:in `store_axml'
    /srv/www/obs/common/lib/activexml/transport.rb:230:in `save'
    /srv/www/obs/common/lib/activexml/base.rb:89:in `save'
    /app/controllers/source_controller.rb:404:in `package_meta'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:1158:in `send'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:1158:in `perform_action_without_filters'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:697:in `call_filters'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:689:in `perform_action_without_benchmark'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
    /usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/rescue.rb:199:in `perform_action_without_caching'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/caching.rb:678:in `perform_action'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in `cache'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/query_cache.rb:8:in `cache'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/caching.rb:677:in `perform_action'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:524:in `send'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:524:in `process_without_filters'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:685:in `process_without_session_management_support'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/session_management.rb:123:in `process'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:388:in `process'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:171:in `handle_request'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:115:in `dispatch'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:126:in `dispatch_cgi'
    /usr/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:9:in `dispatch'
    /usr/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/fcgi_handler.rb:101:in `process_request'
    /usr/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/fcgi_handler.rb:149:in `with_signal_handler'
    /usr/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/fcgi_handler.rb:99:in `process_request'
    /usr/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/fcgi_handler.rb:77:in `process_each_request'
    /usr/lib/ruby/vendor_ruby/1.8/fcgi.rb:612:in `each_cgi'
    /usr/lib/ruby/vendor_ruby/1.8/fcgi.rb:609:in `each'
    /usr/lib/ruby/vendor_ruby/1.8/fcgi.rb:609:in `each_cgi'
    /usr/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/fcgi_handler.rb:76:in `process_each_request'
    /usr/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/fcgi_handler.rb:50:in `process!'
    /usr/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/fcgi_handler.rb:24:in `process!'
    /public/dispatch.fcgi:24

Rendering status
errorcode 'uncaught_exception' - Mysql::Error: Duplicate entry '1-1-3' for key 2: INSERT INTO `package_user_role_relationships` (`role_id`, `bs_user_id`, `db_package_id`) VALUES(3, 1, 1)
Rendering status (500)