Bug 533041

Summary: Kickstart fails with org.hibernate.NonUniqueResultException
Product: [Community] Spacewalk Reporter: Kevin Arhelger <kevarh>
Component: APIAssignee: Justin Sherrill <jsherril>
Status: CLOSED NOTABUG QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: high Docs Contact:
Priority: low    
Version: 0.6CC: cperry, jsherril, kevarh, mmraka
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-04-14 20:45:58 UTC Type: ---
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: 559281    
Attachments:
Description Flags
/var/log/tomcat5/catalina.out none

Description Kevin Arhelger 2009-11-04 19:13:13 UTC 
Created attachment 367521 [details]
/var/log/tomcat5/catalina.out

Description of problem:
System fails to kickstart.


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

How reproducible:
Every time

Steps to Reproduce:
1. Attempt kickstart.
2. Kickstart trys to download http://example.com/ks/dist/fc10/Packages/perl-Error-0.17015-1.fc10.noarch.rpm
3. Results in "File Download Failed" and attempts to retry ten times.
4. Catalina log shows "org.hibernate.NonUniqueResultException: query did not return a unique result: 10"
  
Expected results:
http://example.com/ks/dist/fc10/Packages/perl-Error-0.17015-1.fc10.noarch.rpm provides the RPM.


Additional info:
catalina.log file is attached
Comment 1 Michael Mráka 2009-11-06 08:02:54 UTC 
According to tomcat error this looks like an API error not server. Reassigning to API component.
Comment 2 Michael Mráka 2009-11-06 08:05:46 UTC 
Just to be sure: example.com is a placeholder for your satellite's FQDN, isn't it? You are not trying download package from real example.com site...
Comment 3 Kevin Arhelger 2009-11-06 15:09:30 UTC 
Yes, example.com is a place-holder for our fully qualified domain name.
Comment 4 Justin Sherrill 2009-12-14 16:32:47 UTC 
So the traceback seems to indicate that you have 10 packages with the same filename in the specified channel.  

Can you run the following query on the spacewalk server:

# sqlplus spacewalk/spacewalk@xe
sql>  select p.id from rhnPackage p inner join rhnChannelPackage cp on cp.package_id = P.id where cp.channel_id = 2662 and P.path like '%perl-Error-0.17015-1%';


*NOTE* replace 2662 in that query with the channel id of the fc10 channel.  (You can get this id by hovering your mouse over a link to that channel and looking at what cid=XXX is in the url).


I believe that should show 10 different packages, which seems a bit odd.  We can add something to handle the case where there is more than one, but if they had different checksums, it could lead to a failed kickstart.
Comment 5 Justin Sherrill 2010-04-14 20:45:58 UTC 
Gonna go ahead and close this since there was no reply.  If this is still an issue, please reopen the bugzilla.

Thank you!

-Justin