[Spacewalk-list] Problems kickstarting

[Milan Zazrivec]

> Hi all
> 
> I'm trying to kickstart a RHEL4 based node from Spacewalk v1.6
> (Oracle).  The kickstart is failing with a message saying it failed to
> retrieve netstg2.img.
> 
> Looking at the Apache logs, I see quite a few lines with status of 500
> for updates.img, product.img and netstg2.img.  As there was nothing
> interesting in /var/log/httpd/error_log, I looked in
> /var/log/tmcat6/catalina.out and saw:
> ---
> 2012-04-13 11:34:01,135 [TP-Processor2] WARN
> org.apache.struts.action.RequestProcessor - Unhandled Exception
> thrown: class org.hibernate.NonUniqueResultException
> 2012-04-13 11:34:01,141 [TP-Processor2] ERROR
> com.redhat.rhn.frontend.servlets.SessionFilter - Error during
> transaction. Rolling back
> javax.servlet.ServletException:
> org.hibernate.NonUniqueResultException: query did not return a unique
> result: 2
>         at
> org.apache.struts.action.RequestProcessor.processException(RequestProcesso
> r.java:520) at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProc
> essor.java:427) at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:22
> 8) at
> com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProce
> ssor.java:99) at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati
> onFilterChain.java:290) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Chain.java:206) at
> com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:91)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati
> onFilterChain.java:235) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Chain.java:206) at
> com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilt
> er.java:129) at
> com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.ja
> va:77) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati
> onFilterChain.java:235) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Chain.java:206) at
> com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(Local
> izedEnvironmentFilter.java:67) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati
> onFilterChain.java:235) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Chain.java:206) at
> com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFil
> ter.java:108) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati
> onFilterChain.java:235) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Chain.java:206) at
> com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java
> :55) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati
> onFilterChain.java:235) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Chain.java:206) at
> com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCh
> aracterEncodingFilter.java:97) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati
> onFilterChain.java:235) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Chain.java:206) at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.
> java:233) at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.
> java:191) at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:1
> 27) at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:1
> 02) at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja
> va:109) at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298
> ) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:69
> 8) at
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.ja
> va:891) at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.j
> ava:690) at java.lang.Thread.run(Thread.java:679)
> Caused by: org.hibernate.NonUniqueResultException: query did not
> return a unique result: 2
>         at
> org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:
> 820) at
> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:8
> 11) at
> com.redhat.rhn.domain.kickstart.KickstartFactory.lookupKickstartTreeByLabe
> l(KickstartFactory.java:536) at
> com.redhat.rhn.frontend.action.common.DownloadFile.handleKickstartDownload
> (DownloadFile.java:246) at
> com.redhat.rhn.frontend.action.common.DownloadFile.execute(DownloadFile.ja
> va:108) at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProc
> essor.java:425) ... 40 more
> ---
> 
> Anyone got any ideas on how to resolve this?

sqlplus into your database, what does the following query give you?

 select org_id, label from rhnKickstartableTree order by org_id;

-MZ