Hello Andy,
valid issue.
I've fixed it in commit 02615216b445d80bcce43b7d5fa91a4ce2c3c5ae.
The fix will be available in spacewalk-java-1.6.26-1 in nightly repo.
Thanks for catching this!
Regards,
Tomas
--
Tomas Lestach
RHN Satellite Engineering, Red Hat
----- Original Message -----
> From: "Andy Speagle" <andy.spea...@wichita.edu>
> To: spacewalk-devel@redhat.com
> Sent: Friday, August 19, 2011 10:43:07 PM
> Subject: [Spacewalk-devel] Error Deleting Distribution
>
>
>
>
>
> Team,
>
>
>
> I’m running into an error trying to delete a few “kickstartable
> distributions” … here’s the trace… looks like I’ve another
> inconsistency in my database. Has anyone seen this?
>
>
>
> Exception:
>
> javax.servlet.ServletException: Executing query
> Channel.findByIdAndUserId with params {userId=21, cid=null} failed
>
> at
> org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
>
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
>
> at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)
>
> at
> com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:99)
>
> at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
>
> at
> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:117)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)
>
> at
> com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
>
> at
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
>
> at
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
>
> at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
>
> at
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
>
> at
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
>
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>
> at java.lang.Thread.run(Thread.java:662)
>
> Caused by: com.redhat.rhn.common.hibernate.HibernateRuntimeException:
> Executing query Channel.findByIdAndUserId with params {userId=21,
> cid=null} failed
>
> at
> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)
>
> at
> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>
> at
> com.redhat.rhn.domain.channel.ChannelFactory.lookupByIdAndUser(ChannelFactory.java:92)
>
> at
> com.redhat.rhn.frontend.action.kickstart.tree.BaseTreeAction.processCommandSetters(BaseTreeAction.java:105)
>
> at
> com.redhat.rhn.frontend.action.BaseEditAction.execute(BaseEditAction.java:61)
>
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
>
> ... 40 more
>
> Caused by: org.hibernate.exception.SQLGrammarException: could not
> execute query
>
> at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
>
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>
> at org.hibernate.loader.Loader.doList(Loader.java:2223)
>
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>
> at org.hibernate.loader.Loader.list(Loader.java:2099)
>
> at
> org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
>
> at
> org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
>
> at
> org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
>
> at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
>
> at
> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>
> at
> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>
> ... 45 more
>
> Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent
> datatypes: expected NUMBER got BINARY
>
>
>
> at
> oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
>
> at
> oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)
>
> at
> oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:542)
>
> at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
>
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
>
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
>
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
>
> at
> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
>
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>
> at
> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>
> at org.hibernate.loader.Loader.doQuery(Loader.java:674)
>
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>
> at org.hibernate.loader.Loader.doList(Loader.java:2220)
>
> ... 53 more
>
>
>
>
>
> Andy Speagle
>
> System & Storage Administrator
>
> UCATS - Wichita State University
>
>
>
> P: 316.978.3869
>
> C: 316.617.2431
>
>
> _______________________________________________
> Spacewalk-devel mailing list
> Spacewalk-devel@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-devel
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
