Bug 1554371

Summary: Upgrade failed from 6.2.14 to 6.3 at step migrate_candlepin
Product: Red Hat Satellite Reporter: Sanket Jagtap <sjagtap>
Component: UpgradesAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED ERRATA QA Contact: Sanket Jagtap <sjagtap>
Severity: high Docs Contact:
Priority: high    
Version: 6.3.0CC: ahumbe, andrew.schofield, aperotti, bcourt, cdonnell, egolov, gapatil, gpulido, inecas, khowell, ktordeur, mbacovsk, nshaik, smane, swadeley
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: candlepin-2.1.15-1 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 1558060 (view as bug list) Environment:
Last Closed: 2018-03-21 16:28:36 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:
Bug Depends On: 1558065    
Bug Blocks:    

Description Sanket Jagtap 2018-03-12 14:09:22 UTC
Description of problem:


Version-Release number of selected component (if applicable):
Upgrading from 6.2.14 to 6.3

How reproducible:


Steps to Reproduce:
1. Installed a 6.2.14 box 
2. Upgraded the box to 6.3.0 GA
3.

Actual results:
########## ERROR ############
Error running command: liquibase --driver=org.postgresql.Driver --classpath=/usr/share/java/postgresql-jdbc.jar:/var/lib/tomcat/webapps/candlepin/WEB-INF/classes/ --changeLogFile=db/changelog
/changelog-update.xml --url=jdbc:postgresql:candlepin --username=candlepin --password=6kuSdXvRjuB3HTaXhd8j5tL3CbTG67Se --logLevel=severe migrate -Dcommunity=False
Status code: 65280
Command output: SEVERE 3/12/18 9:50 AM:liquibase: db/changelog/changelog-update.xml: db/changelog/20170206133825-add-share-consumer-type.xml::20170206133825-1::awood: Change Set db/changelog/
20170206133825-add-share-consumer-type.xml::20170206133825-1::awood failed.  Error: Error executing SQL INSERT INTO public.cp_consumer_type (id, label, manifest) VALUES ('1008', 'share', 'N')
: ERROR: duplicate key value violates unique constraint "cp_consumer_type_label_key"
  Detail: Key (label)=(share) already exists.


Expected results:
Migration should be successfull

Additional info:
The Box has various repo's for various manifests enabled

Comment 1 Sanket Jagtap 2018-03-12 14:10:03 UTC
Edit:
Additional info:
The Box has various repo's for various arch type enabled

Comment 9 Sanket Jagtap 2018-03-21 13:40:18 UTC
Build: Satellite 6.3.0.1 Async 

Upgrade from 6.2.14 to 6.3.0.1 was successful

Registration of Content host was also successfully done

Comment 12 errata-xmlrpc 2018-03-21 16:28:36 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2018:0575

Comment 13 Kevin Howell 2018-06-11 14:15:20 UTC
*** Bug 1556819 has been marked as a duplicate of this bug. ***