Bug 533041 - Kickstart fails with org.hibernate.NonUniqueResultException
Summary: Kickstart fails with org.hibernate.NonUniqueResultException
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Spacewalk
Classification: Community
Component: API
Version: 0.6
Hardware: x86_64
OS: Linux
low
high
Target Milestone: ---
Assignee: Justin Sherrill
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space09
TreeView+ depends on / blocked
 
Reported: 2009-11-04 19:13 UTC by Kevin Arhelger
Modified: 2010-04-14 20:45 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-04-14 20:45:58 UTC
Embargoed:


Attachments (Terms of Use)
/var/log/tomcat5/catalina.out (4.38 KB, application/octet-stream)
2009-11-04 19:13 UTC, Kevin Arhelger
no flags Details

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


Note You need to log in before you can comment on or make changes to this bug.