[Spacewalk-list] Problems kickstarting

[Colin Coe]

On Fri, Apr 13, 2012 at 4:20 PM, Milan Zazrivec <mzazrivec at redhat.com> wrote:
>> 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
>

Hi Milan

the output is:

SQL> select org_id, label from rhnKickstartableTree order by org_id;

    ORG_ID LABEL
---------- ----------------------------------------------------------------
         1 el-4.8-x86_64
         1 el-5.6-x86_64
         1 el-6.1-x86_64
         2 el-4.8-x86_64
         2 el-5.6-x86_64
         2 el-6.1-x86_64

6 rows selected.

SQL>

Thanks

CC

-- 
RHCE#805007969328369