Bug 869985

Summary:	"ORA-00001: unique constraint" during schema upgrade
Product:	[Community] Spacewalk	Reporter:	Milan Zázrivec <mzazrivec>
Component:	Server	Assignee:	Milan Zázrivec <mzazrivec>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	urgent	Docs Contact:
Priority:	high
Version:	1.8	CC:	cbuissar, cperry, fdewaley, jpazdziora, mhuth, rnelson
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:	867408	Environment:
Last Closed:	2012-11-01 16:20: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:
Bug Blocks:	871344

Description Milan Zázrivec 2012-10-25 09:50:54 UTC

+++ This bug was initially created as a clone of Bug #867408 +++

Description of problem:

Schema upgrade from Spacewalk 1.6 to Spacewalk 1.7:

...

update rhnpackagegroup set name = substr(name, 1, length(name)-1)
*
ERROR at line 1:
ORA-00001: unique constraint (RHNSAT.RHN_PACKAGE_GROUP_NAME_UQ) violated
----


Version-Release number of selected component (if applicable):
Spacewalk 1.6 -> 1.7 schema upgrades

How reproducible:
Deterministic

Steps to Reproduce:
1. Spacewalk 1.6
2. Push a src rpm to your Spacewalk such that its package group is not
used by any of the binary rpms you have on your Spacewalk already
3. Upgrade to Spacewalk 1.7
  
Actual results:
Schema upgrade failes with the error above.

Expected results:
Schema upgrades successfully.

Additional info:
N/A

Comment 1 Milan Zázrivec 2012-10-25 09:55:03 UTC

spacewalk.git master: 220aa08351af2365ecea664c07416ea24a6ea2a2

Comment 2 Milan Zázrivec 2012-10-25 11:09:19 UTC

spacewalk.git master: 7b83198641109da47a4f5f47448dec5efe07ba13

Comment 3 Jan Pazdziora 2012-10-30 19:25:10 UTC

Moving ON_QA. Packages that address this bugzilla should now be available in yum repos at http://yum.spacewalkproject.org/nightly/

Comment 4 Jan Pazdziora 2012-11-01 16:20:36 UTC

Spacewalk 1.8 has been released: https://fedorahosted.org/spacewalk/wiki/ReleaseNotes18