Bug 1021934

Summary: ISE 500: duplicated rows in Kickstart File Preservation List
Product: Red Hat Satellite 5 Reporter: Pavel Studeník <pstudeni>
Component: WebUIAssignee: Jan Dobes <jdobes>
Status: CLOSED CURRENTRELEASE QA Contact: Ales Dujicek <adujicek>
Severity: medium Docs Contact:
Priority: medium    
Version: 560CC: adujicek, cperry, jdobes
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-01-13 09:55:09 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: 1127641    

Description Pavel Studeník 2013-10-22 11:03:55 UTC
Description of problem:
I created "Kickstart File Preservation List" which contents duplicated rows in one item ("File Preservation List").  
For example:

/var/lib/libvirt/images
/dev/hda1
/var/lib/libvirt/images

And I got Internal Server Error.


Version-Release number of selected component (if applicable):
spacewalk-java-2.0.2-46.el6sat.noarch


How reproducible:
always

Steps to Reproduce:
1. create kickstart file preservation in webUI with duplicated rows: 
   Systems -> Kickstart -> File Preservation -> click "create new file preservation list"

Actual results:
Internal Server Error

Expected results:
without ISE 500 

Additional info:
tail /var/log/tomcat6/catalina.out 
# postgresql
... 
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "rhn_flmembers_flid_cfnid_uq"
...

#oracle
...
java.sql.SQLException: ORA-00001: unique constraint (RHNSAT.RHN_FLMEMBERS_FLID_CFNID_UQ) violated
...

Comment 1 Jan Dobes 2013-11-19 12:11:22 UTC
fixed in spacewalk master git commit:

19e7cf397f91fa5b9bc7e548a85c470fd3ec8c3f

Comment 3 Clifford Perry 2015-01-13 09:55:09 UTC
With the release of Red Hat Satellite 5.7 on January 12th 2015 this bug is
being moved to a Closed Current Release state. 

The Satellite 5.7 GA Errata:
 - https://rhn.redhat.com/errata/RHSA-2015-0033.html 

Satellite 5.7 Release Notes:
 -
https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.7/html-single/Release_Notes/index.html

Satellite Customer Portal Blog announcement for release:
 - https://access.redhat.com/blogs/1169563/posts/1315743 

Cliff