Bug 1105024
| Summary: | 500 ISE on creating an activation key with same name as the one already exists in other org | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Sachin Ghai <sghai> | ||||
| Component: | WebUI | Assignee: | Christine Fouant <cfouant> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | sthirugn <sthirugn> | ||||
| Severity: | high | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 6.0.3 | CC: | cfouant, jmontleo, sghai, sthirugn, tomckay | ||||
| Target Milestone: | Unspecified | ||||||
| Target Release: | Unused | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| URL: | http://projects.theforeman.org/issues/6336 | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2014-09-11 12:19:13 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
Since this issue was entered in Red Hat Bugzilla, the release flag has been set to ? to ensure that it is properly evaluated for this release. I was able to create an activation key in two separate orgs with the act key having the same name. Are you creating both keys via api? Can I get both calls you are making? Its reproducible on two diff setups of same build(snap8). I was trying from webUI.
logs from poduction.log when creating activation key (ak1) under org1(id==3)
=============================================================================
Processing by Katello::EnvironmentsController#registerable_paths as JSON
Parameters: {"organization_id"=>"3"}
Completed 200 OK in 66ms (Views: 0.8ms | ActiveRecord: 8.7ms)
Processing by Katello::Api::V2::ContentViewsController#index as JSON
Parameters: {"environment_id"=>"5", "full_result"=>"true", "organization_id"=>"3", "api_version"=>"v2"}
Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/api/v2/content_views/index.json.rabl within katello/api/v2/layouts/collection (60.1ms)
Completed 200 OK in 120ms (Views: 55.1ms | ActiveRecord: 11.5ms)
Processing by Katello::Api::V2::ActivationKeysController#create as JSON
Parameters: {"usage_limit"=>-1, "name"=>"ak1", "environment"=>{"id"=>5, "name"=>"Library", "select"=>true, "selected"=>true}, "content_view_id"=>4, "organization_id"=>"3", "api_version"=>"v2", "activation_key"=>{"name"=>"ak1", "organization_id"=>"3", "usage_limit"=>-1, "content_view_id"=>4}}
Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/api/v2/common/create.json.rabl within katello/api/v2/layouts/resource (785.6ms)
Completed 200 OK in 1200ms (Views: 781.8ms | ActiveRecord: 5.7ms)
logs from poduction.log when creating activation key (ak1) under org2(id==4)
=============================================================================
Processing by Katello::EnvironmentsController#registerable_paths as JSON
Parameters: {"organization_id"=>"4"}
Completed 200 OK in 63ms (Views: 0.7ms | ActiveRecord: 7.7ms)
Connecting to database specified by database.yml
Processing by Katello::Api::V2::ContentViewsController#index as JSON
Parameters: {"environment_id"=>"6", "full_result"=>"true", "organization_id"=>"4", "api_version"=>"v2"}
Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/api/v2/content_views/index.json.rabl within katello/api/v2/layouts/collection (492.6ms)
Completed 200 OK in 559ms (Views: 488.3ms | ActiveRecord: 10.9ms)
Connected to server.
Client connected.
Client disconnected.
Processing by Katello::Api::V2::ActivationKeysController#create as JSON
Parameters: {"usage_limit"=>-1, "name"=>"ak1", "environment"=>{"id"=>6, "name"=>"Library", "select"=>true, "selected"=>true}, "content_view_id"=>5, "organization_id"=>"4", "api_version"=>"v2", "activation_key"=>{"name"=>"ak1", "organization_id"=>"4", "usage_limit"=>-1, "content_view_id"=>5}}
PGError: ERROR: duplicate key value violates unique constraint "index_activation_keys_on_label"
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:1171:in `get_last_result'
Created redmine issue http://projects.theforeman.org/issues/6336 from this bug Moving to POST since upstream bug http://projects.theforeman.org/issues/6336 has been closed Verified. I was able to create 2 activation keys - ak1, ak2 under two different Orgs of satellite. version tested: * apr-util-ldap-1.3.9-3.el6_0.1.x86_64 * candlepin-0.9.19-1.el6_5.noarch * candlepin-scl-1-5.el6_4.noarch * candlepin-scl-quartz-2.1.5-5.el6_4.noarch * candlepin-scl-rhino-1.7R3-1.el6_4.noarch * candlepin-scl-runtime-1-5.el6_4.noarch * candlepin-selinux-0.9.19-1.el6_5.noarch * candlepin-tomcat6-0.9.19-1.el6_5.noarch * elasticsearch-0.90.10-4.el6sat.noarch * foreman-1.6.0.29-1.el6sat.noarch * foreman-compute-1.6.0.29-1.el6sat.noarch * foreman-gce-1.6.0.29-1.el6sat.noarch * foreman-libvirt-1.6.0.29-1.el6sat.noarch * foreman-ovirt-1.6.0.29-1.el6sat.noarch * foreman-postgresql-1.6.0.29-1.el6sat.noarch * foreman-proxy-1.6.0.21-1.el6sat.noarch * foreman-selinux-1.6.0-8.el6sat.noarch * foreman-vmware-1.6.0.29-1.el6sat.noarch * katello-1.5.0-27.el6sat.noarch * katello-ca-1.0-1.noarch * katello-certs-tools-1.5.6-1.el6sat.noarch * katello-installer-0.0.56-1.el6sat.noarch * openldap-2.4.23-32.el6_4.1.x86_64 * pulp-katello-0.3-3.el6sat.noarch * pulp-nodes-common-2.4.0-0.23.beta.el6sat.noarch * pulp-nodes-parent-2.4.0-0.23.beta.el6sat.noarch * pulp-puppet-plugins-2.4.0-0.23.beta.el6sat.noarch * pulp-puppet-tools-2.4.0-0.23.beta.el6sat.noarch * pulp-rpm-plugins-2.4.0-0.23.beta.el6sat.noarch * pulp-selinux-2.4.0-0.23.beta.el6sat.noarch * pulp-server-2.4.0-0.23.beta.el6sat.noarch * python-ldap-2.3.10-1.el6.x86_64 * ruby193-rubygem-net-ldap-0.3.1-3.el6sat.noarch * ruby193-rubygem-runcible-1.1.0-2.el6sat.noarch This was delivered with Satellite 6.0 which was released on 10 September 2014. |
Created attachment 902448 [details] Logs from production.log Description of problem: I created an org "org1" and created a activation key with name "ak1" under org1. Later, i created another org "org2" and tried to create an activation key with same name "ak1" (as the one already in org1) but this time I couldn't able to save the create activation key form. And production.log thrown an 500 Internal Server error: Processing by Katello::Api::V2::ActivationKeysController#create as JSON Parameters: {"usage_limit"=>-1, "name"=>"ak1", "environment"=>{"id"=>2, "name"=>"Library", "select"=>true, "selected"=>true}, "content_view_id"=>2, "organization_id"=>"3", "api_version"=>"v2", "activation_key"=>{"name"=>"ak1", "organization_id"=>"3", "usage_limit"=>-1, "content_view_id"=>2}} PGError: ERROR: duplicate key value violates unique constraint "index_activation_keys_on_label" Version-Release number of selected component (if applicable): sat6 beta snap8 (Satellite-6.0.3-RHEL-6-20140604.0) How reproducible: always Steps to Reproduce: 1. Create org1 2. create activation key with name ak1 under org1 3. create org2 4. create another activation key with same name "ak1" under "org2" Actual results: Processing by Katello::Api::V2::ActivationKeysController#create as JSON Parameters: {"usage_limit"=>-1, "name"=>"ak1", "environment"=>{"id"=>2, "name"=>"Library", "select"=>true, "selected"=>true}, "content_view_id"=>2, "organization_id"=>"3", "api_version"=>"v2", "activation_key"=>{"name"=>"ak1", "organization_id"=>"3", "usage_limit"=>-1, "content_view_id"=>2}} PGError: ERROR: duplicate key value violates unique constraint "index_activation_keys_on_label" Expected results: I think user should be able to create activation key with same name in two different orgs and there shouldn't be any error in production.log Additional info: