Bug 784712

Summary: Cannot have same name product on different Orgs
Product: Red Hat Satellite Reporter: Og Maciel <omaciel>
Component: APIAssignee: Tomas Strachota <tstrachota>
Status: CLOSED CURRENTRELEASE QA Contact: Katello QA List <katello-qa-list>
Severity: high Docs Contact:
Priority: high    
Version: 6.0.0CC: bkearney, cwelton, gkhachik, gstoecke, hbrock, inecas, jlabocki, jlaska, tomckay, tstrachota
Target Milestone: UnspecifiedKeywords: TestBlocker, Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: candlepin-0.5.23, katello-0.2.3-1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 802795 (view as bug list) Environment:
Last Closed: 2012-08-22 18:23:00 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On: 788940    
Bug Blocks: 747354, 802795    
Attachments:
Description Flags
katello log with full traceback none

Description Og Maciel 2012-01-25 21:45:20 UTC
Created attachment 557533 [details]
katello log with full traceback

Description of problem:

Seems that we cannot have a product with the same name in different Orgs.

Version-Release number of selected component (if applicable):

Katello Version: 0.1.195-1.el6 

How reproducible:


Steps to Reproduce:
1. Create Org1 with a product Prod1
2. Create Org2 with a product Prod1 (same as the one above
3. 
  
Actual results:

Seeing this error message:

Runtime Error Could not execute JDBC batch update at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError:2,598

Expected results:


Additional info:

Removing Prod1 from Org1 and then adding it to Org2 works. See attached log.

Comment 1 James Laska 2012-02-07 18:03:13 UTC
Adding qa_ack for cloudforms-1.0.0 ... straightforward to test and easy to document+workaround for the beta.

Comment 2 Tomas Strachota 2012-02-08 15:28:29 UTC
This error is caused by candlepin not allowing to have two products with the same name. I'm investigating if they could remove the uniqueness constraint.

Comment 3 Tomas Strachota 2012-02-09 10:54:06 UTC
We're waiting for candlepin bug 788940. Once it is fixed it will be possible to create products with the same name (in different orgs) also in Katello.

Comment 4 Ivan Necas 2012-02-22 08:30:59 UTC
*** Bug 795926 has been marked as a duplicate of this bug. ***

Comment 6 Ivan Necas 2012-02-28 08:52:05 UTC
*** Bug 749517 has been marked as a duplicate of this bug. ***

Comment 7 Tomas Strachota 2012-02-28 16:56:16 UTC
Name uniqueness constraint was removed from products in candlepin-0.5.23

With this version it is possible to have same name for products in different orgs.

Comment 9 Corey Welton 2012-02-28 20:28:20 UTC
QA Verified with candlepin candlepin-0.5.23-1.el6.noarch

Comment 12 Jeff Weiss 2012-03-07 02:16:51 UTC
This isn't even in katello yet, will hold ON_QA until it's in a real build.

Comment 13 Corey Welton 2012-03-08 16:01:16 UTC
It's fixed in the current brew build. 

QA Verified: 0.1.303-1.el6