Bug 869985 - "ORA-00001: unique constraint" during schema upgrade
Summary: "ORA-00001: unique constraint" during schema upgrade
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 1.8
Hardware: Unspecified
OS: Linux
high
urgent
Target Milestone: ---
Assignee: Milan Zázrivec
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space18
TreeView+ depends on / blocked
 
Reported: 2012-10-25 09:50 UTC by Milan Zázrivec
Modified: 2012-11-01 16:20 UTC (History)
6 users (show)

Fixed In Version:
Clone Of: 867408
Environment:
Last Closed: 2012-11-01 16:20:36 UTC
Embargoed:

Attachments (Terms of Use)

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 (Red Hat) 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 (Red Hat) 2012-11-01 16:20:36 UTC 
Spacewalk 1.8 has been released: https://fedorahosted.org/spacewalk/wiki/ReleaseNotes18
Note You need to log in before you can comment on or make changes to this bug.