-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Hello all,
I recently updated Spacewalk from version 2.8 to 2.9. Since then I'm unable to manage multiple servers at once. As soon as I select some servers on the "Systems" tab and click the "Manage" button, I get an internal server error. Looking at the Tomcat catalina.out log, I can see the following SQL error: 2019-02-01 07:14:02,504 [TP-Processor11] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: SELECT COUNT(*) as count FROM rhnSet WHERE rhnSet.user_id = ? AND rhnSet.label = ? AND ( SELECT COUNT(*) FROM rhnServerFeaturesView WHERE rhnSet.element = rhnServerFeaturesView.server_id AND rhnServerFeaturesView.label = ? ) = 0; com.redhat.rhn.common.db.WrappedSQLException: ORA-00933: SQL command not properly ended at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:82) at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:143) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:414) at com.redhat.rhn.common.db.datasource.CachedStatement.internalExecute(CachedStatement.java:293) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:232) at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:90) at com.redhat.rhn.manager.BaseManager.makeDataResult(BaseManager.java:57) at com.redhat.rhn.manager.system.SystemManager.countSystemsInSetWithoutFeature(SystemManager.java:1333) at com.redhat.rhn.common.security.acl.Access.aclAllSystemsInSetHaveFeature(Access.java:208) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.redhat.rhn.common.security.acl.Acl.evalAcl(Acl.java:470) at com.redhat.rhn.frontend.nav.AclGuard.canRender(AclGuard.java:69) at com.redhat.rhn.frontend.nav.RenderGuardComposite.canRender(RenderGuardComposite.java:49) at com.redhat.rhn.frontend.nav.Renderable.canRender(Renderable.java:126) at com.redhat.rhn.frontend.nav.DialognavRenderer.navNodeInactive(DialognavRenderer.java:102) at com.redhat.rhn.frontend.nav.RenderEngine.renderLevel(RenderEngine.java:96) at com.redhat.rhn.frontend.nav.RenderEngine.render(RenderEngine.java:58) at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.render(RenderUtils.java:148) at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.renderNavigationMenu(RenderUtils.java:132) at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.renderNavigationMenu(RenderUtils.java:73) at com.redhat.rhn.frontend.taglibs.NavMenuTag.doStartTag(NavMenuTag.java:53) at org.apache.jsp.WEB_002dINF.pages.ssm.ssmindex_jsp._jspx_meth_rhn_005fdialogmenu_005f0(Unknown Source) at org.apache.jsp.WEB_002dINF.pages.ssm.ssmindex_jsp._jspService(Unknown Source) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1083) at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:396) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:232) at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:105) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1926) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:451) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:104) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.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:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:299) 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:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:777) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:673) at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:546) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:1320) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:140) ... 74 more 2019-02-01 07:14:02,513 [TP-Processor11] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back javax.servlet.ServletException: javax.servlet.jsp.JspException: Error writing to JSP file: at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791) at org.apache.jsp.WEB_002dINF.pages.ssm.ssmindex_jsp._jspService(Unknown Source) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1083) at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:396) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:232) at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:105) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1926) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:451) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:104) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.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:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:299) 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:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:748) Caused by: com.redhat.rhn.common.MethodInvocationException: IllegalInvocationException calling aclAllSystemsInSetHaveFeature ("all_systems_in_set_have_feature(ftr_kickstart)"): null at com.redhat.rhn.common.security.acl.Acl.evalAcl(Acl.java:492) at com.redhat.rhn.frontend.nav.AclGuard.canRender(AclGuard.java:69) at com.redhat.rhn.frontend.nav.RenderGuardComposite.canRender(RenderGuardComposite.java:49) at com.redhat.rhn.frontend.nav.Renderable.canRender(Renderable.java:126) at com.redhat.rhn.frontend.nav.DialognavRenderer.navNodeInactive(DialognavRenderer.java:102) at com.redhat.rhn.frontend.nav.RenderEngine.renderLevel(RenderEngine.java:96) at com.redhat.rhn.frontend.nav.RenderEngine.render(RenderEngine.java:58) at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.render(RenderUtils.java:148) at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.renderNavigationMenu(RenderUtils.java:132) at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.renderNavigationMenu(RenderUtils.java:73) at com.redhat.rhn.frontend.taglibs.NavMenuTag.doStartTag(NavMenuTag.java:53) at org.apache.jsp.WEB_002dINF.pages.ssm.ssmindex_jsp._jspx_meth_rhn_005fdialogmenu_005f0(Unknown Source) ... 51 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.redhat.rhn.common.security.acl.Acl.evalAcl(Acl.java:470) ... 62 more Caused by: com.redhat.rhn.common.db.WrappedSQLException: ORA-00933: SQL command not properly ended at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:82) at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:143) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:414) at com.redhat.rhn.common.db.datasource.CachedStatement.internalExecute(CachedStatement.java:293) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:232) at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:90) at com.redhat.rhn.manager.BaseManager.makeDataResult(BaseManager.java:57) at com.redhat.rhn.manager.system.SystemManager.countSystemsInSetWithoutFeature(SystemManager.java:1333) at com.redhat.rhn.common.security.acl.Access.aclAllSystemsInSetHaveFeature(Access.java:208) ... 67 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:777) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:673) at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:546) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:1320) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:140) ... 74 more What could be the problem here? Any help would be appreciated! Specs: CentOS 6.10 Kernel 2.6.32-754.10.1.el6.x86_64 Oracle DB Regards, Christian Hailer -----BEGIN PGP SIGNATURE----- Version: PGP Universal 3.4.2 (Build 353) Charset: us-ascii wsFVAwUBXFPm/yMT++4TjnpaAQi/pQ//cJHoQTiZwTc/3kYDAXvIMS21Fc47W6HS CDBzcmRWZCtnZSS8kTXKpEE+/sblYhpWXlMi1tfJ9RWRbvSFz7GOgFfXRC5Ckdtd Rk+ZH5RQaZqhpzRuUOWY0kBj0hA5xm24ja7LdVu83LVJmlIcXEpMrY/HSlwiCVEL r4gQqYg0r1lmW87mROck22JFk6nQyc8+I8U8dWQqiQjovd+Cn1ihSQNpPqmG20CK R+/9QSTPdbl7SdIKw/2IHTZHYJM8xrQF7ST98PaH2VMSEUUlbF1DSc0Xy5+Bxh2e r3zG7tctoquNtUrnrq6vZq0op1v2mIztSfYMH3jNKguc7kvlWiQc+CjFh2QI3WLF Ih0C2ltFYHariIb3TR9T10zdzJGJvFM+m84he7FgMv2aEBmGKwDp1m2UI4CAxZIi M04lGhF9GSRhPPoDWq5VxxFwRPpXtqpjeaTJhX/I9hOUsnY/CFr+JbD66ycO9qm4 hQzuom/ns34pxjNFV8GfUNxscrsMLFx+auxBqSNKjDXKUMTHkIbIBgfugTbMRKA4 3xmRUIIgz/Z7cB2IFkfohb/qRmQL0OzyUMnt2hCbhuKUmT361bdGPjtsBaJE8Aco Meql9osU/VXxqBHJCpyIYBr/0q+Ba7G0CiffHVt/Hz7RaxZSHr7yDRZL+C8qGURW RFhtTOFGH6Y= =CEcB -----END PGP SIGNATURE----- _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list